ORA-00054:resource busy and acquire with nowait specified解决方法
标签(空格分隔): Oracle 管理 ORA
–查看数据库都有哪些锁
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;
–查询哪些对象被锁
sel...
原创
2019-11-04 16:05:18 ·
150 阅读 ·
0 评论