Time Model - Connection management,
PL/SQL compilation, parse, SQL execution, and PL/SQL
execution are available
SQL Statistics - SQL statistics
Java time and
wait-class time, bind variables, efficient top SQL based on
CPU, elapsed and parse statistics.
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.