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$426a34cc_at_news.free.fr>
Date: Sat, 1 Aug 2009 10:25:02 +0200
Message-ID: <4a73fbe0$0$22859$426a34cc_at_news.free.fr>
"kevin" <majunyue_at_hotmail.com> a écrit dans le message de news: d2576cda-88c6-42b3-8771-0c03b8e2bff1_at_u16g2000pru.googlegroups.com...
|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
/
Regards
Michel
Received on Sat Aug 01 2009 - 03:25:02 CDT