Re[2]: Dirty reads

From: <dgoulet_at_vicr.com>
Date: Wed, 4 Oct 2000 09:58:33 -0400
Message-Id: <10639.118462@fatcity.com>

The subject of "dirty reads" has been around for as long as I've worked w= ith
Oracle, which started back in 1985. It's basically a forbidden subject. = I know
DB2 allows this and there are others who would like it since rollback seg= ments
would become unnecessary from their point of view (it would also make som= e batch
processing a little more error free). But in looking at the ANSI SQL sta= ndard
book that I've got here, dirty reads are NOT standard behavior, actually = it's
prohibited!!

Dick Goulet.

____________________Reply Separator____________________

Subject: Re: Dirty reads
Author: "Ron Rogers" <RROGERS_at_galottery.org> Date: 10/3/00 1:11 PM

I don't think that Oracle would allow it because until the commit is issu= ed the
other users see the "old" data and the user making the changes sees the n= ew
data. If the user wants to see both copies of the data have them login tw= ice.
One to make the changes and the other to view the original data. To circu= mvent
Oracle's method of data integrity would destroy the foundation building b= locks
of the database
ROR =AA=BF=AA
>>> turner_at_tellme.com 10/03/00 03:51PM >>>
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

Please see the official ORACLE-L FAQ: http://www.orafaq.com =

Author: David Turner
INET: turner_at_tellme.com =

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- =

Author: Ron Rogers
INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------