Re: Client session IP address

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 25 Feb 2005 15:40:26 GMT
Message-ID: <Xns96084E10C397BSunnySD@68.6.19.6>

"Irudaya Raj" <jirudayaraj_at_gmail.com> wrote in news:1109315151.207880.213180_at_g14g2000cwa.googlegroups.com:

> 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.

DBMS_SYSTEM might help.

In a three tier architecture, more than likely all the DB will 'see' is the middle tier server(s) and never 'see' the actual client IP#. Received on Fri Feb 25 2005 - 09:40:26 CST