Re: question about 'job_queue_processes'

On 10 Feb 2003 10:25:30 -0800, rgaffuri_at_cox.net (Ryan Gaffuri) wrote:

>I used to think that this was simply the number of jobs that can be
>queued at once. I just read somewhere that this has something to do
>with 'SNP'. I didnt quite follow this. Does this parameter have
>anything to do with the number of jobs I have queued at once?

job_queue_processes is simply the number of background processes available to deal with job requests, they don't constitute different queues and simply the first available process is used. That said if you have n SNP<x> processes, and you have more than n jobs (say all running every minute) you will likely see jobs drift away from their schedule.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Feb 10 2003 - 13:55:40 CST