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

Last updated on DECEMBER 05, 2016

Applies to:

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

Symptoms

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

Changes

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms