Re: SNPn processes

A copy of this was sent to Kenneth C Stahl <BlueSax_at_Unforgettable.com> (if that email address didn't require changing) On Tue, 16 Nov 1999 08:12:50 -0500, you wrote:

>I have a 7.3.4 database on a Unixware 2.1.2 platform and when I do a:
>
>ps -ef | grep -i ora
>
>I see that there is an SNP0 process running.
>
>Can someone tell me why? I understand that this has something to do with
>snapshots. What would I need to do to turn it off?

SVRMGR> show parameter job_queue

NAME                                TYPE    VALUE
----------------------------------- ------- ------------------------------
job_queue_interval                  integer 30                            
job_queue_keep_connections          boolean TRUE                          
job_queue_processes                 integer 3    

yours will probably have a processes = 1.

depending on release you can:

alter system set job_queue_processes = 0;

and then fix up your init.ora so it remains at 0 with the next reboot (the snp process will go away, give it a little time).

with earlier releases you will have to change the init.ora and then restart the database for this to take effect.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Nov 16 1999 - 07:51:26 CST