Hello everyone,

I ran into a problem when I tried to do:
SELECT * FROM v$session . I get an empty value for the action field, although in fact it is not empty and ACTION HASH is not null.

If I try:
SELECT * FROM sys.v_$session, then everything is displayed correctly.

I noticed that when selecting from v$session, the 'ACTION' field type is varchar2, and when selecting from sys.v_$session type of ACTION field is varchar2(64).

Have anyone encountered this problem? I've already tried changing nls_lang, but it didn't work. The problem does not occur in TOAD.

Using PL/SQL 15.0.4.2064 64 bit,
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Sorry for bad english.

Could it be that your Oracle user has a synonym, a view, or a table with the name V$SESSION? This would explain the different results when querying the sys.v_$session view.