Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: log file sync
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 13 2006 - 08:40:51 CDT
![]() |
![]() |