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

Summary of economic dimensions of financing healthcare, Normal 0 ...

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

What are polyclonal antibodies, Antibodies of dissimilar specificities, whi...

Antibodies of dissimilar specificities, which react to the same antigen, are known as polyclonal antibodies.

Abolition of arrhythmias by exercise, Q. Abolition of Arrhythmias by Exerci...

Q. Abolition of Arrhythmias by Exercise? The induction of arrhythmias by exercise is well recognized, but the abolition of ectopic activity is less commonly appreciated. The me

Explain the primary root growth, Explain the Primary Root Growth? Prim...

Explain the Primary Root Growth? Primary Growth in Roots :  Roots grow down and through the soil by adding new cells at the tip of the root (called the root tip). There is a

Thermodynamics and cell shapes, Thermodynamics and Cell Shapes Why are...

Thermodynamics and Cell Shapes Why are protoplasts (cells devoid of cell wall) spherical? Why are most of the unicellular organisms (prokaryotes and eukaryotes) spherical? A s

Clinical evaluation in the continuing care cycle, Clinical Evaluation in ma...

Clinical Evaluation in maintenance in the Continuing Care Cycle Examination of gingival contours, along with mechanical evaluation of the prosthesis, implants, and implant comp

# FUNGAL NUTRITION, Write on spoilage of food products by fungi,nutrition,c...

Write on spoilage of food products by fungi,nutrition,condition for growth,consequencies and prevention.

Define water losses by insensible perspiration, Define water losses by Inse...

Define water losses by Insensible perspiration? Insensible perspiration accounts for a relatively constant amount of water loss that is proportional to the surface area of the

What is aprecise diagnosis, Q. What is Aprecise diagnosis? Aprecise dia...

Q. What is Aprecise diagnosis? Aprecise diagnosis is necessary to establish the mode of therapy. Patients with initial blood phenylketonuria level of 121 m moll1 (> 2 mg/dl) sh

Explain about platyhelminth phylum, What are the best known representatives...

What are the best known representatives of the platyhelminth phylum? The most popular representatives of the platyhelminthes are worms that cause human diseases, like taenia an

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