Database Tuning‎ > ‎

Generating Various Types of AWR Reports

posted Aug 31, 2011, 7:17 AM by Sachchida Ojha   [ updated Feb 2, 2012, 6:36 PM ]
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.

Comments