eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: SYS.PLAN_TABLE$

Object Details

Object Name:	PLAN_TABLE$
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Temporary Table Details

SYS.PLAN_TABLE$ is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0001099453C00027$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length
STATEMENT_ID	VARCHAR2	(30)
PLAN_ID	NUMBER
TIMESTAMP	DATE
REMARKS	VARCHAR2	(4000)
OPERATION	VARCHAR2	(30)
OPTIONS	VARCHAR2	(255)
OBJECT_NODE	VARCHAR2	(128)
OBJECT_OWNER	VARCHAR2	(128)
OBJECT_NAME	VARCHAR2	(128)
OBJECT_ALIAS	VARCHAR2	(261)
OBJECT_INSTANCE	NUMBER
OBJECT_TYPE	VARCHAR2	(30)
OPTIMIZER	VARCHAR2	(255)
SEARCH_COLUMNS	NUMBER
ID	NUMBER
PARENT_ID	NUMBER
DEPTH	NUMBER
POSITION	NUMBER
COST	NUMBER
CARDINALITY	NUMBER
BYTES	NUMBER
OTHER_TAG	VARCHAR2	(255)
PARTITION_START	VARCHAR2	(255)
PARTITION_STOP	VARCHAR2	(255)
PARTITION_ID	NUMBER
OTHER	LONG	(0)
OTHER_XML	CLOB	(4000)
DISTRIBUTION	VARCHAR2	(30)
CPU_COST	NUMBER
IO_COST	NUMBER
TEMP_SPACE	NUMBER
ACCESS_PREDICATES	VARCHAR2	(4000)
FILTER_PREDICATES	VARCHAR2	(4000)
PROJECTION	VARCHAR2	(4000)
TIME	NUMBER
QBLOCK_NAME	VARCHAR2	(30)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT STATEMENT_ID
,      PLAN_ID
,      TIMESTAMP
,      REMARKS
,      OPERATION
,      OPTIONS
,      OBJECT_NODE
,      OBJECT_OWNER
,      OBJECT_NAME
,      OBJECT_ALIAS
,      OBJECT_INSTANCE
,      OBJECT_TYPE
,      OPTIMIZER
,      SEARCH_COLUMNS
,      ID
,      PARENT_ID
,      DEPTH
,      POSITION
,      COST
,      CARDINALITY
,      BYTES
,      OTHER_TAG
,      PARTITION_START
,      PARTITION_STOP
,      PARTITION_ID
,      OTHER
,      OTHER_XML
,      DISTRIBUTION
,      CPU_COST
,      IO_COST
,      TEMP_SPACE
,      ACCESS_PREDICATES
,      FILTER_PREDICATES
,      PROJECTION
,      TIME
,      QBLOCK_NAME
FROM SYS.PLAN_TABLE$;

Dependencies

[top of page]

SYS.PLAN_TABLE$ does not reference any database object

SYS.PLAN_TABLE$ is referenced by following:

PUBLIC: PLAN_TABLE