티스토리 뷰
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 |
- Total
- Today
- Yesterday
- 아이폰4
- PL/SQL
- iPhone
- 인덱스
- iOS5
- PostgreSQL
- SQLPlus
- 테이블정보
- Backup
- 오라클
- tablespace
- 갤럭시S
- 출시일
- linux
- MS-SQL
- 리눅스
- index
- parameter
- 아이폰
- postgresql.conf
- oracle
- 윈도우
- mysql
- 투싼
- 컬럼정보
- 독도
- Flashback
- recovery
- 한글
- Managing Schema Objects
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |