[code language=”sql”]

Set Define on
set numwidth 16
col username format a15
col machine format a30
col sysdate format a21

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

set define off

[/code]