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: Client session IP address

Re: Client session IP address

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 24 Feb 2005 23:36:56 -0800
Message-ID: <1109316835.875934@yasure>


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)
Received on Fri Feb 25 2005 - 01:36:56 CST

Original text of this message

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