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>

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

Original text of this message