Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 347 of 521


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(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 

 

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 

 

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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback