【数据库】死锁排查方式

定位

查是否锁表

select username,lockwait,status,machine,program from v$session where sid in
(select session_id from v$locked_object);

查锁表sql

select sql_text from v$sql where hash_value in 
(select sql_hash_value from v$session where sid in
(select session_id from v$locked_object));

到这里就可以根据sql进行分析

临时处理方式

查sid

SELECT s.sid||','|| s.serial#, s.sid, s.serial#, l.type, o.object_name  
FROM v$lock l  
JOIN dba_objects o ON l.id1 = o.object_id  
JOIN v$session s ON l.sid = s.sid  
WHERE o.object_type = 'TABLE'  
AND l.type IN ('TM', 'TX')
order by sid;

根据sid进行kill

ALTER SYSTEM KILL SESSION '862,9556';