Re: Autonomous Transactions - Good or Bad

From: Kurt Franke <kurt-franke_at_web.de>
Date: Tue, 13 Mar 2012 14:53:24 +0100 (CET)
Message-ID: <trinity-d872daf3-e055-41d5-992f-c7c593894c4c-1331646803942_at_3capp-webde-bs38.dlan.cinetic.de>

 =0AHi,sometimes=20I=
=20used=20an=20autonomous=20transaction=20to=20avoid=20a=20global=20commit=
=20which=20otherwise=20would=20be=20issued=20by=20a=20ddl=
=20statement.Look=20the=20following=20examp=
le:after=20checking=20new=20loaded=20data=
=20the=20partitions=20to=20create=20are=20deduced.=20Then=
=20the=20add=20/=20split=20partition=20is=20done=20which=20is=20really=20DD=
L=20and=20would=20cause=20a=20commit.Thus=20all=20previous=
=20changes=20are=20commited=20and=20a=20problem=20later=20may=20cause=20a=
=20break.The=20new=20data=20from=20the=20load=20are=20then=
=20are=20incomplete=20because=20the=20load=20is=20broken.A=
=20special=20cleanup=20must=20be=20be=20done=20then.To=20avoid=20this=20do=20
the=20split=20/=20add=20partition=20in=20= an=20autonomous=20transaction=20where=20theautomatically=20= issued=20pre-DDL-commit=20does=20not=20affect=20the=20global=20transaction=
=20of=20the=20loadbut=20only=20the=20autonomous=20transacti= onregardskf=
=0A=20=20=20=20=0A=20=20=20=20=20= =20=20=20Gesendet:
Montag,=2012.=20M&auml;rz=202012=20um=2015:1= 9=20Uhr=0A=20=20=20=20=20=20=20=20Von: "Jeff=20Chirco=

"=20<JChirco_at_innout.com>=0A=20=20=20=20=20=20=20=20An:
"oracle-l_at_freelists.org"=20<oracle-l_at_freelists.org>=


=0A=20=20=20=20=20=20=20=20=0A=20=20=20=20=20=20=20=20Betreff:&=

nbsp;Autonomous=20Transactions=20-=20Good=20or=20Bad=0A=20=20=20=20=

=0A=20=20=20=20=0A=20=20=20=20=20=20=20=20I=
=20recently=20saw=20Tom=20Kyte=20and=20he=20mentioned=20how=20he=20doesn't=
=20like=20autonomous=20transactions=20and=20said=20you=20should=20never=20r=
eally=20use=20them=20except=20for=20when=20logging=20errors.=20=20I=20didn'= t=20understand=20what=20was=20so=20bad=20about=20them=20and=20didn't=20get=
=20a=20chance=20to=20ask=20him.=20=20So=20I=20was=20wondering=20if=20any=20=

of=20you=20agree=20with=20this=20statement=20and=20why?=20=20I=20personally=

=20try=20to=20avoid=20them=20but=20I=20have=20other=20developers=20that=20u=
se=20them=20frequently=20because=20they=20need=20to=20run=20other=20transac= tions=20over=20their=20current=20one.=0AThanks=20for=20any=20info.=0AJeff=0A= 0A--=0Ahttp://www.freelists.org/webpage/oracle-= l[0]=0A=0A=0A=0A=20=20=20=20=0A

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 13 2012 - 08:53:24 CDT