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

Home -> Community -> Usenet -> c.d.o.server -> Re: Lots of "log file sync" waits and nothing else on inserts and commits

Re: Lots of "log file sync" waits and nothing else on inserts and commits

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 29 Jan 2004 06:36:54 +0100
Message-ID: <tt6h10he3gm82l45jge99s8genncp2n2h1@4ax.com> 





On 28 Jan 2004 13:43:32 -0800, bdurrettccci_at_yahoo.com (Bobby Durrett)
wrote:



>Any ideas?




A log file sync is a result of a commit.
You must be committing every individual record.
This is one of the safest recipes to get an unscalable application.



--
Sybrand Bakker, Senior Oracle DBA


Received on Wed Jan 28 2004 - 23:36:54 CST












Original text of this message













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