Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Advantages of second CPU
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