-
Are there any views that will tell me what NLS parameters (e.g. NLS_TERRITORY) a session has set?
Thanks.
-
use this:
SQL>sho parameter NLS
Susan
-
nls_session_parameters
nls_instance_parameters and
nls_database_parameters
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. "
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|