Awr / Ash Report, Oracle

AWR Reports Rac and Single Oracle Database

1) AWR various Report.

SQL> @?/rdbms/admin/awrsqrpt.sql –> awr report for only single sql_id
SQL> @?/rdbms/admin/awrrpt.sql –> Traditional awr report for instance.

2) RAC Related awr Report

In 11gR2 there are two new scripts awrgrpt.sql AND awrgdrpt.sql for RAC

SQL> @?/rdbms/admin/awrgrpt.sql — AWR Global Report (RAC) (global report)
SQL> @?/rdbms/admin/awrgdrpt.sql — AWR Global Diff Report (RAC)

Other important scripts under $ORACLE_HOME/rdbms/admin

SQL> @?/rdbms/admin/spawrrac.sql — Server Performance RAC report
SQL> @?/rdbms/admin/awrsqrpt.sql — Standard SQL statement Report
SQL> @?/rdbms/admin/awrddrpt.sql — Period diff on current instance
SQL> @?/rdbms/admin/awrrpti.sql — Workload Repository Report Instance (RAC)