問(wèn)題描述：
我在oem下執(zhí)行一些操作時(shí)，有時(shí)碰到如下信息：
如何解決ORA-00054資源正忙，要求指定NOWAIT，
查閱錯(cuò)誤代碼指南后有如下提示：
ORA-00054 resource busy and acquire with NOWAIT specified
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
解決方法：
1.通過(guò)上句查找出已被鎖定的數(shù)據(jù)庫(kù)表及相關(guān)的sid、serial#及spid
select object_name as 對(duì)象名稱,s.sid,s.serial#,p.spid as 系統(tǒng)進(jìn)程號(hào)
from v$locked_object l , dba_objects o , v$session s , v$process p
where l.object_id=o.object_id and l.session_id=s.sid and s.paddr=p.addr;
2.在數(shù)據(jù)庫(kù)中滅掉相關(guān)session
alter system kill session 'sid,serial#';--sid及serial#為第一步查出來(lái)的數(shù)據(jù)
舉例：
select object_name as 對(duì)象名稱,s.sid,s.serial#,p.spid as 系統(tǒng)進(jìn)程號(hào)
from v$locked_object l , dba_objects o , v$session s , v$process p
where l.object_id=o.object_id and l.session_id=s.sid and s.paddr=p.addr;
alter system kill session '125,287'