* available nodes
<code PLSQL>
select instance_name, host_name, archiver, thread#, status
from gv$instance
</code>
 
  * current node where user is connected
<code PLSQL>
select INSTANCE_NUMBER,instance_name,HOST_NAME,INSTANCE_ROLE,STATUS from v$instance
</code>