Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Advantages of second CPU

Re: Advantages of second CPU

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Tue, 26 Jan 1999 02:57:24 GMT
Message-ID: <36ad2efb.261919910@news.cyberus.ca>


Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote:

>On Mon, 25 Jan 1999, Billy Verreynne wrote:
>>
>> Aj wrote in message <78385o$fv2$2_at_ash.prod.itd.earthlink.net>...
>> >Big boost will be from the parallel qurery option..... U need atleast
>> >two CPUs for this.... after all Two means less load on one.
>>
>> Need at least 2 CPUs for Oracle PQ? Not true. This is a common
>> misconception which I am not going to try and correct -again- in this
>> newsgroup. So just believe me when I say you can RUN and USE PQ on only
>> ONE CPU!
>
>True that PQ will run on a single-proc. machine, but what good is it? You
>just add a bunch more overhead for the PQ enqueue/dequeue and using Oracle
>as a process scheduler instead of the O/S, which is more likely to be
>optimized for the chip. You can use 100% of the processor with one Oracle
>server process, or 100% of the processor with ten server processes. You
>just add overhead.
>
>--
>Jeremiah Wilton http://www.wolfenet.com/~jeremiah
>

Let's not get Billy going again...
Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Mon Jan 25 1999 - 20:57:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US