OEM rocks!
March 26, 2019
OEM rocks!
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Enterprise Manager
We use Oracle Enterprise Manager including the Diagnostic and Tuning Packs to monitor and administer over 200 production and non-production Oracle databases on about 30 Linux servers. These databases are used across our entire company and range from 50 GB to 30 TB. We have SAP, Hyperion, and homegrown applications using the databases. OEM allows me (a single Oracle DBA) to maintain a large amount of complicated database including Oracle RAC, Oracle single instance, and Oracle Dataguard standby databases. It also provides monitoring of servers, storage, network, listeners, and agents.
- OEM is fantastic at monitoring databases and servers. It is a single place to check the enterprise-wide database, listener, agent, and server status. You can set thresholds on many metrics including space at the operating system level and the database level.
- OEM can easily push agents to remote servers.
- Once an agent is deployed to a server, it can easily be configured to monitor the server, databases, listener, and agent with various thresholds on many metrics. Alerts can be viewed on the OEM Console or via email.
- OEM can be used to administer databases. Any function that can be done in an SQLplus command line can also be done in OEM. A few such tasks are tablespace management, user management, table/index/object management, etc.
- OEM can be used to implement Dataguard Standby databases.
- OEM can be used to monitor backups in real time.
- OEM can be used to monitor SQL real time. The Diagnostic and Tuning Packs allow you to create SQL Profiles for slow SQL that can increase run times by 1000s of percents.
- There can be some bugs in OEM. Usually there is a workaround, but sometimes you might need to install a patch.
- We can monitor and administer many databases with only one Oracle DBA so it has a huge positive impact on ROI.
OEM is better and cheaper at managing Oracle databases.