2012-12-27 11gR2 "Performance Tuning Guide" page 83

本文详细介绍了如何在 Oracle 环境中转移 Automatic Workload Repository (AWR) 数据，包括数据加载和从 SQL 命令行提取数据的过程。同时，提供了生成 RAC 的 AWR 报告、在特定数据库实例上生成 AWR 报告、为 SQL 语句生成 AWR 报告、性能比较报告和 ASH 报告的方法。

Transporting Automatic Workload Repository Data -- 转移AWR数据
Extracting AWR Data
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrextr.sql
A list of the databases in the AWR schema is displayed.

Loading AWR Data
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrload.sql

Generating an Oracle RAC AWR Report -- 生成RAC的AWR报告
The awrgrpt.sql SQL script generates an HTML or text report that displays
statistics for a range of snapshot IDs using the current database identifier and all
available database instances in an Oracle Real Application Clusters (Oracle RAC)
environment.
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrgrpt.sql

Generating an AWR Report on a Specific Database Instance -- 在某个单独的实例上生成AWR
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrrpti.sql

Generating an AWR Report for a SQL Statement -- 为SQL语句生成AWR
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

Generating an AWR Report for a SQL Statement on a Specific Database Instance -- 某实例的SQL语句生成AWR
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql

Generating an AWR Compare Periods Report -- 生成AWR性能比较报告
The awrddrpt.sql SQL script generates an HTML or text report that compares
detailed performance attributes and configuration settings between two selected time
periods.
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrddrpt.sql

Generating an Oracle RAC AWR Compare Periods Report -- 生成RAC的AWR性能比较报告
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrgdrpt.sql

Generating an AWR Compare Periods Report on a Specific Database Instance -- 生成某个实例上的AWR性能比较报告
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrddrpi.sql

Generating an Oracle RAC AWR Compare Periods Report on Specific Database
Instances -- 生成RAC的某个实例上的AWR性能比较
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrgdrpi.sql

Generating an ASH Report -- 生成ASH性能报告
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/ashrpt.sql

Generating an ASH Report on a Specific Database Instance
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/ashrpti.sql

Generating an Oracle RAC ASH Report
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/ashrpti.sql