PROD->SELECT name, 1-(physical_reads / (consistent_gets + db_block_gets ) )
2 “HIT_RATIO” FROM V$BUFFER_POOL_STATISTICS
3 WHERE ( consistent_gets + db_block_gets ) !=0;
NAME HIT_RATIO
——————– ———-
KEEP .999922843
RECYCLE .618495732
DEFAULT .86601863
For more information about buffer pool : http://jonathanlewis.wordpress.com/2007/09/05/hit-ratios-2/
