Re: Hit Ratio

Ah yes, you could introduce heuristically (spelling?!) skewed hit ratios. As Dave Ensor explained at UKOUG, the word "heuristic" in Oracle's optimizer code can be translated directly into "constant". So add a number here or there until it fits.

Mogens

Jonathan Lewis wrote:

>Easy,
>
>A new formula for the hit ratio
>
>
>Regards
>
>Jonathan Lewis
>http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
>One-day tutorials:
>http://www.jlcomp.demon.co.uk/tutorial.html
>
>
>Three-day seminar:
>see http://www.jlcomp.demon.co.uk/seminar.html
>____UK___November
>
>
>The Co-operative Oracle Users' FAQ
>http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Sunday, December 21, 2003 1:19 AM
>
>
>Actually, it isn't SAP. I was simply creating a set of MV's
>based on SAP tables in another database.
>
>The script I was running is used to keep track of how much
>IO is going on, just to ensure that everything is still
>working during the build. Once the physical IO exceeds
>the logical IO, the HR goes negative.
>
>I wonder what I need to tune to fix this?
>
>Jared
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?UTF-8?B?TW9nZW5zIE7DuHJnYWFyZA==?=
  INET: mln_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).