|
SQL_TEXT |
VARCHAR2(1000) |
The first eighty characters of the SQL text for the current cursor |
|
SHARABLE_MEM |
NUMBER |
Amount of shared memory, in bytes used by this child cursor |
|
PERSISTENT_MEM |
NUMBER |
Fixed amount of memory, in bytes, used for the lifetime of this child cursor |
|
RUNTIME_MEM |
NUMBER |
Fixed amount of memory required during the execution of this child cursor |
|
SORTS |
NUMBER |
The number of sorts that was done for this child cursor |
|
LOADED_VERSIONS |
NUMBER |
1 if context heap is loaded, 0 otherwise |
|
OPEN_VERSIONS |
NUMBER |
1 if the child cursor is locked, 0 otherwise |
|
USERS_OPENING |
NUMBER |
The number of users executing the statement |
|
EXECUTIONS |
NUMBER |
The number of executions that took place on this object since it was brought into the library cache |
|
USERS_EXECUTING |
NUMBER |
The number of users executing the statement |
|
LOADS |
NUMBER |
The number of times the object was loaded or reloaded |
|
FIRST_LOAD_TIME |
VARCHAR2(19) |
The time stamp of the parent creation time |
|
INVALIDATIONS |
NUMBER |
The number of times this child cursor has been invalidated |
|
PARSE_CALLS |
NUMBER |
The number of parse calls for this child cursor |
|
DISK_READS |
NUMBER |
The number of disk reads for this child cursor |
|
BUFFER_GETS |
NUMBER |
The number of buffer gets for this child cursor |
|
ROWS_PROCESSED |
NUMBER |
The total number of rows the parsed SQL statement returns |
|
COMMAND_TYPE |
NUMBER |
The Oracle command type definition |
|
OPTIMIZER_MODE |
VARCHAR2(10) |
Mode under which the SQL statement is executed |
|
OPTIMIZER_COST |
NUMBER |
The cost of this query given by the optimizer |
|
PARSING_USER_ID |
NUMBER |
The user ID of the user who originally built this child cursor |
|
PARSING_SCHEMA_ID |
NUMBER |
The schema ID that was used to originally build this child cursor |
|
KEPT_VERSIONS |
NUMBER |
Indicates whether this child cursor has been marked to be kept pinned in cache using the DBMS_SHARED_POOL package |
|
ADDRESS |
RAW(4) |
The address of the handle to the parent for this cursor |
|
TYPE_CHK_HEAP |
RAW(4) |
The descriptor of the type check heap for this child cursor |
|
HASH_VALUE |
NUMBER |
The hash value of the parent statement in the library cache |
|
CHILD_NUMBER |
NUMBER |
The number of this child cursor |
|
MODULE |
VARCHAR2(64) |
Contains the name of the module that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_MODULE |
|
MODULE_HASH |
NUMBER |
The hash value of the module that is named in the MODULE column |
|
ACTION |
VARCHAR2(64) |
Contains the name of the action that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_ACTION |
|
ACTION_HASH |
NUMBER |
The hash value of the action that is named in the ACTION column |
|
SERIALIZABLE_ABORTS |
NUMBER |
The number of times the transaction fails to serialize, producing ORA-8177 errors, per cursor |
|
OUTLINE_CATEGORY |
VARCHAR2(64) |
If an outline was applied during construction of the cursor, this column displays the category of that outline. Otherwise the column is left blank. |
