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
1. a. Write a trigger that fires when a part's price is updated. The trigger will write a record into a table called PriceUpdates. The record should contain the information of

I would like to have a custom MS Access database designed and coded that would help me schedule my customer's orders and that would help me track my employees production output and

What are 3 good practices of modeling and/or implementing data warehouses?

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

IN Mode An IN parameter pass the values to the subprogram being called. Within the subprogram, an IN parameter acts like a constant. And hence, it cannot be assigned a value.

Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Declarations in SQL Your program stores values in the variables and constants. As the program executes, the value of the variables can change, but the values constants cannot.

write the program for traffic control system with 10 second, 15 secod, and 20 second delay

Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope