Static Data Dictionary Views, 299 of 452

PLAN_TABLE

PLAN_TABLE is the default table for results of the EXPLAIN PLAN 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 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(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

OTHER

LONG

Holds SQL text for remote cursors and parallel execution slaves

DISTRIBUTION

VARCHAR2(30)

The distribution method

Column	Datatype	Description
`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(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
`OTHER`	`LONG`	Holds SQL text for remote cursors and parallel execution slaves
`DISTRIBUTION`	`VARCHAR2(30)`	The distribution method