But most Queries are I/O bound..........
Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote in message
news:Pine.OSF.4.02.9901250734370.4785-100000_at_gonzo.wolfenet.com...
>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
>
Received on Tue Jan 26 1999 - 04:14:33 CST
