log file sync vs log file parallel write
From: HansP <hans-peter.sloot_at_atosorigin.com>
Date: Fri, 3 Oct 2008 03:31:48 -0700 (PDT)
Message-ID: <3eb022d6-6654-40ec-94cd-35dddc991a8b@q5g2000hsa.googlegroups.com>
Date: Fri, 3 Oct 2008 03:31:48 -0700 (PDT)
Message-ID: <3eb022d6-6654-40ec-94cd-35dddc991a8b@q5g2000hsa.googlegroups.com>
Hello all,
While investigating performance problems in a database I discovered that the 'log file sync' wait event is almost always in the top 5. (I am looking at the statspack datat)
Calculating the ratio of the average wait time of the 'log file sync' and the 'log file parallel write' gives a ratio of 10.
Does someone know why this may happen?
Regards Hans-Peter Received on Fri Oct 03 2008 - 05:31:48 CDT