Oracle查询并杀死锁死进程

一.查询锁死的进程
 SELECT SID, SERIAL#
    FROM V$SESSION T
   WHERE T.SID IN (SELECT SESSION_ID FROM V$LOCKED_OBJECT);
 
二.结束掉进程,sesson对应的值是上行查询出来的结果
 
alter system kill session '8,6732';
alter system kill session '65,7286';
alter system kill session '298,7392';