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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rick Ricky Sent: Thursday, May 22, 2008 11:56 AM To: oracle-l@xxxxxxxxxxxxx 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?