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

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





--
Regards
Zhu Chao
www.cnoug.org

Other related posts: