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]

VIEW: SYS.ALL_SQLSET_PLANS

Object Details

Object Name:	ALL_SQLSET_PLANS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SQLSET_NAME	VARCHAR2	(128)	Yes
SQLSET_OWNER	VARCHAR2	(128)
SQLSET_ID	NUMBER		Yes
CON_DBID	NUMBER		Yes
SQL_ID	VARCHAR2	(13)	Yes
FORCE_MATCHING_SIGNATURE	NUMBER		Yes
PLAN_HASH_VALUE	NUMBER		Yes
SQL_SEQ	NUMBER		Yes
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	(38)
OBJECT_TYPE	VARCHAR2	(30)
OPTIMIZER	VARCHAR2	(255)
SEARCH_COLUMNS	NUMBER
ID	NUMBER	(38)	Yes
PARENT_ID	NUMBER	(38)
DEPTH	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	(0)
DISTRIBUTION	VARCHAR2	(30)
CPU_COST	NUMBER	(38)
IO_COST	NUMBER	(38)
TEMP_SPACE	NUMBER	(38)
ACCESS_PREDICATES	VARCHAR2	(4000)
FILTER_PREDICATES	VARCHAR2	(4000)
PROJECTION	VARCHAR2	(4000)
TIME	NUMBER	(38)
QBLOCK_NAME	VARCHAR2	(128)
OTHER_XML	CLOB	(4000)
EXECUTIONS	NUMBER
STARTS	NUMBER
OUTPUT_ROWS	NUMBER
CR_BUFFER_GETS	NUMBER
CU_BUFFER_GETS	NUMBER
DISK_READS	NUMBER
DISK_WRITES	NUMBER
ELAPSED_TIME	NUMBER
LAST_STARTS	NUMBER
LAST_OUTPUT_ROWS	NUMBER
LAST_CR_BUFFER_GETS	NUMBER
LAST_CU_BUFFER_GETS	NUMBER
LAST_DISK_READS	NUMBER
LAST_DISK_WRITES	NUMBER
LAST_ELAPSED_TIME	NUMBER
POLICY	VARCHAR2	(10)
ESTIMATED_OPTIMAL_SIZE	NUMBER
ESTIMATED_ONEPASS_SIZE	NUMBER
LAST_MEMORY_USED	NUMBER
LAST_EXECUTION	VARCHAR2	(10)
LAST_DEGREE	NUMBER
TOTAL_EXECUTIONS	NUMBER
OPTIMAL_EXECUTIONS	NUMBER
ONEPASS_EXECUTIONS	NUMBER
MULTIPASSES_EXECUTIONS	NUMBER
ACTIVE_TIME	NUMBER
MAX_TEMPSEG_SIZE	NUMBER
LAST_TEMPSEG_SIZE	NUMBER

Query Text

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


SELECT SQLSET_NAME
,      SQLSET_OWNER
,      SQLSET_ID
,      CON_DBID
,      SQL_ID
,      FORCE_MATCHING_SIGNATURE
,      PLAN_HASH_VALUE
,      SQL_SEQ
,      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
,      DISTRIBUTION
,      CPU_COST
,      IO_COST
,      TEMP_SPACE
,      ACCESS_PREDICATES
,      FILTER_PREDICATES
,      PROJECTION
,      TIME
,      QBLOCK_NAME
,      OTHER_XML
,      EXECUTIONS
,      STARTS
,      OUTPUT_ROWS
,      CR_BUFFER_GETS
,      CU_BUFFER_GETS
,      DISK_READS
,      DISK_WRITES
,      ELAPSED_TIME
,      LAST_STARTS
,      LAST_OUTPUT_ROWS
,      LAST_CR_BUFFER_GETS
,      LAST_CU_BUFFER_GETS
,      LAST_DISK_READS
,      LAST_DISK_WRITES
,      LAST_ELAPSED_TIME
,      POLICY
,      ESTIMATED_OPTIMAL_SIZE
,      ESTIMATED_ONEPASS_SIZE
,      LAST_MEMORY_USED
,      LAST_EXECUTION
,      LAST_DEGREE
,      TOTAL_EXECUTIONS
,      OPTIMAL_EXECUTIONS
,      ONEPASS_EXECUTIONS
,      MULTIPASSES_EXECUTIONS
,      ACTIVE_TIME
,      MAX_TEMPSEG_SIZE
,      LAST_TEMPSEG_SIZE
FROM SYS.ALL_SQLSET_PLANS;

Dependencies

[top of page]

SYS.ALL_SQLSET_PLANS references the following:

SYS: WRI$_SQLSET_DEFINITIONS; WRI$_SQLSET_PLANS; WRI$_SQLSET_PLAN_LINES; WRI$_SQLSET_STATEMENTS

SYS.ALL_SQLSET_PLANS is referenced by following:

PUBLIC: ALL_SQLSET_PLANS