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.
GLOBAL_CONTEXT_POOL_SIZE
This parameter used to allocate memory in SGA for storing and managing global application context
MAX_ENABLED_ROLES
It specifies max no of roles that can be enabled by a user
OPTIMIZER_ADAPTIVE_FEATURES
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
PARALLEL_AUTOMATIC_TUNING
It provides default value for controlling parallel processing
PARALLEL_IO_CAP_ENABLED
It is replaced with PARALLEL_DEGREE_LIMIT to spcify default degree of parallellism
PARALLEL_SERVER
It is to start database in parallel server mode. It is replaced by CLUSTER_DATABASE
PARALLEL_SERVER_INSTANCES
It specify no of instances configured in cluster database environment and is replaced by CLUSTER_DATABASE_INSTANCES
USE_INDIRECT_DATA_BUFFERS
The parameter was used to enable the Very Large Memory feature for 32-bit platforms. These platforms are no longer supported.
Pavan DBA's Blog 
Leave a Reply