Re: Client session IP address

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 25 Feb 2005 08:06:44 -0800
Message-ID: <1109347425.665269@yasure>

Mark Bole wrote:

> DA Morgan wrote:
> 

>> Irudaya Raj wrote:
>>
>>> Hello Everybody,
>>> I have a need to know what is the source IP address of every session
>>> that gets created on my Oracle 9i instance.
>>> I have queried the v$session view, it does show a 'MACHINE' name for
>>> users who have connected from apps. like SQLPLUS, but there are
>>> connections comming in from JDBC client, Web Servlets,etc., these
>>> connections are shown under 'MACHINE' column as the application name
>>> itself.
>>> But I need to know the IP address from where this application was run.
>>>

> [...]
> 

>>
>> http://www.psoug.org
>> click on Morgan's Library
>> click on SYS_CONTEXT Function
>>
>> Hoepfully you are not working with Windows.

> 
> 
> What's the issue with Windows?  (the PSOUG web page you reference 
> doesn't say).
> 
> -Mark Bole

Who would come to my lectures if I put everything on the web site? ;-)

There are situations, I can't find my source reference right this minute, where with Windows NULL is returned by the function. It is certainly the case on my stand-alone notebook.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Fri Feb 25 2005 - 10:06:44 CST