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
Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

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

Accessing Attributes: You can refer to an attribute only by its name not by its position in the object type. To access or modify the value of an attribute, you can use the dot

Cursor Variables Similar to a cursor, cursor variable points to the current row in the result set of a multi-row query. But, dissimilar a cursor, a cursor variable can be opene

Anatomy of a Table: Figure shows the terminology used in SQL to refer to parts of the structure of a table. As you can see, SQL has no official terms for its counterpa

which operation is used if we are interested in only certain columns of a table?

Deriving Predicates from Predicates in SQL The corresponding section in the theory book describes how predicates can be derived from predicates using (a) the logical connectiv

Effects of NULL for Multiple Assignments - SQL If the row expression given as the source for a multiple assignment evaluates to NULL, then NULL is assigned to each target. If

Operator Precedence The operations within an expression are completed in a particular order depending on their precedence (priority). The table shows the default order of the op

Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t