select ‘ALTER SYSTEM KILL SESSION ‘‘‘||t2.sid||‘,‘||t2.serial#||‘‘‘ immediate;‘from v$locked_object t1,v$session t2where t1.session_id=t2.sid and t1.object_id=72688order by t2.logon_time;
生成kill掉锁住某个对象的语句
原文:https://www.cnblogs.com/zhangqhs/p/15041831.html