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: joel garry <joel-garry_at_home.com>
Date: 9 May 2007 11:31:35 -0700
Message-ID: <1178735495.729271.192830@u30g2000hsc.googlegroups.com>


On May 9, 3: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

The following google web search can be quite informative:

costs single block read "jonathan lewis"

jg

--
@home.com is bogus.  "This is why I conceived of Web Zero.0, Anti-
Social Software. I don't need more ways for people to network with me
via the internet, I need more ways to make them leave me alone. ASS
would eliminate all incentives to game the system, it recognizes that
the "collective intelligence" is full of annoying junk and tries to
block it from reaching the user. Subtract all the Web 2.0 crap from
the Internet and you're left with the remainder, Web Zero.0, which
must contain the few useful things not yet spoiled by mass
commercialization." - Charles
Received on Wed May 09 2007 - 13:31:35 CDT

Original text of this message

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