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.

Posted in 12cR2 New features | Leave a Comment »

12cR2 feature # 1 – deprecated parameters

Posted by Pavan DBA on December 8, 2016

Hey friends, as many of you already know that Oracle database 12c Release 2 documentation is officially available now in Oracle site. Thought of sharing some new features through some posts.

When software is available, I will share the practical demos on these new features.

12cR2 feature # 1 –

Following init parameters are deprecated


This parameter prevents any schema to access SYS schema objects.


In 12cR2 ASM, specifying the preferred read failure groups is done automatically. We need to use the PREFERRED_READ.ENABLED disk group attribute to control the preferred read functionality.


This specifies the use of adaptive algorithm to improve performance in multi-user environments that use parallel execution. We need to use Database feature parallel statement queuing instead of this parameter.


Oracle recommends to use DIRECTORY feature instead of this parameter.


Posted in 12cR2 New features | Tagged: , , , , | Leave a Comment »

TechMaster – New SQL Server DBA online batch

Posted by Pavan DBA on December 6, 2016

Attend demo tomorrow ie 7th Dec 2016 at 6 AM IST using below link directly

Posted in Training | Leave a Comment »

TechMaster announcing Business Intelligence (Qlikview) online training

Posted by Pavan DBA on November 23, 2016

TechMaster announcing Business Intelligence (Qlikview) online training by Mahesh
New batch: 28th Nov 2016 at 7:30 AM IST
Mode: Online training
Duration: 20 – 25 days
Frequency: 5 days a week
Timings: 7:30 AM – 9:30 AM IST
Fee: 15000 INR
Demo date : 26th Nov 2016 at 7:30 AM IST
Please register for demo using below link
After registering you will receive a confirmation email containing information about joining the demo.
For more details:-
Email to:
Call or Whatsapp to: +91 9676516545

Posted in Training | Leave a Comment »

TechMaster – New batch for Oracle 12c DBA training

Posted by Pavan DBA on November 10, 2016

DBA classes starting from Monday ie 14th Nov.

Duration: 35 days
Frequency: 5 days a week (excluding weekend)

Contact or call/whatsapp to +919676516545 for demo video and registration process.


Posted in Training | Leave a Comment »

%d bloggers like this: