V$ROWCACHE definition in Oracle Database 11.2
V$ROWCACHE

select
  cache#,                                  -- CACHE# NUMBER
  type,                                    -- TYPE VARCHAR2(11)
  subordinate#,                            -- SUBORDINATE# NUMBER
  parameter,                               -- PARAMETER VARCHAR2(32)
  count,                                   -- COUNT NUMBER
  usage,                                   -- USAGE NUMBER
  fixed,                                   -- FIXED NUMBER
  gets,                                    -- GETS NUMBER
  getmisses,                               -- GETMISSES NUMBER
  scans,                                   -- SCANS NUMBER
  scanmisses,                              -- SCANMISSES NUMBER
  scancompletes,                           -- SCANCOMPLETES NUMBER
  modifications,                           -- MODIFICATIONS NUMBER
  flushes,                                 -- FLUSHES NUMBER
  dlm_requests,                            -- DLM_REQUESTS NUMBER
  dlm_conflicts,                           -- DLM_CONFLICTS NUMBER
  dlm_releases                             -- DLM_RELEASES NUMBER
from
  gv$rowcache
where
  inst_id = USERENV('Instance')

home |  up