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
When do you use the term 2' carbon and when do you use 2 carbons on a molecular structure? I need examples please!

Q.How is it produced and what is the function of cholecystokin in the digestive process? The fat level of the chyme detected in the duodenum stimulates the secretion of cholecy

Equal Distribution of Hereditary Material: In mitosis the heredity material is equally distributed in the daughter cell. 2.No Change in Genetic Information: As there is no

Neurulation in Amphibians The first step in the neurulation process is the flattening and thickening of dorsal ectoderm to form neural plate. The plate of cells are different

Explain the role of solutions? Solutions:  A solution consists of a liquid solvent plus substances dissolved in it, called solutes. Solutes may be ions, atoms, or small molec

Determine the Requirement of carbohydrate for Endurance Events? For endurance events like sprinting (100 m run), football, hockey, the carbohydrate intake can be placed at 7:10

We now understand that mutations that cause the inhibition of apoptosis are found in tumors. Because proliferation itself is not induced by the inhibition of apoptosis, explain how

what are the general characteristicss of porifera

What are intraspecific and interspecific ecological interactions? Intraspecific ecological interactions are those among individuals of the same species. Interspecific ecologic