Oracle AWR报告提取方法

本文旨在用来指导项目人员自行提取Oracle数据库的AWR报告.

1.当前连接实例的AWR报告提取：@?/rdbms/admin/awrrpt

2.RAC的其他实例AWR报告提取：@?/rdbms/admin/awrrpti

3.手工生成一个快照 

1.当前连接实例的AWR报告提取：@?/rdbms/admin/awrrpt

SQL> @?/rdbms/admin/awrrpt

//注意输入的@?/rdbms/admin/awrrpt 中间没有任何空格，需要在数据库服务器上Oracle用户登陆，sqlplus / as sysdba 进入SQL> 下执行.
Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
  857123342 JY                  1 jy1


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: 
//注意这里直接回车即可，默认就是html格式的
Type Specified:  html


Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
  857123342