Since the introduction of statspack and then AWR reports, it has become a specialist skill to be able to analyse these reports. This further become novelty if AWR reports are done on Exadata.
Any way I believe below notes can help in analyzing the AWR.
Automatic Workload Repository (AWR) Reports - Start Point (Doc ID 1363422.1)
FAQ: How to Use AWR reports to Diagnose Database Performance Issues (Doc ID 1359094.1)
Further to that I am going to add my own experience.
HOW TO GATHER AWR REPORT
there are two scripts comes with automatic workload repository reports (awrrpt.sql and awrrpti.sql). Both scripts generate similar report but the difference is that awrrpt.sql generate the consolidated report for a database whereas awrrpti.sql work per instance. The reports can be generated as follows.
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
@$ORACLE_HOME/rdbms/admin/awrrpti.sql
The scripts prompt you to enter the report format (html or text), the start snapshot id, the end snapshot id and the report filename. The resulting report can be opend in a browser or text editor accordingly.
You need to follow Top-Down Approach
. Report starts with settings overview
. Next provides Top-5 waits
. Use the Waits to guide further analysis
Any way I believe below notes can help in analyzing the AWR.
Automatic Workload Repository (AWR) Reports - Start Point (Doc ID 1363422.1)
FAQ: How to Use AWR reports to Diagnose Database Performance Issues (Doc ID 1359094.1)
Further to that I am going to add my own experience.
HOW TO GATHER AWR REPORT
there are two scripts comes with automatic workload repository reports (awrrpt.sql and awrrpti.sql). Both scripts generate similar report but the difference is that awrrpt.sql generate the consolidated report for a database whereas awrrpti.sql work per instance. The reports can be generated as follows.
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
@$ORACLE_HOME/rdbms/admin/awrrpti.sql
The scripts prompt you to enter the report format (html or text), the start snapshot id, the end snapshot id and the report filename. The resulting report can be opend in a browser or text editor accordingly.
You need to follow Top-Down Approach
. Report starts with settings overview
. Next provides Top-5 waits
. Use the Waits to guide further analysis
