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

State the functional domains in children, Functional Domains in Children ...

Functional Domains in Children There are three functional domains of particular interest in this age range: Attention, Memory, and Executive function. The

Explain results of abdominal aneurysm surgery, Explain Results of  abdomin...

Explain Results of  abdominal aneurysm surgery? Results:  For ascending aorta replacement, the hospital mortality varies from 0 to 9 per cent. Aortic arch has higher risk of

Determine the production of red blood cells, What is the substance that sti...

What is the substance that stimulates the production of red blood cells? Which is the organ that secretes it? Under what conditions does this secretion increase? The substance

Historical development of psychiatric nursing, HISTORICAL DEVELOPMENT OF PS...

HISTORICAL DEVELOPMENT OF PSYCHIATRIC NURSING: History is a  record of opportunities, recognized and informed,  that produce profound changes in a given field. History of psyc

Human milk composition and infant growth and development, Explain the Human...

Explain the Human Milk Composition and Infant Growth and Development? This sub-section deals with composition of human milk, compares human milk with cow's milk and why human m

Disorder of parathyroid function, Disorder of Parathyroid Function: Th...

Disorder of Parathyroid Function: The disorders of parathyroid function may  either  lead  to increased production or decreased production of parathormone.  Hypoparathyroid

Explain the types of care of teeths, Explain the types of care of teeths ...

Explain the types of care of teeths a) Plastic/ Nylon  Scalers: These are available in a variety of shapes and are moderately effective in calculus removal. Can be Ultrasonic

Neo-zoonoses, Neo-zoonoses In recent times, some of the pre-existing l...

Neo-zoonoses In recent times, some of the pre-existing low profile and less frequent zoonoses and some entirely newly recognized zoonoses are emerging with a new dimension. Th

Cell biology, what is the role of cholesterol in membrane fluidity?

what is the role of cholesterol in membrane fluidity?

Staphylococcal food poisoning, Staphylococcal food poisoning results from c...

Staphylococcal food poisoning results from consumption of food containing enterotoxin produced by enterotoxigenic strains of Staphylococcus aureus. It is caused by ingestion of imp

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