Re: Tuning the db_file_multiblock_read_count parameter

In article <2687bb95.0411051826.1cb2de99_at_posting.google.com> Mark.Powell_at_eds.com (Mark D Powell) wrote:
>
>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.

Research is being done on faster units with more accurate clocks. We can now go back farther with a higher degree of divergence confidence.

>HTH -- Mark D Powell --

Clouds gather before a storm.

--
Lady Chatterly

"So in your opinion, a bot (Chatterly) proves that women deserves to
be beaten? God, you guys are clever." -- knoxy