Isolation Level in XA Transactions

From: Ralf Schenkel <schenkel_at_cs.uni-sb.de>
Date: 4 Feb 1999 09:00:11 GMT
Message-ID: <79bnir$7v2$1@hades.rz.uni-sb.de>

Hi,

is there a way to change the isolation level of a distributed transaction? Our project (a federated DB) uses Oracle's XA interface to begin and commit transactions. By default, those transactions run in "Read Committed" mode, but we require "Serializable".

The SQL command "set transaction" is explicitly forbidden in XA transactions, and "alter session" didn't change the mode. Somewhere Oracle's docs talk about using "alter system" to change the default isolation mode, but the parameters mentioned there don't exist.

We could change the "serializable" parameter in Oracle's initialization section, but this enables table locks, reducing possible throughput.

Did anybody experience this problem, too? We use Oracle 7.3.3 on Solaris 2.5.

Ralf Schenkel
--
Ralf Schenkel - http://www-dbs.cs.uni-sb.de/~schenkel/ Received on Thu Feb 04 1999 - 03:00:11 CST