Where to find the session information

[kzhangkzhang]

Hi All:

We can use alter session command to change a lot of session information (e.g. ALTER SESSION SET OPTIMIZER_MODE = RULE).

My question is how to find all session information? What command can tell me the value for OPTIMIZER_MODE of my current session?

Thanks!

 

[kzhangkzhang]

I think I figure it out by myself:

select * from v$parameter
where name = 'optimizer_mode'
/