Re: Determining Transaction Isolation Level

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

aaravali_at_hotmail.com (Aaravali Karavali) wrote in message news:<7161618e.0209141430.91b0c9b_at_posting.google.com>...
> Is there any way to tell, at runtime, under what transaction isolation
> level a certain database operation is operating under?
>
> Thanks!
Received on Sun Sep 15 2002 - 02:37:45 CDT