http://www.itpub.net/24114.html

select distinct utl_inaddr.get_host_address(terminal),terminal from v$session;