Re: Shutdown of one instance takes about 1hr

Perhaps this is coming into play:

On "startup", Oracle starts a number of "snp" processes based on the "init.ora" parameter "JOB_QUEUE_PROCESSES".

Depending on how long Oracle takes to process the "shutdown" and the value specified in the "init.ora" parameter "JOB_QUEUE_INTERVAL", one or more of the "snp" processes may wake up to check the job queue. The smaller the value of "JOB_QUEUE_INTERVAL", the sooner the "snp" processes will wake up.

You may need to adjust the above referenced parameters.

Regards,

    Eugene Pokopac (Oracle DBA - GSFA - Tucker, GA) Received on Thu Feb 01 2007 - 08:43:09 CST