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.