1. Real time monitoring and notifications of system failures, workload, and limits or capacities (end to end, including hardware, software and configuration).
  2. SQL Tuning Advisor can run through more tests and simulations, in a few minutes on a given SQL, than a person can in a few days.
  3. Real Time SQL and PL/SQL monitoring, interactive reports, and dashboards with drill down / back on specific SQL metrics and utilizations.
  4. Real Time database instance overview with ties to underlying OS and Hardware resources; key in on top utilization and drill down to SQL, Sessions, or even OS processes.
  5. AWR – historical performance data, as well as, basic analysis and reporting on top usage, top SQL, and automated suggestions on parameters changes, SQL changes, and overall recommendations.
  6. ADDM – automated analysis of performance related settings and SQL underlying object structures.
  7. ASH – historical review of SQL performance, ability to detect changes in SQL plan history, and bind variable usage.
    • We loose access to dictionary views:
      • dba_addm_ views, dba_hist ordba_advisor without it
      • Can’t access sql_monitor and sql_plan_monitor
  8. Extensibility for user defined metrics and automated actions on notifications or incidents.
  9. Integration into engineered systems – Exadata Cell information, Grid health information, and resource usage.
  10. Foundation for more automation and autonomous database features without autonomous (supporting customer existing environments and investments).