PLAN_TABLE

PLAN_TABLE is the default table for results of the EXPLAINPLAN statement. It is created by UTLXPLAN.SQL, and it contains one row for each step in the execution plan.

Column

Datatype

NULL

Description

STATEMENT_ID

VARCHAR2(30)

Optional statement identifier specified in the EXPLAINPLAN statement

TIMESTAMP

DATE

Date and time that the EXPLAINPLAN 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(30)

Options used for the operation performed at this step

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

Not currently used

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