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