Re: Retrieve "alter session" made by other sessions ?

> Moreover, i would like to know how to retrieve the current
> isolation_level
> set by an alter session set isolation_level=xxxx :
> I saw that this parameter seems not to be in v$parameter for
> the current session ?
>

Isolation_level is a session only parameter, not an initialization parameter. Look up V$transaction.flag :

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=42ffa8fa.0209142337.72304d81%40posting.google.com

SQL> select to_bin(268435456) from dual;

TO_BIN(268435456)

10000000000000000000000000000

So, if that particular bit is set, you are in serializable isolation level.

• Jusung Yang