| nls session parameters [message #60540] |
Fri, 13 February 2004 03:10  |
ajb
Messages: 2
Registered: February 2004
|
Junior Member |
|
|
Hi
Is there any way to view the session parameters for all the sessions running on a database?
-aj
|
|
|
|
| Re: nls session parameters [message #60548 is a reply to message #60540] |
Fri, 13 February 2004 07:04  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You could use v$nls_parameters to see the nls parameter values , nls_session_parameters for the session(local) , but I am not sure if there is a way to see other session's nls settings ,if they override the default. The doubtful session can be made to dump nls_session_parameters ,though.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
