My Oracle Support Banner

Non US7ASCII characters may not be seen correctly in V$Session OSUSER, MACHINE and PROGRAM fields. (Doc ID 759325.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 11.2]
Information in this document applies to any platform.


Non US7ASCII characters ( = anything besides A-Z,a-z,0-9) may not be seen correctly in V$Session OSUSER, MACHINE and PROGRAM fields.

Note that this has nothing as such to do with the ability to store non-US7ASCII characters, this problem may only be seen in the OSUSER, MACHINE and PROGRAM fields of V$SESSION and is related to client side information retrieved  from the OS by the client stack. We assume here that your client/server NLS setup is correct and is able to store and retrieve these characters. Please test first with Sqldeveloper in a test table using VARCHAR2 column if your database is capable of storing the characters and then if your client setup is correct, we also suggest to use SQLdeveloper to check the fix once in place. See also:
<Note:179133.1> The correct NLS_LANG in a Windows Environment
<Note:264157.1> The correct NLS_LANG setting in Unix Environments


You are selecting from V$SESSION and any of the OSUSER, MACHINE and PROGRAM fields do not correctly return the non-US7ASCII data from the client side.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.