1 person found this helpful
SQLDeveloper 4 is not using the V$SESSION view but GV$SESSION.
Is there a way to modify this setting? My user access does not appear to include GV$SESSION unfortunately.
There's a workaround, yes.
In the reports interface, take the Sessions report, copy it down to the User Defined Reports, and edit the queries to go against the v$ views.
Example of how to do that is here