Re: changing the isolation level

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 13 Jan 2007 17:12:12 -0800
Message-ID: <1168737131.847599.162230@v45g2000cwv.googlegroups.com>

Marten Lehmann wrote:
> Hello,
>
> I have an upcoming migration from Sybase to Oracle and a problem I ran
> into is the different isolation level for transactions.
>
> We have several applications here where one application is creating or
> changing entries and then another application is performing some tests
> on these changed data. The changes or creations are not commited until
> the tests have been successfully. With Sybase, the testing application
> could see the new and changed records, but with Oracle, it cannot see
> them. How can I change the isolation level in Oracle for this
> application? Or do I have so set it for the whole Oracle server?
>
> Regards
> Marten

What you need is READ UNCOMMITTED ISOLATION LEVEL. See: http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html "The READ UNCOMMITTED isolation level allows dirty reads. Oracle Database doesn't use dirty reads, nor does it even allow them."

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Sat Jan 13 2007 - 19:12:12 CST