//查询死锁  
    select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode  
       from v$locked_object lo,dba_objects ao,v$session sess  
    where ao.object_id = lo.object_id and lo.session_id = sess.sid;  
      
     //杀死进程  
    alter system kill session 'SID,SERIAL#';