/*
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;