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

Example of unwrap operator - sql, Example of UNWRAP Operator - SQL Exa... Example of UNWRAP Operator - SQL Example here shows how unwrapping can be done in longhand in SQL. Example: Unwrapping in SQL Letting CONTACT_INFO_WRAPPED denote the res

Defining records, Defining and Declaring Records To create records, yo... Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

Updating variables, Updating Variables For assignment, SQL uses the ke... Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

Updating objects in pl sql, Updating Objects: To change the attributes... Updating Objects: To change the attributes of objects in an object table, you can use the UPDATE statement, as the illustration below shows: BEGIN UPDATE persons p SET p

Use serially reusable packages - performance of application, Use Serially R... Use Serially Reusable Packages To help you to manage the use of memory, the PL/SQL gives the pragma SERIALLY_ REUSABLE that mark some packages as serially reusable . So mark

Using count, Using COUNT The COUNT returns the number of elements that... Using COUNT The COUNT returns the number of elements that a collection presently contains. For instance, when a varray projects contains 15 elements, then the following IF con

In operator-comparison operators, IN Operator The operator IN tests the ... IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Using bulk collect clause- bulk bind performance improvement, Using the BUL... Using the BULK COLLECT Clause The keywords BULK COLLECT specify the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine. You can use these ke

Tautologies, Tautologies: Above given table allows us to read the trut... Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

Using invoker rights in pl sql, Using Invoker Rights: By default, the ... Using Invoker Rights: By default, the stored procedure executes with the privileges of its definer, not its invoker. These procedures are bound to the schema in which they inh