Re: interpreting wait/stat time per second

From: Anjo Kolk <anjo.kolk_at_oraperf.com>
Date: Wed, 1 Aug 2007 17:54:11 +0200
Message-ID: <54973d5e0708010854k2f99ae0fjacf79075a97155e0@mail.gmail.com>

CPU time is limited by the number of CPUs. The wait time is limited by the number of sessions. So if you have 8 CPUs you can have 8 CPU seconds per second. If you have 30 session you can have a max of 30 seconds of wait time per elapsed second.

Anjo.

On 8/1/07, Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is> wrote:
>
> Is is true that time metrics per second can be more than 1 second(per
> second) when server has more than one CPU? Meaning for example that on 8 CPU
> machine maximum wait time should not exceed 8 seconds unless we have some
> rounding errors or bug.
>
>
> Fyrirvari/Disclaimer
> http://www.landsbanki.is/disclaimer
>

-- 
Anjo Kolk
Owner and Founder OraPerf Projects
tel:    +31-577-712000
mob: +31-6-55340888

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

Received on Wed Aug 01 2007 - 10:54:11 CDT