连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
--执行脚本
SQL>@/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/awrrpt.sql;
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1316098433 ORCL 1 ORCL
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'
输入report_type的值: html
--按html格式导出
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 1316098433 1 ORCL ORCL 108.local
Using 1316098433 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 without
specifying a number lists all completed snapshots.
--导出天数
输入num_days的值: 1
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
ORCL ORCL 11300 23 12月2013 00:00 1
11301 23 12月2013 01:00 1
11302 23 12月2013 02:00 1
11303 23 12月2013 03:00 1
11304 23 12月2013 04:00 1
11305 23 12月2013 05:00 1
11306 23 12月2013 06:00 1
11307 23 12月2013 07:00 1
11308 23 12月2013 08:00 1
11309 23 12月2013 09:00 1
11310 23 12月2013 10:00 1
11311 23 12月2013 11:00 1
--起止Snap Id
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入begin_snap的值: 11300
Begin Snapshot Id specified: 11300
输入end_snap的值: 11310
End Snapshot Id specified: 11310
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_11300_11310.html. To use this name,
press to continue, otherwise enter an alternative.
--导出文件文件名,如果没有指定导出路径,oracle导出到当前目录。
输入report_name的值: /home/oracle/awrrpt20131223.html