生成kill掉锁住某个对象的语句


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
;

posted @ 2021-07-21 22:04  Mike张  阅读(40)  评论(0)    收藏  举报