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 plate counts and colony forming unit, Define Plate Counts and Colony...

Define Plate Counts and Colony Forming Unit? Plate counts is the most frequently used method to measure microbial numbers. The technique, however, can be used only for those mi

How to compare and contrast acids, Compare and contrast acids and bases in ...

Compare and contrast acids and bases in terms of their H+ ion and OH- ion concentrations.

Life processes, mode of nutrition : out side the body

mode of nutrition : out side the body

Protozoa phylum, wht is the main quality of this phylum

wht is the main quality of this phylum

Triploblastic, What Is the advantage of having a coelomic body cavity

What Is the advantage of having a coelomic body cavity

Bacterial diseases-actinobacillosis, Actinobacillosis Synonym   : Woo...

Actinobacillosis Synonym   : Wooden Tongue Causative organism                  : Actinobacillus lignieresii Species affected                   : Ruminants, cattle and s

What hormones participate in digestive secretions, Q. The releasing of dige...

Q. The releasing of digestive secretions is controlled by hormones. What are the hormones that participate in this regulation? The hormones that participate in the regulation o

In hormonal terms why does menses occur, Q. In hormonal terms why does mens...

Q. In hormonal terms why does menses occur? Menses is the endometrial monthly desquamation that occurs as the progesterone and estrogen levels fall after the regression of the

What is sympatric isolation, A few individuals from a herd of deer are forc...

A few individuals from a herd of deer are forced to migrate to a new herd. This is an example of  resulting in.   a.  Gene flow; enhance in similarities between populations.

Canine distemper, Canine distemper Canine distemper, a highly contagio...

Canine distemper Canine distemper, a highly contagious disease of dogs, is caused primarily by air- borne virus which belongs to the genus Morbillivirus in family Paramyxoviri

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