Re: Restarting dead background process QMNC ...
- From: Bala <oratips@xxxxxxxxx>
- To: Yong Huang <yong321@xxxxxxxxx>, outlawdba@xxxxxxxxx
- Date: Sun, 31 Oct 2010 15:48:08 -0500
Thank you very much Yong and Ellis -- I did the following reading through
the notes
"If AQ_TM_PROCESSES is not specified in versions 10.1 and above, QMNC only
runs when you have AQ objects in your database" -- so basically i removed
this parameter, and let oracle decide -- now the startup and Shutdown times
have improved to under 3 minutes.
Thanks again.
Bala --
On Sun, Oct 31, 2010 at 10:57 AM, Yong Huang <yong321@xxxxxxxxx> wrote:
> > Restarting dead background process...has
> > become pain, Shutdown or Startup database takes over 15 mintutes.
>
> Bala,
>
> Unless you're using streams or queues explicitly, you can set
> aq_tm_processes to 0 (v$parameter.isdefault will change from 'TRUE' to
> 'FALSE'). Most of the time the problem can go away. But be aware of the
> consequence. For example, sys.sys$service_metrics_tab in sysaux
> tablespace may grow and never get shrunk. See
> http://yong321.freeshell.org/oranotes/aq_tm_processes.txt
>
> It would be better to work with Oracle, or at least go through the MOS
> notes found by a search of "Restarting dead background process QMNC"
> (exact phrase). If you have qmnc trace files in bdump, they should help.
> Otherwise, events such as 10852 (Enable tracing for Enqueue Dequeue
> Operations), 10850 (Enable time manager tracing) may be used. In short,
> there must be a reason why QMNC keeps crashing.
>
> Yong Huang
>
>
>
>
--
Bala Rao
Other related posts:
