Skip to content
- Real time monitoring and notifications of system failures, workload, and limits or capacities (end to end, including hardware, software and configuration).
- 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.
- Real Time SQL and PL/SQL monitoring, interactive reports, and dashboards with drill down / back on specific SQL metrics and utilizations.
- 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.
- 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.
- ADDM – automated analysis of performance related settings and SQL underlying object structures.
- 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
- Extensibility for user defined metrics and automated actions on notifications or incidents.
- Integration into engineered systems – Exadata Cell information, Grid health information, and resource usage.
- Foundation for more automation and autonomous database features without autonomous (supporting customer existing environments and investments).
