Re: ORACLE 8 efficiency/number of processor

It depends a bit what these sessions are doing. You need to experiment a bit. With more sessions keeping read consistency will keep Oracle busy more and more. Generally with large systems you keep the commit frequency of batch jobs to a minimum but there are certain tricks to get around that.

Hope this helps,

--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com


"bourdon" <bertrand.bourdon_at_sycomore.fr> wrote in message
news: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

>

>                    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