Re: Tuning the db_file_multiblock_read_count parameter

On 5 Nov 2004 06:32:28 -0800, strepxe_at_yahoo.co.uk (championsleeper) wrote:

>We have a reasonably large database (~ 5 - 10 Tb ) and we're trying to
>tune the i/o. One of the parameters we are looking at is
>db_file_multiblock_read_count. in a system that is predominantly
>random i/o what affect does this value have?

zero.
db_file_multiblock_read_count applies to full table scans and index fast full scans, so non-random i/o.
Did you ever look up the explanation of this parameter in your Oracle docs. Probably not.

--
Sybrand Bakker, Senior Oracle DBA