Re: CPU Upgrade Advice

Larry,

There is no simple answer your question. Your HP vendor should be able to articulate the distintions between using a single-mega-fast CPU versus other options for your specific application.

As for query performance, I think most oracle geeks will concur that bottlenecks are most likely to occur at the I/O level. 50GB+ over 2 controllers sounds weak but , I may be spoiled. When it comes to CPU operations such as sorting, you will want to know how your hardware configuration (ie. CPU(s)) will perform for such operations.

In addition, I would suggest you explore/exploit the use of parallel query processing as this will provide fabulously better performance than the conventional single task query. Even if you have a single CPU, you will find applications which can benefit from this functionality.

I hope this response provides you some nominal benefit.

Good luck,

-D

On 6 Dec 1996 12:26:36 GMT, "Larry Monack" <lmonack_at_sprynet.com> wrote:

>Hypothetical question: In a data warehousing environment, is it better to
>have 2 cpus running in parallel or 1 cpu that is twice as fast?
>
>I have a 50+GB Oracle data warehouse running on an HP G30 that has 12 disk
>drives connected to 2 SCSI controllers. I'm about to do a CPU upgrade and
>would like to get as much bang-for-the-buck as I can. I'm concerned mostly
>about query performance.
>
>Any advice would be greatly appreciated.
>
>Larry Monack
>lmonack_at_fsco.com
>lmonack_at_sprynet.com

################################################################

Email: darryl.snedeker_at_fmr.com

Disclaimer: The opinions expressed herein are my own and in

             no way reflects the same of my employer.
             All recommendations and advice must be verified
             to be accurate by the recipient before implementation.

Quote Du' Jour: Thinking up some cute saying to entertain the masses.

#############################################################################