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. |