SQL> sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 – Production on 星期一 4月 8 10:04:35 2013
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn ds/ds@192.168.50.203_sjcj
已连接。
SQL> @?\RDBMS\ADMIN\awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
———– ———— ——– ————
503803200 SJCJ 1 sjcj
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
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
———— ——– ———— ———— ————
* 503803200 1 SJCJ sjcj WIN08-203
Using 503803200 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.
输入 num_days 的值:7
Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
sjcj SJCJ 5900 07 4月 2013 19:00 1
5901 07 4月 2013 20:00 1
5902 07 4月 2013 21:00 1
5903 07 4月 2013 22:00 1
5904 07 4月 2013 23:00 1
5905 08 4月 2013 00:00 1
5906 08 4月 2013 01:00 1
5907 08 4月 2013 02:00 1
5908 08 4月 2013 03:00 1
5909 08 4月 2013 04:00 1
5910 08 4月 2013 05:00 1
5911 08 4月 2013 06:00 1
5912 08 4月 2013 07:00 1
5913 08 4月 2013 08:00 1
5914 08 4月 2013 09:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入 begin_snap 的值:5900
Begin Snapshot Id specified: 5900
输入 end_snap 的值:5914
