DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.WRI$_SQLSET_PLAN_LINES

Object Details
Object Name: WRI$_SQLSET_PLAN_LINES
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRI$_SQLSET_PLAN_LINES_PK
  1. ColumnSTMT_ID
  2. ColumnPLAN_HASH_VALUE
  3. ColumnID
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000366589C00038$$ LOB UNIQUE TablespaceSYSAUX
WRI$_SQLSET_PLAN_LINES_PK NORMAL UNIQUE TablespaceSYSAUX ColumnSTMT_ID
ColumnPLAN_HASH_VALUE
ColumnID
Columns
Name Datatype Length Mandatory Comments
STMT_ID NUMBER
Yes
PLAN_HASH_VALUE 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

CON_DBID NUMBER
Yes
Query Text

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


SELECT STMT_ID
,      PLAN_HASH_VALUE
,      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
,      CON_DBID
FROM SYS.WRI$_SQLSET_PLAN_LINES;

Dependencies

[top of page]

SYS.WRI$_SQLSET_PLAN_LINES does not reference any database object

SYS.WRI$_SQLSET_PLAN_LINES is referenced by following:

SchemaSYS
ViewALL_SQLSET_PLANS
ViewDBA_SQLSET_PLANS
PL/SQL PackageDBMS_SQLTUNE_INTERNAL - show dependent code
Package BodyDBMS_SQLTUNE_INTERNAL - show dependent code
ViewUSER_SQLSET_PLANS