Query to find out total number of session in database from different machine and osuser
select osuser, machine, count(*)
from v$session
group by osuser, machine order by count(*) desc ;
select osuser, machine, count(*)
from v$session
group by osuser, machine order by count(*) desc ;