V$SQL_CURSOR

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 
V$SQLAREA 
V$SQLTEXT 
V$SQLTEXT_WITH_NEWLINES 
V$SQL_BIND_DATA 
V$SQL_BIND_METADATA 
V$SQL_SHARED_MEMORY