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
Use of COUNT in SQL It describes and discusses various general methods of expressing constraints, eventually noting that support for "=" with relation operands is sufficient f

Use Bulk Binds If SQL statements execute inside a loop using the collection elements as bind variables, context switching between the PL/SQL & SQL engines can slow down the ex

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Type versus Representation Confusion in SQL This describes how a value might have two or more distinct representations. For example, user-defined type POINT might have a decla

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Multiple Assignment- SQL SQL supports multiple assignment to local variables and also applies multiple assignment semantics in SET clauses of UPDATE statements, but does not

DBMS_PIPE: The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to

Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

WHILE-LOOP The WHILE-LOOP statement relates a condition with the series of statements enclosed by the keywords LOOP and END LOOP, as shown: WHILE condition LOOP sequence_of_sta