Re: Nested loop cost looks too high on 19c

From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Wed, 1 Jun 2022 08:09:19 +0100
Message-ID: <CAGtsp8nxzTHkD5xa=2fPL+WFr5O4rb5nz9RnPP7Maebx+O6GaA_at_mail.gmail.com>

Sorry,
I forget you'd already said granularity=>'PARTITION' Does that mean you have a procedure that populates a partition then gathers stats (with a trickle of change thereafter)?

Regards
Jonathan Lewis

On Tue, 31 May 2022 at 23:47, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> One other thing to check on gathering stats - what was the setting for the
> granularity paramter?
>
> Regards
> Jonathan Lewis
>
>
>

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

Received on Wed Jun 01 2022 - 09:09:19 CEST

This message: [ Message body ]
Next message: Stefan Koehler: "Re: Why ASMLib doesn't restart automatically on Oracle RAC 19c/12c after restarting Linux 7 server?"
Previous message: Quanwen Zhao: "Why ASMLib doesn't restart automatically on Oracle RAC 19c/12c after restarting Linux 7 server?"
In reply to Jonathan Lewis: "Re: Nested loop cost looks too high on 19c"
Next in thread: Pap: "Re: Nested loop cost looks too high on 19c"
Reply: Pap: "Re: Nested loop cost looks too high on 19c"
Reply: Pap: "Re: Nested loop cost looks too high on 19c"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message