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 ;

Comments