|
SQL_TEXT
|
VARCHAR2(1000)
|
First thousand characters of the SQL text for the current cursor
|
|
SHARABLE_MEM
|
NUMBER
|
Amount of shared memory used by this child cursor (in bytes)
|
|
PERSISTENT_MEM
|
NUMBER
|
Fixed amount of memory used for the lifetime of this child cursor (in bytes)
|
|
RUNTIME_MEM
|
NUMBER
|
Fixed amount of memory required during the execution of this child cursor
|
|
SORTS
|
NUMBER
|
Number of sorts that were done for this child cursor
|
|
LOADED_VERSIONS
|
NUMBER
|
Indicates whether the context heap is loaded (1) or not (0)
|
|
OPEN_VERSIONS
|
NUMBER
|
Indicates whether the child cursor is locked (1) or not (0)
|
|
USERS_OPENING
|
NUMBER
|
Number of users executing the statement
|
|
FETCHES
|
NUMBER
|
Number of fetches associated with the SQL statement
|
|
EXECUTIONS
|
NUMBER
|
Number of executions that took place on this object since it was brought into the library cache
|
|
USERS_EXECUTING
|
NUMBER
|
Number of users executing the statement
|
|
LOADS
|
NUMBER
|
Number of times the object was either loaded or reloaded
|
|
FIRST_LOAD_TIME
|
VARCHAR2(19)
|
Timestamp of the parent creation time
|
|
INVALIDATIONS
|
NUMBER
|
Number of times this child cursor has been invalidated
|
|
PARSE_CALLS
|
NUMBER
|
Number of parse calls for this child cursor
|
|
DISK_READS
|
NUMBER
|
Number of disk reads for this child cursor
|
|
BUFFER_GETS
|
NUMBER
|
Number of buffer gets for this child cursor
|
|
ROWS_PROCESSED
|
NUMBER
|
Total number of rows the parsed SQL statement returns
|
|
COMMAND_TYPE
|
NUMBER
|
Oracle command type definition
|
|
OPTIMIZER_MODE
|
VARCHAR2(10)
|
Mode under which the SQL statement is executed
|
|
OPTIMIZER_COST
|
NUMBER
|
Cost of this query given by the optimizer
|
|
PARSING_USER_ID
|
NUMBER
|
User ID of the user who originally built this child cursor
|
|
PARSING_SCHEMA_ID
|
NUMBER
|
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 the cache using the DBMS_SHARED_POOL package
|
|
ADDRESS
|
RAW(4 | 8)
|
Address of the handle to the parent for this cursor
|
|
TYPE_CHK_HEAP
|
RAW(4)
|
Descriptor of the type check heap for this child cursor
|
|
HASH_VALUE
|
NUMBER
|
Hash value of the parent statement in the library cache
|
|
PLAN_HASH_VALUE
|
NUMBER
|
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
|
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, which is set by calling DBMS_APPLICATION_INFO.SET_MODULE
|
|
MODULE_HASH
|
NUMBER
|
Hash value of the module listed 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, which is set by calling DBMS_APPLICATION_INFO.SET_ACTION
|
|
ACTION_HASH
|
NUMBER
|
Hash value of the action listed in the ACTION column
|
|
SERIALIZABLE_ABORTS
|
NUMBER
|
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, then 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 | 8)
|
Address of the child cursor
|
|
SQLTYPE
|
NUMBER
|
Denotes the version of the SQL language used for this statement
|
|
REMOTE
|
VARCHAR2(1)
|
Indicates whether the cursor is remote mapped (Y) or not (N)
|
|
OBJECT_STATUS
|
VARCHAR2(19)
|
Status of the cursor (VALID or INVALID)
|
|
LITERAL_HASH_VALUE
|
NUMBER
|
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, then the value is 0.
|
|
LAST_LOAD_TIME
|
VARCHAR2(19)
|
Time at which the query plan (heap 6) was loaded into the library cache
|
|
IS_OBSOLETE
|
VARCHAR2(1)
|
Indicates whether the cursor has become obsolete (Y) or not (N). This can happen if the number of child cursors is too large.
|
|
CHILD_LATCH
|
NUMBER
|
Child latch number that is protecting the cursor
|
