查出当前存在所的锁,并和相关的SQL语句找出来(任何insert、update、delete都可能会产生锁)
select t2.username||' '||t2.sid||' '||t2.serial#||' '||t2.logon_time||' '||t3.sql_text
from v$locked_object t1,v$session t2,v$sqltext t3
where t1.session_id=t2.sid
and t2.sql_address=t3.address
order by t2.logon_time;
关键就是要查出sid和serial#
一般,就是看,这个SQL语句执行了很长时间,还不结束
你想要把它干掉,就执行前面说的
alter system kill session 'sid,serial#' immediate;
例如:alter system kill session '3096,38383' immediate;