Closed yahonda closed 1 year ago
This pull request removes OPTIMIZER_FEATURES_ENABLE('11.2.0.2') hint
OPTIMIZER_FEATURES_ENABLE('11.2.0.2')
This hint caused slowness #2179, and I decided to remove this hint.
There are no significant elapsed time changes with/without this hint in our CI:
With OPTIMIZER_FEATURES_ENABLE('11.2.0.2') hint
test that runs Oracle Database 23c XE https://github.com/rsim/oracle-enhanced/actions/runs/4963761266/jobs/8883291198?pr=2337
Finished in 5 minutes 43 seconds (files took 0.70408 seconds to load)
Finished in 17 minutes 39 seconds (files took 0.6625 seconds to load)
Without OPTIMIZER_FEATURES_ENABLE('11.2.0.2') hint
test that runs Oracle Database 23c XE https://github.com/rsim/oracle-enhanced/actions/runs/4963590072/jobs/8882971220?pr=2337
Finished in 5 minutes 45 seconds (files took 0.67993 seconds to load)
Finished in 17 minutes 43 seconds (files took 0.7018 seconds to load)
Fix #2179
This pull request removes
OPTIMIZER_FEATURES_ENABLE('11.2.0.2')
hintThis hint caused slowness #2179, and I decided to remove this hint.
There are no significant elapsed time changes with/without this hint in our CI:
With
OPTIMIZER_FEATURES_ENABLE('11.2.0.2')
hinttest that runs Oracle Database 23c XE https://github.com/rsim/oracle-enhanced/actions/runs/4963761266/jobs/8883291198?pr=2337
Without
OPTIMIZER_FEATURES_ENABLE('11.2.0.2')
hinttest that runs Oracle Database 23c XE https://github.com/rsim/oracle-enhanced/actions/runs/4963590072/jobs/8882971220?pr=2337
Fix #2179