Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: interpreting wait/stat time per second

Anjo Kolk

2007-08-01

Replies:

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@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
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.