Re: Problem with Oracle's Txn Isolation Level

The Oracle default read consistency model guarentees that the data returned to a query is at the point in time of the query based on the then comitted state of the data so that session B will not see any pending changes to the data made by session A at the time the query by B starts. To session A this guarentees that changes made by A are not visible to any other session until such time as session A commits (or rollbacks) its changes.

Take the time to re-read the Concepts manual chapter on read consistency and transaction management. This is one of the most important concepts to understand in order to be able to design properly working applications in Oracle.

HTH -- Mark D Powell -- Received on Sun Jan 16 2005 - 11:15:02 CST