Automatic Workload Repository

• Time Model - Connection management, PL/SQL compilation, parse, SQL execution, and PL/SQL execution are available using v$sys_time_model.
   

• SQL Statistics - SQL statistics include PL/SQL Java time and wait-class time, bind variables, efficient top SQL based on CPU, elapsed and parse statistics.

Automatic Database Diagnostic Monitor

Automatic Database Diagnostic Monitor (ADDM) analyzes the information collected by the AWR for database performance problems including top SQL statements. The database automatically captures statistical information from the SGA and stores the information inside the workload repository in the form of snapshots in one hour intervals. These snapshots are written to disk and are similar to STATSPACK snapshots, except they are more detailed in nature.

The ADDM is also scheduled to run the MMON process automatically on every database instance to detect problems proactively. Every time a snapshot is taken, the ADDM triggers an analysis of the period corresponding to the last two snapshots. Although this automatic analysis covers the previous two snapshots, ADDM can analyze across any two snapshots.