OEM Oracle's swiss army knife
September 08, 2017

OEM Oracle's swiss army knife

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

Overall Satisfaction with Oracle Enterprise Manager

We monitor databases, schedule RMAN backups, provision databases, patching, user management, space management and run reports in BI Publisher.
  • Gives a big picture view your Oracle infrastructure, and plug-ins for SQL Server, IIS if needed.
  • Manages jobs in each instance using dbms_scheduler package.
  • Integrates with Oracle support for patch download, applies patches.
  • Manages space in tablespaces, data files. Alerts set to your comfort level for warning critical thresholds.
  • Interface clunky at times. Some space management is faster in SQL Developer DBA tool. Their free tool works well.
  • Setup of default page gets lost at times. Bug?
  • Managing a script run across databases. The default is backwards. SYSDBA should be the default. Not normal.
  • Positive ROI. Console view allows big picture of all components. Faster to develop new databases, do maintenance or fix problems.
SQL Developer DBA module allows user, space management, SQL Tuning, ad-hoc queries, and schema management. Great free product supported and enhanced from Oracle.
Job management, provisioning, patching, space management