Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: p3 parameter in "direct path read"

Re: p3 parameter in "direct path read"

From: Zhu,Chao <zhuchao_at_gmail.com>
Date: Sat, 31 Mar 2007 11:04:10 +0800
Message-ID: <962cf44b0703302004v3e55326x5538bad6d1ad4456@mail.gmail.com>


By default it is now 1M in most platform.

_db_file_direct_io_count                      1048576
Sequential I/O buf size

On 3/31/07, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
>
> Folks,
> Does anyone know how Oracle computes value for the p3 parameter during
> direct path reads? It seems that this is not directly governed by the
> MRBC setting because in my raw trace file, with MRBC set to 8, I am
> seeing this value as high as 31.
>
> Thanks
> Amir
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Regards
Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 30 2007 - 22:04:10 CDT

Original text of this message

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