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