Re: Oracle RDBMS performance on multiprocessor systems. [Q]

        I used to see this statement in the past, but it was a     reference to parallel execution services, not multiple processors.     In effect, it is not worth configuring parallel processing,     which splits a single operation up and allows multiple processors     to work on it in parallel, at less than 4 cpus.

        Many non-technical people hear this and don't     understand that multiple operations will still be distributed     across all available cpus by the operating system.     

Miroslaw Ryba wrote:
>
> Hello Everyone,
>
> I have recently heard an opinion that the Oracle database engine
> does not take full benefit of multiple processor hardware until
> the number of processors reaches four.
> I am not sure if this statement was ment to describe a general
> property of Oracle RDBMS or some particular hardware+OS+Oracle
> combination.
>
> Is there anyone on this list who could share some experience or
> knowledge in this area?
>
> We are currently planning purchase of a new Sun Enterprise Server
> to host large database and would very much appreciate any advice.
>
> Regards,
>
> Miroslaw Ryba,
> Oracle DBA
> CSIRO - Marine Research
> Hobart, Australia.
Received on Fri Nov 10 2000 - 14:11:14 CST