Re: Instance + Hostname

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 6 Jan 2005 07:34:23 -0800
Message-ID: <1105025663.362047.148510@f14g2000cwb.googlegroups.com>

Mark D Powell wrote:
> Zephyr, the "machine" column of v$session shows you the machine that
> the cleint session came from which is likely not the host name of the
> database server. They can be the same but the values will usually be
> different as most clients come from Web Servers, Application Servers,
> or client machines.
>
> HTH -- Mark D Powell --

where sid = 1 from v$session will give you the hostname of the server where database is running. However, using utl_inaddr, as mentioned in your previous post, is a better option as it can show both hostname and ip address (utl_inaddr.get_host_address).

Regards
/Rauf Received on Thu Jan 06 2005 - 09:34:23 CST