Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: three reads to get 64 blocks with dfmrc=32
I don't think it really matters at all and that it is simply not something
to be concerned about.
Did you notice the "ela=" values for the "direct path read" wait-events? They were quite a bit faster than those for the "db file scattered read" events.
Instead of investigating the buffering of "direct path read" into the PGA, perhaps it would be more profitable to worry about the elapsed time per "db file scattered read" into the SGA? I'll bet that there is nothing that you can do about it, as the more heavily mutexed SGA is bound to be "slower" to access and modify than the non mutexed PGA, but it might still be something worth investigating...
on 5/17/05 4:02 PM, jaromir nemec at jaromir_at_db-nemec.com wrote:
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 17 2005 - 18:47:08 CDT