Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > job_queue_processes

job_queue_processes

Oracle 11.1.0:

Parameter Name:job_queue_processes
Description:maximum number of job queue slave processes
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:job_queue_processes
Description:number of job queue slave processes
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:job_queue_processes
Description:number of job queue slave processes
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:job_queue_processes
Description:number of job queue slave processes
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

Parameter Name:job_queue_processes
Description:number of job queue processes to start
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.0.6:

Parameter Name:job_queue_processes
Description:number of job queue processes to start
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 7.3.4:

Parameter Name:job_queue_processes
Description:number of job queue processes to start
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Related Error Messages:

ORA-12042: cannot alter job_queue_processes in single process mode
    Cause: An attempt was made to alter job_queue_processes in single process mode.

    Action: Do not attempt to set job_queue_processes in single process mode.//

ORA-25261: JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation

    Cause: AQ Propagator encountered a setting for JOB_QUEUE_PROCESSES that is insufficient for AQ propagation.

    Action: Set the number of JOB_QUEUE_PROCESSES to at least 2 for AQ propagation.

ORA-30435: job_queue_processes must be non-zero in order to refresh summaries

    Cause: The server must be started with parameter 'job_queue_processes' greater than zero//

    Action: Correct the value of job_queue_processes and restart the server instance

This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ job_queue_processes ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US