|
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) |
Pointer to the parent cursor handle |
|
PARENT_LOCK |
RAW(4) |
Pointer to the parent cursor lock |
|
CHILD_LOCK |
RAW(4) |
Pointer to the child cursor lock |
|
CHILD_PIN |
RAW(4) |
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) |
