Re: Dirty reads

From: yong huang <yong321_at_yahoo.com>
Date: Wed, 4 Oct 2000 07:19:37 -0700 (PDT)
Message-Id: <10639.118466@fatcity.com>

Hi,

ANSI SQL92 standard defines four levels of transaction isolation levels. The first and the "dirtiest" is what you describe. Oracle does not support this level. It's said that MS SQL server does. Oracle only supports Read Committed (default) and Serializable, plus a non-ANSI standard Read Only.

For more information, read Chapter 24 Data Concurrency and Consistency of the Concept manual at
http://technet.oracle.com/doc/oracle8i_816/server.816/a76965/toc.htm.

Yong Huang
yong321_at_yahoo.com

you wrote:

 From: David Turner
 Date: Tue, 3 Oct 2000 11:46:02 -0700
 Subject: Dirty reads

Is there any way to say I want a select that won't look at the rollback segment? The user doesn't care if it's a dirty read.

Dave Turner

---

Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ Received on Wed Oct 04 2000 - 09:19:37 CDT