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]

TYPE: SYS.SQL_PLAN_ROW_TYPE

Object Details

Object Name:	SQL_PLAN_ROW_TYPE
Object Type:	TYPE
Owner:	SYS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

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	(30)
OBJECT_NAME	VARCHAR2	(30)
OBJECT_ALIAS	VARCHAR2	(65)
OBJECT_INSTANCE	DECIMAL
OBJECT_TYPE	VARCHAR2	(30)
OPTIMIZER	VARCHAR2	(255)
SEARCH_COLUMNS	NUMBER
ID	DECIMAL
PARENT_ID	DECIMAL
DEPTH	DECIMAL
POSITION	DECIMAL
COST	DECIMAL
CARDINALITY	DECIMAL
BYTES	DECIMAL
OTHER_TAG	VARCHAR2	(255)
PARTITION_START	VARCHAR2	(255)
PARTITION_STOP	VARCHAR2	(255)
PARTITION_ID	DECIMAL
DISTRIBUTION	VARCHAR2	(30)
CPU_COST	DECIMAL
IO_COST	DECIMAL
TEMP_SPACE	DECIMAL
ACCESS_PREDICATES	VARCHAR2	(4000)
FILTER_PREDICATES	VARCHAR2	(4000)
PROJECTION	VARCHAR2	(4000)
TIME	DECIMAL
QBLOCK_NAME	VARCHAR2	(30)
OTHER_XML	CLOB	(0)

Dependencies

[top of page]

SYS.SQL_PLAN_ROW_TYPE references the following:

SYS: STANDARD - show dependent code

SYS.SQL_PLAN_ROW_TYPE is referenced by following:

PUBLIC: SQL_PLAN_ROW_TYPE
SYS: DBMS_SQLTUNE_INTERNAL - show dependent code; SQL_PLAN_ALLSTAT_ROW_TYPE; SQL_PLAN_STAT_ROW_TYPE; SQL_PLAN_TABLE_TYPE