Autonomous versus nested transactions, PL-SQL Programming

Autonomous versus Nested Transactions

Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below:

(i) It does not share the transactional resources (like locks) with the major transaction.

(ii)It does not depend on the major transaction. For illustration, if the major transaction rolls back, nested transactions roll back, while the autonomous transactions do not.

(iii)Its committed changes are visible to other transactions instantly. Whereas the nested transaction's committed changes are not visible to other transactions till the major transaction commits.

Posted Date: 10/5/2012 4:45:09 AM | Location : United States







Related Discussions:- Autonomous versus nested transactions, Assignment Help, Ask Question on Autonomous versus nested transactions, Get Answer, Expert's Help, Autonomous versus nested transactions Discussions

Write discussion on Autonomous versus nested transactions
Your posts are moderated
Related Questions
Perform the following queries on the Hospital1.DB using SQL Anywhere (START EARLY!). a. Which patients have purchased the drug "Tylenol"? List the names and addresses. Arrange the

TTITLE and BTITLE are commands in Pl-SQL to control report headings and footers. This Ttitle & Btitle are mainly used on creating SQL*PLUS report. Ttitle is used for toptitle headi

heap sort program in pl/sql

Use Object Types and Collections The Collection types and object types increase your efficiency by allowing for the realistic data modeling. The Complex real-world entities an

Order of Evaluation When you do not use the parentheses to specify the order of evaluation, the operator precedence determine the order. Now compare the expressions below: NOT

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s

Complete the following steps to create a procedure to calculate the tax on an order. The BB_TAX table contains the states that require taxes to be submitted for Internet sales. If

Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using the  TABLE and CAST operators . The operands of CAST are a collection declared locally

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v