select sid from dba_jobs_running;
select a.spid from v$process a ,v$session b where a.addr=b.paddr and b.sid in (select sid from dba_jobs_running);
EXEC DBMS_JOB.BROKEN(job#,TRUE);
select name,value from v$parameter where name ='job_queue_processes';
ALTER SYSTEM SET job_queue_processes = 0;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22308399/viewspace-750700/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22308399/viewspace-750700/