Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Instance + Hostname

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US