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
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 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 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-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 Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

i NEED THE QURIES TO SOME OF THE PROBLEMS USING plsql

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 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: boolean_expression: This is an expression which yields the Boolean value that is TRUE, FALSE, & NULL. character_expression: This

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