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

TABLE: SYS.WRI$_SQLSET_PLANS_TOCAP

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

Temporary Table Details

SYS.WRI$_SQLSET_PLANS_TOCAP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Primary Key: WRI$_SQLSET_PLANS_TOCAP_PK
  1. ColumnSTMT_ID
  2. ColumnPLAN_HASH_VALUE
Indexes
Index Type Uniqueness Tablespace Column
WRI$_SQLSET_PLANS_TOCAP_PK NORMAL UNIQUE Tablespace ColumnSTMT_ID
ColumnPLAN_HASH_VALUE
Columns
Name Datatype Length Mandatory Comments
STMT_ID NUMBER
Yes
SQL_ID VARCHAR2 (13)
PLAN_HASH_VALUE NUMBER
Yes
LAST_LOAD_TIME DATE

CON_DBID NUMBER
Yes
Query Text

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


SELECT STMT_ID
,      SQL_ID
,      PLAN_HASH_VALUE
,      LAST_LOAD_TIME
,      CON_DBID
FROM SYS.WRI$_SQLSET_PLANS_TOCAP;

Dependencies

[top of page]

SYS.WRI$_SQLSET_PLANS_TOCAP does not reference any database object

SYS.WRI$_SQLSET_PLANS_TOCAP is referenced by following:

SchemaSYS
Package BodyDBMS_SQLTUNE_INTERNAL - show dependent code