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
Oracle缓冲区命中率查询脚本
Oracle缓冲区命中率查询脚本select ((1-( ( sum(decode(name, 'physical reads',value,0) ) - ( sum(decode(name, 'physical re...
点击下载文档
本文2024-09-16 22:23:01发表“eas cloud知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-eas-47777.html
相关文章
您需要登录后才可以发表评论， 登录登录 或者 注册
最新文档
热门文章
