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

When the carbon dioxide concentration is increased, Why is the carbon dioxi...

Why is the carbon dioxide concentration a limiting factor of the photosynthesis process? When the carbon dioxide concentration is increased indefinitely is photosynthesis also incr

Acid indigestion, Acid indigestion It is also known as ruminal acidosis...

Acid indigestion It is also known as ruminal acidosis, acute carbohydrate engorgement, rumen over load or lactic acidosis. Ingestion of large quantities of highly fermentable c

Aves, Flighting adaptations in birds

Flighting adaptations in birds

Zoology, #question.what is protostomous and deuterostomes development.

#question.what is protostomous and deuterostomes development.

Is calcium-sensing receptors serves as a sensor, Which of the following ser...

Which of the following serves as a sensor, or as part of a sensor, that functions in a positive feedback system? A. CaSRs (Calcium-Sensing Receptors) situated in the plasma mem

Discuss about xeno-transplanation, Discuss about xeno-transplanation Mo...

Discuss about xeno-transplanation Most defects / diseases treated by xeno-transplanation are not genetic in origin so the therapy will have no impact on gene pool in terms of c

Describe about development of sexual maturity in children, Briefly Describe...

Briefly Describe about Development of Sexual Maturity in Children? Sexual maturity develops along with growth spurt in adolescence. In girls, growth stops on attaining menarche

Why is the development of bipedalism considered, Why is the development of ...

Why is the development of bipedalism considered to be a major advancement in human evolution?

Determine the bony walls of the maxillary sinus, Determine the bony walls o...

Determine the bony walls of the Maxillary sinus: The Anterior wall of the sinus has thin compact bone above the apex of the canine teeth which may extend to the lateral pirifor

Introduction to metabolism, Introduction to Metabolism An organism have...

Introduction to Metabolism An organism have to be managed its cellular organization and internal equilibrium despite the external forces which act upon it. Cells take in nutrie

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