#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工具下载就好了