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 |
|---|---|---|---|
|
|
|
|
The identifier of the job in the workload of which the current pattern has been found |
|
|
|
|
The identifier of the current pattern |
|
|
|
|
The length of the pattern, that is, the number of items (templates) it consists of |
|
|
|
|
The number of times the current pattern has been executed in the given workload |
|
|
|
|
The total time consumed in the database server by all the executions of the current pattern in the given workload |
See Also: