List Session Waits for RAC
-- -- List session waits for RAC. -- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 COLUMN inst_id FORMAT 99 COLUMN username FORMAT A20 COLUMN sid FORMAT 9999 COLUMN serial# FORMAT 99999 COLUMN event FORMAT A48 COLUMN wait_class FORMAT A15 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 /