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

Viral diseases - avian encephalomyelitis, V i ra l Diseases A v ...

V i ra l Diseases A v ian encephalomyelitis This is enterovirus disease of chicken, pheasants, turkeys and Japanese quails caused by the member of the family Pi

#fbiodiversitytitle.., Alimitation of five kingdom classification sk questi...

Alimitation of five kingdom classification sk question #Minimum 100 words accepted#

Explain phenotypical traits, Why is not Mendel's second law always valid fo...

Why is not Mendel's second law always valid for two or more phenotypical traits of an individual? Mendel's second law, or the law of the independent assortment, is valid for g

Taxonomy, A In taxonomy, what is a "KEY" ? List the different types of key...

A In taxonomy, what is a "KEY" ? List the different types of keys. How are they prepared and what are they used for ?sk question #Minimum 100 words accepted#

Sphaerosome, Sphaerosome Also known as Plant lysosome , because the...

Sphaerosome Also known as Plant lysosome , because they contain hydrolytic enzymes. Hanstei n first observed them and called microsomes . Discovered by Dangeared

What are the technique of operation cardiovascular surgery, What are the Te...

What are the Technique of Operation Cardiovascular Surgery? Technique of Operation Cardiovascular Surgery :  The operation is done on cardiopulmonary bypass with profound h

Show ions used in electrical impulse transmission in neurons, Q. What are t...

Q. What are the two major ions that participate in the electrical impulse transmission in neurons? The two major ions that participate in the electrical impulse transmission in

Explain adaptive radiation and convergence, Adaptive radiation OR convergen...

Adaptive radiation OR convergence Adaptive radiation Explanation of the adaptive radiation process linked to the introduction of a single species and the wide range

How can bacteria produce human insulin, How can bacteria produce human insu...

How can bacteria produce human insulin on an industrial scale? What are the other forms of insulin made available by the pharmaceutical industry? Bacteria do not naturally synt

Homo erectus, Homo erectus first arose about 1.6 million years ago and is b...

Homo erectus first arose about 1.6 million years ago and is believed to have lived for atleast 600,000 years at a time when the transition to Homo sapiens took place. The fosSil fi

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