Oracle 视图 DBA_WI_PATTERNS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图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 |
|---|---|---|---|
|
|
|
|
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:
“DBA_WI_PATTERN_ITEMS”
