Re: AWR Sample Report

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 20 Nov 2008 22:27:55 +0100
Message-ID: <4925d664$0$190$e4fe514c@news.xs4all.nl>


Steve Howard schreef:
> On Nov 19, 1:14 am, raja <dextersu..._at_gmail.com> wrote:

>> Steve Howard,
>> May i know how you calculated the below ones ...
>> "It looks like you had an average of 30% USER CPU for the duration of
>> the snap (92,000 seconds of USER CPU, with 14 CPU's over six hours of
>> available CPU to be used)."
>>

>
> Hi Raja,
>
> The OS STAT piece of your AWR said you used...
>
> Operating System Statistics
> Statistic Total
>
> <<snip>>
>
> USER_TIME 9,246,603
> NUM_CPUS 14
> NUM_CPU_CORES 7
>
> The USER_TIME is quoted in centiseconds, so 9,246,603 / 100 = ~ 92,000
> seconds of user CPU over the six hour window.
>
> You have 14 CPU's of time available to you, so...
>
> 6 hours * 14 CPU's = 302,400 seconds (14 * 6 hours * 60 minutes * 60
> seconds)
>
> 92,000 used / 302400 available = ~30% utilized
>
> That's an average over 6 hours, and I once saw Jonathan Lewis write
> that if your head is on fire and your feet are are in a bucket of ice
> water, on average you should be pretty comfortable :)
>
> YMMV
>
> HTH,
>
> Steve

Try that same case with a light bulb and voltages. Metafores are wonderful things....

Shakespeare Received on Thu Nov 20 2008 - 15:27:55 CST

Original text of this message