记录被另一个用户锁

1. 查询被锁进程:

SELECT   A.OWNER,      
                  A.OBJECT_NAME,      
                  B.XIDUSN,      
                  B.XIDSLOT,      
                  B.XIDSQN,      
                  B.SESSION_ID,      
                  B.ORACLE_USERNAME,      
                  B.OS_USER_NAME,      
                  B.PROCESS,      
                  B.LOCKED_MODE,      
                  C.MACHINE,      
                  C.STATUS,      
                  C.SERVER,      
                  C.SID,      
                  C.SERIAL#,      
                  C.PROGRAM    
        FROM   ALL_OBJECTS   A,      
                  V$LOCKED_OBJECT   B,      
                  SYS.GV_$SESSION   C  
      WHERE   (   A.OBJECT_ID   =   B.OBJECT_ID   )  
          AND   (B.PROCESS   =   C.PROCESS   )
      ORDER   BY   1,2

 

2. 杀死进程

alter system kell session 'sid, serial#'