FW: p3 parameter in "direct path read"

Meant to send this reply to the list.

--

Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA

"There are 10 types of people in the world: Those who understand binary, and those who don't."

-----Original Message-----

From: Bobak, Mark
Sent: Friday, March 30, 2007 1:43 PM
To: 'Amir.Hameed_at_xerox.com'
Subject: RE: p3 parameter in "direct path read"

I believe it's governed by _db_file_direct_io_count?

--

Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA

"There are 10 types of people in the world: Those who understand binary, and those who don't."

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hameed, Amir Sent: Friday, March 30, 2007 12:31 PM
To: oracle-l_at_freelists.org
Subject: 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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 30 2007 - 12:43:55 CDT