Re: About read consistency

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 16 Dec 2005 01:57:17 GMT
Message-Id: <pan.2005.12.16.01.57.16.281282@sbcglobal.net>

On Thu, 15 Dec 2005 19:42:36 +0100, Maxim Demenko wrote:

> I've the same behaviour on 9.2.0.6 and 10.2.0.1 on Linux and on 9.2.0.6
> on Solaris. Is it a (maybe well known) bug, or did i overlook something
> obvious ?
> All insights appreciated.
>
> Best regards
>
> Maxim

You overlooked so called "write consistency". Yes, transaction "B" should not return any data before it has begun, but the transaction finds that the records that it was waiting on were modified while it was waiting. Transaction is then re-started and now the commit point is no longer before the transaction start. Therefore, you will get back all rows. It's an expected behavior, described in Tom Kyte's book.

-- 
http://www.mgogala.com

Received on Thu Dec 15 2005 - 19:57:17 CST