RE: IP address for a session without audit enable

I can do this in 8.1.6:

SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') from dual

Tony Aponte

-----Original Message-----

From: Khedr, Waleed [mailto:Waleed.Khedr_at_FMR.COM]

Sent: Tuesday, October 30, 2001 11:35 AM

To: Multiple recipients of list ORACLE-L

Subject: IP address for a session without audit enable

Hi,

Does any one know a way of finding the IP address for a session?

The Terminal or the Machine columns in v$session are not guaranteed to have

ip addresses.

Regards,

Waleed

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com

--

Author: Khedr, Waleed

  INET:         Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California        -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing). Received on Tue Oct 30 2001 - 14:16:26 CST