Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_WI_PATTERN_ITEMS

Each row in DBA_WI_PATTERN_ITEMS represents a template that participates in a significant pattern that has been found by the given Workload Intelligence job.

Column Datatype NULL Description
JOB_ID NUMBER NOT NULL The identifier of the job in the workload of which the current pattern has been found
PATTERN_ID NUMBER NOT NULL The identifier of the pattern to which the current item (template) belongs
SEQUENCE_NUMBER NUMBER NOT NULL Number that indicates the position of the current item in the given pattern
TEMPLATE_ID NUMBER NOT NULL The identifier of the template that participates in the given position of the current pattern
IS_FIRST_IN_LOOP CHAR(1) NOT NULL A flag that indicates whether or not the current item marks the beginning of a loop in the given pattern. The possible values are Y and N.
IS_LAST_IN_LOOP CHAR(1) NOT NULL A flag that indicates whether or not the current item marks the end of a loop in the given pattern. The possible values are Y and N.