• available nodes

SELECT instance_name, host_name, archiver, thread#, status
FROM gv$instance

• current node where user is connected

SELECT INSTANCE_NUMBER,instance_name,HOST_NAME,INSTANCE_ROLE,STATUS FROM v$instance