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

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 10 May 2007 10:44:09 +0200
Message-ID: <5ag4acF2mocmqU3@mid.individual.net>

On 10.05.2007 04:10, EscVector 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 does cost have to do with response time?
> Are you looking to speed something up or is this just like "tuning the
> cache hit ratio".

assumed IO cost => Plan => Performance

where "=>" means influences.

        robert Received on Thu May 10 2007 - 03:44:09 CDT