DBA Data[Home] [Help]

VIEW: SYS.GV_$SQL_CURSOR

Source

View Text - Preformatted

select "INST_ID","CURNO","FLAG","STATUS","PARENT_HANDLE","PARENT_LOCK","CHILD_LOCK","CHILD_PIN","PERS_HEAP_MEM","WORK_HEAP_MEM","BIND_VARS","DEFINE_VARS","BIND_MEM_LOC","INST_FLAG","INST_FLAG2","CHILD_HANDLE","CON_ID" from gv$sql_cursor
View Text - HTML Formatted

SELECT "INST_ID"
, "CURNO"
, "FLAG"
, "STATUS"
, "PARENT_HANDLE"
, "PARENT_LOCK"
, "CHILD_LOCK"
, "CHILD_PIN"
, "PERS_HEAP_MEM"
, "WORK_HEAP_MEM"
, "BIND_VARS"
, "DEFINE_VARS"
, "BIND_MEM_LOC"
, "INST_FLAG"
, "INST_FLAG2"
, "CHILD_HANDLE"
, "CON_ID"
FROM GV$SQL_CURSOR