Find user's ip address.

Below query find user's ip adderss  to use UTL_INADDR package.

select sid, machine,UTL_INADDR.get_host_address
(substr(machine,instr(machine,'\')+1))ip from v$session 
where type='USER' and username is not null order by sid;