Need query for which session is on which RAC instance


Hi I'm looking for a DBA type query that will list every connection to the RAC database and tell me which instance its on. In other words we connect system/manager@db1

When you do a select instance_name from V$instance;
sometimes it says db11 and sometimes it says db12.

What we want is a similar query that will show all connections at once and the RAC instance they're on. Any help much appreciated thanks...

Hub
.