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
Scope Rules You cannot declare an exception twice in the similar block. Though, you can, declare the similar exception in 2 different blocks. The Exceptions declared in a bloc

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

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.

Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl

Albeit simple method : These all the truth tables give us our first as albeit simple method for proving a theorem: where check whether it can be written in propositional logic

Using Savepoints The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined

UTL_FILE: The Package UTL_FILE permits your PL/SQL programs to read & write operating system (OS) text files. It gives a restricted version of the standard OS stream file I/O,

Initializing Objects: Till you initialize an object by calling the constructor for its object type, the object is automatically null. That is, the object itself is null, not me

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

I want to implement heap sort algorithm in pl sql please share the source code for guidance