Re: Oracle Job Queue

On Jan 20, 7:42 am, bdbafh <bdb..._at_gmail.com> wrote:
> 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

I think you were right. JOB_QUERE_PROCESSES was set to 1. As soon as I set it to 2, jobs started to run.

Any idea on why this value has to be greater than 1 for 10g??? Received on Sun Jan 20 2008 - 14:32:47 CST