SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||SERIAL#||''';' FROM v$locked_object l,v$session s WHERE s.SID IN(
select FINAL_BLOCKING_SESSION from gv$session where FINAL_BLOCKING_SESSION IS NOT NULL ) and l.SESSION_ID = s.SID
union all
SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||SERIAL#||''';' FROM v$locked_object l,v$session s
WHERE FINAL_BLOCKING_SESSION IS NOT NULL and l.SESSION_ID = s.SID
oracle kill session
最新推荐文章于 2023-02-24 18:38:20 发布