Oracle RAC Load Checking
-- Monitor active sessions by service and instance in real-time
SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS') AS sample_time,
s.inst_id,
i.instance_name,
s.service_name,
COUNT(*) AS session_count
FROM gv$session s
JOIN gv$instance i
ON s.inst_id = i.inst_id
WHERE s.username IS NOT NULL -- exclude background/system sessions
GROUP BY TO_CHAR(SYSDATE, 'HH24:MI:SS'), s.inst_id, i.instance_name, s.service_name
ORDER BY sample_time, inst_id, service_name;
