%DB Time in AWR report seem wrong.
Hi, I have a RAC 2 node DB. Today, I get awr on 1 node to monitor database working.
I pay attention to % DB time. As I know that DB Time = CPU I/O Time + Non Idle waittime.
But in my AWR Report, sum of % Non Idle waittime is more than 100%.
Could you explain this case for me?
Thank in advance
Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
---|---|---|---|---|---|
DFS lock handle | 67,506 | 31.3K | 463 | 53.5 | Other |
DB CPU | 15.5K | 26.5 | |||
log file sync | 2,320,811 | 9995.3 | 4 | 17.1 | Commit |
db file sequential read | 1,858,439 | 4925.5 | 3 | 8.4 | User I/O |
inactive transaction branch | 5,492 | 4893.9 | 891 | 8.4 | Other |
gc buffer busy acquire | 1,038,723 | 2958 | 3 | 5.1 | Cluster |