librarycache命中率:
select sum(pinhits)/sum(pins)*100 from v$librarycache
rowcache命中率:
select sum(gets),sum(getmisses),100*sum(gets-getmisses)/sum(gets) from v$rowcache where gets>0
librarycache命中率:
select sum(pinhits)/sum(pins)*100 from v$librarycache
rowcache命中率:
select sum(gets),sum(getmisses),100*sum(gets-getmisses)/sum(gets) from v$rowcache where gets>0