Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question about 'job_queue_processes'
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?
Its the ceiling on the number of jobs concurrently running. In 8i they are called SNP because years ago they were used purely for refreshing snapshots. Now they can be used for anything. In 9i, the processes are called Jnnn and are transient.
hth
connor
Received on Wed Feb 12 2003 - 02:29:55 CST