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