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

Determine the categories of Taxonomic breakdown, For convenience, living th...

For convenience, living things are placed into different groups. Taxonomic breakdown of living things comprises the following categories: Family, Class, Genus, Phylum, Order, K

How are living beings divided into two groups, Q. According to the cellular...

Q. According to the cellular organization how are living beings divided into two groups? Cellular beings are divided into two groups, unicellular beings and the prokaryotes who

Explain ketoconazole, Explain Ketoconazole It is now seldom used. The ...

Explain Ketoconazole It is now seldom used. The other azoles have fewer adverse effects and are usually preferred. Ketoconazole remains an option for treatment of infections w

Diplotene and diakinesis, Diplotene: The paired chromosomes repel eac...

Diplotene: The paired chromosomes repel each other and begin to separate. Separation however, is not completed, because homologous chromosomes remain united by their point

What is the climax stage of an ecological succession, Q. What is the climax...

Q. What is the climax stage of an ecological succession? The climax stage is the stage of an ecological succession in which the community of an ecosystem turn into stable and d

How far from the building should the fire hose be located, A fire hose ejec...

A fire hose ejects a stream of water at an angle of 38.8 ° above the horizontal. The water leaves the nozzle with a speed of 26.6 m/s. Assuming that the water behaves like a projec

What are gene interactions?, What are gene interactions? What are the three...

What are gene interactions? What are the three main types of gene interactions? The Gene interaction is the phenomenon in which a given phenotypical trait is conditioned by two

Lotic ecosystems rivers, Lotic Ecosystems Rivers The lotic or flowing...

Lotic Ecosystems Rivers The lotic or flowing water habitats include rivers streams, brooks etc. The most outstanding features of such habitats is the continuously flowing wat

Photosynthesis, explain the role of photophosphorylation and chemiosmosis i...

explain the role of photophosphorylation and chemiosmosis in photosynthesis

Describe some food borne diseases, Q. Describe some Food borne disease? ...

Q. Describe some Food borne disease? Food borne diseases are caused by the ingestion of foods containing toxic or infectious agents. In India, the diseases transmitted by foo

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