sql @?/rdbms/admin/awrrpt.sql current instance ~~~~~~~~~~~~~~~~ db id db name inst num instance ———– ———— ——– ———— 3393548168 xff 1 xff specify the report type ~~~~~~~~~~~~~~~~~~~~~~~ would you like an html report, or a plai
sql> @?/rdbms/admin/awrrpt.sql
current instance
~~~~~~~~~~~~~~~~
db id db name inst num instance
———– ———— ——– ————
3393548168 xff 1 xff
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
———— ——– ———— ———— ————
* 3393548168 1 xff xff xifenfei-pc
using 3393548168 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 的值: 2[天数]
listing the last 2 days of completed snapshots
snap
instance db name snap id snap started level
———— ———— ——— —————— —–
xff xff 119 22 4月 2011 21:22 1
120 22 4月 2011 21:40 1
121 22 4月 2011 21:40 1
122 22 4月 2011 22:02 1
123 22 4月 2011 22:30 1
124 22 4月 2011 23:00 1
125 22 4月 2011 23:30 1
126 23 4月 2011 00:00 1
specify the begin and end snapshot ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入 begin_snap 的值: 120[起始快照号]
begin snapshot id specified: 120
输入 end_snap 的值: 125[结束快照号]
end snapshot id specified: 125
specify the report name
~~~~~~~~~~~~~~~~~~~~~~~
the default report file name is awrrpt_1_120_125.html. to use this name,
press to continue, otherwise enter an alternative.
输入 report_name 的值: xifenfei.html[文件名]
[回车执行]