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

What are the main types of cancer that affect humans, Q. What are the main ...

Q. What are the main types of cancer that affect humans? An Excluding skin cancer, that are the more easily detected and so cases are registered in larger number, the main type

Define the equilibrium potential for potassium ions, A complete motor neuro...

A complete motor neuron is removed from a frog and placed in a large volume of normal physiological saline.  The neuron is healthy; it has a stable resting voltage of -70 millivolt

Illustrate the maturation of honey, Q. Illustrate the maturation of honey? ...

Q. Illustrate the maturation of honey? Honey is the oldest sweet food known to man. Although honey is a natural sweetener, it is considered a refined sugar because 96% of dr

Rheumatic heart disease, Rheumatic heart disease was the predisposing cardi...

Rheumatic heart disease was the predisposing cardiac lesion for IE in 20 to 25 per cent. In patients with rheumatic heart disease, endocarditis occurs most frequently on the mitral

Define iron requirements of school children and adolescents, Define Iron re...

Define Iron requirements of school children and adolescents? The iron requirements are also computed by factorial method and should therefore add iron requirement of maintenanc

Define fatty acid synthesis, Fatty acid synthesis is the formation of fatty...

Fatty acid synthesis is the formation of fatty acids from malonyl-CoA and acetyl-CoA precursors by action of enzymes called as fatty acid synthases. It is a very significant part o

Gene targeting in somatic cells, Gene targeting in somatic cells: Since t...

Gene targeting in somatic cells: Since the pioneering work with sheep at Roslin cloning by nuclear transfer has now been exemplified in a number of other livestock species includ

Class of crustacea - branchiopoda, Class of Crustacea - Branchiopoda ...

Class of Crustacea - Branchiopoda These are small fresh water crustaceans. The trunk appendages are flattened and leaf like and are helpful for locomotion also respiration he

Which terrestrial vertebrate group is extremely rare deserts, Which terrest...

Which terrestrial vertebrate group is extremely rare in deserts? The Amphibians are terrestrial vertebrates very rare in desert environments (although there are a few species a

Explain about cyanocobalamin, Explain about Cyanocobalamin Cyanocobala...

Explain about Cyanocobalamin Cyanocobalamin occurs as dark red crystals or as a crystalline hygroscopic powder of the same colour without odour and taste. Upon standing in the

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