col machine format a22
col program format a40
col nu      format 9999
select count(*) nu, machine, program
from v$session
group by machine, program
order by 1
/
