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';

posted @ 2021-01-01 01:02  shyCory  阅读(90)  评论(0)    收藏  举报