select count(*),
username,
machine
from gv$session 
where username = upper('&1')
group by username,
         machine;