Oracle 11g AWR Series 5: how to generate AWR reports?

1. generate an AWR report for a single instance:

@ $ ORACLE_HOME/rdbms/admin/awrrpt. SQL

2. generate an Oracle rac awr report:

@ $ ORACLE_HOME/rdbms/admin/awrgrpt. SQL

3. Generate AWR reports for specific database instances in the RAC environment:

@ $ ORACLE_HOME/rdbms/admin/awrrpti. SQL

4. How to generate AWR reports for multiple database instances in the Oracle RAC environment:

@ $ ORACLE_HOME/rdbms/admin/awrkgti. SQL

5. generate an AWR report for the SQL statement:

@ $ ORACLE_HOME/rdbms/admin/awrsqrpt. SQL

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

@ $ ORACLE_HOME/rdbms/admin/awrsqrpi. SQL

-- Generate AWR period comparison report

7. Generate AWR period comparison report for a single instance

@ $ ORACLE_HOME/rdbms/admin/awrddrpt. SQL

9. Generate the Oracle rac awr period comparison report

@ $ ORACLE_HOME/rdbms/admin/awrgdrpt. SQL

10. Generate AWR period comparison reports for specific database instances

@ $ ORACLE_HOME/rdbms/admin/awrddrpi. SQL

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

@ $ ORACLE_HOME/rdbms/admin/awrgdrpi. SQL

For reprint, please indicate the author's source and original article link:

Http://blog.csdn.net/xiangsir/article/details/8661181