Database Tuning (MOSC)

MOSC Banner

[10.2.0.4 on W2K3] log file sync

edited May 30, 2011 4:09AM in Database Tuning (MOSC) 8 commentsAnswered
Hi, I noticed a slow down of our database.
Looking at AWR report (one hour delay), the Top 5 Timed Events looks as follow

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
log file sync 42,162 6,665 158 88.6Commit
log file parallel write 33,873 1,229 36 16.3System I/O
db file parallel write 3,798 429 113 5.7System I/O
db file sequential read 3,029 404 133 5.4User I/O
control file parallel write 1,137 367 323 4.9System I/O

 I read that it could be produced by multiple commits, so here are the following ratios :

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center