6.111 DBA_WI_PATTERNS

Each row in DBA_WI_PATTERNS represents a pattern that has been identified by Workload Intelligence as significant in the workload associated with the given job. Such a pattern consists of one or more templates.

These templates that comprise the given pattern are described in the related view DBA_WI_PATTERN_ITEMS.

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 current pattern

LENGTH

NUMBER

NOT NULL

The length of the pattern, that is, the number of items (templates) it consists of

NUMBER_OF_EXECUTIONS

NUMBER

NOT NULL

The number of times the current pattern has been executed in the given workload

DB_TIME

NUMBER

NOT NULL

The total time consumed in the database server by all the executions of the current pattern in the given workload

See Also:

"DBA_WI_PATTERN_ITEMS"