Re: Suggestions for updating Jonathon Lewis' upper bound stat adjustment script for 12c?
From: Stefan Koehler <contact_at_soocs.de>
Date: Wed, 25 Sep 2019 07:48:19 +0200 (CEST)
Message-ID: <1231269355.264477.1569390499858_at_ox.hosteurope.de>
Date: Wed, 25 Sep 2019 07:48:19 +0200 (CEST)
Message-ID: <1231269355.264477.1569390499858_at_ox.hosteurope.de>
Hello Jay,
just for completeness - you can control it with DBMS_STATS and option ENABLE_HYBRID_HISTOGRAMS, e.g. described here: https://antognini.ch/2015/01/restrict-the-query-optimizer-through-optimizer_features_enable-and-top-frequency-hybrid-histograms/
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: _at_OracleSK
> dmarc-noreply_at_freelists.org hat am 24. September 2019 um 22:38 geschrieben:
>
> Or alternatively is there a way to force the autostats gathering to not create hybrid histograms for this table or database?
>
> TIA,
> Jay Miller
>
> --
> http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 25 2019 - 07:48:19 CEST