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

TABLE: SYS.WRI$_ADV_SQLW_COLVOL

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRI$_ADV_SQLW_CV_PK
  1. ColumnWORKLOAD_ID
  2. ColumnTABLE#
  3. ColumnCOL#
Indexes
Index Type Uniqueness Tablespace Column
WRI$_ADV_SQLW_CV_PK NORMAL UNIQUE TablespaceSYSAUX ColumnWORKLOAD_ID
ColumnTABLE#
ColumnCOL#
Columns
Name Datatype Length Mandatory Comments
WORKLOAD_ID NUMBER
Yes
TABLE_OWNER# NUMBER

TABLE# NUMBER
Yes
COL# NUMBER
Yes
UPD_FREQ NUMBER

UPD_ROWS NUMBER

Query Text

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


SELECT WORKLOAD_ID
,      TABLE_OWNER#
,      TABLE#
,      COL#
,      UPD_FREQ
,      UPD_ROWS
FROM SYS.WRI$_ADV_SQLW_COLVOL;

Dependencies

[top of page]

SYS.WRI$_ADV_SQLW_COLVOL does not reference any database object

SYS.WRI$_ADV_SQLW_COLVOL is referenced by following:

SchemaSYS
ViewDBA_ADVISOR_SQLW_COLVOL
Package BodyPRVT_WORKLOAD - show dependent code
ViewUSER_ADVISOR_SQLW_COLVOL