RE: Suggestions for updating Jonathon Lewis' upper bound stat adjustment script for 12c?

Thank you Stefan and Jonathon!

Jay Miller
Sr. Oracle DBA
201.369.8355

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stefan Koehler Sent: Wednesday, September 25, 2019 1:48 AM To: oracle-l_at_freelists.org
Subject: Re: Suggestions for updating Jonathon Lewis' upper bound stat adjustment script for 12c?

Hello Jay,
just for completeness - you can control it with DBMS_STATS and option ENABLE_HYBRID_HISTOGRAMS, e.g. described here: https://urldefense.proofpoint.com/v2/url?u=https-3A__antognini.ch_2015_01_restrict-2Dthe-2Dquery-2Doptimizer-2Dthrough-2Doptimizer-5Ffeatures-5Fenable-2Dand-2Dtop-2Dfrequency-2Dhybrid-2Dhistograms_&d=DwICaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=zloGd1bgbSmoM_CVT8Fflz8jJqNiXRUbGFoEukbL65Y&s=L-OX4DQGyyAydAoiAWwUVXZgVlPOqicbSGAHwialp6M&e=

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de&d=DwICaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=zloGd1bgbSmoM_CVT8Fflz8jJqNiXRUbGFoEukbL65Y&s=uivHvkcyeeoXAMfgkK_Ht5G6G9Elt73hfNRst0lGr3s&e= 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
>
> --
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwICaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=zloGd1bgbSmoM_CVT8Fflz8jJqNiXRUbGFoEukbL65Y&s=e5k8uzY7jI65VBufjTvvU7Mp1Uc6aI89bFEc3dkzVGM&e=
--
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwICaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=zloGd1bgbSmoM_CVT8Fflz8jJqNiXRUbGFoEukbL65Y&s=e5k8uzY7jI65VBufjTvvU7Mp1Uc6aI89bFEc3dkzVGM&e=

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Wed Sep 25 2019 - 15:59:05 CEST