Re: Defunct processes in 10g(mmon and qmnc)

  • From: "Sriram Kumar" <k.sriramkumar@xxxxxxxxx>
  • To: Rich.Jesse@xxxxxx
  • Date: Fri, 28 Apr 2006 12:18:24 +0530

Hi Rich,

Thank you for the valuable inputs. I am waiting for the defunct processes to
re appear. Planning to raise a SR. lets see.

Thanks again

Cheers

Sriram Kumar


On 4/27/06, Jesse, Rich <Rich.Jesse@xxxxxx> wrote:
>
>  Yup.  10.1.0.4 on Solaris 9.  The defuncts death spiraled until we ran
> out of OS process slots and I had to bounce the instance.  All 10000+
> processes that I saw were from MMON.  And this was on a production box.
> From the SR: "Development indicates that the MMON messages occur when
> manageability features like automatic snapshots stop if one executes 'alter
> system enable restricted session' and then 'alter system disable restricted
> session'."
>
> I had not touched any of the ADDM stuff in this database, so I'm not
> exactly buying the answer, but YMMV.
>
> GL!
>
> Rich
>
>
>
>  -----Original Message-----
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sriram Kumar
> *Sent:* Thursday, April 27, 2006 9:25 AM
> *To:* ORACLE-L
> *Subject:* Defunct processes in 10g(mmon and qmnc)
>
> Hello Gurus,
>
> Environment: 10.1.0.4
> OS : Solaris 9 (Sunfire V440)
>
> Was casually checking process listing of oracle id and found a lot (about
> 70-80 processes) of <defunct> processes and most of these processes have
> thier PPID as qmnc' s (queue monitor) or mmon's (mem mon) process id.  being
> a test box I had killed qmnc and mmon and these processes disappeared.
>
> I am closely monitoring the systems for these symptoms again and plan to
> raise a SR with metablink. Have any one of you seen this before?
>
> Best Regards
>
> Sriram Kumar
>
>
>
>
>

Other related posts: