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
Oil seed meals as source of limiting amino acids Generally ruminants are not perceived to have a requirement for essential amino acids as the rumen microbes can synthesis esse

Q. What is the vector of Chagas' disease? How is the disease transmitted? The vector of the Chagas' disease is its intermediate host, a triatomine bug. The key species is Triat

Q. How different are animal cells from plant cells? While plant cells are eukaryotic, photosynthetic, autotrophic and have chloroplasts and cell wall, the animal cells are hete

Gastro Epiploic Artery (GE) :  Gastro epiploic artery is a less popular arterial conduit now. The midline chest incision is extended to the umbilicus and the right ga

Genic Type-Genetic basis of Sex Determination In some organisms, certain indepe~ident genes located on different chromosomes are responsible for sex determination. Most species

State the goals of Neuropsychological assessment Neuropsychological assessment therefore has twin goals. i) The first goal is to recognize the disrupted psychological compo

Q. What is the difference between diastoleSystole and systole and diastole are the two stages into which the cardiac cycle is divided Diastole is the stage of the cardiac cycle

Q. Urine Examination of the diabetes Patient? Generally when blood testing facilities are not available, urine is tested for the presence of sugar. A urine sample shows presenc

Polyarthritis  1)  Gonococcal - Therapeutic trial of pencillin may help in diagnosis of gonococcal  infection.  2)  Viral infections such as rubella and hepatitis B may have

Oogenesis Oogenesis is the formation of ovum from oogonial cells that are formed in the ovary from primordial germ cells. And as in spermatogenesis it involves meiosis to pro