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#;//杀掉进程;
