Oracle AWR Report

AWR is Oracle’s mechanism for gathering and preserving statistics useful for performance analysis. Oracle 10g introduced a new background process, MMON (Manageability Monitor), to do this work. Every 15 minutes, it takes a snapshot of statistics needed for performance tuning and diagnostics. Snapshots older than one week are automatically purged. Snapshot data is stored in a set of tables in the SYSAUX tablespace; these tables are owned by SYS. AWR is fully Oracle RAC aware and is active by default on all the instances. One of the MMON processes acts as the master and coordinates snapshots on all the active instances. AWR takes concurrent snapshots on all the instances and statistics from all the instances stored in the AWR ...

Get Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.