List Users Connected to Oracle Database

col ip_address format a16

select username,osuser,terminal,
UTL_INADDR.get_host_address(substr(machine,instr(machine,'\')+1)) ip
from v$session
where username is not null order by username,osuser;