Personal tools
You are here: Home → Oracle → How To's → Buffer Cache Hit Ratio for multiple pools
Navigation
Log in


Forgot your password?
 
Document Actions

Buffer Cache Hit Ratio for multiple pools

Buffer Cache Hit Ratio for multiple pools


SELECT name,1-(physical_reads/(db_block_gets + consistent_gets)) "Hit Ratio" FROM v$buffer_pool_statistics WHERE db_block_gets + consistent_gets > 0
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls