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: Exception raised in a loop

Re: Exception raised in a loop

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Wed, 18 Apr 2007 14:32:01 GMT
Message-ID: <pan.2007.04.18.14.32.00@verizon.net> 





On Wed, 18 Apr 2007 06:52:44 -0700, sybrandb wrote:



> COMMITTing inside a loop is one of the Seven Main Sins in Oracle.




Nope. it isn't. There is an optimization that I learned about from 
Jonathan Lewis (his course in Connecticut in 2005) which makes Oracle
proceed and not wait for LGWR. The only case when Oracle does wait for 
commit is when the transaction is distributed.


-- 
http://www.mladen-gogala.com


Received on Wed Apr 18 2007 - 09:32:01 CDT












Original text of this message













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