AWR report section 'SQL ordered by Elapsed Time'
Hi,
In my daily AWR report I found following entry in 'SQL ordered by Elapsed Time' section :
My checked that this job is finished so question here is "Why the executions column is 0 and 'elap per exec' is null?"
BR,
Anurag
In my daily AWR report I found following entry in 'SQL ordered by Elapsed Time' section :
| Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|
| 148,051 | 15 | 0 | 13.03 | 4mwuzv12gvy8a | pmdtm@dap-ccdw-ora02 (TNS V1-V3) | SELECT AG_BILL_SUBSCR_MONTH.PE.. |
My checked that this job is finished so question here is "Why the executions column is 0 and 'elap per exec' is null?"
BR,
Anurag
0