一、ORA-00054资源正忙,但指定以NOWAIT方式获取资源,或者超时失效
遇到这种情况,稍等2分钟后重试。如果仍报错的话,说明有锁定被操作表的会话。执行如下查询:
SELECT /* +rule */
s.username,
decode(l.type, 'TM', 'TABLE_LOCK', 'TX', 'ROW LOCK', NULL)LOCK_LEVEL
o.owner,
o.object_name,
o.object_type,
s.sid,
s.serial#
FROM gv$session s, gv$lock l, dba_objects o
WHERE l.sid = s.sid
AND l.id1 = o.object_id(+)
AND s.username is NOT NULL
AND O.OWNER='CRM';
查询结果
USERNAME LOCK_LEVEL OWNER OBJECT_NAME OBJECT_TYPE SID SERIAL#
—————– ——————– ———— ———