Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: log file sync

Re: log file sync

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 13 Oct 2006 10:52:44 -0400
Message-ID: <c2213f680610130752q178a6857h80ba52a536b71041@mail.gmail.com>


I can only second what Christian already said. Can you check the raw trace file and search all occurencies of XCTEND and "log file sync"? The latter should be preceding by XCTEND.

On 10/13/06, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
>
> Hi
>
> > The big question on my mind is whether log file sync is directly
> > attributed to commits or if the volume of inserts is enough to
> > create this. The application does issue many many many inserts.
>
> IIRC I never saw log file sync without a COMMIT. I.e., AFAIK, only
> COMMITs wait on that event. In addition notice that all other writes
> that the LGWR has to perform are not synchronous.
>
> In your trace file log file sync events are scattered over the whole
> trace file?
>
>
> HTH
> Chris
>

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 13 2006 - 09:52:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US