O'Reilly logo

Oracle Database 11g Oracle Real Application Clusters Handbook, Second Edition by K Gopalakrishnan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required