Re: Request: "Are you still using cache hit ratios?" Hotsos paper

Hi Mark,

Thanks for your reply.

I had already those two articles (and also his book) and they're still very useful and accurate, as the focus is on fundamentals.

As for the article mentioned on the subject, I saw it mentioned by Tom Kyte on and old Ask Tom post and got curious about it.

Kind Regards,
Lucas Pimentel Lellis

Em qua, 30 de jun de 2021 04:12, Mark J. Bobak <mark_at_bobak.net> escreveu:

> I did a quick Google search, know exact match for that title, but there
> are a couple of papers from Cary Millsap that are still available... One is
> called "why you should focus on LIOs instead of PIOs" and the other is "Why
> a 99%+ buffer cache hit ratio is not ok". These papers are a couple of
> decades old now, but the fundamental strategy around tuning SQL hasn't
> really changed much in that time...
>
> -Mark
>
> On Tue, Jun 29, 2021, 20:18 Lucas Pimentel Lellis <lucaslellis_at_gmail.com>
> wrote:
>
>> Hi,
>>
>> Does anybody have the "Are you still using cache hit ratios?" paper that
>> used to be on Hotsos' website?
>>
>> Kind Regards,
>>
>> Lucas Pimentel Lellis
>>
>

--
http://www.freelists.org/webpage/oracle-l