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: sybrandb <sybrandb_at_gmail.com>
Date: 18 Apr 2007 08:18:32 -0700
Message-ID: <1176909512.744641.171520@y5g2000hsa.googlegroups.com>


On Apr 18, 4:32 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net> wrote:
> 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

ora-1555 anyone? Come on, Mladen, don't promote bad habits!!

--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Apr 18 2007 - 10:18:32 CDT

Original text of this message

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