Each row in DBA_WI_TEMPLATES describes a template that has been found in the workload that is related to the Workload Intelligence job whose identifier is equal to JOB_ID. A template can represent either a simple query, or an entire transaction. Two queries in the given workload belong to the same template, if they exhibit trivial differences, for example, if they contain different literal values, different bind variable names, different comments, or different white spaces.
The identifier of the job in the workload of which the given template has been found
The identifier of a template in a given job
Flag that indicates whether the given template represents a transaction:
Y - indicates that the given template represents a transaction
N - indicates that the given template does not represent a transaction