Hi all,
When I took the awr report when there is a slowness in application I found the below details.
| Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
|---|
| log file sync | 49,336 | 69,135 | 1401 | 56.35 | Commit |
| cursor: pin S wait on X | 118 | 34,955 | 296227 | 28.49 | Concurrency |
| library cache lock | 5,266 | 7,045 | 1338 | 5.74 | Concurrency |
| DB CPU | | 5,113 | | 4.17 | |
| db file scattered read | 7,687 | 2,316 | 301 | 1.89 | User I/O |
What shall I do to reduce the log_file_sync?
Is there any issue when the wait calss is as 'CONCURRENCY'?
Thanks in advance.