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')

home |  up