Re: Oracle / HP / Multiple Processors.

Hi,
Well, it all depends on two things:

1. How many queries do you run simultaneously? There are two extreme cases: (1) you run one query only: in this case adding more CPUs will have no effect. (2) You run many queries: each one will run faster.
2. Do you use Paralle Query (Oracle7) or Parallel DML (Oracle8)? If Yes, then additional CPUs will speed up the query even if it is the only job on the box.

Regards,
Sev

byronm wrote in message <7ufifn$oat$1_at_nnrp1.deja.com>...
>
>
>Question. I have an HP box running HP UX 11.0. Its a k200 with
>2 processors and 2 gigs of memory. I would like to speedup
>query performance and am just wondering how Oracle handles
>multiple CPU's.
>
>Would adding 2 more CPU's to this box speed up performance
>on individual queries or only allow more simultaneous queries
>at the current performance?
>
>just curious how hp/oracle and the k boxes spread out the
>cpu cycles. 2 more processors isn't that terrible of an
>expense, but i'd like to speak to anyone who has had experience
>with that type of upgrade and how it performed before i put
>a po out for it.
>
>Thanks.
>--
>-byron
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Oct 19 1999 - 03:18:46 CDT