##  DBA Command Post - dc_cache.sql

set numw 8

select substr(parameter,1,20) parameter, 
       gets, 
       getmisses misses, 
       decode(gets,0,100,round(100*getmisses/gets)) ratio,
       count, 
       usage, 
       decode(count,0, 100, round(100*usage/count)) capacity
from   sys.v_$rowcache
/