Pavan DBA's Blog

The DBA Knowledge Store

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 4,846 other followers

  • Follow Pavan DBA's Blog on
  • Visitor Count

  • Categories

  • Vote your opinion…

  • Advertisements

12cR2 feature # 3 – parameters default value change

Posted by Pavan DBA on December 12, 2016

Some parameters default value has been changed in 12cR2 as follows

OPTIMIZER_ADAPTIVE_PLANS controls adaptive plans. It is now set by default to FALSE. Adaptive plans is the alternative execution plans which will be decided during query executions.

OPTIMIZER_ADAPTIVE_STATISTICS controls adaptive statistics. It is set by default to FALSE.


If a user want to perform DELETE or UPDATE on an object, it should have SELECT privilege as mandatory from now onwards.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: