20 of 38
Autonomous vs. Nested Transactions
– Summary
uAutonomous transactions do not share transactional
resources (such as locks) with the
main transaction.
uAutonomous transactions do not depend on the main transaction.
uNon-committed changes of parent transactions are not immediately visible to autonomous transactions, but
visible for nested ones.
uChanges made by autonomous transactions may or may not
be visible to the parent
one depending upon the isolation level. Changes made by nested transactions are always visible
to the parent one.
uExceptions raised in an autonomous transaction cause a transaction-level rollback, not a statement-level
rollback.