Oracle Enterprise Manager - A Comprehensive Enterprise-Wide Database System Management Tool
September 18, 2019

Oracle Enterprise Manager - A Comprehensive Enterprise-Wide Database System Management Tool

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Enterprise Manager

Oracle Enterprise Manager is being used by the database administrators in the IT department. It servers as an important tool and interface for database monitoring.
  • It manages all relevant targets (hosts, Oracle databases, and listeners) in one place
  • We can use it to quickly drill down an issue to its detail
  • In addition to monitoring and performance tuning, it can be used to present information effectively
  • It relies on a monitoring agent to be installed on monitored target hosts, and that dependency can be problematic at times
  • The performance of Oracle Enterprise Manager itself can be slow
  • It makes databases easier to manage, and enhances team collaboration
  • Alerts and reports are more accessible and manageable, which leads to quicker resolving of issues
  • We are able to present oracle databases performance status and history more effectively through graphics
Toad for Oracle is more suited for individual users who have a strong focus on database development, and it is not as comprehensive as Oracle Enterprise Manager. While it is quite decent in logical database layer tasks, such as schema objects and SQL, it lacks visibility into host level and I/O layer performance stats.
Oracle Enterprise Manager is well suited for monitoring multiple oracle database, especially RAC databases (where multiple hosts are involved in clusters). It is probably an overkill if just for one or two single instances. It is also good at troubleshooting complex performance issues with queries, when an effective time-based monitoring on multiple facets of the system (CPU, memory, I/O, and SQL plans, etc) is needed. It is a good tool to present such information as well, in a well laid out, graphical manner.

Oracle Enterprise Manager Feature Ratings

Remote monitoring
7
Multiple Server Monitoring
10
Multi-device monitoring
Not Rated
Automated alerts and notifications
8
Patch Management
7
Service configuration management
7
Software and hardware inventory
8
Policy-based automation
7
Performance data reports
9
Customizable reporting
7
Data visualization
10
Risk analysis
6
Data backup and recovery
7
Administrator access control
9