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

Ask an Expert

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

Write your message here..

Related Questions

Write a program to implement inverted file shown slider, Write a program to... Write a program to implement the inverted file shown in the slides (Simple Index file, LabelID file and Data file).  Use the Avail_List to point at the deleted Label IDs so that th

Logical operators-pl/sql expressions , Logical Operators The logical op... Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Commit statement in pl sql, COMMIT Statement The COMMIT statement expli... COMMIT Statement The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered e

Existential quantification - sql, Existential Quantification - SQL Ex... Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Effects of null in aggregate operator - sql, Effects of NULL in Aggregate O... Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

PROCEDURES AND FUNCTIONS QURIES, i NEED THE QURIES TO SOME OF THE PROBLEMS ... i NEED THE QURIES TO SOME OF THE PROBLEMS USING plsql

Ensuring backward compatibility, Ensuring Backward Compatibility   The... Ensuring Backward Compatibility   The PL/SQL Version 2 permits some abnormal behavior which Version 8 disallows. Particularly, Version 2 permits you to (i) Make the forw

Logical connectives - sql, Logical Connectives - SQL SQL's extended t... Logical Connectives - SQL SQL's extended truth tables in which the symbol, for unknown, appears along with the usual T and F. Negation (NOT, ¬) Conjunction (

Keyword & parameter description - expressions, Keyword & Parameter Descript... Keyword & Parameter Description: boolean_expression: This is an expression which yields the Boolean value that is TRUE, FALSE, & NULL. character_expression: This

Package dbms output in pl/sql, DBMS_OUTPUT: The Package DBMS_OUTPUT en... DBMS_OUTPUT: The Package DBMS_OUTPUT enables you to display output from the PL/SQL subprograms and blocks, that makes it easier to test and debug them. The procedure put_ line