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

Difference between plants and animals, DIFFERENCE BETWEEN PLANTS  AND ANIM...

DIFFERENCE BETWEEN PLANTS  AND ANIMALS - S . N o . C h a ra c ter P l an ts A n i m al s 1 Nutrition

Skeletal tissue, what is the classification of skeletal tissue?

what is the classification of skeletal tissue?

Define the vitamin and minerals required for elderly, Define the Vitamin an...

Define the Vitamin and Minerals required for elderly? Decreased gastric secretion and intestinal motility affect the absorption and intake of nutrients especially calcium, iron

Explain the steps of converting food into energy, Explain the steps of conv...

Explain the steps of converting food into energy. There are four steps to convert food into energy: a) Ingestion, mastication and swallowing : Ingestion or taking in of food

Meiosis and Mitosis, #question.Consider a cell that has 10 homologous pairs...

#question.Consider a cell that has 10 homologous pairs of chromosomes and is just starting to go through meiosis. After meiosis is complete, there will be 40 cells that each contai

Define hydrolytic rancidity - lipolysis, Define hydrolytic rancidity Li...

Define hydrolytic rancidity Lipolysis is a major action occurring during deep fat frying due to large amounts of water introduced from the food and the relatively high temperat

List the five major phases of the cell cycle, List the five major phases of...

List the five major phases of the cell cycle, and briefly explain what happens during each phase. G1 phase: the cell grows. S phase: DNA is copied. G2 phase: the cell prepares

How does the amoeboid movement occur, How does the amoeboid movement occur?...

How does the amoeboid movement occur? What are examples of beings and cells that use such movements for locomotion? Amoeboid movements are formed by cytoplasmic movements and p

Percentage ratio of ash in honey, Q. Percentage ratio of ash in honey? ...

Q. Percentage ratio of ash in honey? Standards allow ash content in honey up to 0.5 per cent, but the ash of genuine honey seldom exceeds 0.35 per cent. It is determined by cha

Which heavy metals cause toxic pollution, Besides mercury which other heavy...

Besides mercury which other heavy metals cause toxic pollution? Examples of other heavy metals that cause toxic pollution are lead, cadmium and chromium.

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