先执行这个 然后一幕了然
select t2.username,
t3.owner || '.' || t3.object_name object,
t2.sid,
t2.serial#,
t2.logon_time
from v$locked_object t1, v$session t2, all_objects t3
where t1.session_id = t2.sid
and t1.object_id = t3.object_id
order by t2.logon_time比如 t2.sid = 123 and t2.serial# = 1161那么删除锁执行下面格式语句 alter system kill session '123,1161'
select t2.username,
t3.owner || '.' || t3.object_name object,
t2.sid,
t2.serial#,
t2.logon_time
from v$locked_object t1, v$session t2, all_objects t3
where t1.session_id = t2.sid
and t1.object_id = t3.object_id
order by t2.logon_time比如 t2.sid = 123 and t2.serial# = 1161那么删除锁执行下面格式语句 alter system kill session '123,1161'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货