What is our primary use case?
We use Oracle Enterprise Manager primarily for database management, with a focus on performance monitoring.
Our environments are composed of both standalone and cluster databases which, in turn, are deployed in Oracle appliances like ODA and Exadata, as well as others hardware vendors.
In addition, we use the tool to create, configure and manage high-availability environments using Oracle Data Guard and Real Application Clusters, automation of manual activities and patching.
How has it helped my organization?
With Enterprise Manager, we have achieved a dramatic decrease in the number of database incidents. As a result, unplanned downtime has been reduced because we are resolving issues before the business is even aware of them.
What is most valuable?
The product has powerful features for diagnosis of database issues, complemented with tuning capabilities for most of the issues found.
With ASH Analytics, ADDM, Real-Time SQL Monitoring, SQL Tuning Advisor, we can measure SLAs, detect performance hotspots, perform deep diagnostics into specific tiers, tune applications, and remediate.
What needs improvement?
Oracle is always making improvements to Oracle Enterprise Manager. I think Enterprise cloud integration presents new management challenges.
For how long have I used the solution?
More than five years.
What do I think about the stability of the solution?
We always strive to have the latest version of this product, which has always helped to improve stability and performance.
What do I think about the scalability of the solution?
Yes, we encountered scalability issues. However, there are several techniques for achieving optimal performance. It can also help with capacity planning, sizing, and maximizing overall performance in a large scale environment.
Inadequately-sized Enterprise Manager deployments may result in the overall benefits of Enterprise Manager being compromised.
How is customer service and technical support?
How was the initial setup?
The initial setup is pretty straightforward. Today, you can even download the templates found on the Oracle website.
What's my experience with pricing, setup cost, and licensing?
The basic functions are free. You only pay license fees for advanced features.
Which other solutions did I evaluate?
I’ve been using this product for years. I evaluated other options from different vendors such as Foglight and SolarWinds, to name a couple.
What other advice do I have?
To me this is the best product for enterprise database management. I rate it a 10 out of 10.
Now, before you implement, you can do several tests with the Enterprise Manager templates VMS, available from Oracle. Also, check the compatibility matrix and try to always keep your system up to date.