Buffer Hit Ratio

1. SELECT 1 -(SUM(DECODE(NAME, 'physical reads', VALUE, 0))/
(SUM(DECODE(NAME, 'db block gets', VALUE, 0))+
(SUM(DECODE(NAME, 'consistent gets', VALUE, 0))))) "Buffer Hit Ratio"
FROM v$sysstat;

2. SELECT 1-(physical_reads)/(consistent_gets+db_block_gets) AS buffer_BIT_Ratio
FROM v$buffer_pool_statistics;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8289905/viewspace-917336/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8289905/viewspace-917336/