--

-- 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

/