GV$ROWCACHE definition in Oracle Database 10.2 / www.oracledba.ru
GV$ROWCACHE
select
inst_id, -- INST_ID NUMBER
kqrstcid, -- CACHE# NUMBER
decode -- TYPE VARCHAR2(11)
(kqrsttyp, 1, 'PARENT', 'SUBORDINATE'),
decode -- SUBORDINATE# NUMBER
(kqrsttyp, 2, kqrstsno, null),
kqrsttxt, -- PARAMETER VARCHAR2(32)
kqrstcsz, -- COUNT NUMBER
kqrstusg, -- USAGE NUMBER
kqrstfcs, -- FIXED NUMBER
kqrstgrq, -- GETS NUMBER
kqrstgmi, -- GETMISSES NUMBER
kqrstsrq, -- SCANS NUMBER
kqrstsmi, -- SCANMISSES NUMBER
kqrstsco, -- SCANCOMPLETES NUMBER
kqrstmrq, -- MODIFICATIONS NUMBER
kqrstmfl, -- FLUSHES NUMBER
kqrstilr, -- DLM_REQUESTS NUMBER
kqrstifr, -- DLM_CONFLICTS NUMBER
kqrstisr -- DLM_RELEASES NUMBER
from
x$kqrst