Show all the active Oracle users in the system. Query the v$session table to see the username and machine user is on.
set lines 200 set pages 200 select sid, serial#,user#, Username, machine, program, server, status, command, type from v$session order by username;