Transaction visibility, PL-SQL Programming

Transaction Visibility

As the figure shows, the changes made by an autonomous transaction become visible to another transaction whenever the autonomous transaction commits. The changes also become visible to the major transaction if it resumes, but only if its isolation level is set to READ COMMITTED (the default).

When you set the isolation level of the major transaction to SERIALIZABLE, as shown, the changes made by its autonomous transactions are not visible to the major transaction when it resumes:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

2226_transaction visibility.png

Figure: Transaction Visibility

Posted Date: 10/5/2012 4:49:04 AM | Location : United States







Related Discussions:- Transaction visibility, Assignment Help, Ask Question on Transaction visibility, Get Answer, Expert's Help, Transaction visibility Discussions

Write discussion on Transaction visibility
Your posts are moderated
Related Questions
Recursion The Recursion is a powerful method for simplify the design of the algorithms. Principally, the recursion means the self-reference. In the recursive mathematical serie

Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean's wants to create a trigger that automatically updates the stock level of all pr

Implicit Cursors The Oracle implicitly opens a cursor to process each SQL statement not related with an explicitly declared cursor. The PL/SQL lets you refer to the most recen

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

CLOSE Statement The CLOSE statement allows the resources held by a cursor variable or open cursor to be reused. No more rows can be fetched from the cursor variable or closed

Implicit Rollbacks Before execute the INSERT, UPDATE, or DELETE statement, the Oracle marks an implicit savepoint . When the statement fails, the Oracle rolls back to the save

Using RENAME in combination with JOIN - SQL Example gives pairs of ids of students having the same name, by joining two renamings of IS_CALLED. Example gives an equivalent ex

Explicit Cursor Attributes The cursor variable or each cursor has four attributes: %FOUND, %ISOPEN, %ROWCOUNT, and %NOTFOUND. When appended to the cursor or cursor variable, th