Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: p3 parameter in "direct path read"
By default it is now 1M in most platform.
_db_file_direct_io_count 1048576Sequential 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-lReceived on Fri Mar 30 2007 - 22:04:10 CDT
![]() |
![]() |