RAC: List details for sessions wait from all instances in RAC.

 
SET LINESIZE 230
SET PAGESIZE 300
COLUMN username FORMAT A30
COLUMN event FORMAT A30
COLUMN wait_class FORMAT A20
SELECT s.inst_id,
NVL(s.username, '(oracle)') AS username,
s.sid,
s.serial#,
sw.event,
sw.wait_class,
sw.wait_time,
sw.seconds_in_wait,
sw.state
FROM gv$session_wait sw, gv$session s
WHERE s.sid = sw.sid
AND s.inst_id = sw.inst_id
ORDER BY sw.seconds_in_wait DESC ;