[10.2.0.4 on W2K3] Question about sql execute elapsed time
Hi,
In my AWR report (time between snaphots = 1 hour), I've got a sql execute elapsed time = 730s (as shown below)
Time Model Statistics
- Total time in database user-calls (DB Time): 828,6s
- Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
- Ordered by % or DB time desc, Statistic name
| Statistic Name | Time (s) | % of DB Time |
|---|---|---|
| sql execute elapsed time | 730.87 | 88.20 |
| DB CPU | 216.18 | 26.09 |
| parse time elapsed | 20.61 | 2.49 |
| hard parse elapsed time | 14.29 | 1.72 |
| PL/SQL execution elapsed time | 0.74 | 0.09 |
| hard parse (bind mismatch) elapsed time | 0.10 | 0.01 |
| hard parse (sharing criteria) elapsed time | 0.10 | 0.01 |
| repeated bind elapsed time | 0.09 | 0.01 |
| connection management call elapsed time |
0