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 agar shake tube method, Define the Agar Shake Tube Method Th...

Define the Agar Shake Tube Method The agar shake tube method is useful for isolation of anaerobic microorganisms. What are anaerobic microorganisms? You may recall the theory c

List out the different preservation techniques, List out the Different Pres...

List out the Different Preservation Techniques? The different preservation techniques commonly used today are given in the Table. Table: Methods of food preservation a)

What do you mean by sex ratio, What do you mean by sex ratio? Sex Rati...

What do you mean by sex ratio? Sex Ratio is defined as "the number of females per 1000 males". Sex ratio is an important social indicator to measure the extent of prevailing e

frog, what is the xternal & internal respiration in fro

what is the xternal & internal respiration in frog

Retention of soil moisture, Retention of Soil Moisture The movement of ...

Retention of Soil Moisture The movement of water into and within the soil, moisture storing capacity of soils and the availability of moisture to plants are governed by soil pr

Temperature and concentration of nutrients, Temperature and Concentration o...

Temperature and Concentration of Nutrients Temperature Temperature like salinity remains almost constant in the oceans in contrast to the land or terrestrial ecosystems

Which statement about asexual reproduction is false, Which statement below ...

Which statement below about asexual reproduction is FALSE? a.With asexual reproduction, offspring are genetically identical to the parent. b.Asexual reproduction requires no

State the series of stimuli, State the series of stimuli ERPs a series ...

State the series of stimuli ERPs a series of stimuli such as tones or light flashes are presented to the participant, and the raw EEG for a precise one or two second period fol

Explain cephalosporin, Explain cephalosporin Third-generation cephalosp...

Explain cephalosporin Third-generation cephalosporins, like cefotaxime  (Claforan), ceftriaxone  (Rocephin), cefoperazone  (Cefobid), ceftazidime (Fortaz, and others), or cefti

Define herbals - old books about plants, Define Herbals - Old books about P...

Define Herbals - Old books about Plants? During the Middle Ages, following the decline of the Greek and Roman civilisations, little significant botanical progress was made. The

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