How to Relate Log file Parallel Write wait events in AWR
Hello
I am seeing the following in AWR for a process taking 13 hours now after a patch which should be 30 Min normally earlier.
Any body can help urgently to tell me what should be next steps to investigate ?
Background Wait Events
- ordered by wait time desc, waits desc (idle events last)
- Only events with Total Wait Time (s) >= .001 are shown
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
log file parallel write | 6,422,976 | 0 | 12,314 | 2 | 0.63 | 49.96 |
gcs log flush sync | 484,425 | 6 | 1,181 | 2 | 0.05 | 4.79 |
db file parallel write | 298,015 | 0 | 963 | 3 | 0.03 | 3.91 |
log file sequential read |
0