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

Osmoregulation in terrestrial environment, Osmoregulation in Terrestrial En...

Osmoregulation in Terrestrial Environment  Earlier you have learnt about osmoregulation in aquatic environment. In this section, we shall study how the terrestrial animals cop

Acid hydrolysis of non-reducing sugar, Q. Acid Hydrolysis of Non-Reducing S...

Q. Acid Hydrolysis of Non-Reducing Sugar? It involves the acid hydrolysis of non-reducing sugars to reducing sugars. It is also known as the process of inversion. Acid hydrolys

What is microtubules, What is Microtubules? Microtubules are the largest...

What is Microtubules? Microtubules are the largest intracellular fibers, with a diameter of about 25 nm (2.5 x 10-8 meters). They consist of hollow fibers composed of a protein

Define placental transfer of nutrients, Define Placental Transfer of Nutrie...

Define Placental Transfer of Nutrients? The placenta is n transitory structure developing during pregnancy and lies implanted on the uterine wall. It is connected with the foet

Special situations of pulmonary embolism, Q. Special situations of Pulmonar...

Q. Special situations of Pulmonary Embolism? The CXR is often abnormal in pulmonary embolism. Atelectasis and other focal pulmonary parenchymal abnormalities are the most commo

Explain the both sex-linked trait and a sex-influenced trait, Explain the d...

Explain the difference among a sex-linked trait and a sex-influenced trait. A sex-influenced trait is influenced by the presence of sex hormones and its genes are not situated

Reactants of photosynthesis, what are the reactants and the products of pho...

what are the reactants and the products of photosynthesis? under the thylakoid, stroma,and combined

What is the conjugate acid, Calculate the pH: 300mL of 0.25M sodium ascorba...

Calculate the pH: 300mL of 0.25M sodium ascorbate plus 150mL of 0.2M HCl (the pKa of ascorbic acid is 4.04) okay, what's the conjugate acid and base of this problem? Can someone wa

What is the Evolution of migration, Evolution of migration Eg Be...

Evolution of migration Eg Benefits associated with migratory flights must be greater than those associated with staying in Alaska and having to tolerate seasonal changes

Eczema and dermatitis, Eczema and Dermatitis: Eczema and Dermatitis ar...

Eczema and Dermatitis: Eczema and Dermatitis are a common problem  all over the world. Their incidence is 2-3  per cent of all medical problems seen  in practice (about 30 per

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