[Home] [Help] [Dependency Information]
Object Name: | WRH$_SQL_PLAN |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
SYS.WRH$_SQL_PLAN does not reference any database object
SYS.WRH$_SQL_PLAN is referenced by following:
|
|
|