Personal tools
You are here: Home → Oracle → How To's → How to check the Database Hit-Ratio
Navigation
Log in


Forgot your password?
 
Document Actions

How to check the Database Hit-Ratio

Hit-Ratio :

SELECT  (1-(pr.value/(dbg.value+cg.value)))*100
FROM    v$sysstat pr, v$sysstat dbg, v$sysstat cg
WHERE   pr.name = 'physical reads'
AND     dbg.name = 'db block gets'
AND     cg.name = 'consistent gets';
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls