select distinct 'alter system kill session ''' || t2.sid || ',' || t2.serial# || ''' immediate;'
from gv$locked_object t1, gv$session t2, dba_objects t3
where t1.session_id = t2.sid
and t1.object_id = t3.object_id;
oracle 查杀死锁的语句
最新推荐文章于 2024-05-11 07:00:37 发布