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')