[10.2.0.4 on W2K3] log file sync
Hi,
I noticed a slow down of our database.
Looking at AWR report (one hour delay), the Top 5 Timed Events looks as follow
I read that it could be produced by multiple commits, so here are the following ratios :
What do you think about ?
Rgds,
Looking at AWR report (one hour delay), the Top 5 Timed Events looks as follow
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|---|---|---|---|---|
| log file sync | 42,162 | 6,665 | 158 | 88.6 | Commit |
| log file parallel write | 33,873 | 1,229 | 36 | 16.3 | System I/O |
| db file parallel write | 3,798 | 429 | 113 | 5.7 | System I/O |
| db file sequential read | 3,029 | 404 | 133 | 5.4 | User I/O |
| control file parallel write | 1,137 | 367 | 323 | 4.9 | System I/O |
| user calls | 1,426,574 | 393.38 | 51.55 |
| user commits | 26,839 | 7.40 | 0.97 |
| user I/O wait time | 70,263 | 19.38 | 2.54 |
| user rollbacks | 835 | 0.23 | 0.03 |
What do you think about ?
Rgds,
0