Re: DB CPU in Time Model

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 16 Aug 2011 06:53:33 +0100
Message-ID: <CABe10sYmEhFhscbxrsDfdSFYFhy3_9v+RQ_Fk5NyHxqKxcD5bg_at_mail.gmail.com>



On a machine with more than one 'CPU' you can spend more than 1 second on cpu time for each second of elapsed time.

On Mon, Aug 15, 2011 at 9:08 PM, Venkat Krish <venkat.lear_at_gmail.com> wrote:

> Hi -
> This is just a curious question that popped up my mind by looking at
> someone's AWR.. I dont have access to database and wont be able to run any
> related query or anything.
>
> The TimeModel statistics have been pasted here:
> http://pastebin.com/YZ7SRX0M
>
>
> The question is related to "DB CPU" metric ..
>
> Here is what I know or my thought process.. please correct me, if I am
> missing anything or incorrectly ruling out
>
> -- the SQL elapsed time accounts only to less than 50% (if there was a
> culprit sql or API, it should hv been counted against this.)
> -- parsing is near zero (so its not parsing cpu)
> -- there could have been no PL/SQL (looping with dbms_lock.sleep or
> anything similar) because PLSQL exec time is almost zero
>
>
> what could be causing this DB CPU.. ?? if the db is spending 83% on total
> db time cpu but doesnt correspond to sql or plsql elapsed time, is it a good
> or bad indicator?
>
> Thanks in advance,
> Venkat
>
> PS: DB version : 11.2.0.2 running on Solaris
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 16 2011 - 00:53:33 CDT

Original text of this message