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 are the male pronucleus and the female pronucleus, Q. What are the mal...

Q. What are the male pronucleus and the female pronucleus? The female pronucleus is the proper haploid nucleus of the egg cell and Male pronucleus is the haploid nucleus of the

What are the values of dpd for plant cells under hypertonic, What are the v...

What are the values of DPD for plant cells under hypertonic, isotonic and hypotonic media? In plant cells under hypertonic medium there is loss of water for the exterior, SF >

What are cell movements, What are cell movements? How are these movements c...

What are cell movements? How are these movements created? Cell movements are movements done by cell structures, like the movements of cilia and flagella, the pseudopod movement

Glucagon and glucocorticoids, Important  aspects  related to regulation inc...

Important  aspects  related to regulation include: 1)  The hormones glucagon and glucocorticoids  which are  secreted  during  starvation stimulate  glucose-6-phosphatase to en

Iron age, Explain the factors that led to the decline of Science in Europe ...

Explain the factors that led to the decline of Science in Europe during iron age

Colonial theory - metazoa, Colonial Theory - Metazoa  This is the most...

Colonial Theory - Metazoa  This is the most popular theory on the origin of Metazoa. The idea was conceived by Haeckel (1874) modified by Metschnikoff (1886) and revived by Hy

Determine the duodenum from the stomach called, What is the valve that sepa...

What is the valve that separates? What is its function? The valve that divides the stomach from the duodenum is the pylorus. It has the function of keeping the food bolus within

What is meningitis, What is meningitis? Meningitis is the generic name ...

What is meningitis? Meningitis is the generic name given to inflammation of the meninges, membranes that cover the central nervous system. Meningitis can have various causes (i

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