Re: Better demonstration of the serious transaction bug in Oracle

From: mligac <ligacNOliSPAM_at_pobox.sk.invalid>
Date: Tue, 08 Feb 2000 01:05:36 -0800
Message-ID: <052897bc.154deb5a@usw-ex0110-075.remarq.com>

Hi,
I tried it on Oracle 7.3.4 for NT and get 821:179 result. Reading manual (Oracle7 Tuning, release 7.3.3) I found in chapter this (Transaction Modes) interresting sentence: <FONT COLOR="#FF0000"><b>!!!! If you wish to set the transaction isolation level, you must do so before the transaction begins. !!!!</b></font>

So I tried to move SET TRANSACTION ISOLATION LEVEL SERIALIZABLE two lines higher, before the BEGIN, and results were OK (1000:0)!!!

Hope this will explain "serious transaction bug in Oracle", if no please feel this just like a newbie answer.

mligac

Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Tue Feb 08 2000 - 03:05:36 CST