Re: Restarting dead background process QMNC ...
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oratips@xxxxxxxxx
- Date: Sun, 31 Oct 2010 08:57:29 -0700 (PDT)
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
