Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Ip address

Ip address

From: Adi Hirschtein <adi_at_zetapoint.com>
Date: Sun, 11 Feb 2007 13:11:56 +0200
Message-id: <0JDA003VRPRCJ8D0@i_mtaout3.012.net.il>


Hi guys,

Do u know if and where Oracle keep the IP address of each session?

I know that I can get it through UTL_INADDR.get_host_address & sys_context

But I don't know if this information is being kept somewhere in the SGA or is it executed as network command

each time the function is running?  

Thanks a lot,

Adi    

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 11 2007 - 05:11:56 CST

Original text of this message

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