Buffer Cache Hit Ratio
S SELECT substr((1-(phy.value/(cur.value + con.value)))*100,1,5)
"Buffer Cache Hit Ratio"
FROM v$sysstat cur, v$sysstat con, v$sysstat phy
WHERE cur.name = 'db block gets'
AND con.name = 'consistent gets'
AND phy.name = 'physical reads'
/
Library Cache Hit Ratio
SELECT substr(SUM(PINS-RELOADS)/SUM(PINS)*100,1,5) "Library Cache
Hit Ratio" FROM V$LIBRARYCACHE;
Dictionary Cache Hit Ratio
SELECT substr((SUM(GETS-GETMISSES))/SUM(GETS)*100,1,5) "Dictionary
Cache Hit Ratio" FROM V$ROWCACHE;
