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

Genetics, how to determine that the phenotype of a wild type is due to the ...

how to determine that the phenotype of a wild type is due to the action of one or two genes?

Algae, classificationof algae

classificationof algae

Use of gloves as personal protective equipment, Q. Use of Gloves as persona...

Q. Use of Gloves as personal protective equipment? Gloves are task specific. The different types of gloves worn in the dental office are: i) Examination gloves ii) Over o

Nervous tissue, This constitutes about 2.4% of the body weight of man viz. ...

This constitutes about 2.4% of the body weight of man viz. Brain-1400 gram Spinal nerve-150 gram Spinal cord-30 gram Cranial nerve-10 gram C.S.F. is altogether not present in

Aschelminthes, in what part of the human body aschelminthes found?

in what part of the human body aschelminthes found?

Explain adverse effects of famciclovir, Adverse Effects of Famciclovir ...

Adverse Effects of Famciclovir Famciclovir has been generally well tolerated. Headache, nausea and diarrhea have been reported. Like acyclovir, famciclovir has been associated

Fate of pyruvate, Pyruvate Pyruvate has three different  fates. Under a...

Pyruvate Pyruvate has three different  fates. Under aerobic conditions,  pyruvate enters mitochondriaand is converted to acetyl CoA. The acetyl CoA enters thecitric acid cycle.

Explain the term tracheostomy, Explain the term Tracheostomy ? If the d...

Explain the term Tracheostomy ? If the duration of mechanical ventilation is likely to be prolonged, it is wise to do an early tracheostomy. Otherwise, a tracheostomy is usuall

Describe oxidative stress in new cardio-vascular, Describe Oxidative Stress...

Describe Oxidative Stress in New Cardio-vascular Risk Factors ? In the risk conferred by LDL cholesterol, the oxidative modification of LDL plays a central role, because it is

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