Are there any views that will tell me what NLS parameters (e.g. NLS_TERRITORY) a session has set?
Thanks.
04-08-2002, 11:28 AM
srlhome00
use this:
SQL>sho parameter NLS
Susan
04-08-2002, 11:56 AM
pando
nls_session_parameters
nls_instance_parameters and
nls_database_parameters
you are interested in the first one
04-10-2002, 04:10 AM
ssmith
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, 03:25 AM
ssmith
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. "