Recently i have created a new database in Solaris using scripts manually. I could find a process called "cjq0" ???
I have created other databases in the same server through DBCA and it did not create the above process?
I am not clear under what circumstances they are created and why?
This is job queue coordinator process. This process will not start if you put the parameter JOB_QUEUE_PROCESSES =0. CJQ0 dynamically spawns job queue slave processes (J000…J999) to run the jobs.
More details see,
Click Here to Expand Forum to Full Width