Advantages of autonomous transactions, Biology

Assignment Help:

Advantages of Autonomous Transactions

An autonomous transaction, once started is fully independent. It shares no locks, resources, or commit-dependency with the main transaction. Therefore, you can log the events, increment retry counters, and so on, even when the main transaction rolls back. Most important, the autonomous transactions help you to build modular, and reuse the software components. For illustration, the stored procedures can start and finish the autonomous transactions on their own. The calling applications do not require to know about a procedure's autonomous operations and the procedure do not require knowing about the application's transaction context. It makes the autonomous transactions less error-prone than the regular transactions and easier to use.

Moreover, autonomous transactions have all the functionality of a regular transaction. They permit parallel queries, distributed processing, & all the transaction control statements including the SET TRANSACTION.


Related Discussions:- Advantages of autonomous transactions

Kind of tetrasporic embruo sac, what are the kinds of tetrasporic embryo sa...

what are the kinds of tetrasporic embryo sac...detail information

Explain epimerism, Epimerism:- Another type of stereo isomerism known ...

Epimerism:- Another type of stereo isomerism known as epimerism occurs with respect to a single asymmetric carbon atom of a monosaccharide possessing more than one asymmetric

Blood flow during exercise - circulation, Normal 0 false fals...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Explain the intracellular perfusion fluid, At 1 AM, a healthy squid giant a...

At 1 AM, a healthy squid giant axon is placed in a bath of normal squid physiological extracellular saline and is internally perfused with normal squid intracellular saline.

Explain about the niacin (nicotinic acid) deficiency, Explain about the Nia...

Explain about the Niacin (nicotinic acid) deficiency? Niacin (nicotinic acid) deficiency classically results in pellagva, which is a chronic wasting disease associated with a c

Excreation, what is the role of liver for the metabolism of carbohydrates

what is the role of liver for the metabolism of carbohydrates

Pressure flow mechanism for translocation, experiments that support pressur...

experiments that support pressure flow as a mechanism for translocation

M - mode echocardiography, M-Mode was the earliest form of cardiac ultrasou...

M-Mode was the earliest form of cardiac ultrasound used clinically. It displays the amplitude signals of various structures along the length of ultrasound beam with distance or

Why tpp and ttp are vital for the nerves and cardiac tissues, Why TPP and T...

Why TPP and TTP are vital for the nerves and cardiac tissues? TPP and TTP are interconvertible and arc involved in carbohydrate metabolism. As discussed above, when there is in

Excretion, what is the composition of urine in fishes and reptiles ?

what is the composition of urine in fishes and reptiles ?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd