Re: p3 parameter in "direct path read"
- From: "Zhu,Chao" <zhuchao@xxxxxxxxx>
- To: Amir.Hameed@xxxxxxxxx
- Date: Sat, 31 Mar 2007 11:04:10 +0800
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@xxxxxxxxx> 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
- References:
- p3 parameter in "direct path read"
- From: Hameed, Amir
Other related posts:
- » p3 parameter in "direct path read"
- » Re: p3 parameter in "direct path read"
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
- p3 parameter in "direct path read"
- From: Hameed, Amir