Re: Request: "Are you still using cache hit ratios?" Hotsos paper
From: Mark J. Bobak <mark_at_bobak.net>
Date: Wed, 30 Jun 2021 03:12:35 -0400
Message-ID: <CAFQ5ACJNkNM4W68vH9Z-DO1Oumda2q7QQTPhOi-tbxUfz7BODA_at_mail.gmail.com>
Date: Wed, 30 Jun 2021 03:12:35 -0400
Message-ID: <CAFQ5ACJNkNM4W68vH9Z-DO1Oumda2q7QQTPhOi-tbxUfz7BODA_at_mail.gmail.com>
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-lReceived on Wed Jun 30 2021 - 09:12:35 CEST