Re: Shutdown of one instance takes about 1hr

On Feb 1, 3:43 pm, epoko..._at_excite.com wrote:
> 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)

Job_queue_interval is obsolete in 9i and higher. snp processes have been renamed.
Your advice is consequently incorrect.

The OP may need to set (temporarily) job_queue_processes and aq_tm_processes to 0.

--
Sybrand Bakker
Senior Oracle DBA