[Home] [Help] [Dependency Information]
Object Name: | WRI$_SQLSET_WORKSPACE_PLANS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000469373C00036$$ | LOB | UNIQUE | SYSAUX | |
WRI$_SQLSET_WORKSPACE_PLANS_PK | NORMAL | UNIQUE | SYSAUX |
PLAN_ID
ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATEMENT_ID | VARCHAR2 | (30) | ||
PLAN_ID | NUMBER | Yes | ||
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 |
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
, 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.WRI$_SQLSET_WORKSPACE_PLANS;
SYS.WRI$_SQLSET_WORKSPACE_PLANS does not reference any database object
SYS.WRI$_SQLSET_WORKSPACE_PLANS is referenced by following:
|
|
|