Re: AWR Sample Report
Date: Wed, 19 Nov 2008 06:12:57 -0800 (PST)
Message-ID: <fbdce636-a032-4f73-af20-4feacf9a6847@g17g2000prg.googlegroups.com>
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 Received on Wed Nov 19 2008 - 08:12:57 CST