Home » SQL & PL/SQL » SQL & PL/SQL » Autonomous Transactions
Autonomous Transactions [message #241322] Tue, 29 May 2007 04:30 Go to next message
akilaoraclefaq
Messages: 4
Registered: May 2007
Location: chennai
Junior Member
Hi,

Can any one say me how many maximum autonomous transactions are possible in a procedure?
Re: Autonomous Transactions [message #241330 is a reply to message #241322] Tue, 29 May 2007 04:50 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I think that limits are based on your hardware. Each autonomous transaction creates a "mini session" within your main transaction. I haven't checked it but I think that Oracle didn't impose explicit limits to the number of autonomous trainsactions.

MHE

[Updated on: Tue, 29 May 2007 04:51]

Report message to a moderator

Re: Autonomous Transactions [message #241508 is a reply to message #241322] Tue, 29 May 2007 16:34 Go to previous messageGo to next message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
IMHO - if you have more than 1 - check your design.

Michael
Re: Autonomous Transactions [message #241510 is a reply to message #241508] Tue, 29 May 2007 16:49 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
It's fine to have multiple autonomous transaction calls within the execution of a procedure, but if it's for something like audit logging, then a single autonomous tx to do the logging would be preferable. It would generally be quite difficult to get multiple autonomous transactions running at the same sime in a single session (unless it involves papallel query option).
Re: Autonomous Transactions [message #241538 is a reply to message #241322] Tue, 29 May 2007 22:30 Go to previous messageGo to next message
akilaoraclefaq
Messages: 4
Registered: May 2007
Location: chennai
Junior Member
So there are no restrictions in the maximum number of Autonomous transactions being used in a procedure.Am i right?
Re: Autonomous Transactions [message #241540 is a reply to message #241322] Tue, 29 May 2007 22:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Just because you can do something really foolish or stupid, does not mean it is good practice to do so.
Re: Autonomous Transactions [message #241544 is a reply to message #241322] Tue, 29 May 2007 23:14 Go to previous message
akilaoraclefaq
Messages: 4
Registered: May 2007
Location: chennai
Junior Member
ok thanks,
I got it.
Previous Topic: coalesce puzzle
Next Topic: Pl/SQL procedure for Packed data format
Goto Forum:
  


Current Time: Fri Feb 14 15:16:53 CST 2025