$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"登录地点)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22934571/viewspace-1045109/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22934571/viewspace-1045109/