Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exception raised in a loop
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 DBAReceived on Wed Apr 18 2007 - 10:18:32 CDT