Deprecated Initialization Parameter in Oracle 12c Release 2

March 21, 2019 | By

To understand changes and replacements in parameter settings, review the parameters are following.

O7_DICTIONARY_ACCESSIBILITY Initialization Parameter:

The formatting parameter O7_DICTIONARY_ACCESSIBILITY controls restrictions on SYSTEM privileges. If the parameter is about to TRUE, then access to things within the SYS schema is allowed. The default setting is fake. This default setting prevents system privileges that permit access to things in any schema from permitting access to things within the SYS schema. The O7_DICTIONARY_ACCESSIBILITY parameter is deprecated.


The ASM_PREFERRED_READ_FAILURE_GROUPS data formatting parameter is deprecated in Oracle Automatic Storage Management 12c unharness two ( beginning with Oracle Automatic Storage Management (Oracle ASM) 12c unharness two (, specifying the popular scan failure teams is finished mechanically, that the use of the ASM_PREFERRED_READ_FAILURE_GROUPS data formatting parameter isn’t any longer needed. Use PREFERRED_READ.ENABLED disk cluster attribute to manage the popular scan practicality.

PARALLEL_ADAPTIVE_MULTI_USER Initialization Parameter:

The format parameter PARALLEL_ADAPTIVE_MULTI_USER specifies if you would like to use AN adaptational rule to enhance performance in multi-user environments that use parallel execution. This parameter is deprecated, and also the default worth is currently FALSE. there’s no replacement for this parameter. Oracle recommends that you simply use the Oracle information feature Parallel Statement Queuing to get parallel execution performance gains.

UTL_FILE_DIR Initialization Parameter:

The format parameter UTL_FILE_DIR specifies accessible directories for PL/SQL file I/O. This parameter is deprecated, and Oracle recommends that you simply don’t offer UTL_FILE_DIR access. Oracle recommends that you simply instead use the directory object feature, that replaces UTL_FILE_DIR.

Above all parameters are deprecated in Oracle 12c rel 2 (12.2) version.

Tags: , , , ,

Category: oracle 12c dba, oracle 12c release 2, oracle parameters

Comments are closed.