You have a simple sql statement like this:
select machine, count(*) as users
from v$session
group by machine
This query returns the session count on each machine:
MACHINE USERS
machine1 16
machine2 17
machine3 15
machine4 14
tags:oracle sql
Read more from " Oracle SQL: Summarize a calculated column (like a count(*) column) with ROLLUP "





comment