ORACLE死锁后kill该session时进程报错ORA-00031：标记要终止的会话

ORACLE死锁后kill该session时进程报错ORA-00031：标记要终止的会话

 

解决方法：

1. 查看当前被锁对像

SELECT SESS.SID,

       SESS.SERIAL#,

       LO.ORACLE_USERNAME,   ---ORACLE_USERNAME为登录账号

       LO.OS_USER_NAME,      ---USER_NAME 为登录的电脑

       AO.OBJECT_NAME,       ---OBJECT_NAME 为被锁的表名

       LO.LOCKED_MODE,       ---LOCKED_MODE 为锁住的级别

       SESS.MACHINE

FROM V$LOCKED_OBJECT LO,

     DBA_OBJECTS AO,

     V$SESSION SESS

WHERE AO.OBJECT_ID = LO.OBJECT_ID AN