V$SQL_CURSOR

Data Dictionary View

Columns
   ___________________________
 
   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

Related:

V$OPEN_CURSOR 
V$SQL.address      = v$sql_cursor.parent_handle
V$SQLAREA.address    = v$sql_cursor.parent_handle 
V$SQLTEXT 
V$SQLTEXT_WITH_NEWLINES 
V$SQL_BIND_DATA 
V$SQL_BIND_METADATA 
V$SQL_SHARED_MEMORY


© Copyright SS64.com 1999-2013
Some rights reserved