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>
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?
- doing stuff
- log what i am doing. commit it and don't want to commit do stuff
- continue doing stuff
anyone use it for anything else?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 22 2008 - 12:44:10 CDT