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

Attempted suicide - psychiatric emergencies, Attempted Suicide: Suicid...

Attempted Suicide: Suicide and homicide represent major source of morbidity and mortality in psychiatric practice.  Suicide means killing of  oneself.  An attempted suicide is

Spermiogenesis - spermatogenesis, Spermiogenesis - Spermatogenesis At ...

Spermiogenesis - Spermatogenesis At the end of the meiosis the spermatids appear as simple spherical cells with a centrally located nucleus. Their differentiation into sperm r

Chemolithoautotrophs - nutritional types of microorganisms, Explain Chemoli...

Explain Chemolithoautotrophs - Nutritional Types of Microorganisms These microorganisms use inorganic compound as source of energy and electron and CO 2 as a source of carbon.

Needle and sharp instrument safety, Needlestick/sharp instrument injuries a...

Needlestick/sharp instrument injuries are of major concern to health care workers. All of the significant exposures reported in the academic year 2003/04 in our Faculty, were injur

What are phenotypical & genotypical proportions in f1 & f2, According to th...

According to the Mendel's second law, in the crossing between homozygous individuals concerning two pairs of nonlinked alleles, AABB x aaBB, what are the phenotypical and genotypic

Bottleneck for external sources for health care, Bottleneck for External So...

Bottleneck for External Sources for Health Care The implementation bottlenecks arising out of funding by external sources have important implications for the resource allocati

Food and diet, state one benefit of including vegetable fibre in the diet

state one benefit of including vegetable fibre in the diet

Define the diseses shigellosis, Define the diseses Shigellosis Shigello...

Define the diseses Shigellosis Shigellosis or bacterial dysentery is caused by facultative anaerobic, gram-negative, non-spore forming, rod-shaped  Shigella in the family enter

Explain advantages of having internal gills, 1. Explain the challenges and ...

1. Explain the challenges and advantages of having internal gills over external gills for gas exchange? 2. Explain how increased stress levels can affect hormones which ultimate

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