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

Define the role of riboflavin in respiratory chain, Define the Role of Ribo...

Define the Role of Riboflavin in Respiratory Chain? Riboflavin catalyzes numerous oxidation-reduction reactions. Conversion of riboflavin to flavin mononucleotide (FMN) and the

Sample titration - estimation of vitamin c in chillies, Define Sample Titra...

Define Sample Titration - estimation of vitamin c in chillies? Take a clean and dry large chilli and weigh it. Note the weight of the chilli. Grind the chilli to a fine paste i

Role of private sector in health care - competition, Role of Private Sector...

Role of Private Sector in Health Care - Competition When the private sector is driven by competition it tends to be more efficient. With competition, benefits like cost reduct

What is the meaning of ideometric approach, What is the meaning of Ideometr...

What is the meaning of Ideometric approach Ideometric approach in the context of neuropsychological assessment emphasises the patient's premorbid functioning with reference to

Explain the complications of burns, Explain the Complications of Burns? ...

Explain the Complications of Burns? Most minor burns are superficial and do not cause complications. However, deep second-degree and third-degree burns swell and take more time

Photophosphorylation, explain the role of cyclic photophosphorylation in p...

explain the role of cyclic photophosphorylation in photosynthesis

Cardiac care on admission for operation, Cardiac Care on Admission (First t...

Cardiac Care on Admission (First two hours) ECG is monitored by more than one lead (three to five). Left atrial pressure, arterial BP, central venous pressure, respiration

Nudation - processes in succession, Nudation - Processes in Succession ...

Nudation - Processes in Succession The first step or requirement is the availability of the right kind of habitat, primary succession takes place in a bare area, that is, with

Define oseltamivir, Oseltamivir (Tamiflu)   This oral neuraminidase i...

Oseltamivir (Tamiflu)   This oral neuraminidase inhibitor, started within 36 hours of symptom onset, can decrease the severity and duration of symptoms caused by either influ

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