RAC环境查找行锁冲突排查阻塞

mahan

1、查找数据库当前等待事件
select event,SID,SERIAL#,INST_ID,sql_id,program ,username,client_info from gv$session where wait_class<>'Idle';

找到行锁的会话是1503

2、通过行锁的会话去找出“谁”阻塞了
SELECT blocking_instance, blocking_session
FROM gv$session
WHERE sid = 1503 AND inst_id = 1;


3、找到阻塞的 SID 后，查询它的具体信息，看看是哪台机器、哪个程序、哪个用户在干嘛
SELECT sid, serial#, username, machine, client_info, program, status, sql_id, prev_sql_id
FROM gv$session
WHERE sid = 1332
  AND inst_id = 1;