1. 查詢出要刪除的Lock Session ID select a . sid || ',' || a . serial #,a.machine from v$session a , DBA_DML_LOCKS b where a . sid = b . session_id group by a . sid || ',' || a . serial #,a.machine; 2. 刪除Session ID alter system kill session 'xxx,yyyy' immediate ; (其中, 'xxx,yyy'為第1步查到的資料) Ref: 參考資料