SNP'S are job Queue Processes, These processes wake up periodically and refresh any snapshots that are scheduled to be automatically refreshed. If more than one job queue process is used, the processes share the task of refreshing snapshots.
Unlike other Oracle background processes, failure of an SNPn process does not cause the instance to fail. If an SNPn process fails, Oracle restarts it.
These processes also execute job requests created by the DBMS_JOB package and propagate queued messages to queues
on other databases.
Main Topics
Browse All Topics





by: niko_itPosted on 2000-05-30 at 02:05:45ID: 2861549
SNP'S are job Queue Processes, These processes wake up periodically and refresh any snapshots that are scheduled to be automatically refreshed. If more than one job queue process is used, the processes share the task of refreshing snapshots.
Unlike other Oracle background processes, failure of an SNPn process does not cause the instance to fail. If an SNPn process fails, Oracle restarts it.
These processes also execute job requests created by the DBMS_JOB package and propagate queued messages to queues
on other databases.