Re: ORACLE 8 efficiency/number of processor
Date: Mon, 09 Jul 2001 15:09:49 GMT
Message-ID: <1Pj27.321971$p33.6474469_at_news1.sttls1.wa.home.com>
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 - 17:09:49 CEST