Re: Tuning the db_file_multiblock_read_count parameter

strepxe_at_yahoo.co.uk (championsleeper) wrote in message news:<103a78f3.0411050632.15da869a_at_posting.google.com>...
> 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?

Depending on your exact version and the use of system statistics with version 9+ larger values for the db_file_multiblock_read_count parameter influence the cost based optimizer to favor full table scans over using indexes.

HTH -- Mark D Powell -- Received on Fri Nov 05 2004 - 20:26:43 CST