Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

RE: ISOLATION LEVEL

Peter McLarty

2007-07-12

Replies:


Must be to overcome some performance issues like the do in that other
great database SQL Server

Funny MS has introduced some new features for coding in 2005 to try and
move away from it, of course that other great database Access
automatically does read uncommitted when it queries a SQL Server DB, go
figure.
I never have worked out from a business perspective how a report made of
uncommitted data is a valid business tool, but then I am "just a dba"

Cheers
Peter

-----Original Message-----
From: Buchanan, Jason [mailto:oracle@(protected)]
Sent: Friday, 13 July 2007 05:03 AM
To: hkchital@(protected)
Cc: niall.litchfield@(protected)
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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.