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