Generating Various Types of AWR Reports

from http://www.dbaref.com/database-tuning/generatingvarioustypesofawrreports

 

Running a Basic ReportWith appropriate licenses for AWR, you may generate an AWR report by executing the following script and pick the two snapshots you want to use for the sample :

 

$ORACLE_HOME/rdbms/admin/awrrpt.sql Depending on the reasons for collecting the report, the default can be used, or for a more focused view, a short 10-15 minute snapshot could be used. You will also be asked for the format of the report (text or html) along with the report name. AWR reports can be generated by running various SQL scripts to satisfy various requirements. Each report is available in HTML or TXT format:  awrrpt.sql Displays various statistics for a range of snapshots Ids. awrrpti.sql  Displays statistics for a range of snapshot Ids on a specified database and instance. awrsqrpt.sql Displays statistics of a particular SQL statement for a range of snapshot Ids. Run this report to inspect or debug the performance of a particular SQL statement. awrsqrpi.sql  Displays statistics of a particular SQL statement for a range of snapshot Ids on a specified SQL. awrddrpt.sql Compares detailed performance attributes and configuration settings between two selected time periods.  awrddrpi.sql  Compares detailed performance attributes and configuration settings between two selected time periods on a specific database and instance.