Recently, we felt that some guidance would be helpful when starting to look at an AWR report with a view to diagnosing Database Performance issues. The header of the report contains information that, while it might not directly identify the problem, provides a basis to review the rest of the report against. To that end we created an article: AWR Report Interpretation Checklist for Diagnosing Database Performance Issues (Doc ID 1628089.1) to highlight this information before you start looking at the top waits to find out where all your time is going.

Once you have scanned this information, guidance on how to approach the rest of the report can be found here: How to Use AWR Reports to Diagnose Database Performance Issues (