Oracle AWR report Oracle Database Tips by Donald Burleson

See my notes on Reading Oracle AWR report and see the book Oracle Tuning: The Definitive Reference for a comprehensive treatment of AWR for Oracle tuning.  Also see these tips for Oracle AWR reports:

1. Oracle AWR SQL Tuning Scripts

2. Oracle AWR sysaux tablespace

3. Interpreting RAC AWR reports

4. Oracle STATSPACK vs. AWR

5. AWR script for physical disk reads

6. Oracle transportable AWR snapshots

7. Oracle Creating an AWR Report

8. Oracle AWR disk file statistics

The Oracle AWR report is the evolution of the STATSPACK report in Oracle 10g, and is invoked as follows:

$ORACLE_HOME/rdbms/admin/awrrpt.sql
$ORACLE_HOME/rdbms/admin/awrrpti.sql
$ORACLE_HOME/rdbms/admin/awrinput.sql

The AWR report was originally developed for Oracle Technical Support, and the sections of an AWR report are not well-documented.  Understanding the AWR report also requires significant Oracle AWR experience.  Here are details on reading the main sections of a STATSPACK and AWR report.

I have a whole chapter dedicated to reading a STATSPACK report (and the AWR report) in my new book "Oracle Tuning: The Definitive Reference".  It has a online code depot of downloadable AWR scripts.

You can also use Ion for Oracle to automate the generation of AWR deltas, in a more usable report format, with additional tips.

Click "Play" to take the tour or visit www.Ion-DBA.com