解決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#';