1.执行一下sql,查询出被锁表的session和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
上面的sql语句会查询出被锁住的事务,下面根据查询出的session_id和serial#,把这个事务删除就可以
2.删除事务
alter system kill session 'session_id,serial#';