①首先进入$ORACLE_HOME/rdbms/admin目录
[oracle@host02 ~]$ cd $ORACLE_HOME/rdbms/admin
该目录下
[oracle@host02 admin]$ ls -l awrrpt.sql
-rw-r--r-- 1 oracle oinstall 1999 Oct 24 2003 awrrpt.sql
以SYSDBA身份登录运行@awrrpt
SQL> @awrrpt Current Instance
~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
241462155 ORA11GR2 1 ORA11GR2 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: Type Specified: html Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 241462155 1 ORA11GR2 ORA11GR2 host02 Using 241462155 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: 1 Listing the last day's Completed Snapshots Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
ORA11GR2 ORA11GR2 19 15 Oct 2016 18:37 1
20 15 Oct 2016 19:00 1 Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 19
Begin Snapshot Id specified: 19 Enter value for end_snap: 20
End Snapshot Id specified: 20 Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_19_20.html. To use this name,
press <return> to continue, otherwise enter an alternative. Enter value for report_name: Using the report name awrrpt_1_19_20.html