Additional statistics

 

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