Re: Changing isolation level?

Hemant Shah wrote:

> Folks,
>
> I have been working with DB2 for few years now, and in DB2 I can use the
> isolation level of CS. If one process has updated the row or deleted the row
> but not yet commited it, and another process tries to read it, it will be
> blocked until the first process commits the changes.
>
> In Oracle the default behaviour is that the select of the second process
> gets the old version of the data. How can I change the isolation level,
> preferably at database level, so that is blocks the selects if the select
> for update and delete has not yet commited the changes.
>
> Which isolation level in Oracle can I use?

You're out of luck. Oracle only has two isolation levels, and neither of them will block any reader from seeing committed data, regardless of whether there is some other transaction that will soon commit data changes or deletes.
Joe Weinstein at BEA
>
>
Received on Tue Dec 02 2003 - 15:49:59 CST