Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disable optimizer_adaptive_features with 12.1.0.2 database version

SGUMay 23 2019 — edited May 27 2019

Hi experts,

We faced few performance issues and we have decided to disable the optimiser adaptive features

Database version 12.1.0.2

We have disabled it using alter system set optimiser_adaptive_features=false scope=both; but still we could see the plans using adaptive plans and adaptive statistics.

This is a result of execution plan from a query which ran after disabling optimiser_adaptive_features

Note

-----

- dynamic statistics used: dynamic sampling (level=2)

- this is an adaptive plan

- 3 Sql Plan Directives used for this statement

Please help out to disable these features

Thank you

Added on May 23 2019

#general-database-discussions

10 comments

11,319 views