Re: Huge MMON traces
Date: Sat, 15 Nov 2008 12:43:36 -0800 (PST)
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 ...
- 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
> Yong Huang