Are there any views that will tell me what NLS parameters (e.g. NLS_TERRITORY) a session has set?
SQL>sho parameter NLS
you are interested in the first one
Thanks for the feedback but what I need to know is the session parameters while a session is logged into the database. The clients use an application Icon and therefore doesn't see the SQL prompt.
If anyone wants to know I have the following information from Oracle:
"Unfortunately, that information is only available within the user session. There is no data dictionary view which provides insight into the session-level settings for another user. "