Re: Re[2]: Dirty reads

From: Jim Conboy <Jim.Conboy_at_trw.com>
Date: Wed, 04 Oct 2000 08:12:35 -0700
Message-Id: <10639.118476@fatcity.com>

Am I the only one with no imagination? How is uncommitted data of any = practical value? Of course I can see the desire to read data as up-to-date= as possible, but if the possibility exists that the data read is 'wrong' = I can't see any advantage to this, and loads of potential harm.

Jim

>>> dgoulet_at_vicr.com 10/04/00 11:06AM >>>
The subject of "dirty reads" has been around for as long as I've worked = with
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 = segments
would become unnecessary from their point of view (it would also make some = batch
processing a little more error free). But in looking at the ANSI SQL = standard
book that I've got here, dirty reads are NOT standard behavior, actually = it's
prohibited!!

Dick Goulet.

____________________Reply Separator____________________
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 = issued the
other users see the "old" data and the user making the changes sees the = new
data. If the user wants to see both copies of the data have them login = twice.
One to make the changes and the other to view the original data. To = circumvent
Oracle's method of data integrity would destroy the foundation building = blocks
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

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: David Turner
INET: turner_at_tellme.com=20

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).

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Ron Rogers
INET: RROGERS_at_galottery.org=20

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

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

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

Received on Wed Oct 04 2000 - 10:12:35 CDT