- 首先查看数据库中哪些表被锁了,找到session ID:
select 'alter system kill session '''||sess.sid||','||sess.serial#||''';'
from v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id = lo.object_id and lo.session_id = sess.sid;
2,执行该语句
alter system kill session '169,29687';