Thursday, August 13, 2020
dbametrix
More
    Home Oracle DBA Tips Deprecated 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:

    - Advertisement -
    dbametrix

    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.

    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:

    - Advertisement -
    dbametrix

    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.

    1+
    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    nosql Security Vulnerabilities

    Article explain in detail of NoSQL database security challenges and how to find out Vulnerabilities.

    SQL vs noSQL Which is better

    Blog post explains basic differences of sql and nosql and when it is better to use nosql for getting best performance and security.

    Performance of noSQL Database

    The article shows reasons of performance of nosql downgrading or not.

    What is Computer security

    The article explains about what are the kinds of computer security vulnerability and how to protect and find out most common vulnerabilities risks.

    Recent Comments

    Gordon Coleclough on Oracle Tuning Basics Part-1
    Gordon Coleclough on ASM Disk creation issue