oracle 数据缓冲命中率

数据缓冲命中率 应接近1

 

select 1-a.PHYSICAL_READS/(a.DB_BLOCK_GETS+a.CONSISTENT_GETS) from v$buffer_pool_statistics a

 

或者

    select round((1- sum(decode(name,'physical reads',value,0))/
    (sum(decode(name,'db block gets',value,0)) + sum(decode(name,'consistent gets',value,0)))),2)
 from v$sysstat

 

 

比较下可以看出关键字段：db_block_gets 、consistent_gets、physical_reads