Generating Automatic Workload Repository Reports:
Oracle provide following scripts to produce Automatic workload repository reports . They are similar in format to the statspack reports and give the option of HTML or plain text formats. The reports can be generated as follows.
SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql — To generate an AWR report
SQL> @$ORACLE_HOME/rdbms/admin/awrrpti.sql — To generate an AWR report on a specific database instance.
SQL> @$ORACLE_HOME/rdbms/admin/awrgrpt.sql — To generate an AWR report in an Oracle RAC environment.
SQL> @$ORACLE_HOME/rdbms/admin/awrgrpti.sql — To generate an AWR report on a specific database instance in an Oracle RAC environment.
SQL> @$ORACLE_HOME/rdbms/admin/awrsqrpt.sql — To generate an AWR report for a particular SQL statement.
SQL> @$ORACLE_HOME/rdbms/admin/awrsqrpti.sql — To generate an AWR report for a particular SQL statement on a specified database instance.
SQL> @$ORACLE_HOME/rdbms/admin/awrddrpt.sql — To generate an AWR Compare Periods report.
SQL> @$ORACLE_HOME/rdbms/admin/awrddrpti.sql — To generate an AWR Compare Periods report on a specified database instance.
SQL> @$ORACLE_HOME/rdbms/admin/awrgdrpt.sql — To generate an AWR Compare Periods report in an Oracle RAC environment.
SQL> @$ORACLE_HOME/rdbms/admin/awrgdrpti.sql — To generate an AWR Compare Periods report on a specified database instance in an Oracle RAC environment.
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 opened in a browser or text editor accordingly.
Thank you for reading …..This is Airy…Enjoy 🙂