停止oracle正在执行的JOB

select b.SID,b.SERIAL#,c.SPID
from dba_jobs_running a,v$session b,v$process c
where a.sid = b.sid and b.PADDR = c.ADDR

 

 alter system kill session '41,2617';

 

posted @ 2022-05-07 16:02  南国之恋  阅读(190)  评论(0编辑  收藏  举报