Pavan DBA's Blog

The DBA Knowledge Store

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.


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: