Oracle 11g AWR series five: How do I generate an AWR report?

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?