오라클 캐쉬 히트율 확인

라이브러리 캐시 Hit율

select sum(pins), sum(reloads), sum(pins)*100/sum(pins+reloads)"Pin Hit%"

from v$librarycache;

 

딕셔너리 캐시 Hit율

select sum(getmisses), sum(gets), sum(getmisses)*100/sum(gets)"MISS%"

from v$rowcache;

버퍼캐시 히트율 확인

select 1 - (phy.value - lob.value - dir.value) / ses.value "CACHE HIT RATIO"

from v$sysstat ses, v$sysstat lob,

v$sysstat dir, v$sysstat phy

where ses.name = 'session logical reads'

and dir.name='physical reads direct'

and lob.name='physical reads direct (lob)'

and phy.name='physical reads';