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

最新推荐文章于 2022-12-09 11:36:51 发布

weixin_30760895

最新推荐文章于 2022-12-09 11:36:51 发布

阅读量98

点赞数

原文链接：http://www.cnblogs.com/abclife/p/7066855.html

版权

开发说测试环境在删除表的时候，报了如下错误：

SQL> drop table tke purge;
drop table tke purge
           *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

查看一下锁住对象的会话id：

SQL> select session_id from v$locked_object;

SESSION_ID
----------
         6

根据会话id继续查看：

SQL> SELECT sid, serial# FROM v$session where sid = 6;

       SID    SERIAL# 
---------- ----------
         6         99

因为是测试环境，直接kill了会话：

sql> alter system kill session '6,96';

当然也可以在具体查看一下产生锁得会话信息等，比如：

SQL> select object_name ,s.sid,s.serial#,p.spid 
  2  from v$locked_object l , dba_objects o , v$session s , v$process p
  3  where l.object_id=o.object_id and l.session_id=s.sid and s.paddr=p.addr;


OBJECT_NAME                         SID    SERIAL# SPID
---------------------------- ---------- ---------- ---------
TKE                                   6         96 30761

转载于:https://www.cnblogs.com/abclife/p/7066855.html