Re: About read consistency

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Fri, 16 Dec 2005 14:09:11 +0100
Message-ID: <43a2bcf0$0$27891$9b4e6d93@newsread4.arcor-online.net>

Mladen Gogala schrieb:
> 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.
>

Please, disregard my previous post,
now ,i think, i've got it.
Thank you again

Best regards

Maxim Received on Fri Dec 16 2005 - 07:09:11 CST