Re: Stats gather taking longer -19c

I tried running the stats gathered manually on one of the lower -19C databases on a non partition table with sampe_size=>50 and with auto sample size. Its 10 minutes vs 2minutes run time .I tried capturing the underlying sqls that were running in parallel from the ASH. I added those in the location below. It seems, in the case of the 50% sample oracle is executing a lot many sql queries as compared to auto_sample_size.

https://gist.github.com/oracle9999/1aa06b032b871a276f88540e49fa0889

On Fri, Jun 24, 2022 at 3:36 PM Pap <oracle.developer35_at_gmail.com> wrote:

> I was trying to do that and compare the trace between 11.2 vs 19.11. but
> unfortunately all the lower environment are already moved to 19.11. So not
> able to perform that at current moment.
>
> On Fri, 24 Jun 2022, 3:32 pm Nenad Noveljic, <nenad.noveljic_at_gmail.com>
> wrote:
>
>> Hi Pap,
>>
>> You could trace the statistics job on 11.2 to answer your questions about
>> different behaviours in both Oracle releases.
>>
>> Best regards,
>> Nenad
>>
>>>

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