Are there any views that will tell me what NLS parameters (e.g. NLS_TERRITORY) a session has set?
04-08-2002, 12:28 PM
SQL>sho parameter NLS
04-08-2002, 12:56 PM
you are interested in the first one
04-10-2002, 05:10 AM
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.
04-11-2002, 04:25 AM
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. "