Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Better demonstration of the serious transaction bug in Oracle

Re: Better demonstration of the serious transaction bug in Oracle

From: <mligac_at_my-deja.com>
Date: Tue, 08 Feb 2000 08:44:27 GMT
Message-ID: <87ol1a$4cm$1@nnrp1.deja.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 via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 08 2000 - 02:44:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US