Query session parameter values of running session I don't think there's a way to do this, but I'd like to be able to query what value a running session currently has for its COMMIT_WRITE session parameter.

I haven't seen anything in the v$ performance views... anyone know of a SYS x$ view from which such a value could be retrieved?



Clarification - the need is to pull the parameter setting for another session, running independent of current session.
I know this question is more than a year old, but in case anyone stumbles here like I did, you can query V$SES_OPTIMIZER_ENV:

SYS&gt; select name, value 
        from  V$SES_OPTIMIZER_ENV 
        where sid=54 
           and name='hash_area_size';

NAME                                     VALUE
—————————————- ————————-
hash_area_size                           100000


Source: http://oracleinaction.com/other-session-params/