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

TABLE: SYS.WI$_FREQUENT_PATTERN

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WI$_FREQUENT_PATTERN_PK
  1. ColumnJOBID
  2. ColumnPATTERNID
Indexes
Index Type Uniqueness Tablespace Column
WI$_FREQUENT_PATTERN_PK NORMAL UNIQUE TablespaceSYSAUX ColumnJOBID
ColumnPATTERNID
Foreign Keys
Table
Foreign Table Foreign Key Column
WI$_FREQUENT_PATTERN WI$_FREQUENT_PATTERN_FK1 TableWI$_JOB WI$_FREQUENT_PATTERN JOBID
TableWI$_FREQUENT_PATTERN_ITEM WI$_FREQUENT_PATTERN_ITEM_FK1 WI$_FREQUENT_PATTERN WI$_FREQUENT_PATTERN_ITEM JOBID
WI$_FREQUENT_PATTERN_ITEM PATTERNID
Columns
Name Datatype Length Mandatory Comments
JOBID NUMBER
Yes
PATTERNID NUMBER
Yes
LENGTH NUMBER
Yes
NUMBEROFEXECUTIONS NUMBER
Yes
DBTIME NUMBER
Yes
Query Text

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


SELECT JOBID
,      PATTERNID
,      LENGTH
,      NUMBEROFEXECUTIONS
,      DBTIME
FROM SYS.WI$_FREQUENT_PATTERN;

Dependencies

[top of page]

SYS.WI$_FREQUENT_PATTERN does not reference any database object

SYS.WI$_FREQUENT_PATTERN is referenced by following:

SchemaSYS
ViewDBA_WI_PATTERNS