Re: cpu utilization on solaris

From: Danisment Gazi Unal (Unal Bilisim) <danisment.unal_at_unal-bilisim.com>
Date: Thu, 24 May 2001 07:13:49 -0700
Message-ID: <F001.0030D19B.20010524054119@fatcity.com>

Hello,

Hi Ranganath,

This bug is specific to Sun E10000 models when USE_ISM is set. It's Note#77604.1. anyway, setting USE_ISM gains performance. But, if you are using E10000 models, see Note#77604.1. This bug causes Oracle block corruptions.

from Note#77604.1:

---

There are also cases where the system may seem like it's hung but the kernel CPU usage is so high that no other activity can take place. Simply enabling the ISM reduced the kernel CPU usage, eliminating the hanging situations.

---

And,

You can also examine your database. many people believe that OS kernel usage is relavent to OS only and Oracle waits do not use CPU. These are definitly wrong. When Oracle waits are timed-out(becasue of semaphore structures), waits check resources if They are available. This took CPU cycles(note that process is still in wait mode). And, If there are a lot of waiting processes in a system, this may cause high kernel CPU usage Since management of timing-out is done in kernel mode.

regards...

Ranganath K wrote:

> Hi Unal,
>
> Can you send me the Doc Id of the article by Erhan Odok?
>
> Thanks and Regards,
>
> Ranganath
>
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Danisment Gazi
> Unal (Unal Bilisim)
> Sent: Thursday, May 24, 2001 3:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: cpu utilization on solaris
>
> Hi,
>
> As I remember, there was a bug on Sun-A1000 with CPU utilizitation. There
> should
> be an article of Erhan Odok on metalink which gives Sun's bug number.
>
> regards...
>
> Jared Still wrote:
>
> > Run 'top' and see what the CPU hogs are. If they are
> > Oracle shadow processes, check with the user that
> > owns the session. It may belong to someone whose
> > PC crashed or the just shut it off, and you have a
> > disconnected session consuming resources.
> >
> > If you discover a shadow process is consuming 100%
> > of a CPU, it probably needs to be killed. Just be sure
> > to find out if it's OK to do so first.
> >
> > Jared
> >
> > On Wednesday 23 May 2001 13:56, Nihar wrote:
> > > Hi gurus
> > >
> > > I am running oracle 8.1.6 on solaris 2.7. All of a sudden my cpu
> > > utilization reached 85-90%.
> > > I am also having Sun A1000 hardware RAId attached to the box. Can any
> body
> > > help me out in this.
> > > i am sending my report.txt file here after running utlbstat and
> utlestat.
> > >
> > > thanks
> > >
> > > -Nihar
> >
> > ----------------------------------------
> > Content-Type: text/plain; charset="iso-8859-1"; name="report.txt"
> > Content-Transfer-Encoding: quoted-printable
> > Content-Description:
> > ----------------------------------------
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Danisment Gazi Unal (Unal Bilisim)
> INET: danisment.unal_at_unal-bilisim.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: danisment.unal_at_unal-bilisim.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu May 24 2001 - 09:13:49 CDT