select session_id from v$locked_object;
SELECT sid, serial#, username, osuser FROM v$session where sid = 153;
SELECT sid, serial#, username, osuser FROM v$session where sid = 81;
SELECT sid, serial#, username, osuser FROM v$session where sid = 102;
SELECT sid, serial#, username, osuser FROM v$session where sid = 271;
SELECT sid, serial#, username, osuser FROM v$session where sid = 310;
SELECT sid, serial#, username, osuser FROM v$session where sid = 313;
//注意这里记得不要把SYSTEM 写成 "SYSTEM"
//ALTER SYSTEM KILL SESSION '81,5032'; 前面81代表session_id 后面 5032代表serial#
ALTER SYSTEM KILL SESSION '81,5032';
ALTER SYSTEM KILL SESSION '102,49307';
ALTER SYSTEM KILL SESSION '271,9661';
ALTER SYSTEM KILL SESSION '310,902';
ALTER SYSTEM KILL SESSION '313,1486';
oracle:ORA-00054: 资源正忙, 但指定以 NOWAIT 方式获取资源, 或者超时失效
最新推荐文章于 2024-01-04 16:57:52 发布