ORACLE - RAC Services

set linesize 500
col SERVICE_NAME for a40
col machine for a30
select inst_id, SERVICE_NAME, machine, count(*) from gv$session group by inst_id, SERVICE_NAME, machine order by machine;