Job Queue Processes

Job queue processes automatically execute local jobs. In a replication environment, job queue processes handle the automatic propagation of the deferred transaction queue and the purging of the deferred transaction queue. Accordingly, each master site in a replication environment must start one or more job queue processes. It is important that you have enough job processes allocated to handle the amount of local jobs at the local site.

The JOB_QUEUE_PROCESSES initialization parameter specifies the maximum number of Jn background processes per server, where n is 000 to 999. Set this parameter to a value of one or higher. You should typically have one job queue process for each scheduled link at a replication site, as well as additional job queue processes for purge jobs and other local jobs.

You can change the value for this initialization parameter in the following ways:

• Use the Instance Management tool in Oracle Enterprise Manager.

• Edit the initialization parameter file.

• Use the ALTER SYSTEM statement to change the setting dynamically.