Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to view session parameters of other sessions?

491733Jul 14 2009 — edited Mar 14 2012

Hi

I have a problem with an application that is related to character sets, codepages and NLS settings.

As all my tests (with sqlplus) where successful I suppose the application is setting any NLS parameters that cause the problem. To further investigate the issue I'd like to see the session parameters of the session the application is using.

I know NLS_SESSION_PARAMETERS has the information for my session, but how do I get the information for any other session?? Is this possible at all?

best regards,
Marcus

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2012

Added on Jul 14 2009

#general-database-discussions, #session

8 comments

8,224 views