Re: Parameter to influence Oracle's Idea of IO Cost?

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 09 May 2007 16:37:22 +0200
Message-ID: <5ae4kkF2oaet3U2@mid.individual.net>

On 09.05.2007 16:22, Valentin Minzatu wrote:

> On May 9, 6:48 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:

>> Hi,
>>
>> this is on 10.2.0.1.0. I think I remember that there is a parameter
>> that will affect how Oracle costs IO but can't seem to find it (searched
>> DB Reference, Performance Tuning Guide, PL/SQL Package Reference, Web).
>> Does my memory fail me?
>>
>> Do you know other ways to influence how Oracle costs single block reads
>> vs. multi block reads (apart from DB_FILE_MULTIBLOCK_READ_COUNT and
>> hinting that is)? Thank you!
>>
>> Kind regards
>>
>> robert

> 
> What is the problem you try to address by chaging the optimizer
> behavior?

I'm trying to bias the CBO towards multi block reads.

Kind regards

        robert Received on Wed May 09 2007 - 09:37:22 CDT