"rjpfal" <ralbertson_at_comcast.net> wrote in message
news:2932a99f.0312311154.7117ef9b_at_posting.google.com...
>
> Also out of curiosity I ran same test but against all 8 CPU's rather
> than a dedicated 2. What is of interest is that the total elapsed time
> was greater when using all 8 rather than 2:
This may well be the case if, as we all seem to be agreeing you are
experiencing IO contention as the limiting factor. Increasing the number of
processes that request IO from a saturated disk will not speed things up :(
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Jan 01 2004 - 10:31:44 CST
