Re: ora_cjq0

On Tue, May 13, 2003 at 07:40:52AM -0800, Robert Stauffer wrote:
> It's the job queue background process. I believe Oracle changed the job processing mechanism in 9i.

Doc ID: 222180.1

JQ0 is Coordinator of Job Queue slave processes. .
CJQ0 dynamically spawns job queue slave processes (J000...J999) which performs actions (jobs). Jobs are defined through interface package DBMS_JOB and can be seen through DBA_JOBS view.
The job queue process (Jnnn) executes one of the jobs that was selected by the CJQ process for execution. The Jnnn processes executes one job at a time. .
After the process (Jnnn) finishes execution of a single job, it polls for more jobs. If there are no scheduled jobs for execution, it enters a sleep state, from which it wakes up at periodic intervals and polls for more jobs. If the process does not find any new jobs, it aborts after a preset interval. .
Note:
The coordinator process is not started if the init.ora parameter JOB_QUEUE_PROCESSES is set to 0.

For more information check following documentation:

        'Oracle9i Database Concepts' - 'Process Architecture'
        'Oracle9i Database Administrator's Guide' - 'Managing Job Queues'

>
> >>> john.dunn_at_sefas.co.uk 05/13/2003 05:36:38 >>>
> What is the process ora_cjq0 in oracle 9i ?????
>
> I do not recall seeing it in 8i?
>
> Platform is Solaris
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
> **DISCLAIMER
> This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Robert Stauffer
> INET: rstauffer_at_decommunications.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).