p3 parameter in "direct path read" - oracle-l - FreeLists

p3 parameter in "direct path read"

From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 30 Mar 2007 12:30:46 -0400

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

Follow-Ups:
- Re: p3 parameter in "direct path read"
  - From: Zhu,Chao

Other related posts:

» p3 parameter in "direct path read"
» Re: p3 parameter in "direct path read"