Home » SQL & PL/SQL » SQL & PL/SQL » IP adress from session id
IP adress from session id [message #249379] Wed, 04 July 2007 04:03 Go to next message
Buchas
Messages: 83
Registered: March 2006
Member
Hello,

How do I know the IP adress of a client, if I know the Oracle session ID? (The IP adress, that started the Oracle session)

Re: IP adress from session id [message #249384 is a reply to message #249379] Wed, 04 July 2007 04:17 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Check out these threads first. Next time use the search button yourself Wink.

MHE
Re: IP adress from session id [message #249400 is a reply to message #249379] Wed, 04 July 2007 06:16 Go to previous messageGo to next message
Buchas
Messages: 83
Registered: March 2006
Member
OK, thanks!
Re: IP adress from session id [message #249774 is a reply to message #249400] Thu, 05 July 2007 18:01 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
 select distinct username,utl_inaddr.get_host_address
    from v$session;
Re: IP adress from session id [message #249776 is a reply to message #249379] Thu, 05 July 2007 18:19 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
> select distinct username,utl_inaddr.get_host_address from v$session;
In a 3-tier architecture the above will only return IP# of the middle tier systems & not the true IP# of the actual remote client.
Previous Topic: server databases
Next Topic: Adding 15 hours to PST
Goto Forum:
  


Current Time: Sat Dec 03 04:00:57 CST 2016

Total time taken to generate the page: 0.07766 seconds