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

Molecules that make possible active transport, Which are the molecules that...

Which are the molecules that make possible active transport through membranes? Ans) Active transport is made by particular membrane proteins. These proteins are known as "pumps"

Define deficiency and toxicity of vitamin d, Define Deficiency and Toxicity...

Define Deficiency and Toxicity of Vitamin D? Infants constitute a population at-risk for vitamin D deficiency because of relatively large vitamin D needs brought about by their

Psychosocial therapy, PSYCHOSOCIAL THERAPY: Psychosocial therapy is on...

PSYCHOSOCIAL THERAPY: Psychosocial therapy is one of  the important treatment modaIities used for the patients with mental disorders. It is given along with other therapies or

Discuss about human ears, Ears We have a pair of ears. Each ear has thr...

Ears We have a pair of ears. Each ear has three parts - external, middle and inner ear. The function of the middle ear is transmission of sound waves from external to inner ear

What is sodium bicarbonate, What is Sodium Bicarbonate? The administrat...

What is Sodium Bicarbonate? The administration of bicarbonate may be considered if the pH remains below 7.1 or if hyperkalemia or tricyclic antidepressant overdose is suspected

Discuss about the common migraine, Discuss about the Common migraine Th...

Discuss about the Common migraine This is the most frequent type, occurring in more than 80% of migraine sufferers. There is no clear aura as there is in classic migraine, but

Explain activators, Activators Activity  of many  enzymes is  influence...

Activators Activity  of many  enzymes is  influenced by  certain ions called as activators. Large number of enzymes such as hexokinase that require ATF are also in need of diva

Agro industrial-incriminating factors in feeds, Agro Industrial-Incriminati...

Agro Industrial-Incriminating factors in feeds There are many anti-nutritional factors present in feeds and fodders which affect the utilization of nutrients. Some of these are

What are the two divisions of the autonomic nervous system, What are the tw...

What are the two divisions of the autonomic nervous system? The autonomic nervous system is separated into the sympathetic nervous system and the parasympathetic nervous system

What proportion of changes in the third position, If a codon is CDC, what p...

If a codon is CDC, what proportion of nucleotide changes in the third position result in a new amino acid? If the codon is AGG, what proportion of changes in the first position res

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