Tuesday, October 20, 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.

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    What is a Database Administrator?

    The blog post explains what is the work of database administrator called DBA in database domain and what is the importance.

    Top Reasons to Implement Remote Database Monitoring

    The blog post explains top three reasons and ideas to get remote monitoring services from outer support company.

    Recent Comments