Close popover
Shiv Dutt (DUTTSH3775)
Charles Schwab

Charles Schwab
DUTTSH3775 Member since 2014 3 posts
Charles Schwab
Posted: January 16, 2018
Last activity: March 20, 2018

Oracle 12C - ‘optimizer_adaptive_features’ Question.

We have just upgraded our Development database to Orace 12c. We are experiencing some performance issues. Oracle 12c has a new feature/parameter ‘optimizer_adaptive_features’, if set to TRUE this an extension to dynamic sampling and can dynamically refresh statistics and alter execution plans during SQL execution. The idea of this is to have the optimizer always choosing the best plan. The default in Oracle 12c is TRUE. What is the recommendation from pega on the value of this Flag. Also have there been any issues using this flag to TRUE in high volume/high use applications.

Feedback would be highly appreciated

System Administration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.