/*
Data dictionary cache miss ratio.
Looking for a good percentage hit rate.
*/
select sum(gets) “Gets”, sum(getmisses) “Misses”,
(1 – (sum(getmisses) / (sum(gets) +
sum(getmisses))))*100 “HitRate”
from v$rowcache;
How to get the data dictionary cache miss ratio