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
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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.
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