select username,machine,osuser,count(1) cnt from v$session where username is not null group by username,machine,osuser ORDER BY count(1) desc;
select username,machine,osuser,count(1) cnt from v$session where username is not null group by username,machine,osuser ORDER BY count(1) desc;