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

Define general protection in the laboratory, Define General protection in t...

Define General protection in the Laboratory? You are required to wear a laboratory coat at all times in the laboratory. It is sensible to buy one of good quality and to launder

What is plant tissues explain there types, What is Plant Tissues explain th...

What is Plant Tissues explain there types? Vascular plants have separate organs to carry out specialized functions. For instance, leaves function to convert radiant energy to

The key enzymes of gluconeogenesis, The key enzymes of gluconeogenesis,incl...

The key enzymes of gluconeogenesis,include: a)  Pyruvate carboxylase b)  Phosphoenol pyruvate carboxykinase c)  Fructose- 1,6-bisphosphatase,  and d)  Glucose-6-phosph

Demonstrate the structure of mitochondria, Demonstrate the structure of mit...

Demonstrate the structure of mitochondria The structure of mitochondria has been examined in great detail with the aid of the electron microscope, and it is now possible to des

Rk, how many chromosomes in human

how many chromosomes in human

Cell division, What is telokinesis and how is it different in animal then p...

What is telokinesis and how is it different in animal then plant cells?

What is coronary bypass graft, Q. What is coronary bypass graft? The Co...

Q. What is coronary bypass graft? The Coronary artery bypass graft is a kind of surgical myocardial revascularization that is a way to provide blood to a myocardium whose blood

Meroblastic or partial cleavage, Meroblastic or partial cleavage The e...

Meroblastic or partial cleavage The egg does not divide totally because divisions are restricted to only a part of the egg where as the rest of the egg remains completely uncl

Scope of user charges, Normal 0 false false false EN-IN...

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

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