1. Generate a single-instance AWR report:
@ $ORACLE _home/rdbms/admin/awrrpt.sql
2. Generate the Oracle RAC AWR report:
@ $ORACLE _home/rdbms/admin/awrgrpt.sql
3. Generate an AWR report for a specific DB instance in the RAC environment:
@ $ORACLE _home/rdbms/admin/awrrpti.sql
4. How to generate AWR reports for multiple DB instances in an Oracle RAC environment:
@ $ORACLE _home/rdbms/admin/awrgrpti.sql
5. Generate the AWR report for the SQL statement:
@ $ORACLE _home/rdbms/admin/awrsqrpt.sql
6. Generate an AWR report for an SQL statement on a specific DB instance:
@ $ORACLE _home/rdbms/admin/awrsqrpi.sql
--Generate AWR Time Comparison report
7. Generate Single instance AWR time comparison report
@ $ORACLE _home/rdbms/admin/awrddrpt.sql
9. Generate Oracle RAC AWR time Comparison report
@ $ORACLE _home/rdbms/admin/awrgdrpt.sql
10. Generate the AWR time comparison report for a specific DB instance
@ $ORACLE _home/rdbms/admin/awrddrpi.sql
11. Generate AWR Time comparison report for specific (multiple) DB instances in an Oracle RAC environment
@ $ORACLE _home/rdbms/admin/awrgdrpi.sql
Reprint please indicate the source of the author and the original link:
http://blog.csdn.net/xiangsir/article/details/8661181
Oracle 11g AWR series five: How do I generate an AWR report?