--数据高速缓存区命中率
--计算公式:1-(physical reads / (db block gets + consistent gets))
--命中率应大于0.90最好
select name,value
from v$sysstat
where name in ('physical reads','db block gets','consistent gets')
/
--共享区库缓存区命中率
--计算公式:SUM(pins - reloads) / SUM(pins)
--命中率应大于0.99
select sum(pins-reloads)/sum(pins)
from v$librarycache
/
--共享区字典缓存区命中率
--计算公式:SUM(gets - getmisses - usage -fixed) / SUM(gets)
--命中率应大于0.85
select sum(gets-getmisses-usage-fixed)/sum(gets)
from v$rowcache
/
--检测回滚段的争用
--SUM(waits)值应小于SUM(gets)值的1%
select sum(gets),sum(waits),sum(waits)/sum(gets)
--计算公式:1-(physical reads / (db block gets + consistent gets))
--命中率应大于0.90最好
select name,value
from v$sysstat
where name in ('physical reads','db block gets','consistent gets')
/
--共享区库缓存区命中率
--计算公式:SUM(pins - reloads) / SUM(pins)
--命中率应大于0.99
select sum(pins-reloads)/sum(pins)
from v$librarycache
/
--共享区字典缓存区命中率
--计算公式:SUM(gets - getmisses - usage -fixed) / SUM(gets)
--命中率应大于0.85
select sum(gets-getmisses-usage-fixed)/sum(gets)
from v$rowcache
/
--检测回滚段的争用
--SUM(waits)值应小于SUM(gets)值的1%
select sum(gets),sum(waits),sum(waits)/sum(gets)