Re: Background processes

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Thu, 22 May 2003 20:32:09 +0400
Message-ID: <baiud7$suj$1@babylon.agtel.net>

> Can anyone tell me what initiates the Oracle background processes which are
> named
>
> ora_j000_SID
> ora_j001_SID ...
>

These are Job Queue Processes (formerly known as SNPn - Snapshot Processes). There also should be CJQ0 process, which is Job Queue Coordinator process - this process coordinates the Jnnn processes and controls what and when they execute. JOB_QUEUE_PROCESSES initialization parameter controls how much Jnnn processes an instance can have.

Further reading is available at http://tahiti.oracle.com. Oracle Concepts - Process Architecture is the required reading. Managing Job Queues in the Database Administrator's Guide should also shed some light on Job Queues and how jobs are managed and executed.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Thu May 22 2003 - 11:32:09 CDT