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