12cR2 feature # 1 – deprecated parameters

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.