AUTONOMOUS_TRANSACTION resources/overhead
I'm having trouble proving what my instincts tell me...
I'm working in an environment where some developers have adopted the practice of adding the AUTONOMOUS_TRANSACTION pragma to ALL of their functions and procedures. It is added whether the function/procedure does DML, DDL or even just queries. 99% of the time, the AUTONOMOUS_TRANSACTION pragma could be eliminated with no effect on the execution of the function/procedure itself.
My gut tells me that there HAS to be some overhead incurred with doing this, but I can't seem to prove it. Does anyone out there have any proof/documentation/reasoning that would support my case?
I'm working in an environment where some developers have adopted the practice of adding the AUTONOMOUS_TRANSACTION pragma to ALL of their functions and procedures. It is added whether the function/procedure does DML, DDL or even just queries. 99% of the time, the AUTONOMOUS_TRANSACTION pragma could be eliminated with no effect on the execution of the function/procedure itself.
My gut tells me that there HAS to be some overhead incurred with doing this, but I can't seem to prove it. Does anyone out there have any proof/documentation/reasoning that would support my case?
0