AWR 生成步骤

$cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
conn /as sysdba;

SQL> exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (flush_level=>'ALL');

PL/SQL procedure successfully completed.

SQL> exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (flush_level=>'ALL');

PL/SQL procedure successfully completed.

SQL> 　@?/rdbms/admin/awrrpt.sql

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

DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1578307715 ZXHS 1 zxhs

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
------------ -------- ------------ ------------ ------------
* 1578307715 1 ZXHS zxhs localhost.lo
caldomain

Using 1578307715 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.

Enter value for num_days: 2

Listing the last 2 days of Completed Snapshots

Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
zxhs ZXHS 3212 23 Jan 2011 00:00 1
3213 23 Jan 2011 01:00 1
3214 23 Jan 2011 02:00 1
3215 23 Jan 2011 03:00 1
3216 23 Jan 2011 04:00 1
3217 23 Jan 2011 05:00 1
3218 23 Jan 2011 06:00 1
3219 23 Jan 2011 07:00 1
3220 23 Jan 2011 08:00 1
3221 23 Jan 2011 09:00 1
3222 23 Jan 2011 10:00 1
3223 23 Jan 2011 11:00 1
3224 23 Jan 2011 12:00 1
3225 23 Jan 2011 13:00 1
3226 23 Jan 2011 14:00 1
3227 23 Jan 2011 15:00 1
3228 23 Jan 2011 16:00 1
3229 23 Jan 2011 17:00 1
3230 23 Jan 2011 18:00 1
3231 23 Jan 2011 19:00 1
3232 23 Jan 2011 20:00 1
3233 23 Jan 2011 21:00 1
3234 23 Jan 2011 22:00 1
3235 23 Jan 2011 23:01 1
3236 24 Jan 2011 00:01 1
3237 24 Jan 2011 01:01 1
3238 24 Jan 2011 02:01 1
3239 24 Jan 2011 03:01 1
3240 24 Jan 2011 04:00 1
3241 24 Jan 2011 05:00 1
3242 24 Jan 2011 06:00 1
3243 24 Jan 2011 07:00 1
3244 24 Jan 2011 08:00 1
3245 24 Jan 2011 09:00 1
3246 24 Jan 2011 10:00 1
3247 24 Jan 2011 11:00 1
3248 24 Jan 2011 12:00 1
3249 24 Jan 2011 13:00 1
3250 24 Jan 2011 14:00 1
3251 24 Jan 2011 15:00 1
3252 24 Jan 2011 15:09 2
3253 24 Jan 2011 15:09 2

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

Enter value for end_snap: 3253

指定生成的名字：awr_zxhs
生成的路径在（$cd $ORACLE_HOME/rdbms/admin，也就是"sqlplus"登录地点）

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22934571/viewspace-1045109/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22934571/viewspace-1045109/