The PLAN_TABLE Table
All of the methods listed in this section rely upon the PLAN_TABLE table. This table is created by the $ORACLE_HOME/rdbms/admin/utlxplan.sql script. Table 8.1 shows the structure of the PLAN_TABLE table.
|
Column |
Format |
|
STATEMENT_ID |
VARCHAR2(30) |
|
TIMESTAMP |
DATE |
|
REMARKS |
VARCHAR2(80) |
|
OPERATION |
VARCHAR2(30) |
|
OPTIONS |
VARCHAR2(30) |
|
OBJECT_NODE |
VARCHAR2(128) |
|
OBJECT_OWNER |
VARCHAR2(30) |
|
OBJECT_NAME |
VARCHAR2(30) |
|
OBJECT_INSTANCE |
NUMBER(38) |
|
OBJECT_TYPE |
VARCHAR2(30) |
|
OPTIMIZER |
VARCHAR2(255) |
|
SEARCH_COLUMNS |
NUMBER |
|
ID |
NUMBER(38) |
|
PARENT_ID |
NUMBER(38) |
|
POSITION |
NUMBER(38) |
|
COST |
NUMBER(38) |
|
CARDINALITY |
NUMBER(38) |
|
BYTES |
NUMBER(38) |
|
OTHER_TAG |
VARCHAR2(255) |
|
PARTITION_START |
VARCHAR2(255) |
|
PARTITION_STOP |
VARCHAR2(255) |
|
PARTITION_ID |
NUMBER(38) |
|
OTHER |
LONG |
|
DISTRIBUTION |
VARCHAR2(30) |
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
