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.

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.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: