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

Mutitations, the concept that new varieties of organisms are still evolving...

the concept that new varieties of organisms are still evolving is best supported by the.......?

Functions of insulin, FUNCTION S - (a) It is antagonistic to glucagon....

FUNCTION S - (a) It is antagonistic to glucagon. Insulin decreases the level of glucose in the blood. It acts by increasing the rate at which glucose is transported out of the

How an electron acceptor becomes nadh, If NAD+ is an electron acceptor that...

If NAD+ is an electron acceptor that becomes NADH and the NADH then donates a proton to ATPase, shouldn't NADH now become NAD- since it lost it's proton but still has the electron?

What is the determination of vitamin B1, What is the Determination of vitam...

What is the Determination of vitamin B 1 Vitamin B 1 is determined by chemical method and microbiological assay. In the chemical method, vitamin B 1 is oxidized in alkaline

Explain erythema migrans, Erythema migrans Oral antibiotic therapy sho...

Erythema migrans Oral antibiotic therapy shortens the duration of the rash and generally prevents development of late sequelae. Among the 3 drugs used for this indication, onl

How did the first fermenting autotrophs appeared, How did the first ferment...

How did the first fermenting autotrophs appeared? What about the first aerobic beings? A heterotrophic hypothesis asserts that the first living beings were the fermenting heter

Illustrate wild life sanctuaries, Q. Illustrate Wild Life Sanctuaries? ...

Q. Illustrate Wild Life Sanctuaries? You must have seen how some of the parks are fenced. The intention is to keep the animals from wandering out and not to destroy neighbourin

Animals vs plants, Animals vs Plants Organisms are of two main types an...

Animals vs Plants Organisms are of two main types animals and plants, although all the above mentioned Unifying concepts of Biology apply equally to both animals and plants, ye

01.03 New Technology , What is the best microscope to get a detailed view o...

What is the best microscope to get a detailed view of the parts inside of a preserved plant cell? Transmission electron microscope Scanning electron microscope Compound li

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