Retrieve "alter session" made by other sessions ?

[Pascal Gineste]

High oracle gurus,

I'm a beginner with oracle and i'm wondering if this is possible to
retrieve parameters altered with the "alter session set xxxx=yyyy"
commands
BUT ON OTHER SESSIONS THAN THE CURRENT ONE.

Indeed, v$parameter allows to retrieve parameters for the current
session.

What about if session has been established by for exemple
impromptu/business object or SAS (those sessions are not the current
one).

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 ?

Thank you in advance,

[Jusung Yang]

> 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