解决PLSQL工具,Oracle一直Executing…,表被锁住,无法for update 操作进行修改数据。
–查看哪些表被锁住
select b.owner, b.OBJECT_NAME, session_id, a.locked_mode
from v$locked_object a, dba_objects b where b.OBJECT_ID = a.OBJECT_ID;
–查询引起死锁的回话
select b.USERNAME, b.SERIAL#,logon_time from v$locked_object a, v$session b where a.session_id = b.sid order by b.LOGON_TIME;
–查询出sid和serial#
select sid, serial#, paddr from v$session where sid = 183
–杀死进程(sid,serial#)
alter system kill session '183,31345'
注意:杀死线程时,sid和serial都要输进去
alter system kill session '183,31345’
这两个值是上面查出来的,查出来后用记事本记下来,一个sid一个sid的解锁。