Oracle会话被锁:ORA-00054: 资源正忙
SELECT SESSION_ID FROM V$LOCKED_OBJECT;
1351为第一步查询值
SELECT SID, SERIAL#, USERNAME, OSUSER FROM V$SESSION WHERE SID = 1351;
第二部查询出两个数字填上,删除会话锁
ALTER SYSTEM KILL SESSION '1351,31413';
SELECT SESSION_ID FROM V$LOCKED_OBJECT;
1351为第一步查询值
SELECT SID, SERIAL#, USERNAME, OSUSER FROM V$SESSION WHERE SID = 1351;
第二部查询出两个数字填上,删除会话锁
ALTER SYSTEM KILL SESSION '1351,31413';