Enterprise Manager Database Management

Enterprise Manager Database Management

Oracle’s Database management capabilities make DBA lives easier by providing a full-lifecycle solution encompassing change and configuration management, patching, provisioning, testing, masking/subsetting, performance management and automatic tuning.

Documentation and Video

Documentation: Database Manageability

Documentation: Database Manageability

Video: Managing Your Hybrid Database Fleet with Oracle Enterprise Manager

Video: Drive Your Autonomous Future with Oracle Enterprise Manager

Solution Overview

Increase DBA productivity by 80% and reduce database testing time by 90%. Oracle Database and Oracle Enterprise Manager provide the most extensive self-management capabilities in the industry, ranging from zero-overhead instrumentation to integrated self-healing and full lifecycle management for Databases deployed anywhere: including on-premises, Exadata, Oracle Cloud, Exadata Cloud and third-party clouds. Oracle Enterprise Manager's Database Management capabilities include the following key features:

  • Performance management using Automatic Workload Repository (AWR), AWR Warehouse, Automatic Database Diagnostics Monitor (ADDM), AWR Baselines and Adaptive Thresholds, ASH Analytics
  • Application Tuning using SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Database Operations Monitoring
  • Response Time Testing using SQL Performance Analyzer, SPA Quick Check
  • Throughput Testing using Database Replay

Oracle Enterprise Manager's industry-leading Database performance management capabilities are available in the Diagnostics Pack, Tuning Pack and Real Application TestingDatabase Options.

Oracle Enterprise Manager's industry-leading Database lifecycle management capabilities are available in the Database Lifecycle Management Pack and Cloud Management Pack for Oracle Database.