| background process [message #59758] |
Sun, 21 December 2003 20:14  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hi all, can any one pls tell me if i set job_queue_process in my init.ora file which processes are going to start, cjq or snp?
thanx in advance
sam.
|
|
|
|
| Re: background process [message #59764 is a reply to message #59758] |
Sun, 21 December 2003 22:13  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Oracle 8i and below:
Oracle starts as many SNP (snp0 to snp36) as specified by the
JOB_QUEUE_PROCESSES parameter. These processes wake-up every JOB_QUEUE_INTERVAL time (in seconds) to process queued jobs.
Oracle 9i and above:
No more SNP processes - job queue processes (Jnnn - J000 through J999) execute jobs in the job queue. The Job Queue Coordinator (CJQ0) process dynamically spawns these job queue processes. The JOB_QUEUE_INTERVAL parameter is now obsolete.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
