OraFAQ Forum: SQL & PL/SQL » IP adress from session id

Home » SQL & PL/SQL » SQL & PL/SQL » IP adress from session id

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IP adress from session id [message #249379]

Wed, 04 July 2007 04:03

Buchas
Messages: 101
Registered: March 2006

Senior 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)

Report message to a moderator

Re: IP adress from session id [message #249384 is a reply to message #249379]

Wed, 04 July 2007 04:17

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Check out these threads first. Next time use the search button yourself Wink

.

MHE

Report message to a moderator

Re: IP adress from session id [message #249400 is a reply to message #249379]

Wed, 04 July 2007 06:16

Buchas
Messages: 101
Registered: March 2006

Senior Member

OK, thanks!

Report message to a moderator

Re: IP adress from session id [message #249774 is a reply to message #249400]

Thu, 05 July 2007 18:01

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

 select distinct username,utl_inaddr.get_host_address
    from v$session;

Report message to a moderator

Re: IP adress from session id [message #249776 is a reply to message #249379]

Thu, 05 July 2007 18:19

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	server databases
Next Topic:	Adding 15 hours to PST

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 03:15:10 CST 2025