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.WRH$_SQL_PLAN

Object Details

Object Name:	WRH$_SQL_PLAN
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRH$_SQL_PLAN_PK

DBID
SQL_ID
PLAN_HASH_VALUE
ID
CON_DBID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000366296C00038$$	LOB	UNIQUE	SYSAUX
WRH$_SQL_PLAN_PK	NORMAL	UNIQUE	SYSAUX	DBID SQL_ID PLAN_HASH_VALUE ID CON_DBID

Columns

Name	Datatype	Length	Mandatory
SNAP_ID	NUMBER
DBID	NUMBER		Yes
SQL_ID	VARCHAR2	(13)	Yes
PLAN_HASH_VALUE	NUMBER		Yes
ID	NUMBER		Yes
OPERATION	VARCHAR2	(30)
OPTIONS	VARCHAR2	(30)
OBJECT_NODE	VARCHAR2	(128)
OBJECT#	NUMBER
OBJECT_OWNER	VARCHAR2	(128)
OBJECT_NAME	VARCHAR2	(128)
OBJECT_ALIAS	VARCHAR2	(261)
OBJECT_TYPE	VARCHAR2	(20)
OPTIMIZER	VARCHAR2	(20)
PARENT_ID	NUMBER
DEPTH	NUMBER
POSITION	NUMBER
SEARCH_COLUMNS	NUMBER
COST	NUMBER
CARDINALITY	NUMBER
BYTES	NUMBER
OTHER_TAG	VARCHAR2	(35)
PARTITION_START	VARCHAR2	(64)
PARTITION_STOP	VARCHAR2	(64)
PARTITION_ID	NUMBER
OTHER	VARCHAR2	(4000)
DISTRIBUTION	VARCHAR2	(20)
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	(128)
REMARKS	VARCHAR2	(4000)
TIMESTAMP	DATE
OTHER_XML	CLOB	(4000)
CON_DBID	NUMBER		Yes

Query Text

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


SELECT SNAP_ID
,      DBID
,      SQL_ID
,      PLAN_HASH_VALUE
,      ID
,      OPERATION
,      OPTIONS
,      OBJECT_NODE
,      OBJECT#
,      OBJECT_OWNER
,      OBJECT_NAME
,      OBJECT_ALIAS
,      OBJECT_TYPE
,      OPTIMIZER
,      PARENT_ID
,      DEPTH
,      POSITION
,      SEARCH_COLUMNS
,      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
,      REMARKS
,      TIMESTAMP
,      OTHER_XML
,      CON_DBID
FROM SYS.WRH$_SQL_PLAN;

Dependencies

[top of page]

SYS.WRH$_SQL_PLAN does not reference any database object

SYS.WRH$_SQL_PLAN is referenced by following:

SYS: DBMS_RAT_MASK - show dependent code; INT$DBA_HIST_SQL_PLAN