Oracle 收集AWR的SNAPSHO报告

#su - oracle
$ pwd
/home/oracle
$ sqlplus / as sysdba

SQL> @?/rdbms/admin/awrrpt.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: html

Type Specified: html

（今天的选1.2两天的选择2）

Enter value for num_days: 1

因为是整点取得，所以最好跑脚本在这一个时间段内取；开始结束ID 就是时间点的值

Enter value for begin_snap: 11693
Begin Snapshot Id specified: 11693

Enter value for end_snap: 11693
End Snapshot Id specified: 11693

---此生成的报告就存在了Oracle目录下，然后再通过ftp工具下载就好了

Oracle 收集AWR的SNAPSHO报告

原文：https://www.cnblogs.com/lyxbyg/p/13600435.html