Each row in DBA_WI_STATEMENTS describes a statement (SQL or PL/SQL) that is part of the template with identifier TEMPLATE_ID, which has been found in the workload that is related to the Workload Intelligence job whose identifier is equal to JOB_ID. A template may consist of multiple statements, for example, if it represents a transaction. In this case, there is one row in this view for every one of these statements. These statements are ordered, based on the order defined by the corresponding transaction. Column SEQUENCE_NUMBER is used to describe this order.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
The identifier of the job in the workload of which the given statement has been found |
|
|
|
|
The identifier of the template in the given job to which the current statement belongs |
|
|
|
|
A number that indicates the order of the current statement in the given template |
|
|
|
|
The SQL text associated with the current statement. Note that although multiple SQL statements can be classified to the same template, only one row is stored that represents them all. This row corresponds to the first instance of the given template that is found during parsing of the workload. |