Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown of one instance takes about 1hr

Re: Shutdown of one instance takes about 1hr

From: sybrandb <sybrandb_at_gmail.com>
Date: 1 Feb 2007 07:40:20 -0800
Message-ID: <1170344419.998990.131790@q2g2000cwa.googlegroups.com>


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
Received on Thu Feb 01 2007 - 09:40:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US