Pavan DBA's Blog

The DBA Knowledge Store

12cR2 feature #2 – desupported parameters

Posted by Pavan DBA on December 9, 2016

In this post we will see what are all the parameters that are desupported since 12cR2.


This parameter used to allocate memory in SGA for storing and managing global application context


It specifies max no of roles that can be enabled by a user


This has been split into two new parameters.

OPTIMIZER_ADAPTIVE_PLANS=TRUE which determines alternative execution plans
OPTIMIZER_ADAPTIVE_STATISTICS=FALSE which determines alternative plan directives


It provides default value for controlling parallel processing


It is replaced with PARALLEL_DEGREE_LIMIT to spcify default degree of parallellism


It is to start database in parallel server mode. It is replaced by CLUSTER_DATABASE


It specify no of instances configured in cluster database environment and is replaced by CLUSTER_DATABASE_INSTANCES


The parameter was used to enable the Very Large Memory feature for 32-bit platforms. These platforms are no longer supported.

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 )

Facebook photo

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

Connecting to %s

%d bloggers like this: