List of connected users in Oracle

To know the list of connected users to the Oracle Database, run the below sql

select distinct username, osuser, terminal, utl_inaddr.get_host_address(terminal) ip_address, status, logon_time
from v$session
where username is not null
order by username, osuser;