Advantages of autonomous transactions, Biology

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.

Posted Date: 10/5/2012 4:43:36 AM | Location : United States







Related Discussions:- Advantages of autonomous transactions, Assignment Help, Ask Question on Advantages of autonomous transactions, Get Answer, Expert's Help, Advantages of autonomous transactions Discussions

Write discussion on Advantages of autonomous transactions
Your posts are moderated
Related Questions
Significance of Mitosis 1.      Reproduction ;   William Bateson 1906 wrote, Whenever  I observe a dividing  cell under  the  microscope , I feel  as if the original act of  c

A new drug named ANTAG-CaSR has been developed that is an antagonist at calcium-binding sites of CaSRs (Calcium-Sensing Receptors) in the plasma membranes of parathyroid gland cell

Use of genital herpes in pregnancy Although acyclovir is not approved for treatment of pregnant women, its use during pregnancy has not been associated with an increased risk

In that Unit you also learnt about Darwin, who based on his extensive observations and interpretations showed that evolution is a simple fact of nature. It was Theodosius Dobzhansk

Q Which Of substance are microtubules made and In which structures and cellular processes do microtubules participate? Microtubules are made of consecutive dimers of the protei

Cinemicrography Earlier it was impossible to follow the evenvts within the cell due to: i) non-visibility of cell organelles under a light microscope, ii) maintenance of cells

Define Swollen and Tender Joints and haemorrhage in various Tissues? Haemorrhages occur deep in muscle, particularly in calf, thigh, buttocks and forearm, causing pain in surro

Types of Surgery :  Tricuspid valvotomy is done as an open procedure at the end of surgery on mitral and/or aortic valve. It can be done on an arrested heart or on a beating heart

Explain about Osseointegration Osseointegration is regarded as the process of direct bone apposition on implant surfaces where the bone in contact with the implant later underg

This problem refers to the MN and ABO loci mentioned in class. It also refers to the Rh locus, which is responsible for the positive/negative part of the blood type. The Rh+ allele