SQL>exec dbms_workload_repository.create_snapshot();
or
SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sql
---------------------------------------------------------------
SQL> @/oracle/product/10g/rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
xxxx xxxx 1 xxxx
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
EXT
-----
.html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* xxxxx 1 xxxxx xxxx xxxxx
Using xxxxxxx 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: 3
Listing the last 3 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
--------- -------- --------- ------------------ -----
xxxxx xxxxx 15160 07 Apr 2014 00:00 1
15161 07 Apr 2014 01:00 1
15162 07 Apr 2014 02:00 1
15163 07 Apr 2014 03:00 1
15164 07 Apr 2014 04:00 1
15165 07 Apr 2014 05:00 1
15166 07 Apr 2014 06:00 1
15167 07 Apr 2014 07:00 1
15168 07 Apr 2014 08:00 1
15169 07 Apr 2014 09:00 1
15170 07 Apr 2014 10:00 1
15171 07 Apr 2014 11:00 1
15172 07 Apr 2014 12:00 1
15173 07 Apr 2014 13:01 1
15174 07 Apr 2014 14:00 1
15175 07 Apr 2014 15:00 1
15176 07 Apr 2014 16:00 1
15177 07 Apr 2014 17:01 1
15178 07 Apr 2014 18:00 1
15179 07 Apr 2014 19:00 1
15180 07 Apr 2014 20:00 1
15181 07 Apr 2014 21:00 1
15182 07 Apr 2014 22:00 1
15183 07 Apr 2014 23:00 1
15184 08 Apr 2014 00:00 1
15185 08 Apr 2014 01:00 1
15186 08 Apr 2014 02:00 1
15187 08 Apr 2014 03:00 1
15188 08 Apr 2014 04:00 1
15189 08 Apr 2014 05:00 1
15190 08 Apr 2014 06:00 1
15191 08 Apr 2014 07:00 1
15192 08 Apr 2014 08:00 1
15193 08 Apr 2014 09:00 1
15194 08 Apr 2014 10:00 1
15195 08 Apr 2014 11:00 1
15196 08 Apr 2014 12:00 1
15197 08 Apr 2014 13:00 1
15198 08 Apr 2014 14:00 1
15199 08 Apr 2014 15:00 1
15200 08 Apr 2014 16:00 1
15201 08 Apr 2014 17:00 1
15202 08 Apr 2014 18:00 1
15203 08 Apr 2014 19:00 1
15204 08 Apr 2014 20:01 1
15205 08 Apr 2014 21:00 1
15206 08 Apr 2014 22:00 1
15207 08 Apr 2014 23:00 1
15208 09 Apr 2014 00:00 1
15209 09 Apr 2014 01:00 1
15210 09 Apr 2014 02:00 1
15211 09 Apr 2014 03:00 1
15212 09 Apr 2014 04:00 1
15213 09 Apr 2014 05:00 1
15214 09 Apr 2014 06:01 1
15215 09 Apr 2014 07:00 1
Snap
Instance DB Name Snap Id Snap Started Level
--------- --------- --------- ------------------ -----
xxxxx xxxxx 15216 09 Apr 2014 08:00 1
15217 09 Apr 2014 09:00 1
15218 09 Apr 2014 10:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 15168
Begin Snapshot Id specified: 15168
Enter value for end_snap: 15178
End Snapshot Id specified: 15178
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_15168_15178.html. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name awrrpt_1_15168_15178.html
---------------------------------------------------------------
awrrpt_1_15168_15178.html 파일 확인
참고
http://blog.naver.com/kang_sok?Redirect=Log&logNo=60195243518
http://dbservice.kdb.or.kr/info/info_06.php?dbnum=126893&mode=detail
'Oracle(DB관련)' 카테고리의 다른 글
| oracle plsql debugging (0) | 2016.12.05 |
|---|---|
| sqlplus -prelim (0) | 2014.08.11 |
| flashback_transaction_query (0) | 2013.11.07 |
| windows7에 oracle 10g client 설치 (0) | 2013.06.20 |
| oracle redo log file (0) | 2012.10.31 |