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: Asynchronous Commit in Oracle Database 10g R2

Re: Asynchronous Commit in Oracle Database 10g R2

From: VC <boston103_at_hotmail.com>
Date: Fri, 2 Sep 2005 20:43:49 -0400
Message-ID: <JoudnUcHkP8gbIXeRVn-hQ@comcast.com> 





Hi,



"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message 
news:df9tol$oli$1_at_nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...


>

>

> This is an undocumented optimization.




OK, I believe that the idea is that one does not care about potential data 
loss since the application has no control over commits anyway.  All the 
application sees is whether the PL/SQL proc.  committing in a loop succeeded 
or failed.  If the PL/SQL proc. failed,  the number of committed rows is 
unpredictable whether or not the commits are optimized. 
Received on Fri Sep 02 2005 - 19:43:49 CDT












Original text of this message













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