Oracle: V$ROWCACHE

select
   roc.parameter,
   roc.type,   
   roc.usage,   
   roc.count,
   roc.gets,   
   roc.cache#,
   roc.fastgets,
   roc.fixed,
   roc.flushes,
   roc.getmisses,
   roc.modifications,
   roc.scancompletes,
   roc.scanmisses,
   roc.scans,
   roc.dlm_requests,   
   roc.subordinate#,
   roc.con_id,
   roc.dlm_conflicts,  -- obsolete
   roc.dlm_releases    -- obsolete
from
   sys.v_$rowcache roc
order by
   roc.usage desc;

select
   s.kqrstcln latch#,
   r.cache#,
   r.parameter name,
   r.type,
   r.subordinate#
from
   v$rowcache r                               join
   x$kqrst    s on r.cache# = s.kqrstcid