log file synch issue
Hi community,
I am facing transient log file synch issue and would like yto know if I am going the right direction while troubleshooting.
AWR :
Top 10 Foreground Events by Total Wait Time
Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
---|---|---|---|---|---|
log file sync | 139,039 | 81.7K | 588 | 81.9 | Commit |
DB CPU | 12.8K | 12.8 | |||
buffer busy waits | 3,403 | 2208.1 | 649 | 2.2 | Concurrency |
db file sequential read | 2,439,807 | 808.1 | 0 | .8 | User I/O |
log buffer space | 274 | 759 | 2770 | .8 | Configuration |
direct path write temp | 17,520 | 385.6 | 22 | .4 | User I/O |
flashback log file sync | 9,246 | 270.9 | 29 | .3 | User I/O |
direct path read | 3,288,295 | 267 | 0 | .3 | User I/O |
direct path write | 12,499 | 225.1 | 18 | .2 | User I/O |
SQL*Net message from dblink | 3,864 | 160.8 | 42 | .2 | Network |
0