AWR
S SYS> desc
dba_hist_snapshot
Name
Null? Type
-----------------------------------------------------------
--------
----------------------------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
STARTUP_TIME
NOT NULL
TIMESTAMP(3)
BEGIN_INTERVAL_TIME NOT
NULL
TIMESTAMP(3)
END_INTERVAL_TIME NOT
NULL
TIMESTAMP(3)
FLUSH_ELAPSED
INTERVAL DAY(5) TO
SECOND(1)
SNAP_LEVEL
NUMBER
ERROR_COUNT
NUMBER
S SYS> select SNAP_ID,STARTUP_TIME from dba_hist_snapshot order by SNAP_ID;
SNAP_ID STARTUP_TIME
----------
------------------------------------------------------------------------
---
63 03-JUN-09 04.15.34.000 PM
64 03-JUN-09 04.15.34.000
PM
95 18-JUN-09 01.37.45.000 PM
96 18-JUN-09 01.37.45.000
PM
97 18-JUN-09 01.37.45.000 PM
98 18-JUN-09 01.37.45.000
PM
99 18-JUN-09 01.37.45.000 PM
100 18-JUN-09 01.37.45.000
PM
101 18-JUN-09 01.37.45.000 PM
102 19-JUN-09 04.23.05.000
PM
103 19-JUN-09 04.23.05.000 PM
104 22-JUN-09 03.09.26.000
PM
105 22-JUN-09 03.55.02.000 PM
106 22-JUN-09 04.31.41.000
PM
107 22-JUN-09 04.31.41.000 PM
108 23-JUN-09 02.36.02.000
PM
109 23-JUN-09 02.36.02.000 PM
110 23-JUN-09 02.36.02.000
PM
111 23-JUN-09 02.36.02.000 PM
112 24-JUN-09 02.17.55.000
PM
113 24-JUN-09 02.17.55.000 PM
114 24-JUN-09 02.17.55.000
PM
115 24-JUN-09 02.17.55.000 PM
116 25-JUN-09 02.28.27.000
PM
'DataBase > Oracle' 카테고리의 다른 글
| Admin 2. 11장 Managing Storage (실제 저장공간,t/s) (0) | 2012.10.18 |
|---|---|
| Admin 2. 10장 Managing Schema Objects (0) | 2012.10.18 |
| Admin 2. 08장 Monitoring and Manaing Memory (0) | 2012.10.18 |
| Admin 2. 07장 Dealing with Database Corruption (0) | 2012.10.18 |
| Admin 2. 06장 Flashback (0) | 2012.10.18 |