oracle 00054 资源正忙
解决方案:
select session_id from v$locked_object;
--sid为上一个sql执行获得的sid
sELECT sid, serial#, username, osuser FROM v$session where sid = 159 for update;
ALTER SYSTEM KILL SESSION '159,4242';
oracle 00054 资源正忙
解决方案:
select session_id from v$locked_object;
--sid为上一个sql执行获得的sid
sELECT sid, serial#, username, osuser FROM v$session where sid = 159 for update;
ALTER SYSTEM KILL SESSION '159,4242';