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

TABLE: SYS.WI$_FREQUENT_PATTERN_METADATA

Object Details
Object Name: WI$_FREQUENT_PATTERN_METADATA
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WI$_FREQ_PATTERN_METADATA_PK
  1. ColumnJOBID
Indexes
Index Type Uniqueness Tablespace Column
WI$_FREQ_PATTERN_METADATA_PK NORMAL UNIQUE TablespaceSYSAUX ColumnJOBID
Foreign Keys
Table
Foreign Table Foreign Key Column
WI$_FREQUENT_PATTERN_METADATA WI$_FREQ_PATTERN_METADATA_FK1 TableWI$_JOB WI$_FREQUENT_PATTERN_METADATA JOBID
Columns
Name Datatype Length Mandatory Comments
JOBID NUMBER
Yes
MODELORDER NUMBER
Yes
THRESHOLD NUMBER
Yes
Query Text

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


SELECT JOBID
,      MODELORDER
,      THRESHOLD
FROM SYS.WI$_FREQUENT_PATTERN_METADATA;

Dependencies

[top of page]

SYS.WI$_FREQUENT_PATTERN_METADATA does not reference any database object

SYS.WI$_FREQUENT_PATTERN_METADATA is referenced by following:

SchemaSYS
ViewDBA_WI_JOBS