RE: Ip address

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Mon, 12 Feb 2007 11:31:17 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08B19@EXCNYSM0A1AJ.nysemail.nyenet>

Adi,  

The following query gets the IP address of a client session connected to the database:  

    SELECT UPPER(program) program, username,

           osuser, terminal,

           sys_context('USERENV','IP_ADDRESS') ip_addr

      FROM V$SESSION       WHERE AUDSID = USERENV('SESSIONID');   Tom    

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams Sent: Monday, February 12, 2007 11:17 AM To: adi_at_zetapoint.com
Cc: oracle-l_at_freelists.org
Subject: Re: Ip address  

Adi,

Since nobody has responded to your question, I'll provide what I know and it isn't much.

Take a look at the terminal column of v$process and the terminal and machine columns of v$session. I could swear I've seen the ip address pop up for some connections on some servers. It may be related to how the user connects, or to some network configuration. Try that, otherwise your UTL command may be a more consistent way to get this info.  

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 12 2007 - 10:31:17 CST