發(fā)現(xiàn)網(wǎng)上很多鎖檢查腳本更新一個(gè)鎖檢查腳本：都有些不符合預(yù)期春哨，自己寫了一個(gè)：
set line 300
col "SQL" for a50
col "waiting sid" for 99999
col event for a35
col "Holder SQL" for a50
SELECT DISTINCT a.SID "waiting sid",---被阻塞會(huì)話SID
c.sql_text "SQL",---被阻塞會(huì)話執(zhí)行sql
b.SID "blocking sid",---阻塞源會(huì)話SID
a.blocking_instance,---阻塞源實(shí)例id
b.serial#,---阻塞源會(huì)話serial#
b.event,---阻塞源等待時(shí)間
b.sql_id,---阻塞源sqlid
b.prev_sql_id,---阻塞源prev_sqlid
d.sql_text "Holder SQL" ---阻塞源SQL
FROM gv$session a,
v$session b,
gv$sql c,
v$sql d
WHERE a.blocking_session = b.SID
AND c.sql_id = a.sql_id
and b.blocking_session? is null
AND d.sql_id = NVL (b.sql_id, b.prev_sql_id);
