Hi guys,
One generic question.
Why in AWR report, the section "Wait Classes by Total Wait Time", the total of "% DB time" is more than100?
It's Oracle 12c R2 on Linux
Following is an example of what I've got:
| Wait Class | Waits | Total Wait Time (sec) | Avg Wait Time | % DB time | Avg Active Sessions |
|---|
| Commit | 318,377 | 691 | 2.17ms | 51.2 | 0.2 |
| System I/O | 327,592 | 612 | 1.87ms | 45.4 | 0.2 |
| DB CPU | | 601 | | 44.6 | 0.2 |
| Other | 144,694 | 86 | 596.56us | 6.4 | 0.0 |
| User I/O | 363,509 | 84 | 232.00us | 6.3 | 0.0 |
| Concurrency | 6,009 | 21 | 3.48ms | 1.6 | 0.0 |
| Network | 774,869 | 1 | 926.61ns | .1 | 0.0 |
| Scheduler | 13 | 0 | 10.69ms | .0 | 0.0 |
| Configuration | 39 | 0 | 2.58ms | .0 | 0.0 |