[code language=”sql”]

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

[/code]