Oracle 操作出现 resurce busy and acquire with NOWAIT specified or timeout expired

resurce busy and acquire with NOWAIT specified or timeout expired 异常记录

记录异常：下面是解决方式
–oracle 出现未释放锁 查询出 sdi 与 serial 杀死进程事务

SELECT T2.USERNAME,T2.SID,T2.SERIAL#,T2.LOGON_TIME
       FROM V$LOCKED_OBJECT T1,V$SESSION T2
       WHERE T1.SESSION_ID=T2.SID ORDER BY T2.LOGON_TIME

–根据 sid 查询出sql sql 不重要 这步可跳过

SELECT SQL_TEXT FROM V$SESSION A,V$SQLTEXT_WITH_NEWLINES B
      WHERE DECODE(A.SQL_HASH_VALUE, 0, PREV_HASH_VALUE, SQL_HASH_VALUE)=B.HASH_VALUE
      AND A.SID=209 ORDER BY PIECE;  

–根据 sid 与 serial kill掉锁定事务 执行后 再次尝试即可

ALTER SYSTEM KILL SESSION '209,34735';

以上内容参考与：https://blog.csdn.net/wanghuan203/article/details/16944013