select s.type,p.spid,s.username,s.process,s.machine, s.program from
v$session s,v$process p where s.paddr=p.addr;
v$session s,v$process p where s.paddr=p.addr;
select owner, job_name, session_id, slave_os_process_id, running_instance
from dba_scheduler_running_jobs
where slave_os_process_id = 'SPID';
from dba_scheduler_running_jobs
where slave_os_process_id = 'SPID';
停止job
BEGIN
DBMS_SCHEDULER.stop_job (job_name => ' job_name', force => TRUE);
END;
/
DBMS_SCHEDULER.stop_job (job_name => ' job_name', force => TRUE);
END;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24756186/viewspace-746267/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
