ORACLE Find host name of a currently connected Schema/Instance

This query would give you the server host name of ORACLE machine


 SELECT sys_context('USERENV', 'SERVER_HOST') FROM DUAL;