Thank you Stefan and Jonathon!
Jay Miller
Sr. Oracle DBA
201.369.8355
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Stefan Koehler
Sent: Wednesday, September 25, 2019 1:48 AM
To: oracle-l@xxxxxxxxxxxxx
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: @OracleSK
dmarc-noreply@xxxxxxxxxxxxx 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=