这个查询会对丢失率大于10%的查询前加上星号
select r.PARAMETER,
r.GETS,
r.GETMISSES,
r.MODIFICATIONS,
r.FLUSHES,
(r.GETMISSES / decode(r.GETS, 0, 1, r.GETS)) getmiss_ratio,
(case
when (r.GETMISSES / decode(r.GETS, 0, 1, r.GETS)) > .1 then
'*'
else
''
end) " "
from v$rowcache r
where r.GETS + r.GETMISSES <> 0;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25964700/viewspace-707347/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25964700/viewspace-707347/