Re: high log file sync wait

From: Frits Hoogland <frits.hoogland_at_gmail.com>
Date: Mon, 3 Dec 2012 08:17:17 +0100
Message-ID: <-7705471570010695865_at_unknownmsgid>

It might be good to investigate the logwriter IO time. The foreground posts the logwriter for the write.
Frits Hoogland

http://fritshoogland.wordpress.com
frits.hoogland_at_gmail.com
+31 6 53569942 <+31%206%2053569942>

Op 3 dec. 2012 om 03:56 heeft Sidney Chen <huanshengchen_at_gmail.com> het volgende geschreven:

During the commit, There is communication between user session and lgwr, on rac, SCN sync happens between the db instances. That's the wait times and elapse time of the event "wait for scn ack". check below notes.

Bug 8220734 Long "log file sync" wait in RAC Bug 6193945 High LGWR CPU use and long 'log file sync' latency in RAC Troubleshooting: log file sync' Waits [ID 1376916.1]

On Sat, Dec 1, 2012 at 2:39 AM, Andreas Piesk <a.piesk_at_gmx.net> wrote:

parallel

--

Regards
Sidney Chen

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 03 2012 - 08:17:17 CET