Re: ISOLATION LEVEL

I have to agree with that.  I didnt really want to get into that
discussion.  But, I believe not reading uncommitted data is part of the
defining specification for  a relational database.  Lets not get into the
discussion of whether or not Oracle is a truly relational database or not.

On 7/12/07, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:


IMHO, the fact that Oracle doesn't support uncommitted read isolation
level is a feature, not a bug!

-Mark

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
734.997.4059 or 800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx
www.proquest.com
www.csa.com

ProQuest...Start here.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Buchanan, Jason
Sent: Thursday, July 12, 2007 3:03 PM
To: hkchital@xxxxxxxxxxxxxx
Cc: niall.litchfield@xxxxxxxxx; DBA Deepak; oracle-l
Subject: Re: ISOLATION LEVEL


On Jul 10, 2007, at 10:48 AM, Hemant K Chitale wrote:

> An Oracle query never reads dirty (uncommitted) data.

Uncommitted Read isolation level is one of the few nice features of
DB2 that is lacking in Oracle.
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l






--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Other related posts: