| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dirty reads
Actually, the next release of Oracle (by next I mean 9i) they
will be allowing you to look at uncommitted data. This will
be at the session level and needs to be turned on. It will not
be the default behavior.
-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org]
Sent: Tuesday, October 03, 2000 2:11 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Dirty reads
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
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 --------------------------------------------------------------------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). Received on Tue Oct 03 2000 - 15:36:25 CDT
 |
 |