oracle内存组件命中率

1. data buffer命中率（HIT RATIO的值不低于90%）：
select 1-(phy.value/(cur.value+con.value)) "HIT RATIO" from v$sysstat cur, v$sysstat con, v$sysstat phy where cur.name='db block gets' and con.name='consistent gets' and phy.name='physical reads';

2.dictionary cache命中率（Data Dictionary Hit Ratio的值不低于95%）：
select 1-(sum(getmisses)/sum(gets)) "Data Dictionary Hit Ratio" from v$rowcache;

3.library cache命中率（Library cache Hit Ratio的值不低于99%）
select 1-(sum(reloads)/sum(pins)) "Library cache Hit Ratio" from v$librarycache;