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. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l