Advantages of autonomous transactions, Biology

Assignment Help:

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.


Related Discussions:- Advantages of autonomous transactions

What do you meant by diabetic ketoacidosis, Q. What do you meant by Diabeti...

Q. What do you meant by Diabetic Ketoacidosis? Diabetic Ketoacidosis (DKA) is one of the acute complications of diabetes mellitus. The name itself implies that there is acidosi

Experiment, I need an idea for a Biology experiment

I need an idea for a Biology experiment

Define isomerases, Isomerases These  enzymes (code  EC 5)  catalyze geo...

Isomerases These  enzymes (code  EC 5)  catalyze geometric  or  structural  changes  within  a molecule. According  to the  type of  isomerism,  they  may be  called  racemases

Male reproductive disorders-cryptorchidism, Cryptorchidism Cryptorchid...

Cryptorchidism Cryptorchidism or incomplete descent of testis or retention of testis in the abdominal cavity occurs in all domestic species but is seen most commonly in stalli

Which does not contain a guanidinium group, Which of the following does NOT...

Which of the following does NOT contain a guanidinium group Select one: a. Urea b. arginine c. creatine d. guanidinium ion

Interphase again between meiosis ii and meiosis i, Q. Is there interphase a...

Q. Is there interphase again between meiosis II and meiosis I? There is no interphase or DNA duplication between the divisions of meiosis. Only a short interval termed as diaki

State the definition of bio-medical waste, State the definition of Bio-medi...

State the definition of Bio-medical waste 'Bio-medical waste' means any solid and/or liquid waste including its container and any intermediate product, which is generated durin

Oral route - administration of drugs, Oral Route Paediatric Medication...

Oral Route Paediatric Medications are prepared as Tablets (which can be crushed), powders, granules, mixtures, emulsions, elixirs and syrups. It is easier to persuade olde

Obtain half their genes from one parent, If children obtain half their gene...

If children obtain half their genes from one parent and half from the other parent, why aren't siblings identical?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd