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: What is Parallel DML?

Re: What is Parallel DML?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Sat, 21 Jul 2001 21:53:32 +0200
Message-ID: <9jcmi1$nrr$1@ctb-nnrp1.saix.net>

"Howard J. Rogers" <howardjr_at_www.com> wrote

> The short story is that you are going to get multiple server processes
> updating different data blocks at the same time. Accordingly, whatever
 DML
> it is that you are performing takes much less time to perform.
>
> Totally pointless on a single CPU box, really, since only one process can
> run on a CPU at any one nanosecond, but in a multi-CPU and multi-Gigabyte
> database, it can make a lot of difference.

Bull. If there is one thing that really makes me want to swing my lead pipe, even when I had my first early morning cup, is ignorance shared as a pearl of wisdom.

It makes a difference - a HUGE difference. Go and read up some on before making statements like that.

It is a FANTASY story that PQ or parallel processing does not work, or does not work well, on a single CPU box.

--
Billy
Received on Sat Jul 21 2001 - 14:53:32 CDT

Original text of this message

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