RE: db_file_multiblock_read_count and performance

I think what he is trying to prove is that given two full table scans one should perform faster by adjusting the size of the multiblock reads. The right questions might be....

1. Is DBMRC informative in nature only (tells Oracle what the actual read count size is for OS)?

or

2) Does DBMRC actually influence the size of read count at IO level? =20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling Sent: Monday, December 06, 2004 1:50 PM
To: ryan_gaffuri_at_comcast.net
Cc: Oracle-L_at_freelists.org
Subject: Re: db_file_multiblock_read_count and performance

Yes, I certainly have. I used it in conversion programs where I knew=20 that a lot of full scans were performed.

ryan_gaffuri_at_comcast.net wrote:

> has anyone see a response time improvement from this parameter
anywhere?=20

--=20
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

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