Oracle Enterprise Manager Reviews

Provide 24x7 monitoring of application system availability for both on-premise, and on-cloud application systems, and forecasting data relating to overall system utilization (or under-utilization.)

With over 2,700 different target components deployed and in-use, it would be impossible for 4 DBA's to otherwise monitor and assess the condition of this number of separate application and database systems by individually logging into separate administration consoles for each product. The automation elements reduce the training time required to get our junior operators up to speed doing routine patching or cloning, and allow the senior staff to have more resource time available for strategic planning and ensuring overall availability of the critical systems without sacrificing proper monitoring and security awareness checking.

Recently, including new off-premises (cloud- based) application re-hosting, presents the challenge of whether to monitor cloud from on-premise, or vice-versa. We are currently experimenting with a cloud-watches-cloud plus on-premise-watches-on-premise approach.

I use Oracle Enterprise Manager for real-time monitoring. It allows me to see what SQL is running and which SQL is consuming a lot of time. It also provides a session browser to monitor which user is doing what.

Oracle Enterprise Manager helps me ensure I am connected to the right database and provides confidence in running operations in the correct region. It allows me to manage resources effectively and monitor active sessions.

It is a good tool for monitoring databases. It enhances the overall visibility within the database.

The older version of the product works with Flash technology. Although the latest version works with Java, it still requires Flash technology. It should utilize only a Java plugin to visualize your dashboard. Additionally, It is complicated to run it on Google Chrome.

We use OEM for managing Production, Test and Development environments. It provides a centralized location for proactively administering all database components with the ability to do much more.

SQL Tuning allows massive performance gains behind the scenes in order to more easily troubleshoot the most complex SQL statements. The use of SQL Profiles and creating SQL Baselines, makes improving SQL performance a less time consuming exercise. We've developed a number of monthly metrics we use to show our customer performance and any potential bottlenecks. In addition, we have set up a number of alerts for quickly addressing potential issues.

We use the platform to identify issues, find SQL that needs to be rewritten, and work with indexes. While some clients use it for scheduling backups, we predominantly focus on tuning. In our environment, which includes various client setups, we use Oracle Enterprise Manager to address reported slowdowns by analyzing SQL activity during specific timeframes to identify the root causes of performance issues.

The solution's most valuable feature is the ability to examine SQL code, track how many times it’s been parsed and used, and utilize this data for tuning. 

When we have a tuning problem, we use this solution. 

It's incredibly useful for drawing up the SQL that's being run, identifying and resolving a problematic SQL. You can monitor performance using the various performance data which is what some employees in the companies where I work use it for. 

The majority of the time, I use it to aid in the detection of a performance issue.

It makes things a lot faster. 

We used to have to try to run down the SQL by using queries against the database and run explain plans and go through a number of different processes by hand, which would be very time-consuming. I am pointing and clicking, seeing what the top SQL is in terms of performance and utilization, taking up resources, and I am more or less navigating through it to get to the problem. What used to take hours to solve a problem, can be done in a matter of minutes.