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.