Oracle缓冲区命中率查询脚本

select ((1-( ( sum(decode(name, 'physical reads',value,0) ) - ( sum(decode(name, 'physical reads direct',value,0) ) + sum(decode(name, 'physical reads direct (lob)',value,0) ) ) )/(sum(decode(name, 'db block gets',value,0)) +sum(decode(name,'consisten