Oracle缓冲区命中率查询脚本

栏目：eas cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

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,'consistent gets',value,0)) -( sum(decode(name, 'physical reads direct',value,0) ) + sum(decode(name, 'physical reads direct (lob)',value,0) ) )))) * 100) Hit_Ratio from v$sysstat

合格条件：>=90