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博客 ” ,链接:http://blog.itpub.net/24756186/viewspace-746267/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24756186/viewspace-746267/