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

Generate a single instance AWR report: (@ execution means @? / rdbms/admin/awrrpt.sql? Stands for $ORACLE_HOME)

@ $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

Please indicate the source of the author and the link to the original text for reprint:

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

@? rdbms/admin/awrrpt.sql is an extension of the previous statspack to collect information in more detail and view the long-term database, as opposed to ash.

@? rdbms/admin/ashrpt.sql looks at the current database because ash samples from v$session every second, and awr collects much more data than ash.

Generally, the collection of database information should be combined with awr and ash.

@? rdbms/admin/addmrpt. SQL is the equivalent of an expert residing in oracle and is a self-diagnostic engine. Generate symptom,problem,infomation, provide suggestions to solve problems, and automatically fix some specific failures.

@? rdbms/admin/awrinfo.sql displays information about awr, including snapshot information, sysaux space usage, awr components, ash, and so on.

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.