A user's session parameters

959602

Hello All,

I know about NLS_SESSION_PARAMETERS, but is there another table or view or way of seeing a 'normal' user's session parameters? Oracle 10g but I'd be interested for 11g and and 9i if there are different methods.

For example, if I create a logon trigger for user JOE with ALTER SESSION SET query_rewrite_enabled=FORCE, how can JOE verify that the parameter query_rewrite_enabled is actually set to FORCE?

For info : I have searched, but I'm getting the database parameter sessions 99% of the time. I've also tried using SYS_CONTEXT with no luck. I cannot create a specific procedure in the database for this, it should be something available 'as-is'.

Regards,

Matt