Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Parameter to influence Oracle's Idea of IO Cost?

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

From: EscVector <Junk_at_webthere.com>
Date: 9 May 2007 19:10:56 -0700
Message-ID: <1178763055.976387.309940@y80g2000hsf.googlegroups.com>


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". Received on Wed May 09 2007 - 21:10:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US