17,377
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
bicaso_1 2006-10-16
- 打赏
- 举报
^_^
bicaso_1 2006-10-16
- 打赏
- 举报
^_^
难得糊涂糊涂 2006-10-16
- 打赏
- 举报
先执行这个 然后一幕了然
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'
