GV$SQL_CURSOR

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(4)
kxsccplk,                -- PARENT_LOCK RAW(4)
kxsccclk,                -- CHILD_LOCK RAW(4)
kxscccpn,                -- CHILD_PIN RAW(4)
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(4)
from
x$kxscc
home |  up  |  mailbox