|
Re: Autonomous Transactions [message #241330 is a reply to message #241322] |
Tue, 29 May 2007 04:50   |
 |
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 #241510 is a reply to message #241508] |
Tue, 29 May 2007 16:49   |
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).
|
|
|
|
|
|