Re: Client session IP address

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.
>
> Is there a way to find out this.
>
> Please let me know.
>
> Thanks a lot for your time and valuable inputs.
>
> Regards,
> Raj.

http://www.psoug.org
click on Morgan's Library
click on SYS_CONTEXT Function

Hoepfully you are not working with Windows.

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