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

What is an ecosystem?, What is an ecosystem? An ecosystem is the system...

What is an ecosystem? An ecosystem is the system that composed of biotic and abiotic factors in interaction.

What are halophile, What are halophile, thermoacidophile and methanogen arc...

What are halophile, thermoacidophile and methanogen archaebacteria? There are three peculiar parts of archaebacteria. The halophile archaebacteria only survive in salt-rich env

Explain plain dwellers, Which two of the following changes (a - d) usually ...

Which two of the following changes (a - d) usually tend to occur in the plain dwellers when they move to high altitudes (3,500 m or more)? 1. Enhance in red blood cell size 2

Classification, list the major species of echinodermata

list the major species of echinodermata

Features of gateway vector, Could any of the following features be useful i...

Could any of the following features be useful in a gateway vector; (i) Origin of replication (ii) multiple cloning site (iii) blue/white selection (iv) M13 forward and rev

Compare between mummers of dna vs monomers of rna, Name few polymers in the...

Name few polymers in the eukoratic cell? Name the mummers that make up the DNA? Compare and contrast between mummers of DNA VS monomers of RNA?

Precautions by dangers of working in labs with animals, The dangers of work...

The dangers of working in labs with animals will be minimised if the following precautions are taken: 1. Wash all dissection instruments in disinfectant after use. 2. Never

What are anteromedial aspects of temporal lobes, Q. What are anteromedial a...

Q. What are anteromedial aspects of temporal lobes? Olfactory Cortex - found in anteromedial aspects of temporal lobes receive sensory information directly from the olfactory n

Bohr effect, Bohr Effect Another important influence is the pH. Increa...

Bohr Effect Another important influence is the pH. Increase in carbon dioxide or other acids lowers the pH of plasma and shifts the dissociation curve to the right. At high ca

How to decreases the rate limiting, When the product of a metabolic pathway...

When the product of a metabolic pathway decreases the rate limiting earlier in the pathway it is called?

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