select ‘ALTER SYSTEM KILL SESSION ‘‘‘||t2.sid||‘,‘||t2.serial#||‘‘‘ immediate;‘
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid
and t1.object_id=72688
order by t2.logon_time
;
相关文章
- 12-30生成kill掉锁住某个对象的语句
2023-12-30 23:45:10
select ‘ALTER SYSTEM KILL SESSION ‘‘‘||t2.sid||‘,‘||t2.serial#||‘‘‘ immediate;‘
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid
and t1.object_id=72688
order by t2.logon_time
;