Oracle查询并杀死锁死进程

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