Find User count and Session Count of the DB

SELECT se.machine, count(1)
FROM v$open_cursor oc, v$session se
WHERE oc.sid = se.sid
GROUP BY se.machine
HAVING COUNT(1) > 2
Order By Count(1) Desc