Identification of host for an Oracle Instance

Below is the Oracle functionality relating to the identification of host for an Oracle Instance.

V$INSTANCE

The HOST_NAME column of the V$INSTANCE view contains the host name of the server running the instance.

SQL> SELECT host_name FROM v$instance;

HOST_NAME

------------------------------------------------

mydb123

1 row selected.

SQL>