杀死Oracle死锁进程

很多人应该都遇到多ORACLE进程死锁的情况，下面是两个简单的SQL，来杀死死锁进程：
--Sep27, 2008 Eleven.Xu
--Select Locked Process
SELECT s.username,
       l.OBJECT_ID,
       o.name,
       l.SESSION_ID,
       s.SERIAL#,
       l.ORACLE_USERNAME,
       l.OS_USER_NAME,
       l.PROCESS
  FROM V$LOCKED_OBJECT l, V$SESSION S,sys.obj$ o
 WHERE l.SESSION_ID = S.SID
   AND o.obj# = l.OBJECT_ID;

--Sep27, 2008 Eleven.Xu
--Kill Locked Process
alter system kill session 'sid,serial#';