Determining Transaction Isolation Level

[Aaravali Karavali]

Is there any way to tell, at runtime, under what transaction isolation
level a certain database operation is operating under?

Thanks!

[Jusung Yang]

If you get a non-zero count from this SQL, you are in serializable isolation level:

select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) <>0;

SQL> select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) = 0;

COUNT(1)
----------
0

SQL> select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) <>0;

COUNT(1)
----------
0

SQL> insert into tyu values('ab',1,1);

1 row created.

SQL> select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) = 0;

COUNT(1)
----------
1

SQL> select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) <>0;

COUNT(1)
----------
0

SQL> rollback;

Rollback complete.

SQL> set transaction isolation level serializable;

Transaction set.

SQL> select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) = 0;

COUNT(1)
----------
0

SQL> select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) <>0;

COUNT(1)
----------
0

SQL> insert into tyu values('ab',1,1);

1 row created.

SQL> select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) = 0;

COUNT(1)
----------
0

SQL> select count(1) from V$TRANSACTION WHERE bitand(FLAG,268435456) <>0;

COUNT(1)
----------
1

aara...@hotmail.com (Aaravali Karavali) wrote in message news:<7161618e.0209...@posting.google.com>...