AWR报告提取

SQL> @?/rdbms/admin/awrrpt.sql                oracle自带的的脚本文件

Current Instance
~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1265701968 ASMCA 1 asmca

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
------------ -------- ------------ ------------ ------------
* 1265701968 1 ASMCA asmca oracle

Using 1265701968 for database Id
Using 1 for instance number

Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.

Enter value for num_days: 2　　　　　　　　指定要选择的快照的天数

Listing the last 2 days of Completed Snapshots

Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
asmca ASMCA 1 15 Dec 2017 23:00 1
2 16 Dec 2017 00:00 1
3 16 Dec 2017 01:00 1
4 16 Dec 2017 02:00 1

5 15 Dec 2017 17:00 1
6 15 Dec 2017 18:00 1

 

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 2
Begin Snapshot Id specified: 2

Enter value for end_snap: 4　　　　　　　　　　　　指定开始和结束快照id
End Snapshot Id specified: 4

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_2_4.html. To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:                                         指定报告名称，默认就好

End of Report
</body></html>
Report written to awrrpt_1_2_4.html
SQL> exit