Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Advantages of second CPU
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 Mon Jan 25 1999 - 09:45:30 CST