MIME-Version: 1.0
References: <DM6PR11MB34831A86630FF3F2F247F070F4BC9@DM6PR11MB3483.namprd11.prod.outlook.com>
 <CAGtsp8=uWbyjyA9tS7jno9F1e8hOMO+S3Rp82FxbaGvzWZgY_Q@mail.gmail.com>
 <DB7PR10MB209040C214FB69FB0BD548D085BA9@DB7PR10MB2090.EURPRD10.PROD.OUTLOOK.COM>
 <CAORjz=PO_mAt+M3=P41HsLSZmN5N7nDURuBZ8_cufNCFe1mWLg@mail.gmail.com>
 <SA2PR10MB456903641FFA617B07DACFE4A3B69@SA2PR10MB4569.namprd10.prod.outlook.com>
 <cd686c7d-1d6b-bc99-a9d8-134bd97e9301@gmail.com>
In-Reply-To: <cd686c7d-1d6b-bc99-a9d8-134bd97e9301@gmail.com>
From: Jonathan Lewis <jlewisoracle@gmail.com>
Date: Tue, 2 Feb 2021 15:30:46 +0000
Message-ID: <CAGtsp8n8ae+GcynQZ=EjA9ThLvgEVFFWgSm9Q4gvhK0CpNqksA@mail.gmail.com>
Subject: Re: [External] : Re: Question on gathering System Statistics
To: Oracle L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="00000000000043a38805ba5c281b"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: jlewisoracle@gmail.com
--00000000000043a38805ba5c281b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Here's Nigel Bayliss' relatively recent blog note about it.
https://blogs.oracle.com/optimizer/should-you-gather-system-statistics

I can't find the one that Maria wrote in a similar vein.


Regards
Jonathan Lewis


On Tue, 2 Feb 2021 at 06:58, Mladen Gogala <gogala.mladen@gmail.com> wrote:

> Any explanation? This looks a bit counter-intuitive to me. Would it be
> possible to persuade to come here and explain the recommendation?
>
> Regards
> On 2/1/21 12:09 PM, Jeff Smith wrote:
>
> Maria confirms
>
> =E2=80=9CThat is correct. Its best not to gather system stats=E2=80=9D
>
>
>
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><div><br></div><div>Here&#39;s Nigel Bayl=
iss&#39; relatively recent blog note about it.</div><div><a href=3D"https:/=
/blogs.oracle.com/optimizer/should-you-gather-system-statistics">https://bl=
ogs.oracle.com/optimizer/should-you-gather-system-statistics</a></div><div>=
<br></div><div>I can&#39;t find the one that Maria wrote in a similar vein.=
</div><div><br></div><div><br></div><div>Regards</div><div>Jonathan Lewis</=
div><div><br></div><div><br></div><div><br></div><div><br></div></div><br><=
div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, 2 F=
eb 2021 at 06:58, Mladen Gogala &lt;<a href=3D"mailto:gogala.mladen@gmail.c=
om">gogala.mladen@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex">
 =20
   =20
 =20
  <div>
    <p>Any explanation? This looks a bit counter-intuitive to me. Would
      it be possible to persuade to come here and explain the
      recommendation?</p>
    <p>Regards<br>
    </p>
    <div>On 2/1/21 12:09 PM, Jeff Smith wrote:<br>
    </div>
    <blockquote type=3D"cite">
      <p class=3D"MsoNormal" style=3D"background:rgb(248,248,248) none repe=
at scroll 0% 0%"><span style=3D"color:black">Maria confirms<br>
          <br>
          =E2=80=9C</span><span style=3D"font-size:11.5pt;font-family:&quot=
;Arial&quot;,sans-serif;color:rgb(29,28,29)">That
          is correct. Its best not to gather system stats=E2=80=9D<u></u><u=
></u></span></p>
      <p class=3D"MsoNormal">=C2=A0</p></blockquote><br></div>

</blockquote></div></div>

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