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

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 9 May 2007 03:53:34 -0700
Message-ID: <1178708014.110180.118330@q75g2000hsh.googlegroups.com>

On 9 mayo, 12:48, 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

OPTIMIZER_INDEX_COST_ADJ HTH Cheers

Carlos. Received on Wed May 09 2007 - 05:53:34 CDT