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: Galen Boyer <galenboyer_at_hotpop.com>
Date: 27 Jul 2001 10:31:19 -0500
Message-ID: <uk80utecd.fsf@verizon.net>

On Fri, 27 Jul 2001, jonathan_at_jlcomp.demon.co.uk wrote:

> If every other block is buffered, the scan will read one, skip
> one, read one, skip one ... and use 8,000 read requests to get
> the rest of the data.

So, moving the head to the correct block on disk (which in this case is the next block not in cache) is the definition of read request?

-- 
Galen Boyer
It seems to me, I remember every single thing I know.
Received on Fri Jul 27 2001 - 10:31:19 CDT

Original text of this message

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