Question

6
Replies
116
Views
DUTTSH3775 Member since 2014 3 posts
Charles Schwab
Posted: January 16, 2018
Last activity: March 20, 2018
Closed

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
Share this page LinkedIn