SQL>@?/rdbms/admin/awrrpt.sql [会被解析为$ORACLE_HOME]
Current Instance
~~~~~~~~~~~~~~~~~~
DB id DB Name Inst Num Instance
588460999 PTLDB 1 ptldb
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文件]
Specify the number of days of snapsshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days(n) will result in the most recent
(n) days of snapshots being listed . Pressing without
specifying a number lists all completed snapshots.
Enter value for num_days:1 [系统列出1天内的报告列表]
Enter value for num_days:1
Listing the last day's Completed Snapshots
Instance DB Name Snap Id Snap Started Snap Level
ptldb PTLDB 7236 28 Dec 2010 00:00 1
7258 28 Dec 2010 21:25 1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap:7236[输入起始的快照,性能测试之前产生的]
Enter value for end_snap:7258[输入结束的快照,性能测试之后产生的]
Specify the Report Name
~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_7236_7258.html. To use this name,
press to continue,otherwise enter an alternative.
Enter value fro report_name:/home/oracle/awrrpt_1_7236_7258.html [输入报告文件名]
End of Report