doc

    Name:   dicthits.sql

    Author: Mark Gurry


The following script lists how effectively the dictionary cache is 
being used. If the getmisses exceeds the count by a significant margin,
you may need to increase your SHARED_POOL_SIZE. 

#


select count, getmisses 
  from v$rowcache
 where getmisses > count;