RE: uses of autonomous transactions

From: Ken Naim <kennaim_at_gmail.com>
Date: Thu, 22 May 2008 13:44:10 -0400
Message-ID: <5D259399675F4AA68ACD1D5B8216C34C@KenPC>


There are many of good and bad uses for them, several Collaborate08 presentations had sections on them. For example you can avoid mutating table trigger errors with them, commit within triggers etc. It is a very powerful feature that can kill you if used improperly. In my Colloaborate08 presentation I showed a case where performance was killed by AT's and showed how to work around it.  

Ken  


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rick Ricky
Sent: Thursday, May 22, 2008 11:56 AM
To: oracle-l_at_freelists.org
Subject: uses of autonomous transactions  

has anyone found a use for this other than for logging?  

  1. doing stuff
  2. log what i am doing. commit it and don't want to commit do stuff
  3. continue doing stuff

anyone use it for anything else?

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 22 2008 - 12:44:10 CDT

Original text of this message