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
Pisciculture: This is the culturing of fishes. There is a principal form of aquaculture called Fish farming, while other methods can come under mariculture. Fish farming main aim i

Membrane-bound organelles are absent in : 1. Saccharomyces 2. Streptococcus 3. Chlamydomonas 4. Plasmodium Streptococcus

Shows evidence of the ability to see the interaction between environment / ecology and genetics /  evolution Some candidates may recognise that evolution can result in less no

Describe the nature of the enzymes involved in the phosphorylation of glucose Phosphorylation of glucose: Glucose is converted to glucose-6-phosphate since phosphorylated inter

Name the sac-like, blind pouch of large intestine, situated below the level of junction of the small intestine into the side of large intestine. At the lower portion of this pouch

Rule of Distal Transformation of Blastema An intriguing phenomenon characteristic of limb regeneration is, that just only the part of the limb removed distal to the level of a

Explain Enzymatic Proteins The most varied and most highly specialized proteins are those with catalytic activity - the enzymes. Virtually all the chemical reactions of organic

What do you understand by Carcinogen? Carcinogen is an agent or a process, which significantly triggers the cell to grow in an uncontrolled manner producing malignant neoplasm

WHAT IS MEGASPOROGENESIS?wHERE IT OCCUR?hOW IT OCCURS?

Q. What are the two major divisions of the chordate phylum? Chordates are divided into vertebrates and protochordates (urochordates and cephalochordates). Q. What are the d