|
Snapshot Level Dynamic SQL |
Logical Data Grouping dynsql |
Monitor Switch Statement |
|
Resettable |
Yes | |
|
Element Name Element Type |
total_exec_time time | |
Description: The total time in seconds and microseconds that was spent executing a particular statement in the SQL cache.
Usage: Use this element with Statement Executions determine the average elapsed time for the statement and identify the SQL statements that would most benefit from a tuning of their SQL. The Statement Compilations must be considered when evaluating the contents of this data element.