statistics name |
description |
recommend action |
redo log space requests |
리두 로그 파일에 공간 확보를 하기 위해 대기한 횟수 |
tune checkpoint, dbwr, archive process use bigger log file |
consistent changes |
consistent read를 위해 롤백된 횟수 |
Automatic undo management 사용 tune work load |
consistent gets |
consistent read모드로 읽은 블럭 수 |
Automatic undo management 사용 tune work load |
table fetch by continued row |
migration or chained rows |
reorganization |
조회 방법.
select name, value from v$sysstat where name like 'redo log space reque%'
union all
select name, value from v$sysstat where name like 'consistent changes%'
union all
select name, value from v$sysstat where name like 'con%'
union all
select name, value from v$sysstat where name like 'table fetch by continuted row';
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 124
consistent changes 930117
concurrency wait time 3854
consistent gets 4241014
consistent gets from cache 4191819
consistent gets from cache (fastpath) 2249943
consistent gets - examination 1670409
consistent gets direct 49195
consistent changes 930117
'Knowledge > Perfomance Tuning' 카테고리의 다른 글
수동통계수집(gathering statistics manually) (0) | 2015.12.29 |
---|---|
histogram 고려사항 (0) | 2015.12.29 |
자동 통계 수집(automatic statistics gathering) (0) | 2015.12.29 |
시스템 통계 수집(gathering system statististics) (0) | 2015.12.29 |
Common wait events (0) | 2015.12.19 |