Oracle Enterprise Manager vs. pganalyze

pganalyze

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Oracle Enterprise Manager	Score 7.4 out of 10	N/A	Oracle’s Enterprise Manager is an on-premises monitoring and management tool. The console is designed primarily to manage other Oracle products, it but can integrate to manage non-Oracle components as well.	N/A
pganalyze	Score 9.0 out of 10	Small Businesses (1-50 employees)	Founded in 2012, pganalyze provides actionable insights into Postgres. Specializing in PostgreSQL database monitoring and optimization, pganalyze gives automatic insights into Postgres query plans, helps improve Postgres query performance with its Index Advisor and VACUUM Advisor, and lets the user perform query drill-down analysis, observe per-query statistics and conduct trend analysis in a platform that integrates with both self-managed Postgres servers as…	$149 per month for 1 database server

Pricing

Oracle Enterprise Manager

pganalyze

Editions & Modules

No answers on this topic

Production: $149
per month for 1 database server
Scale: $399
per month for up to 4 database servers ($100/mo for each additional billable server)
Enterprise Cloud: Contact us
per year per database server
Enterprise Server: Contact us
per year per database server

Offerings

Pricing Offerings
Oracle Enterprise Manager	pganalyze
Free Trial
No	Yes
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

No setup fee

Additional Details

—

Scale plan offers additional database servers at a cost of $100/month for each additional billable server. In general, each 1 Postgres server that is running (i.e. one parent postgres process) is considered 1 billable server. In the case of cloud providers these are often called "instances". Depending on the subscription plan you are on, you may have a special price for replica servers (also called "readers", or "followers"), which is implemented by multiplying the replica count with a multiplier (e.g. 0.5), with the total rounded up. Annual plans are available and come at a discount compared to the monthly plans Contact us for custom requirements

More Pricing Information

Community Pulse
	Oracle Enterprise Manager	pganalyze
Considered Both Products	Oracle Enterprise Manager Verified User Anonymous Chose Oracle Enterprise Manager NA Cannot Disclose Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager Datadog is good at collecting metrics, monitoring, and alerting; whereas, with Oracle Enterprise Manager, in addition to all that, we can manage the infrastructure as well as automate certain fixes. Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager Foglight is great, but expensive. It has great monitoring like OEM, but can negatively impact database performance. OEM is better than Foglight because it is a native application from OEM and has features that Foglight doesn't have. Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager They don't stack up against each other. They complement each other. Incentivized Helpful? KT Ken Turner Oracle Database Administrator Chose Oracle Enterprise Manager Oracle Enterprise Manager is better than Toad in that it allows you to do various server configurations that Toad doesn't allow. Incentivized Helpful? MS Maurice Samuels DBA Chose Oracle Enterprise Manager Kibana from Elastic is another monitoring tool that claims to provide very similar information to OEM. It seems to be an information tool rather than a tool that can actually make changes within a database. I think Kibana is more robust for hardware versus database software so it … Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager Being an Oracle shop using Oracle Database and MySQL, management console from Oracle was a better choice than IBM or Microsoft even though we do use Microsoft Azure and storage/servers from IBM (on-prem). Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager Have not used any other products. Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager OEM is better at monitoring applications, while SolarWinds is better at monitoring the underlying infrastructure such as networks, switches, and routers. Incentivized Helpful? MH Mohan Hundre support executive Chose Oracle Enterprise Manager I am using Nagios Enterprise monitoring tool also, but as compared to Nagios, Oracle Enterprise Manager is best for our company. Nagios is very weak in some aspects. Incentivized Helpful? JK Jody Kelly Owner Chose Oracle Enterprise Manager I used many other Oracle products (like Database, Middleware, Identity Management, etc.) but I have yet to review them. Incentivized Helpful? KN Kathy Nahle Senior Enterprise Oracle DBA Chose Oracle Enterprise Manager Have not tried via Oracle Enterprise Manager, but CommVault is used by corporate for all backups of storage. However, it is just using Ansible to kick off RMAN jobs. Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager Toad for Oracle is more suited for individual users who have a strong focus on database development, and it is not as comprehensive as Oracle Enterprise Manager. While it is quite decent in logical database layer tasks, such as schema objects and SQL, it lacks visibility into … Incentivized Helpful? AK Ayub Khan Project Delivery Manager Chose Oracle Enterprise Manager OEM Cloud Control base version is free to use if you have licensed Enterprise Edition of one of the Oracle Product. It's sophisticated single point of control, we have used other monitoring products such as Veeam but none of the products have all the features packed together … Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager OEM is better and cheaper at managing Oracle databases. Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager Since OEM Cloud Control comes free with Enterprise Edition, we have mostly worked on OEM Cloud Control. I did have my fair share of experience with DBArtisan. It's good and lighter than OEM Cloud Control. It sort of removes your need to even go to SQLPLUS command line most of … Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager It is much simpler to install and configure as compared to Spotlight and Solarwinds. Oracle Enterprise Manager measures performance diagnostics accurately and raises alerts and takes preventive actions. Other products can not take preventive actions even if they raise alerts. It … Incentivized Helpful? JS Joseph Szupiany Database Administrator III Chose Oracle Enterprise Manager I'm not aware of any OEM alternatives. At least, nothing with the kind of features you find in OEM, and nothing that is free. Incentivized Helpful? Verified User Anonymous Chose Oracle Enterprise Manager Oracle Enterprise Manager suited our requirement as the clients were using multiple products of Oracle. They were using several instance of oracle implemented at different geographical locations each in Europe, UK, Canada, and USA. So Oracle Enterprise Manager was best fit for … Incentivized Helpful? CC Candy Carrizales Database Administrator Chose Oracle Enterprise Manager We have not used any other products to monitor and/or manage our oracle instances. We have always used Enterprise Manager, although we did use a previous version (11g Grid Control), right around the time I arrived at my position. I upgraded to 12c Cloud Control with the … Incentivized Helpful? DF David Fowler Senior Database Administrator Chose Oracle Enterprise Manager SQL Developer DBA module allows user, space management, SQL Tuning, ad-hoc queries, and schema management. Great free product supported and enhanced from Oracle. Incentivized Helpful? AD Advait Deshpande Enterprise Analyst Chose Oracle Enterprise Manager Oracle Enterprise Manager is easy to install, use and extend the capability of. It supports many Oracle products, which is what it is used for in my company. We selected OEM for its ease of use, intuitiveness and robustness. Incentivized Helpful?	pganalyze Verified User Anonymous Chose pganalyze It is better in terms of results provided. We were using Microsoft SQL Server Management Studio so far and relying only on that but some one recommend to us to use pganalyze to do the query analysis and we started using it for one project and we liked it much that we have … Incentivized Helpful?

Best Alternatives
	Oracle Enterprise Manager	pganalyze
Small Businesses	DBeaver Score 9.2 out of 10	No answers on this topic
Medium-sized Companies	DBeaver Score 9.2 out of 10	Redgate Monitor Score 8.7 out of 10
Enterprises	DBeaver Score 9.2 out of 10	Redgate Monitor Score 8.7 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	Oracle Enterprise Manager	pganalyze
Likelihood to Recommend	7.7 (0 ratings)	9.0 (0 ratings)
Usability	7.3 (0 ratings)	- (0 ratings)
Support Rating	7.3 (0 ratings)	- (0 ratings)

User Testimonials
	Oracle Enterprise Manager	pganalyze
Likelihood to Recommend	I wish I had an option to give it a 9.5 :) OEM Cloud Control is very well suited if you have a system with multiple implementations of Oracle Database Enterprise Edition. If you are willing to pay for the huge license cost which is typical with Oracle, then you will love to use OEM Cloud Control to monitor your entire ERP solution including web servers, applications, network, storage, and physical servers. It is not worth the buck if your's is a small implementation. Your DBA's should be able to work without depending on OEM Cloud Control. Incentivized Verified User Anonymous Read full review	pganalyze works great with the postgresql and gives a good alternatives to the existing producsts available out there like Slick or basic as microsoft SQL server manaagement studio. We have used in our projects of data migration and integration of enterprise data warehouseing and reporting . And it has provides us satisfactory results. Incentivized Verified User Anonymous Read full review
Pros	Oracle Enterprise Manager is a "one stop shop" for all of our management needs. This is helpful because it minimizes the management of the management software itself. There are less upgrades and connectivity issues to handle. And there are "plug-ins" for additional products we use like Blue Medora's one for PostgreSQL. Managing administrative jobs can be burdensome in a shop with dozens of servers and databases. OEM Cloud Control makes it easy since you can view all the jobs for all servers in one place. It is easy to filter on jobs with problems or the like so that you can quickly look at the logs and fix the issues. Tuning PL/SQL is much easier using OEM Cloud Control. Most DBAs are familiar with trace files and TKPROF, but not having to do those things at a command line smooths the process out. The graphical interface makes it easier to show developers exactly what the issues are. This makes for less finger-pointing and quicker resolution of performance problems. Proactive management is easier using OEM Cloud Control. Before having the gui, I had a collection of scripts that I would have to install on each database server, then set up cron jobs to run them. When Oracle was upgraded, those scripts might have to be updated on each and every server. OEM Cloud Control has those things built in. You can choose exactly which metrics are important to you. And you can keep performance graphs up all day on a second monitor to let you instantly see when something might cause a problem. Incentivized Dorrie Keyes Senior Database Administrator Read full review	User and role setup Performance tuning Tracking of queries Incentivized Verified User Anonymous Read full review
Cons	We also use OEM to monitor SQL Server. However, OEM only provided limited features for SQL Server. It would be nice if we can schedule backup jobs for SQL Server in OEM. The ability to run SQL queries. You can't run queries in OEM. I have to go to SQL Developer or SQL PLUS to run. queries. Incentivized Verified User Anonymous Read full review	Visualization Database insights Incentivized Verified User Anonymous Read full review
Usability	It's great! It does everything and anything you would want it to do. It can monitor things which doesn't comes out of the box by adding plug ins to it, for example, you can even monitor Oracle GoldenGate Replication by adding a plug-in to OEM Cloud Control. Incentivized Verified User Anonymous Read full review	No answers on this topic
Support Rating	I still rate OEM as a must-have tool for central management of Oracle fleet. The pros and cons of the product is prominent. Meanwhile, I also acknowledge that OEM was design about a decade ago. At that time, it did not have the landscape we have today, such as cloud, DEVOPS, machine learning, etc. I hope in future releases, the design will incorporate those features. Incentivized KZ Kevin Zhang Manager of Oracle Infrastructure Read full review	No answers on this topic
Alternatives Considered	Kibana from Elastic is another monitoring tool that claims to provide very similar information to OEM. It seems to be an information tool rather than a tool that can actually make changes within a database. I think Kibana is more robust for hardware versus database software so it is more suited to that purpose and does to compare to the Oracle Database monitoring attributes of OEM. Incentivized MS Maurice Samuels DBA Read full review	It is better in terms of results provided. We were using Microsoft SQL Server Management Studio so far and relying only on that but some one recommend to us to use pganalyze to do the query analysis and we started using it for one project and we liked it much that we have started recomended to all projects teams .. Incentivized Verified User Anonymous Read full review
Return on Investment	Positive: Alerting features. Without this we would have to be a 24x7 shop with someone always manning the helm. With the alerting feature we can define levels of alerts and only get the most pressing alerts sent out. ROI: OEM is free, so the ROI is whatever you make of it. Incentivized Joseph Szupiany Database Administrator III Read full review	Efficient product Good value for money You dont have to depend on external services Incentivized Verified User Anonymous Read full review
ScreenShots		pganalyze Screenshots