MIME-Version: 1.0
References: <CAMWwQge=YU2eL+dzVo7im6XMaA-gYMzzJxegyRtD6v0k760Muw@mail.gmail.com>
In-Reply-To: <CAMWwQge=YU2eL+dzVo7im6XMaA-gYMzzJxegyRtD6v0k760Muw@mail.gmail.com>
From: "Mark J. Bobak" <mark@bobak.net>
Date: Wed, 30 Jun 2021 03:12:35 -0400
Message-ID: <CAFQ5ACJNkNM4W68vH9Z-DO1Oumda2q7QQTPhOi-tbxUfz7BODA@mail.gmail.com>
Subject: Re: Request: "Are you still using cache hit ratios?" Hotsos paper
To: lucaslellis@gmail.com
Cc: ORACLE-L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="000000000000143e1805c5f67393"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: mark@bobak.net
--000000000000143e1805c5f67393
Content-Type: text/plain; charset="UTF-8"

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@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
>

--000000000000143e1805c5f67393
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">I did a quick Google search, know exact match for that ti=
tle, but there are a couple of papers from Cary Millsap that are still avai=
lable... One is called &quot;why you should focus on LIOs instead of PIOs&q=
uot; and the other is &quot;Why a 99%+ buffer cache hit ratio is not ok&quo=
t;.=C2=A0 =C2=A0 These papers are a couple of decades old now, but the fund=
amental strategy around tuning SQL hasn&#39;t really changed much in that t=
ime...<div dir=3D"auto"><br></div><div dir=3D"auto">-Mark</div></div><br><d=
iv class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jun =
29, 2021, 20:18 Lucas Pimentel Lellis &lt;<a href=3D"mailto:lucaslellis@gma=
il.com">lucaslellis@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">Hi,<div><br></div><div>Does any=
body have the=C2=A0&quot;Are you still using cache hit ratios?&quot; paper =
that used to be on Hotsos&#39; website?</div><div><br clear=3D"all"><div><d=
iv dir=3D"ltr">Kind Regards,<br><br>Lucas Pimentel Lellis</div></div></div>=
</div></div>
</blockquote></div>

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