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

TABLE: SYS.WI$_FREQUENT_PATTERN_ITEM

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WI$_FREQUENT_PATTERN_ITEM_PK
  1. ColumnJOBID
  2. ColumnPATTERNID
  3. ColumnRANK
Indexes
Index Type Uniqueness Tablespace Column
WI$_FREQUENT_PATTERN_ITEM_PK NORMAL UNIQUE TablespaceSYSAUX ColumnJOBID
ColumnPATTERNID
ColumnRANK
Foreign Keys
Table
Foreign Table Foreign Key Column
WI$_FREQUENT_PATTERN_ITEM WI$_FREQUENT_PATTERN_ITEM_FK1 TableWI$_FREQUENT_PATTERN WI$_FREQUENT_PATTERN_ITEM JOBID
WI$_FREQUENT_PATTERN_ITEM PATTERNID
WI$_FREQUENT_PATTERN_ITEM WI$_FREQUENT_PATTERN_ITEM_FK2 TableWI$_TEMPLATE WI$_FREQUENT_PATTERN_ITEM JOBID
WI$_FREQUENT_PATTERN_ITEM TEMPLATEID
Columns
Name Datatype Length Mandatory Comments
JOBID NUMBER
Yes
PATTERNID NUMBER
Yes
RANK NUMBER
Yes
TEMPLATEID NUMBER
Yes
ISFIRSTINLOOP CHAR (1) Yes
ISLASTINLOOP CHAR (1) Yes
Query Text

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


SELECT JOBID
,      PATTERNID
,      RANK
,      TEMPLATEID
,      ISFIRSTINLOOP
,      ISLASTINLOOP
FROM SYS.WI$_FREQUENT_PATTERN_ITEM;

Dependencies

[top of page]

SYS.WI$_FREQUENT_PATTERN_ITEM does not reference any database object

SYS.WI$_FREQUENT_PATTERN_ITEM is referenced by following:

SchemaSYS
ViewDBA_WI_PATTERN_ITEMS