Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

V$SQL_CURSOR

V$SQL_CURSOR displays debugging information for each cursor associated with the session querying this view.

Column Datatype Description
CURNO NUMBER Cursor number
FLAG NUMBER Flags set in the cursor
STATUS VARCHAR2(9) Status of the cursor; that is, what state the cursor is in
PARENT_HANDLE RAW(4 | 8) Pointer to the parent cursor handle
PARENT_LOCK RAW(4 | 8) Pointer to the parent cursor lock
CHILD_LOCK RAW(4 | 8) Pointer to the child cursor lock
CHILD_PIN RAW(4 | 8) Pointer to the child cursor pin
PERS_HEAP_MEM NUMBER Total amount of memory allocated from persistent heap for this cursor
WORK_HEAP_MEM NUMBER Total amount of memory allocated from the work heap for this cursor
BIND_VARS NUMBER Total number of bind positions in the query currently parsed into this cursor
DEFINE_VARS NUMBER Total number of define variables in the query currently parsed into this cursor
BIND_MEM_LOC VARCHAR2(64) Which memory heap the bind variables are stored in: either the UGA or the CGA
INST_FLAG VARCHAR2(64) Instantiation object flags
INST_FLAG2 VARCHAR2(64) Instantiation object flags (continued)