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报告

上一篇:洛谷P1551 找亲戚(并查集基础)


下一篇:Floyd算法 C语言实现