Re: log file sync
From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 7 Aug 2012 15:46:21 -0700
Message-ID: <CAGXkmitOTw0zyxGifLHyrdDPMeq43TL=XzevAsAnk-mRjByLUg_at_mail.gmail.com>
You may find the this of use when looking at log file sync and log file parallel write issues using the AWR report (there is usually more to the issue than the lines you provided):
http://structureddata.org/2011/12/20/visualizing-active-session-history-ash-data-with-r/ On Mon, Aug 6, 2012 at 12:55 PM, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
Date: Tue, 7 Aug 2012 15:46:21 -0700
Message-ID: <CAGXkmitOTw0zyxGifLHyrdDPMeq43TL=XzevAsAnk-mRjByLUg_at_mail.gmail.com>
You may find the this of use when looking at log file sync and log file parallel write issues using the AWR report (there is usually more to the issue than the lines you provided):
http://structureddata.org/2011/12/20/visualizing-active-session-history-ash-data-with-r/ On Mon, Aug 6, 2012 at 12:55 PM, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> Hi all,
> My AWR report shows 'log file sync' among the top five events. When I
> look at the 'Foreground Wait Events', I see the following:
> ...
> My question is that if the LGWR is not waiting for the 'log file
> parallel write' during synchronous writes (avg. wait time=0) then why is
> the average wait time of 'log file sync' event for the foreground and
> background processes (DBWR, LMS etc.) is high?
>
-- Regards, Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> | linkedin <http://linkd.in/gregrahn> -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 07 2012 - 17:46:21 CDT