Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

SNP Background Processes

Background processes, called SNP background processes, execute job queues.

SNP processes periodically wake up and execute any queued jobs that are due to be run. You must have at least one SNP process running to execute your queued jobs in the background.

SNP background processes differ from other Oracle background processes in that the failure of an SNP process does not cause the instance to fail. If an SNP process fails, Oracle restarts it.

Multiple SNP Processes

An instance can have up to thirty-six SNP processes, named SNP0 to SNP9 and SNPA to SNPZ. If an instance has multiple SNP processes, the task of executing queued jobs can be shared across these processes, thus improving performance. Note, however, that each job is run at any point in time by only one process. A single job cannot be shared simultaneously by multiple SNP processes.

Starting Up SNP Processes

The job queue initialization parameters allow you to control the operation of the SNP background processes. Set these parameters in the initialization parameter file for an instance. They take effect the next time you start the instance.

Table 10 - 1 describes the job queue initialization parameters.

Parameter Name Description
JOB_QUEUE_PROCESSES Default: 0
Range of values: 0...36
Multiple instances: can have different values
Sets the number of SNP background processes per instance.
JOB_QUEUE_INTERVAL Default: 60 (seconds)
Range of values: 1...3600 (seconds)
Multiple instances: can have different values
Sets the interval between wake-ups for the SNP background processes of the instance.
Table 10 - 1. Job Queue Initialization Parameters


Contents Index Home Previous Next