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

O7_DICTIONARY_ACCESSIBILITY

This parameter prevents any schema to access SYS schema objects.

ASM_PREFERRED_READ_FAILURE_GROUPS

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.

PARALLEL_ADAPTIVE_MULTI_USER 

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.

UTL_FILE_DIR

Oracle recommends to use DIRECTORY feature instead of this parameter.

 

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: