V$SQL_CURSOR definition in Oracle Database 11.2
V$SQL_CURSOR
select
CURNO, -- CURNO NUMBER
FLAG, -- FLAG NUMBER
STATUS, -- STATUS VARCHAR2(9)
PARENT_HANDLE, -- PARENT_HANDLE RAW(8)
PARENT_LOCK, -- PARENT_LOCK RAW(8)
CHILD_LOCK, -- CHILD_LOCK RAW(8)
CHILD_PIN, -- CHILD_PIN RAW(8)
PERS_HEAP_MEM, -- PERS_HEAP_MEM NUMBER
WORK_HEAP_MEM, -- WORK_HEAP_MEM NUMBER
BIND_VARS, -- BIND_VARS NUMBER
DEFINE_VARS, -- DEFINE_VARS NUMBER
BIND_MEM_LOC, -- BIND_MEM_LOC VARCHAR2(64)
INST_FLAG, -- INST_FLAG VARCHAR2(64)
INST_FLAG2, -- INST_FLAG2 VARCHAR2(64)
CHILD_HANDLE -- CHILD_HANDLE RAW(8)
from
GV$SQL_CURSOR
where
inst_id = USERENV('Instance')