Re: three reads to get 64 blocks with dfmrc=32

Hi Tim,

> I would guess that there is only room in those

> read buffers in each P00x process's PGA for sixty-one 16-Kb buffers

Exactly, I set the dfmrc to 64, so there are two reads per extent, 61 blocks and 2 blocks.

Lowering dfmrc to 10 there are 6 x 10 + 1 reads.

I varied pga_aggregate_target between 10M and 50M with no effect on this behavior.

I'll examine the influence of parallel_execution_message_size but this will take some preparation.

It is not really a big issue , but it is *not nice*.

Thanks anyway

Jaromir

• Original Message ----- From: "Tim Gorman" <tim_at_evdbt.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, May 17, 2005 4:30 AM Subject: Re: three reads to get 64 blocks with dfmrc=32

--
http://www.freelists.org/webpage/oracle-l