Re: get other session's ip

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 1 Aug 2009 10:25:02 +0200
Message-ID: <4a73fbe0$0$22859$>

"kevin" <> a écrit dans le message de news:

|I can get my current session's ip with 'select sys_context
| ('USERENV','IP_ADDRESS') FROM DUAL; '. How can I get other session's
| ip?

select sid, machine, utl_inaddr.get_host_address(machine) ip from v$session
where type='USER' and username is not null /

Michel Received on Sat Aug 01 2009 - 03:25:02 CDT

Original text of this message