RE: ISOLATION LEVEL

From: Peter McLarty <p.mclarty_at_cqu.edu.au>
Date: Fri, 13 Jul 2007 09:34:49 +1000
Message-ID: <27AA2E9CA7A0C44283BC1E9B00086AA90742791A@UNIMAIL.staff.ad.cqu.edu.au>

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_at_digistar.com] Sent: Friday, 13 July 2007 05:03 AM
To: hkchital_at_singnet.com.sg
Cc: niall.litchfield_at_gmail.com; 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

Received on Thu Jul 12 2007 - 18:34:49 CDT