If you were talking to someone whose organization is considering Oracle Enterprise Manager, what would you say?
How would you rate it and why? Any other tips or advice?
Enterprise Manager Cloud Control monitoring functionality permits unattended monitoring of your IT environment. Enterprise Manager comes with a comprehensive set of performance and health metrics that allows monitoring of key components in your environment, such as applications, application servers, databases, as well as the back-end components on which they rely (such as hosts, operating systems, storage).
The Management Agent on each monitored host monitors the status, health, and performance of all managed components (targets) on that host. If a target goes down, or if a performance metric crosses a warning or critical threshold, an event is triggered and sent to Enterprise Manager. Administrators or any interested party can be notified of the triggered event through the Enterprise Manager notification system.
This solution is the best! It's perfect! I would rate this solution a ten out of ten.
If you are an Oracle shop, or even an Oracle SI, then familiarity with Oracle one stop management solution is an imperative. Everything ties into this solution, so it has become a de facto standard for Oracle-based software given that the base is free to use with Oracle products. There is no downside to deploying this solution in your data center.
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.
If you have a license contract with Oracle and if you have a lifetime agreement on service on any product from Oracle then this product is worth using. Otherwise it's best to explore the option of using an open source product. Not worth it for start up companies.
Analyze your daily monitoring and service intervention needs, based upon the available (or target) headcount, otherwise you may find yourself inundated with more alerts and notifications than can actually be handled by your staff. Don't just turn on all the alerting and notifications out of the box. Start with what you know you want and are capable of responding to, and closing effectively. Enable those. Then work outwards towards the nice-to-know, or discovery alerts. Currently, depending on your implementation and use timeframe, you may also want to evaluate the Oracle Management Cloud solutions, which are similar, but different in that they employ a pay-as-you-go approach to the monitoring and management cycle. The On-Premise OEM solution works best for dynamically growing environments (that tend to get bigger and bigger over time) or for stable complex environments that will be in-place for the next 10 or more years.
The product is very powerful and should be used to automate more key DBA type tasks. Performance tuning bad SQL becomes extremely simplified as long as you leverage the out of box capabilities and you have purchased the Tuning and Diagnostic Pack. Those are a must have to really take advantage of the capabilities.