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
Acellular and Cellular Organisms you should be able to characterise living and non- living matter. However, the boundary-line between the two is not very precise. As you have

Your breakfast consists of a cup of black coffee with sugar as well as a plain bagel covered with cream cheese. Describe the digestion of this breakfast as it passes through each m

Define Regulation and Excretion of sodium and chloride? Renal excretion and retention of these elements is closely regulated. The total content of body sodium especially the co

What are the antigens and antibodies of each blood type of the ABO blood system? Type A: antigen A, antibody anti-B. Type B: antigen B, antibody anti-A. Type AB: antigens A and

Dendritic Cells a. Are the same as macrophages b. Bind and digest pathogen proteins c. Secrete immunoglobulin d. All of the above

Explain the Sampling and Analysis of Microbial Load? A food or equipment can be free of visible dirt and still be carrying microorganisms or chemicals that can cause food borne

Particulate matter in gaseous effluents consists of particles of size ranging from 0.1 um to 100 um. The device selection is based upon physical and chemical characteristic of part

Anterior Leaflet Procedure: Repair is more difficult and less successful. Previously, a triangular excision of the anterior leaflet used to be done for prolapse and rupture of

What is a Food Allergy (Hypersensitivity)? A food allergy or hypersensitivity is an abnormal response to a food by our immune system. As illustrated in Figure, this non-toxic a

Binding site  is the place on cellular DNA to which a protein (like transcription factor) can bind. Typically, binding sites may be found in the vicinity of genes, and would be inv