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

TABLE: SYS.WRI$_SQLSET_WORKSPACE

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: WRI$_SQLSET_WORKSPACE_PK
  1. ColumnWORKSPACE_NAME
  2. ColumnSQLSET_NAME
  3. ColumnSQL_ID
  4. ColumnPLAN_HASH_VALUE
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000469365C00005$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000469365C00008$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000469365C00010$$ LOB UNIQUE TablespaceSYSTEM
WRI$_SQLSET_WORKSPACE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnWORKSPACE_NAME
ColumnSQLSET_NAME
ColumnSQL_ID
ColumnPLAN_HASH_VALUE
Columns
Name Datatype Length Mandatory Comments
WORKSPACE_NAME VARCHAR2 (128) Yes
SQLSET_NAME VARCHAR2 (128) Yes
SQL_ID VARCHAR2 (13) Yes
PLAN_HASH_VALUE NUMBER
Yes
CONTROL_OPTIONS CLOB (4000)
NEW_PLAN_HASH NUMBER

PLAN_ID NUMBER

EXTRA_RESULT CLOB (4000)
ERROR_CODE NUMBER

ERROR_MESSAGE CLOB (4000)
Query Text

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


SELECT WORKSPACE_NAME
,      SQLSET_NAME
,      SQL_ID
,      PLAN_HASH_VALUE
,      CONTROL_OPTIONS
,      NEW_PLAN_HASH
,      PLAN_ID
,      EXTRA_RESULT
,      ERROR_CODE
,      ERROR_MESSAGE
FROM SYS.WRI$_SQLSET_WORKSPACE;

Dependencies

[top of page]

SYS.WRI$_SQLSET_WORKSPACE does not reference any database object

SYS.WRI$_SQLSET_WORKSPACE is referenced by following:

SchemaSYS
Package BodyDBMS_SQLTUNE_INTERNAL - show dependent code