oracle 性能参数查询

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;
--高速缓存命中率