查询锁住表的SID和SERIAL
select b.username,b.sid,b.serial#,logon_time
from v$locked_object a,v$session b
where a.session_id = b.sid order by b.logon_time
然后通过
alter system kill session 'SID,SERIAL';
杀死锁表进程SID
图示:
我先锁住表:
查询锁表进程SID:
杀死锁表进程,重新登陆打开新窗体执行: