Oracle 数据库查找死锁进程，结束进程

查看死锁进程（sysdba权限）

select distinct '(' || s.sid || ')  - ' || s.serial# || ' ' || username as "(session) - username"
from v$session s, sys.x$kglob o, sys.x$kglpn p
where upper(o.kglnaobj) like upper('%yourobject%')
and p.kglpnhdl = o.kglhdadr
and s.saddr = p.kglpnuse;

kill进程

alter system disconnect session '426,5807'  immediate;

说明：yourobject为操作对象，426为sid，5807为SERIAL