Doc

   Name:   rowcache.sql

   Lists the data dictionary settings and the number of
   misses. 

#

SELECT parameter, count, getmisses 
FROM    v$rowcache
WHERE getmisses > count;

SELECT SUM(gets) "Gets", SUM(misses) "Misses", 
   TO_CHAR(SUM(getmisses) / 
     SUM(gets) * 100 , ‘999.99’)||’%’ "Miss Ratio"
 FROM v$rowcache;