以下SQL为查询数据库命中率的SQL指令:
SQL Command:
select 1-(a.value / (b.value + c.value) ) “Hit Percent”
from
(select value from v$sysstat where name = ‘physical reads’) a,
(select value from v$sysstat where name = ‘db block gets’) b,
(select value from v$sysstat where name = ‘consistent gets’) c
;

————————————————————————————————————
Ending。

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装