Pavan DBA's Blog

The DBA Knowledge Store

«
»

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.

SQL92_SECURITY Default is TRUE

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

This entry was posted on December 12, 2016 at 11:37 AM and is filed under 12cR2 New features. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Facebook photo

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

Cancel

Connecting to %s

«
»
 
%d bloggers like this: