锁号44 进程3507 表名test
alter system kill session '44,3507'; 最后只标记killed实际删除不了
SQL> select SID,SERIAL# ,STATUS from v$session;
SID SERIAL# STATUS
---------- ---------- --------
44 3507 KILLED
处理方法:
alter system kill session '44,3507' immediate;