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.
Pavan DBA's Blog 
Leave a Reply