ORA-00054: 资源正忙,要求指定 NOWAIT
解决方案:
1.查看有没有对象被锁
select * from v$locked_object;
2.得到被锁对象的session_id
select session_id from v$locked_object;
3.通过上⾯得到的session_id去取得v$session的sid和serial#(sid是第2步得到的session_id)
SELECT sid, serial#, username, osuser FROM v$session where sid = '259';
4.杀死该进程(ALTER SYSTEM KILL SESSION 'sid,serial')
ALTER SYSTEM KILL SESSION '259,3057';