报错信息:
中文:
英文:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
分析:资源忙,被占用了。
故障处理
1.检查哪个用户占用资源
select loc.session_id,obj.owner,obj.object_name
from v$locked_object loc,dba_objects obj
where loc.object_id=obj.object_id;
2.利用查出来占用资源的session_id,查出更加详细的信息
SELECT * FROM v$session where sid = 997;
3、根据上面查出来的 SID,SERIAL# 杀掉占用资源的会话:
alter system kill session '997,21423' immediate;
重新执行sql即可
标签:loc,obj,object,session,Oracle,id,00054,ORA From: https://www.cnblogs.com/mjtabu/p/18180184