Re: ORACLE 8 efficiency/number of processor
Date: 13 Jul 2001 01:17:14 -0700
Message-ID: <f08bd788.0107130017.71e9d0fa_at_posting.google.com>
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
"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<1Pj27.321971$p33.6474469_at_news1.sttls1.wa.home.com>...
Bertrand Bourdon
> 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 - 10:17:14 CEST