Re: Oracle Job Queue
Date: Sun, 20 Jan 2008 05:42:55 -0800 (PST)
Message-ID: <61f35307-1562-46b7-bafe-fe2228edf564@e23g2000prf.googlegroups.com>
On Jan 19, 6:07 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Hi,
>
> Previously we were on Oracle 8i and we had a bunch of jobs in the job
> queue, which ran fine.
>
> Last week we moved to 10g, and none of the jobs are running. Why is
> this? Can someone give me a suggestion? I have the JOB_QUEUE_PROCESS
> set to 1 and the JOB_QUEUE_INTERVAL set to 60.
>
> Any other thoughts? I'm lost........
>
> Thanks for any suggestions.
>
> Regards.
without researching this ... my hunch is that the job coordinator takes up one process and its never able to hand the jobs off to slave processes.
the dbca specificed value for job_queue_processes in 10g is 10. I'd say alter it to at least 5 and monitor what (background) sessions are spawned as a result.
-bdbafh Received on Sun Jan 20 2008 - 07:42:55 CST