Forum Stats

  • 3,827,551 Users
  • 2,260,791 Discussions
  • 7,897,297 Comments

Discussions

A user's session parameters

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

This discussion has been closed.