解决oracle死锁

select a.sid,a.serial# from v$session a inner join v$locked_object l on a.SID=l.SESSION_ID //连表查出死锁进程;
ALTER SYSTEM KILL SESSION  a.sid a.serial#;//杀掉进程;

转载于:https://www.cnblogs.com/aasssdd123/p/7309259.html