Oracle错误ORA-00054:resource busy and acquire with NOWAIT specified or timeout expired

最新推荐文章于 2024-01-21 19:30:00 发布

এ某年某月某日এ

最新推荐文章于 2024-01-21 19:30:00 发布

阅读量470

点赞数

分类专栏： Oracle 文章标签： oracle

本文链接：https://blog.csdn.net/weixin_45353401/article/details/107393122

版权

Oracle 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

如需转载分享，请标明出处，且不用于盈利为目的，谢谢合作！

Oracle错误ORA-00054:resource busy and acquire with NOWAIT specified or timeout expired

问题：ORA-00054:resource busy and acquire with NOWAIT specified or timeout expired
解决：
select l.session_id,o.owner,o.object_name from v$locked_object l,dba_objects o where l.object_id=o.object_id;--查出占用的资源session_id
SELECT sid, serial#, username, oSUSEr, terminal,program ,action, prev_exec_start FROM v$session where sid IN(977,625,1186);--SID,SERIAL# 两个会话
 
 --杀掉占用资源的两个会话
 alter system kill session '977,29';
  alter system kill session '625,99';
         alter system kill session '1186,178';