Performance Issue in one of our system
Hello All,
We have an issue in one of our systems where i can see the below wait events during the issue. I need recommendations on how to evaluate further.
Top 5 Timed Foreground Events
| Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| log buffer space | 15,153 | 18,616 | 1229 | 19.00 | Configuration |
| direct path write | 22,501 | 11,069 | 492 | 11.30 | User I/O |
| local write wait | 9,302 | 10,748 | 1155 | 10.97 | User I/O |
| direct path read | 12,282 | 8,365 | 681 | 8.54 | User I/O |
| db file parallel read | 53,437 | 6,905 | 129 | 7.05 | User I/O |
Also recently we increased the log_buffer space from 10M to 25M but the situation got worse so we reverted back to 10M. Not sure why since i can clearly see log_buffer space as problematic wait event.
0