[Home] [Help] [Dependency Information]
Object Name: | WRI$_SQLSET_WORKSPACE |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000469365C00005$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000469365C00008$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000469365C00010$$ | LOB | UNIQUE | SYSTEM | |
WRI$_SQLSET_WORKSPACE_PK | NORMAL | UNIQUE | SYSAUX |
WORKSPACE_NAME
SQLSET_NAME SQL_ID PLAN_HASH_VALUE |
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) |
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;
SYS.WRI$_SQLSET_WORKSPACE does not reference any database object
SYS.WRI$_SQLSET_WORKSPACE is referenced by following:
|
|
|