Re: ORACLE 8 efficiency/number of processor

Thank you for this answer. It seems then that I did formulated it the wrong way.

How does the number of supported users evolved whith the increase of the number of propocessor ? (and by th way, how much memory per session is needed ?)

Thank you

                   Bertrand Bourdon

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<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
Received on Fri Jul 13 2001 - 03:17:14 CDT