Re: ORACLE 8 efficiency/number of processor

If you mean does an individual query execute faster on Oracle 8 parallel server vs non-parallel the answer is no. (actually it may take longer on parallel server depending upon what else is ging on on the system at the same time). There is an option called Oracle Parallel query and that may speed up an indivudal query by splitting it up and having multiple slave processes work on different parts of the query.

Parallel server is to increase scalability (the number of users) and does not increase the performance of an individual query (assuming no other load).
Hope that helps,
Jim
"bourdon" <bertrand.bourdon_at_sycomore.fr> wrote in message news:f08bd788.0107090632.5787859c_at_posting.google.com...
> I am looking for information on ORACLE 8 Parallel Server behaviour vs
> the number of process involved in a multi-pro machine. That is I need
> to simulate ORACLE time of response with different number of processor
> on a E10000 (TPMC bench doesn't seem to content this kind of
> information).
>
>
> Thanks,
>
> Bertrand Bourdon
Received on Mon Jul 09 2001 - 10:09:49 CDT