Bunyamin Karadeniz£¬
ÔÚ 2002-07-12 01:48:00 You wrote:
Hi ,
You encounter log file sync and log file parallel write events .
This can be because of a slow device on which redo log files are on . OR
your redo log sizing is bad.
hi, you said the redo log size have something to do with this log
Connor McDonald£¬
ÔÚ 2002-07-12 02:33:00 You wrote:
Some suggestions
a) Check your commit frequency - if you're committing
like mad then this is a great way to over stress redo
logging operations.
Yes, i check the statspack report and find there is about 20 commits/second in may,
and now
Definitely there is a bottleneck in disks or the response time is very
high.
Since you are using Raid-5, I would suggest as a test to make your redo
groups one member only or to move the other members to another raid while
keeping the log_buffer at 2M.
Regards,
Waleed
-Original