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;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8289905/viewspace-917336/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
