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

home |  up  |  mailbox