Re: IP-Adress of SQL-Connect

From: Vikram Goel <vgoel_at_pop.gate.net>
Date: Mon, 18 May 1998 12:45:05 -0400
Message-ID: <35606591.ABA99363@pop.gate.net>

Klaus,

If your client machine is identified with the IP address (in Win95) set machine id setting in Network Neighborhood) as the machine name, you can query the v$session view in Oracle to determine the IP address of the connecting machine. The column you need to query for this is named 'Machine'

Hope this helps.

Vik. Goel

Klaus Schmenger wrote:

> Hi,
>
> is it possible to find out the IP-Address from which a connect to an
> Oracle-Database is made. I can only find the server process but I think
> there must be a way to find out to which client this server process
> sends and receives data.
>
> Greetings
>
> Klaus Schmenger
>
> --
> This is my personal opinion. I'm not speaking
> for my company.
>
> To reply, please remove the NOSPAM from the address.

Received on Mon May 18 1998 - 11:45:05 CDT