Enterprise Manager-Your database Watchdog
September 29, 2017
Enterprise Manager-Your database Watchdog
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Enterprise Manager
We use Oracle EM to monitor multiple metrics across several of our databases including running processes, active sessions, tablespace and storage utilization, blocking sessions, and several other critical metrics. Oracle EM solves the issue of having to monitor different databases using scripts or linux reporting tools or mail alerts that can pass on cryptic data, but instead simplifies messages that indicate an issue with the database or database connections.
- Creates visuals and graphic indicators for monitoring critical database operations and states.
- Easily identify problematic connections, performance issues, blocking sessions, and identify sql code or scripts that are degrading database performance.
- Easily display AWR reporting or ASH analytic's with a few clicks.
- Easily set up jobs with Oracle scheduler, which you would have to otherwise script directly on the database.
- Connections to targets can become lost or dropped, resulting in the application not doing anything when clicking on a link, with no type of indication of what the issues is.
- Log outs from the console sometime do not complete, and users remain logged in, even after closing the browser session.
- The timeout function in the console has always been problematic, causing me to have to change the time out setting in the config file, whereas the option to disable the time outs on the console when the option comes up does not work. Selecting the option to disable timeouts still causes idle sessions to timeout.
- We have been alerted of critical issues that would have otherwise caused significant production downtime due to the comprehensive alert capabilities.
- Oracle EM has provided many suggestions on fine tuning various SQL to help improve SQL performance as well as database efficiency.
- We have been able to use visual indicators to monitor critical processes and connections at a glance, without having to spend significant time researching potential issues or performance problems.
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 upgrading of our Oracle databases.