RAC: List details for sessions wait from all instances in 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 ;

March 14, 2014 В· Sanjay В· No Comments
Posted in: 3. All Scripts, 6. RAC

Leave a Reply

You must be logged in to post a comment.