select (select SUM(pins) FROM v$librarycache)/((select SUM(pins) FROM v$librarycache)+(select SUM(reloads) FROM v$librarycache))*100 from dual;
--库高速缓存(Library Cache)
SELECT (1-(SUM(getmisses)/(SUM(gets)+SUM(getmisses))))*100 FROM v$rowcache;
--Dictionary Cache 命中率
SELECT (1-(SELECT value FROM V$SYSSTAT WHERE name='physical reads')/((SELECT value FROM V$SYSSTAT WHERE name='db block gets')+(SELECT value FROM V$SYSSTAT WHERE name='consistent gets')))*100
FROM DUAL;
--高速缓存命中率
阅读(853) | 评论(0) | 转发(0) |