SQL_TEXT |
VARCHAR2(1000) |
The first thousand 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 |
PLAN_HASH_VALUE |
NUMBER |
A numerical representation of the SQL plan for this cursor. Comparing one PLAN_HASH_VALUE to another easily identifies whether or not two plans are the same (rather than comparing the two plans line by line). |
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-08177 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. |
CPU_TIME |
NUMBER |
CPU time (in microseconds) used by this cursor for parsing/executing/fetching |
ELAPSED_TIME |
NUMBER |
Elapsed time (in microseconds) used by this cursor for parsing/executing/fetching |
OUTLINE_SID |
NUMBER |
Outline session identifier |
CHILD_ADDRESS |
RAW(4) |
Address of the child cursor |
SQLTYPE |
NUMBER |
Denotes the version of the SQL language used for this statement |
REMOTE |
VARCHAR2(1) |
(Y /N ) Identifies whether the cursor is remote mapped |
OBJECT_STATUS |
VARCHAR2(19) |
Status of the cursor (VALID /INVALID ) |
LITERAL_HASH_VALUE |
NUMBER |
The hash value of the literals which are replaced with system generated bind variables and are to be matched, when CURSOR_SHARING is used. This is not the hash value for the SQL statement. If CURSOR_SHARING is not used, the value is 0. |
LAST_LOAD_TIME |
VARCHAR2(19) |
|