解决Oracle死锁问题

版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.csdn.net/inforstack/article/details/53750459

//查询死锁  
    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#';