Check for Dictionary Cache

ttitle off
btitle off

prompt
prompt Ratio Should be < 15%
prompt

select sum(getmisses), sum(gets)
, (sum(getmisses) * 100)/sum(gets) "Misses To Gets Ratio"
from v$rowcache
/

select parameter, getmisses, gets
from v$rowcache
/