Oracle 11g AWR how to generate AWR report

This article mainly introduces the Oracle 11g AWR how to generate AWR report, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1. Generate a single instance AWR report:

@ $ORACLE_HOME/rdbms/admin/awrrpt.sql

two。 Generate an Oracle RAC AWR report:

@ $ORACLE_HOME/rdbms/admin/awrgrpt.sql

3. Generate an AWR report for a specific database instance in the RAC environment:

@ $ORACLE_HOME/rdbms/admin/awrrpti.sql

4. The method of generating AWR reports for multiple database instances in an Oracle RAC environment:

@ $ORACLE_HOME/rdbms/admin/awrgrpti.sql

5. Generate an AWR report for the SQL statement:

@ $ORACLE_HOME/rdbms/admin/awrsqrpt.sql

6. Generate an AWR report for a SQL statement on a specific database instance:

@ $ORACLE_HOME/rdbms/admin/awrsqrpi.sql

-- generate AWR period comparison report

7. Generate a single instance AWR period comparison report

@ $ORACLE_HOME/rdbms/admin/awrddrpt.sql

9. Generate Oracle RAC AWR period comparison report

@ $ORACLE_HOME/rdbms/admin/awrgdrpt.sql

10. Generate AWR period comparison report for a specific database instance

@ $ORACLE_HOME/rdbms/admin/awrddrpi.sql

11. Generate an AWR period comparison report for specific (multiple) database instances in Oracle RAC environment

@ $ORACLE_HOME/rdbms/admin/awrgdrpi.sql

Thank you for reading this article carefully. I hope the article "how to generate AWR report from Oracle 11g AWR" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and follow the industry information channel. More related knowledge is waiting for you to learn!