select
  inst_id,                                 -- INST_ID NUMBER
  kxscccur,                                -- CURNO NUMBER
  kxscccfl,                                -- FLAG NUMBER
  decode(                                  -- STATUS VARCHAR2(9)
    kxsccsta, 0, 'CURNULL', 1, 'CURSYNTAX', 2, 'CURPARSE', 3, 'CURBOUND', 4, 'CURFETCH', 5, 'CURROW', 'ERROR'),
  kxsccphd,                                -- PARENT_HANDLE RAW(8)
  kxsccplk,                                -- PARENT_LOCK RAW(8)
  kxsccclk,                                -- CHILD_LOCK RAW(8)
  kxscccpn,                                -- CHILD_PIN RAW(8)
  kxscctbm,                                -- PERS_HEAP_MEM NUMBER
  kxscctwm,                                -- WORK_HEAP_MEM NUMBER
  kxscctbv,                                -- BIND_VARS NUMBER
  kxscctdv,                                -- DEFINE_VARS NUMBER
  kxsccbdf,                                -- BIND_MEM_LOC VARCHAR2(64)
  kxsccflg,                                -- INST_FLAG VARCHAR2(64)
  kxsccfl2,                                -- INST_FLAG2 VARCHAR2(64)
  kxsccchd                                 -- CHILD_HANDLE RAW(8)
from
  x$kxscc