Shulou(Shulou.com)06/01 Report--

# # how to collect AWR?

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

8. Generate Oracle RAC AWR period comparison report

@ $ORACLE_HOME/rdbms/admin/awrgdrpt.sql

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

@ $ORACLE_HOME/rdbms/admin/awrddrpi.sql

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

@ $ORACLE_HOME/rdbms/admin/awrgdrpi.sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.