|
STATEMENT_ID
|
VARCHAR2(30)
|
|
Optional statement identifier specified in the EXPLAIN PLAN statement
|
|
TIMESTAMP
|
DATE
|
|
Date and time that the EXPLAIN PLAN statement was issued
|
|
REMARKS
|
VARCHAR2(80)
|
|
Place for comments that can be added to the steps of the execution plan
|
|
OPERATION
|
VARCHAR2(30)
|
|
Name of the operation performed at this step
|
|
OPTIONS
|
VARCHAR2(255)
|
|
Options used for the operation performed at this step; the string returned by the index cost function
|
|
OBJECT_NODE
|
VARCHAR2(128)
|
|
Name of the database link used to reference the object
|
|
OBJECT_OWNER
|
VARCHAR2(30)
|
|
Owner of the object
|
|
OBJECT_NAME
|
VARCHAR2(30)
|
|
Name of the object
|
|
OBJECT_INSTANCE
|
NUMBER(38)
|
|
Numbered position of the object name in the original SQL statement
|
|
OBJECT_TYPE
|
VARCHAR2(30)
|
|
Descriptive modifier that further describes the type of object
|
|
OPTIMIZER
|
VARCHAR2(255)
|
|
The current mode of the optimizer
|
|
SEARCH_COLUMNS
|
NUMBER
|
|
Number of index columns with start and stop keys (that is, the number of columns with matching predicates)
|
|
ID
|
NUMBER(38)
|
|
Identification number for this step in the execution plan
|
|
PARENT_ID
|
NUMBER(38)
|
|
ID of the next step that operates on the results of this step
|
|
POSITION
|
NUMBER(38)
|
|
Order of processing for steps with the same parent ID. For cost-based optimization, the value in the first row of the plan is the statement's execution cost. For rule-based optimization, the value is null in the first row.
|
|
COST
|
NUMBER(38)
|
|
The cost of the current operation estimated by the cost-based optimizer (CBO)
|
|
CARDINALITY
|
NUMBER(38)
|
|
The number of rows returned by the current operation (estimated by the CBO)
|
|
BYTES
|
NUMBER(38)
|
|
The number of bytes returned by the current operation
|
|
OTHER_TAG
|
VARCHAR2(255)
|
|
OTHER_TAG describes the function of the SQL text in the OTHER column. Values for OTHER_TAG are:
SERIAL - the SQL is the text of a locally-executed, serial query plan. Currently, SQL is not loaded in OTHER for this case.SERIAL_FROM_REMOTE - the SQL text shown in the OTHER column will be executed at a remote site.PARALLEL_COMBINED_WITH_PARENT - the parent of this operation is a DFO that performs both operations in the parallel execution plan.PARALLEL_COMBINED_WITH_CHILD - the child of this operation is a DFO that performs both operations in the parallel execution plan.PARALLEL_TO_SERIAL - the SQL text shown in the OTHER column is the top-level of the parallel plan.PARALLEL_TO_PARALLEL - the SQL text shown in the OTHER column is executed and output in parallel.PARALLEL_FROM_SERIAL - this operation consumes data from a serial operation and outputs it in parallel.
|
|
PARTITION_START
|
VARCHAR2(255)
|
|
The start partition of a range of accessed partitions
|
|
PARTITION_STOP
|
VARCHAR2(255)
|
|
The stop partition of a range of accessed partitions
|
|
PARTITION_ID
|
NUMBER(38)
|
|
The step that has computed the pair of values of the PARTITION_START and PARTITION_STOP columns
|
|
OTHER
|
LONG
|
|
Information about parallel execution slaves and parallel queries
|
|
DISTRIBUTION
|
VARCHAR2(30)
|
|
The distribution method
|
|
CPU_COST
|
NUMBER
|
|
User-defined CPU cost
|
|
IO_COST
|
NUMBER
|
|
User-defined I/O cost
|
