Return-Path: <oracle-l-bounce@freelists.org>
X-Original-To: oracle-l@orafaq.com
Delivered-To: oracle-l@orafaq.com
Received: from smtp-aa.freelists.org (smtp-aa.freelists.org [23.23.80.81])
 by malta2546.startdedicated.com (Postfix) with ESMTPS id 5C3D41002E56AA
 for <oracle-l@orafaq.com>; Tue,  2 Feb 2021 16:20:03 +0100 (CET)
Received: from turing.freelists.org (ip-10-0-0-164.ec2.internal [10.0.0.164])
 (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (2048 bits))
 (No client certificate requested)
 by smtp-aa.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id C9CE04560F;
 Tue,  2 Feb 2021 15:20:01 +0000 (UTC)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Postfix) with ESMTP id C11FA3F85E;
 Tue,  2 Feb 2021 15:20:01 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org;
 s=turing; t=1612279201;
 bh=S/lw+IUCkPGYBUvdq/1yY/iM0BaU1at7CSEUXp7G+T8=;
 h=From:Sender:Sender:From;
 b=C5EK1MdAO4g70AQPXAkF+0qN6+tlCogbkE6yWMxEf3k1cPzn1juudniDr0H3KoFvU
	 san2F57ASX60QK9+DuBfrxQHp1hk02OKjOJGqQMkh2RLA+Wr3l1c+zSNSEqp0i3IJS
	 D84wI69PCal368OrAF4xzGqMVUmL6AbxjKR8kbr0=
X-Virus-Scanned: by FreeLists at turing2.freelists.org
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id HyWfGqy-fVQE; Tue,  2 Feb 2021 15:20:01 +0000 (UTC)
Received: from turing.freelists.org (localhost [127.0.0.1])
 by turing.freelists.org (Postfix) with ESMTP id A483B3F96E;
 Tue,  2 Feb 2021 15:19:59 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org;
 s=turing; t=1612279200;
 bh=S/lw+IUCkPGYBUvdq/1yY/iM0BaU1at7CSEUXp7G+T8=;
 h=From:Sender:Sender:From;
 b=RTEYFTYIRSCDD7uIq0Rgu7f06KO1pBqSmXvI98K3vJPi/j77KuV83XecRXwgvZ5Wo
	 F+rQBHoiVE37XlWmYP5blTq2Jbz3Sp7ww4RZNQpczdr9GjAfr/Q7yk0i4FP6mUP9+b
	 7M1osnsqX5jj08c3FAt+lmZgf4ysS7mVsukbR6SE=
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 02 Feb 2021 15:19:58 +0000 (UTC)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Postfix) with ESMTP id 7C36F3F85E
 for <oracle-l@freelists.org>; Tue,  2 Feb 2021 15:19:58 +0000 (UTC)
Authentication-Results: turing.freelists.org;
 dkim=pass (2048-bit key; unprotected) header.d=gmail.com header.i=@gmail.com header.a=rsa-sha256 header.s=20161025 header.b=XTigSyZJ;
 dkim-atps=neutral
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id uUtfxIEOgZx9 for <oracle-l@freelists.org>;
 Tue,  2 Feb 2021 15:19:58 +0000 (UTC)
Received: from mail-qk1-f177.google.com (mail-qk1-f177.google.com [209.85.222.177])
 (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits)
	 key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256)
 (No client certificate requested)
 by turing.freelists.org (Postfix) with ESMTPS id 6BB313F844
 for <oracle-l@freelists.org>; Tue,  2 Feb 2021 15:19:58 +0000 (UTC)
Received: by mail-qk1-f177.google.com with SMTP id a19so20133248qka.2
        for <oracle-l@freelists.org>; Tue, 02 Feb 2021 07:19:58 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:subject:to:references:from:message-id:date
         :user-agent:mime-version:in-reply-to:content-language;
        bh=9UW//5QqDAq/utAPZYcfzz6qjvHvYxCyO6asR/QKt0U=;
        b=la31jKTGICg2l7+L4b6icpFyULEa2GW+ddn+2TXS8klA4Kux5vYU+a6Tu7yISJdNtu
         3sxm5auGVvO+mJ8QMELnywUAhfKEgNtcrfBIA1GVJm1z6H35TywiQwJVZHETq08YlIbN
         zwBwiZTanotvbLwYU+79ypJlwafQSMWrRY9nWtI5LD0U/2I4cokjOpf6wXLwHPcfBpZO
         lK0+jhmzVBA1NCTwxTCwMDXqdsqjagb+h520+hRqwaDF0vHNr4kHZoqhuiyqYVyNbmFJ
         Ut5U8NO3VLjkxdSqDQx35lovVuvERBA8gnIkreRDXy1SE253nPjUMAKDFMA0j31KWF1J
         KuHQ==
X-Gm-Message-State: AOAM530Mmoc3xp1+MrOj8cf5V2zs5ihkoxjrPb2gaCwawkClO2vpXJdG
 mO1ZUTj3uyBtHfB69GsUEn+QvYyYDII/0A==
X-Google-Smtp-Source: ABdhPJxnVX/wpU6nKm7OcjXWcxMBwsZmbSHUzL+o5XqFPml79t0E2MHxp0kzeCpkoBS3s6JPWmMz3g==
X-Received: by 2002:a05:620a:41:: with SMTP id t1mr6946749qkt.322.1612279196997;
        Tue, 02 Feb 2021 07:19:56 -0800 (PST)
Received: from [192.168.2.100] (pool-100-8-54-81.nwrknj.fios.verizon.net. [100.8.54.81])
        by smtp.gmail.com with ESMTPSA id b16sm15735138qtx.85.2021.02.02.07.19.56
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Tue, 02 Feb 2021 07:19:56 -0800 (PST)
Subject: Re: [External] : Re: Question on gathering System Statistics
To: "Mark W. Farnham" <mwf@rsiz.com>, oracle-l@freelists.org
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>
 <2de601d6f96e$f9eac600$edc05200$@rsiz.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
Message-ID: <44c224a2-d297-2207-a36e-71e172c15b2a@gmail.com>
Date: Tue, 2 Feb 2021 10:19:55 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.7.0
MIME-Version: 1.0
In-Reply-To: <2de601d6f96e$f9eac600$edc05200$@rsiz.com>
Content-Type: multipart/alternative;
 boundary="------------E06DDE730CB84B480746164F"
Content-Language: en-US
X-archive-position: 78827
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: gogala.mladen@gmail.com
Precedence: normal
Reply-To: gogala.mladen@gmail.com
List-Help: <mailto:ecartis@freelists.org?Subject=help>
List-Unsubscribe: <mailto:oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-Subscribe: <mailto:oracle-l-request@freelists.org?Subject=subscribe>
List-Owner: <mailto:>
List-post: <mailto:oracle-l@freelists.org>
List-Archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
--------------E06DDE730CB84B480746164F
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

I have emailed her and am awaiting her reply. She's quite busy, so it 
will probably be a while. However, she's a very nice person and I'm 
quite sure that she'll reply when she has some time.

On 2/2/21 9:23 AM, Mark W. Farnham wrote:
> BUT having seen a wide range of the result of the currently actually 
> implemented CBO versus queries with canned defaults versus locally 
> collected statistics I’d go with Maria.

-- 
Mladen Gogala
Database Consultant
https://dbwhisperer.wordpress.com


--------------E06DDE730CB84B480746164F
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>I have emailed her and am awaiting her reply. She's quite busy,
      so it will probably be a while. However, she's a very nice person
      and I'm quite sure that she'll reply when she has some time.<br>
    </p>
    <div class="moz-cite-prefix">On 2/2/21 9:23 AM, Mark W. Farnham
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:2de601d6f96e$f9eac600$edc05200$@rsiz.com"><span
style="font-size:14.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D">BUT
        having seen a wide range of the result of the currently actually
        implemented CBO versus queries with canned defaults versus
        locally collected statistics I’d go with Maria.</span></blockquote>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a></pre>
  </body>
</html>

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


