Integer 

Dynamic. Scope = ALTER SYSTEM. 

0 

0 to 36 

Multiple instances can have different values. 

JOB_QUEUE_PROCESSES is relevant in replication environments. It specifies the number of SNPn job queue processes per instance (SNP0, ... SNP9, SNPA, ... SNPZ). Job queue processes process requests created by DBMS_JOB.

Some job queue requests are created automatically. An example is refresh support for materialized views. If you wish to have your materialized views updated automatically, you must set JOB_QUEUE_PROCESSES to a value of one or higher.

See Also: Oracle8i Replication and Oracle8i Data Warehousing Guide for more information on managing materialized views.