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

Explain three main steps for a good study of genetic tree, What are the thr...

What are the three main steps for a good study of a genetic family tree? Step 1: to determine whether the studied phenotypical form has a dominant or recessive pattern. Step

Class of subphylum uniramia - symphyla, Class of Subphylum Uniramia - Symph...

Class of Subphylum Uniramia - Symphyla Symphyla is yet other small myriapodous group that includes around 160 described species. These are also soil living forms and live in l

Explain the behavioural change communication, Explain the Behavioural chang...

Explain the Behavioural change communication? One of the reasons for the widespread prevalence of PEM in our country is ignorance due to illiteracy, particularly among the fema

How inadequate breast milk cause protein energy malnutrition, How Inadequat...

How Inadequate Breast Milk cause protein energy malnutrition? Though prolonged breastfeeding of children is the rule in US, the amount of breast milk secreted in poor Indian mo

How are the lipids classified, Q. Concerning solubility, how are the lipids...

Q. Concerning solubility, how are the lipids classified? Oils and Fats are hydrophobic molecules, i.e., they are insoluble in water and non polar. Lipids in general are molecul

Define the dietary guidelines, Define the Dietary Guidelines? Dietary G...

Define the Dietary Guidelines? Dietary Guidelines are becoming increasingly powerful tools to help the general public to appreciate the role of diet in prevention of degenerati

Environment , Environment All organisms are intimately dependent on the ...

Environment All organisms are intimately dependent on the environment from which they derive their sustenance. Organisms from virus to man are obligatorily dependent on the envi

Human skeleton, what are the main coponents of human skeleton?

what are the main coponents of human skeleton?

Explain the basal metabolic rate, Explain the Basal Metabolic Rate? The...

Explain the Basal Metabolic Rate? The Basal Metabolic Rate (BMR) gradually decreases after the attainment of maturity due to a decrease in muscle mass tissues and physical acti

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