Re: Account DB CPU vs OS CPU

From: LS Cheng <exriscer_at_gmail.com>
Date: Thu, 24 Sep 2009 07:07:26 +0200
Message-ID: <6e9345580909232207h2cb17147u15ac22041a0c6ac2_at_mail.gmail.com>

By the way I understand that when doing I/O CPU is not accounted by Oracle, so it might be a the cause of such observation?

Thanks

--
LSC


On Thu, Sep 24, 2009 at 6:55 AM, LS Cheng <exriscer_at_gmail.com> wrote:



> Hi

>

> I have a 4 nodes RAC running on Solaris 10 each with 5 quadcore CPU (or

> Dual with Threading not sure). Shows 20 CPU in psrinfo.

>

> A few days ago we were running with two nodes only and one node during peak

> time was consuming an average of 95% CPU. There are 15 instances per node so

> I obtained DB CPU from time model for each instance during the peak time

> (one hour), added them up and got around 45000 seconds. Considering 20 CPU

> there should be around 72000 seconds CPU so from Oracle point of view 62.5%

> of CPU was being used in average but from OS point of view 95%.

>

> There arent any more application running except Patrol agent and Grid

> agent, so how trustie is DB CPU statistic?

>

>

> Thanks!

>

> --

> LSC

>

>


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

Received on Thu Sep 24 2009 - 00:07:26 CDT