Re: buffer hit cache ratio

uhhh... your confusing me with geomancer. I state that they do NOT use the BCHR. It was the other guy who said he does....

I just re-read my post. I guess it could be misleading. Ill be more careful.

lol...
"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3FE8BE95.38C097_at_remove_spam.peasland.com...
> >

http://asktom.oracle.com/pls/ask/f?p=4950:8:44868614384573658::NO::F4950_P8_
> > DISPLAYID,F4950_P8_CRITERIA:5051676080968,
>
> Did you actually read this? Where did Tom say in this link that he uses
> the BCHR for tuning (which is what the OP was asking about)?
>
> In fact, Tom says "You cannot look at a number -- 3,200,691 -- and draw
> ANY conclusions." And "My only idea is -- ignore the cache hit ratio.
> It is not what you want to focus on." And "A cache hit ratio has no
> meaning to me or anyone else as an indicator of a tuned system."
>
> And in this thread, didn't you say "Kyte says the only ratio he uses is
> parse/execute. Its in both of his
> books and i believe on his website."? Why now post a reply where you
> attempt to say that he said something that contradicts your earlier
> statements?
>
> Please read the material for comprehension before using it to defend
> your point.
>
> Cheers and have a nice holiday season!
> Brian
>
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Tue Dec 23 2003 - 18:10:50 CST