AWR reports are showing very low DB-time
Hi,
Context: rdbms 11.2.0.2. 1-hour AWR reports.
When viewing the section 'Top 5 Timed Foreground Events' the column '%DB time' normally adds up to appr. 100%.
Sometimes we see, that the sum of column '%DB time' is very low, down to 20%.
What could be the cause of this?
(We have checked, that there are no Resource Manager plans active).
Please see example below:
Thanks in advance.
Context: rdbms 11.2.0.2. 1-hour AWR reports.
When viewing the section 'Top 5 Timed Foreground Events' the column '%DB time' normally adds up to appr. 100%.
Sometimes we see, that the sum of column '%DB time' is very low, down to 20%.
What could be the cause of this?
(We have checked, that there are no Resource Manager plans active).
Please see example below:
Thanks in advance.
Top 5 Timed Foreground Events
| Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| DB CPU | 1,778 | 18.13 | |||
| TCP Socket (KGAS) | 793 | 345 | 435 | 3.52 | Network |
| library cache lock | 2 | 41 | 20427 | 0.42 | Concurrency |
| db file sequential read | 6,453 | 24 | 4 | 0.24 | User I/O |
| log file switch (checkpoint incomplete) |
0