[code language=”sql”]

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