column osuser format a10
column username format a30
column machine format a30
column program format a50
set lines 132
set pages 500
select osuser, username, machine, program from v$session;
select machine, username, count(1) from v$session
group by machine, username;