Re: Huge MMON traces

  • From: Yong Huang <yong321@xxxxxxxxx>
  • To: tim@xxxxxxxxx
  • 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 ...

Yong Huang

--- On Sat, 11/15/08, Tim Gorman <tim@xxxxxxxxx> wrote:

> From: Tim Gorman <tim@xxxxxxxxx>
> Subject: Re: Huge MMON traces
> To: yong321@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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
> //www.freelists.org/archives/oracle-l/10-2008/msg00145.html
> 
> Yong Huang


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


Other related posts: