Re: Huge MMON traces

I forgot to say. It will be restarted. Here's my screen (instance name changed):

$ kill -9 20576
$ tail -f /home/oracle/oracle/product/10.2.0/db/admin/sidname/bdump/alert_sidname.log ...
Sat Nov 15 14:26:58 2008
Restarting dead background process MMON
MMON started with pid=16, OS id=1776
$ ps -fp 1776

UID        PID  PPID  C STIME TTY          TIME CMD
oracle    1776     1  0 14:26 ?        00:00:00 ora_mmon_sidname

pmon probably restarted it. At the time mmon was killed, pmon trace has a line about state object cleanup: KSS cleanup: kssdch_stage: possible loop ...

Yong Huang

• On Sat, 11/15/08, Tim Gorman <tim_at_evdbt.com> wrote:

> From: Tim Gorman <tim_at_evdbt.com>
> Subject: Re: Huge MMON traces
> To: yong321_at_yahoo.com
> Cc: oracle-l_at_freelists.org
> Date: Saturday, November 15, 2008, 12:44 PM
>
> Thanks, Yong! Does MMON get restarted automatically after
> it is killed? Or do we have to restart the instance in order for
> that to happen?
>
>
> Yong Huang wrote:
>
> > Since its development, how about finding out if the
> > entire instance will shutdown if the MMON process is killed?
>
> Killing MMON doesn't crash instance. Before we migrated
> most our applications from the unstable Itanium boxes
> running 10.2.0.2, we periodically killed MMON to release
> memory. See
> http://www.freelists.org/archives/oracle-l/10-2008/msg00145.html
>
> Yong Huang
      

--
http://www.freelists.org/webpage/oracle-l