remote dba support
More
    HomeOracle DBA TipsDeprecated Initialization Parameter in Oracle 12c Release 2

    Deprecated Initialization Parameter in Oracle 12c Release 2

    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 TRUE, then access to things within the SYS schema is allowed.

    - Advertisement -
    dbametrix

    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.

    ASM_PREFERRED_READ_FAILURE_GROUPS Initialization Parameter:

    The ASM_PREFERRED_READ_FAILURE_GROUPS data formatting parameter is deprecated in Oracle Automatic Storage Management 12c unharness two (12.2.0.1). Beginning with Oracle Automatic Storage Management (Oracle ASM) 12c unharness two (12.2.0.1), 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 adaptation rule to enhance performance in multi-user environments that use parallel execution.

    - Advertisement -
    dbametrix

    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.

    When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.

    This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.

    - Advertisement -
    dbametrix
    - Advertisment -
    remote dba services

    Most Popular