awr报表生成方法

可以通过调用oracle数据库服务器里awrrpt.sql或awrrpti.sql生成awr报表。存储位置在$ORACLE_HOME/rdbms/admin之中。awrrpti.sql脚本与awrrpt.sql类不同就是在awrrpti.sql脚本中，可以指定数据库ID和实例ID。

以sys身份登录sqlplus.
运行@/home/oracle//app/oracle/product/10.2.0/db_1/rdbms/admin/awrrpti.sql命令。





SQL*Plus: Release 10.2.0.4.0 - Production on Sun Mar 6 00:30:12 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> @/home/oracle//app/oracle/product/10.2.0/db_1/rdbms/admin/awrrpti.sql

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: 

根据实际情况进行操作