Skip to content. | Skip to navigation
Hit-Ratio :
SELECT (1-(pr.value/(dbg.value+cg.value)))*100FROM v$sysstat pr, v$sysstat dbg, v$sysstat cgWHERE pr.name = 'physical reads'AND dbg.name = 'db block gets'AND cg.name = 'consistent gets';