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

Why do c4 plants have dimorphic chloroplasts, a) Why do C 4 plants have di...

a) Why do C 4 plants have dimorphic chloroplasts? Describe the different steps involved in C 4 photosynthetic carbon cycle in such plants.

Enzyme activity, Enzyme Activity Enzymes are biomolecules which catalyz...

Enzyme Activity Enzymes are biomolecules which catalyze (i.e. increase the rates of) chemical reactions. Almost all enzymes are proteins. In enzymatic reactions, the molecules

Topology and cell organ shapes, Topology and Cell Organ Shapes Topolog...

Topology and Cell Organ Shapes Topology is an abstract mathematical exercise that deals with the possible shapes and surfaces of an endlessly/infinitely elastic body. Most cel

Heteromorphic types - intra specific incompatibility, Heteromorphic Types -...

Heteromorphic Types - Intra specific Incompatibility Plants of the same species produce flowers that differ in morphology. This involves two (distyly) or three (tristyly) morp

Digestive system of an arthropod, how does the digestive system of an arthr...

how does the digestive system of an arthropod operate

Air movements at tropical latitudes, Air movements at tropical latitudes ...

Air movements at tropical latitudes Let us now explain air movements at tropical latitudes. The surface air that rushes to fill the equatorial void from the north is deflected

Role of mesoderm and ectoderm in limb morphogenesis, Role of Mesoderm and E...

Role of Mesoderm and Ectoderm in Limb Morphogenesis A series of very interesting experiments on wing and leg buds of chick embryos have clarified the respective roles of meso

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