Tools/Sessions and RAC

[g_lagaffe]

we have been switching to a Real Application Cluster (RAC) environment recently and now have the following problem with PL/SQL Developer:
When opening the tools/Sessions window we only get the sessions running on the instance currently connected. Obviously the underlying query only uses the v$session-view instead of the gv$session view, where the sessions of all instances are visible.
Is it possible to change that view in the settings somehow or is it hardcoded?
If it is hardcoded, I'd like to post the following change request:
-query gv$session instead of v$session and add the instance ID column to the sessions-window.

Thanks in advance...

 

[Marco Kalter]

This will be added in the next release, where you can define your own session queries.

 

[hbar]

Is there a way to see the existing query for the tools --> sessions window?

 

[g_lagaffe]

In the meantime I found the following simple workaround that may be interesting for other RAC-users too:
log in with your preferred user and issue the following statement:

create or replace synonym V$SESSION for SYS.GV_$SESSION;

As private synonyms do have precedence against public synonyms the sessions window now queries GV_$SESSION instead of V_$SESSIONS and all sessions are included in the result.
The only information missing is the InstanceID, we have to wait for the next release for that...