Any dictionary view to check what NLS parameters a session has set?

[ssmith]

Are there any views that will tell me what NLS parameters (e.g. NLS_TERRITORY) a session has set?
Thanks.

[srlhome00]

use this:

SQL>sho parameter NLS



Susan

[pando]

nls_session_parameters
nls_instance_parameters and
nls_database_parameters

you are interested in the first one

[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.

[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. "