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

Explain the concept of overheating the bone, Overheating the bone and exert...

Overheating the bone and exerting too much pressure Minimal temperature elevation during surgical drilling of the bone is a key factor in atraumatic surgical technique. Bone ce

Mode of nutrition , What is the mode of nutrition in fish,human,amoeba,scor...

What is the mode of nutrition in fish,human,amoeba,scorpian & toad ?

List the benefits of lsm, List the benefits of LSM. Life style modifica...

List the benefits of LSM. Life style modification helps in the following ways: - Reduction of weight - Good sugar control - Good blood pressure control - Reduction

Types of tissue have the greatest capacity to regenerate, Q. Which types of...

Q. Which types of tissue have the greatest capacity to regenerate? Epithelial and connective tissues have the greatest capacity to regenerate. In injuries andsmall wounds, epit

Eucaryotic cell structure , Eucaryotic cell structure All eucaryotic c...

Eucaryotic cell structure All eucaryotic cells have a cytoskeleton made up of a network of protein filaments (Figure shown below). This network gives the cell its shape, capac

What are respiratory pigments, What are respiratory pigments? What is the r...

What are respiratory pigments? What is the respiratory pigment present in some arthropods? Which is the analogous molecule in humans? Respiratory pigments are molecules able t

Amphibians, respiratory system in amphibains

respiratory system in amphibains

Deifition, what''s the define of mitochodria

what''s the define of mitochodria

How are lipids classified, Regarding solubility, how are lipids classified?...

Regarding solubility, how are lipids classified? Fats and oils are hydrophobic molecules, i.e., they are non polar and insoluble in water. Lipids in general are molecules with

Why are vaccines used in the prevention, Q. Why are vaccines used in the pr...

Q. Why are vaccines used in the prevention but not in the treatment of infections? Why can antivenom serums be used in prevention and treatment? Vaccines are not used in the tr

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