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

Home -> Community -> Usenet -> c.d.o.server -> Re: Session Ip Address

Re: Session Ip Address

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 4 Jan 2007 17:35:51 +0100
Message-ID: <459d2ce8$0$304$426a74cc@news.free.fr> 






"Emre" <emre_at_emre.com> a écrit dans le message de news: Xns98AE940DFD6A7emreemrecom_at_fe06.highwinds-media.phx...


| Hii All

| How can I see client's ip address from v$session ? or is there another view to see

| client's ip address




select sid, machine, utl_inaddr.get_host_address(machine) ip
from v$session


where type='USER' and username is not null
/



Regards


Michel Cadot
Received on Thu Jan 04 2007 - 10:35:51 CST












Original text of this message













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