• EBS initialization parameters


    APPLIES TO:

    Oracle EBS Applications Performance - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
    Oracle Shipping Execution - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
    Information in this document applies to any platform.
    EBS 11i and R12


    PURPOSE



    Refer to:
    - Multi-Lingual Support (MLS) in the current MOS Environment (Document 1480131.1)

    Lists EBS initialization parameters side by side to those from official notes 216205.1 and 396009.1

    REQUIREMENTS

    • Use only on EBS applications (a.k.a. Oracle Applications or APPS)
    • Connect as APPS

    CONFIGURING

    • Download from this note and execute connected as APPS
    • This bde_chk_cbo.sql script is also included within SQLT (SQLTXPLAIN) when SQLT is used on an APPS instance.

    INSTRUCTIONS

    • Connect into sqlplus as APPS
    • START bde_chk_cbo.sql

    CAUTION

    This sample code is provided for educational purposes only, and is not supported by Oracle Support. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

    SCRIPT

    See attachments.

    SAMPLE OUTPUT

    See attachments.

    REFERENCES

    NOTE:216205.1 - Database Initialization Parameters for Oracle Applications Release 11i

    NOTE:396009.1 - Database Initialization Parameters for Oracle E-Business Suite Release 12


    附:

    SPOOL bde_chk_cbo.log;
    SET ECHO ON TERM OFF;
    REM
    REM $Header: 174605.1 bde_chk_cbo.sql 12.1.04 2013/11/11 csierra $
    REM
    REM Copyright (c) 2000-2012, Oracle Corporation. All rights reserved.
    REM
    REM AUTHOR
    REM   carlos.sierra@oracle.com
    REM
    REM NAME
    REM   bde_chk_cbo.sql
    REM
    REM DESCRIPTION
    REM   Lists EBS initialization parameters side by side to
    REM   those from official notes 216205.1 and 396009.1
    REM
    REM PRE-REQUISITES
    REM   1. Only used by EBS (Oracle Applications - APPS).
    REM   2. Execute connecting as APPS.
    REM
    REM PARAMETERS
    REM   None.
    REM
    REM EXAMPLE
    REM   #sqlplus apps
    REM   SQL> START bde_chk_cbo.sql;
    REM
    REM UPDATES
    REM   dchbane  2013/11/11  Added parameters for 12cR1
    REM
    
    SET FEED OFF VER OFF HEA OFF LIN 2000 PAGES 0 TRIMS ON;
    
    VAR v_cpu_count     VARCHAR2(10);
    VAR v_database      VARCHAR2(32);
    VAR v_host          VARCHAR2(64);
    VAR v_instance      VARCHAR2(32);
    VAR v_platform      VARCHAR2(80);
    VAR v_rdbms_release VARCHAR2(17);
    VAR v_rdbms_version VARCHAR2(17);
    VAR v_apps_release  VARCHAR2(50);
    VAR v_sysdate       VARCHAR2(15);
    VAR v_user          VARCHAR2(30);
    
    COL p_cpu_count     NEW_V p_cpu_count     FOR A10;
    COL p_database      NEW_V p_database      FOR A32;
    COL p_host          NEW_V p_host          FOR A64;
    COL p_instance      NEW_V p_instance      FOR A32;
    COL p_platform      NEW_V p_platform      FOR A80;
    COL p_rdbms_release NEW_V p_rdbms_release FOR A17;
    COL p_rdbms_version NEW_V p_rdbms_version FOR A10;
    COL p_apps_release  NEW_V p_apps_release  FOR A50;
    COL p_sysdate       NEW_V p_sysdate       FOR A15;
    COL p_user          NEW_V p_user          FOR A30;
    
    /******************************************************************************/
    
    EXEC :v_cpu_count     := 'Unknown';
    EXEC :v_database      := 'Unknown';
    EXEC :v_host          := 'Unknown';
    EXEC :v_instance      := 'Unknown';
    EXEC :v_platform      := 'Unknown';
    EXEC :v_rdbms_release := 'Unknown';
    EXEC :v_rdbms_version := 'Unknown';
    EXEC :v_apps_release  := 'Unknown';
    EXEC :v_sysdate       := TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI');
    EXEC :v_user          := USER;
    
    BEGIN
        SELECT i.host_name,
               i.version,
               SUBSTR(UPPER(i.instance_name)||'('||TO_CHAR(i.instance_number)||')', 1, 40)
          INTO :v_host, :v_rdbms_release, :v_instance
          FROM v$instance i;
    END;
    /
    
    -- If you need to execute in preparation for an upgrade, just uncomment one of the 5 commands below:
    --EXEC :v_rdbms_release := '8.1.7.X';
    --EXEC :v_rdbms_release := '9.2.0.X';
    --EXEC :v_rdbms_release := '10.1.X';
    --EXEC :v_rdbms_release := '10.2.X';
    --EXEC :v_rdbms_release := '11.1.X';
    --EXEC :v_rdbms_release := '11.2.X';
    --EXEC :v_rdbms_release := '12.1.X';
    
    BEGIN
        :v_rdbms_version := :v_rdbms_release;
        IF :v_rdbms_release LIKE '12.1.%' THEN :v_rdbms_version := '12.1.X'; END IF;
        IF :v_rdbms_release LIKE '11.2.%' THEN :v_rdbms_version := '11.2.X'; END IF;
        IF :v_rdbms_release LIKE '11.1.%' THEN :v_rdbms_version := '11.1.X'; END IF;
        IF :v_rdbms_release LIKE '10.2.%' THEN :v_rdbms_version := '10.2.X'; END IF;
        IF :v_rdbms_release LIKE '10.1.%' THEN :v_rdbms_version := '10.1.X'; END IF;
        IF :v_rdbms_release LIKE '9.2.0.%' THEN :v_rdbms_version := '9.2.0.X'; END IF;
        IF :v_rdbms_release LIKE '8.1.7.%' THEN :v_rdbms_version := '8.1.7.X'; END IF;
    END;
    /
    
    BEGIN
        SELECT db.name||'('||TO_CHAR(db.dbid)||')'
          INTO :v_database
          FROM v$database db;
    END;
    /
    
    BEGIN
        SELECT SUBSTR(value, 1, 10)
          INTO :v_cpu_count
          FROM v$parameter
         WHERE name = 'cpu_count';
    END;
    /
    
    BEGIN
        SELECT SUBSTR(REPLACE(REPLACE(pcv1.product, 'TNS for '), ':' )||pcv2.status, 1, 80)
          INTO :v_platform
          FROM product_component_version pcv1,
               product_component_version pcv2
         WHERE UPPER(pcv1.product) LIKE '%TNS%'
           AND UPPER(pcv2.product) LIKE '%ORACLE%'
           AND ROWNUM = 1;
    END;
    /
    
    BEGIN
        SELECT release_name
          INTO :v_apps_release
          FROM applsys.fnd_product_groups;
    END;
    /
    
    SELECT :v_cpu_count     p_cpu_count,
           :v_database      p_database,
           :v_host          p_host,
           :v_instance      p_instance,
           :v_platform      p_platform,
           :v_rdbms_release p_rdbms_release,
           :v_rdbms_version p_rdbms_version,
           :v_sysdate       p_sysdate,
           :v_apps_release  p_apps_release,
           :v_user          p_user
      FROM DUAL;
    
    DROP TABLE chk$cbo$parameter_apps;
    CREATE TABLE chk$cbo$parameter_apps (
      release                    VARCHAR2(64) NOT NULL,
      version                    VARCHAR2(32) NOT NULL,
      id                         INTEGER NOT NULL,
      name                       VARCHAR2(128) NOT NULL,
      set_flag                   CHAR(1) NOT NULL,
      mp_flag                    CHAR(1) NOT NULL,
      sz_flag                    CHAR(1) NOT NULL,
      cbo_flag                   CHAR(1) NOT NULL,
      value                      VARCHAR2(512)
    );
    
    CREATE OR REPLACE PROCEDURE chk$ebs$parameters (
      p_rdbms_version IN VARCHAR2,
      p_apps_release  IN VARCHAR2 )
    IS
      my_sequence INTEGER := 0;
    
      PROCEDURE ins (
        p_version  IN VARCHAR2,
        p_name     IN VARCHAR2,
        p_set_flag IN VARCHAR2,
        p_mp_flag  IN VARCHAR2,
        p_sz_flag  IN VARCHAR2,
        p_cbo_flag IN VARCHAR2,
        p_value    IN VARCHAR2 )
      IS
        my_count INTEGER;
      BEGIN
        IF p_version <> 'COMMON' AND p_version <> p_rdbms_version THEN
          RETURN;
        END IF;
    
        SELECT COUNT(*)
          INTO my_count
          FROM chk$cbo$parameter_apps
         WHERE name = p_name;
    
        my_sequence := my_sequence + 1;
    
        IF my_count = 0 THEN
          INSERT INTO chk$cbo$parameter_apps VALUES (
            p_apps_release,
            p_version,
            my_sequence,
            p_name,
            p_set_flag,
            p_mp_flag,
            p_sz_flag,
            p_cbo_flag,
            p_value );
        ELSE
          UPDATE chk$cbo$parameter_apps SET
            release  = p_apps_release,
            version  = p_version,
            id       = my_sequence,
            set_flag = p_set_flag,
            mp_flag  = p_mp_flag,
            sz_flag  = p_sz_flag,
            cbo_flag = p_cbo_flag,
            value    = p_value
          WHERE name = p_name;
        END IF;
      END ins;
    
    BEGIN
      IF NVL(p_rdbms_version, 'Unknown') = 'Unknown' OR NVL(p_apps_release, 'Unknown') = 'Unknown' THEN
        RETURN;
      END IF;
    
      IF p_apps_release LIKE '11%' THEN
        /*  version    name                               set  mp   sz   cbo  value                               */
        /*  ========== =============================      ===  ===  ===  ===  =================================== */
        ins('COMMON',  'db_name',                         'Y', 'N', 'N', 'N', 'prod11i');
        ins('COMMON',  'control_files',                   'Y', 'N', 'N', 'N', 'three copies of control file');
        ins('COMMON',  'db_block_size',                   'Y', 'Y', 'N', 'N', '8192');
        ins('COMMON',  '_system_trig_enabled',            'Y', 'Y', 'N', 'N', 'TRUE');
        IF p_apps_release IN ('11.5.1', '11.5.2', '11.5.3', '11.5.4', '11.5.5', '11.5.6', '11.5.7', '11.5.8', '11.5.9') THEN
          ins('COMMON',  'o7_dictionary_accessibility',   'Y', 'Y', 'N', 'N', 'TRUE');
        ELSE
          ins('COMMON',  'o7_dictionary_accessibility',   'Y', 'Y', 'N', 'N', 'FALSE');
        END IF;
        ins('COMMON',  'nls_language',                    'Y', 'N', 'N', 'N', 'AMERICAN');
        ins('COMMON',  'nls_territory',                   'Y', 'N', 'N', 'N', 'AMERICA');
        ins('COMMON',  'nls_date_format',                 'Y', 'Y', 'N', 'N', 'DD-MON-RR');
        ins('COMMON',  'nls_numeric_characters',          'Y', 'N', 'N', 'N', '".,"');
        ins('COMMON',  'nls_sort',                        'Y', 'Y', 'N', 'N', 'BINARY');
        ins('COMMON',  'nls_comp',                        'Y', 'Y', 'N', 'N', 'BINARY');
        ins('COMMON',  'audit_trail',                     'Y', 'N', 'N', 'N', 'TRUE (optional)');
        ins('COMMON',  'max_enabled_roles',               'Y', 'Y', 'N', 'N', '100');
        ins('COMMON',  'user_dump_dest',                  'Y', 'N', 'N', 'N', '?/prod11i/udump');
        ins('COMMON',  'background_dump_dest',            'Y', 'N', 'N', 'N', '?/prod11i/bdump');
        ins('COMMON',  'core_dump_dest',                  'Y', 'N', 'N', 'N', '?/prod11i/cdump');
        ins('COMMON',  'max_dump_file_size',              'Y', 'N', 'N', 'N', '20480');
        ins('COMMON',  'timed_statistics',                'Y', 'N', 'N', 'N', 'TRUE');
        ins('COMMON',  '_trace_files_public',             'Y', 'N', 'N', 'N', 'TRUE');
        ins('COMMON',  'sql_trace',                       'Y', 'N', 'N', 'N', 'FALSE');
        ins('COMMON',  'processes',                       'Y', 'N', 'Y', 'N', '200-2500');
        ins('COMMON',  'sessions',                        'Y', 'N', 'Y', 'N', '400-5000');
        ins('COMMON',  'db_files',                        'Y', 'N', 'N', 'N', '512');
        ins('COMMON',  'dml_locks',                       'Y', 'N', 'N', 'N', '10000');
        ins('COMMON',  'enqueue_resources',               'Y', 'N', 'N', 'N', '32000');
        ins('COMMON',  'cursor_sharing',                  'Y', 'Y', 'N', 'Y', 'EXACT');
        ins('COMMON',  'open_cursors',                    'Y', 'N', 'N', 'N', '600');
        ins('COMMON',  'session_cached_cursors',          'Y', 'N', 'N', 'N', '200');
        ins('COMMON',  'db_block_buffers',                'Y', 'N', 'Y', 'N', '20000-400000');
        ins('COMMON',  'db_block_checking',               'Y', 'N', 'N', 'N', 'FALSE');
        ins('COMMON',  'db_block_checksum',               'Y', 'N', 'N', 'N', 'TRUE');
        ins('COMMON',  'log_checkpoint_timeout',          'Y', 'N', 'N', 'N', '1200');
        ins('COMMON',  'log_checkpoint_interval',         'Y', 'N', 'N', 'N', '100000');
        ins('COMMON',  'log_buffer',                      'Y', 'N', 'N', 'N', '10485760');
        ins('COMMON',  'log_checkpoints_to_alert',        'Y', 'N', 'N', 'N', 'TRUE');
        ins('COMMON',  'shared_pool_size',                'Y', 'N', 'Y', 'N', '400-3000M');
        ins('COMMON',  'shared_pool_reserved_size',       'Y', 'N', 'Y', 'N', '40-300M');
        ins('COMMON',  '_shared_pool_reserved_min_alloc', 'Y', 'N', 'N', 'N', '4100');
        ins('COMMON',  'cursor_space_for_time',           'Y', 'N', 'N', 'N', 'FALSE (default)');
        ins('COMMON',  'java_pool_size',                  'Y', 'N', 'N', 'N', '50M');
        ins('COMMON',  'utl_file_dir',                    'Y', 'N', 'N', 'N', '?/prod11i/utl_file_dir');
        ins('COMMON',  'aq_tm_processes',                 'Y', 'N', 'N', 'N', '1');
        ins('COMMON',  'job_queue_processes',             'Y', 'N', 'N', 'N', '2');
        ins('COMMON',  'log_archive_start',               'Y', 'N', 'N', 'N', 'TRUE (optional)');
        ins('COMMON',  'parallel_max_servers',            'Y', 'N', 'N', 'N', '8 (up to 2*CPUs)');
        ins('COMMON',  'parallel_min_servers',            'Y', 'N', 'N', 'N', '0');
        ins('COMMON',  'db_file_multiblock_read_count',   'Y', 'Y', 'N', 'Y', '8');
        ins('COMMON',  'optimizer_max_permutations',      'Y', 'Y', 'N', 'Y', '2000');
        ins('COMMON',  'query_rewrite_enabled',           'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('COMMON',  '_sort_elimination_cost_ratio',    'Y', 'Y', 'N', 'Y', '5');
        ins('COMMON',  '_like_with_bind_as_equality',     'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('COMMON',  '_fast_full_scan_enabled',         'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('COMMON',  '_sqlexec_progression_cost',       'Y', 'Y', 'N', 'Y', '2147483647');
        ins('COMMON',  'max_commit_propagation_delay',    'Y', 'Y', 'N', 'N', '0 (if using RAC)');
        ins('COMMON',  'cluster_database',                'Y', 'Y', 'N', 'N', 'TRUE (if using RAC)');
        ins('COMMON',  'instance_groups',                 'Y', 'N', 'N', 'N', 'appsN (N is inst_id if using RAC)');
        ins('COMMON',  'parallel_instance_group',         'Y', 'N', 'N', 'N', 'appsN (N is inst_id if using RAC)');
        /* Release-specific database initialization parameters for 8iR3 (8.1.7.X) */
        ins('8.1.7.X', 'compatible',                      'Y', 'Y', 'N', 'N', '8.1.7');
        ins('8.1.7.X', 'rollback_segments',               'Y', 'N', 'N', 'N', '(rbs1,rbs2,rbs3,rbs4,rbs5,rbs6)');
        ins('8.1.7.X', 'sort_area_size',                  'Y', 'N', 'N', 'Y', '1048576');
        ins('8.1.7.X', 'hash_area_size',                  'Y', 'N', 'N', 'Y', '2097152');
        ins('8.1.7.X', 'job_queue_interval',              'Y', 'N', 'N', 'N', '90');
        ins('8.1.7.X', 'optimizer_features_enable',       'Y', 'Y', 'N', 'Y', '8.1.7');
        ins('8.1.7.X', '_optimizer_undo_changes',         'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('8.1.7.X', '_optimizer_mode_force',           'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('8.1.7.X', '_complex_view_merging',           'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('8.1.7.X', '_push_join_predicate',            'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('8.1.7.X', '_use_column_stats_for_function',  'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('8.1.7.X', '_or_expand_nvl_predicate',        'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('8.1.7.X', '_push_join_union_view',           'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('8.1.7.X', '_table_scan_cost_plus_one',       'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('8.1.7.X', '_ordered_nested_loop',            'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('8.1.7.X', '_new_initial_join_orders',        'Y', 'Y', 'N', 'Y', 'TRUE');
        /* Removal list for 8iR3 (8.1.7.X) */
        ins('8.1.7.X', '_b_tree_bitmap_plans',            'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', 'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', 'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', 'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('8.1.7.X', 'event="10929 trace name context forever"',          'N', 'N', 'N', 'N', NULL);
        ins('8.1.7.X', 'event="10932 trace name context level 2"',          'N', 'N', 'N', 'N', NULL);
        ins('8.1.7.X', 'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', 'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', 'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('8.1.7.X', 'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        /* Release-specific database initialization parameters for 9iR2 (9.2.0.X) */
        ins('9.2.0.X', 'compatible',                      'Y', 'Y', 'N', 'N', '9.2.0');
        ins('9.2.0.X', 'db_cache_size',                   'Y', 'N', 'Y', 'N', '156M-3G');
        ins('9.2.0.X', 'nls_length_semantics',            'Y', 'Y', 'N', 'N', 'BYTE');
        ins('9.2.0.X', 'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('9.2.0.X', 'undo_retention',                  'Y', 'N', 'Y', 'N', '1800-14400');
        ins('9.2.0.X', 'undo_suppress_errors',            'Y', 'Y', 'N', 'N', 'FALSE');
        ins('9.2.0.X', 'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('9.2.0.X', 'pga_aggregate_target',            'Y', 'N', 'Y', 'Y', '1-20G');
        ins('9.2.0.X', 'workarea_size_policy',            'Y', 'Y', 'N', 'Y', 'AUTO');
        ins('9.2.0.X', 'olap_page_pool_size',             'Y', 'N', 'N', 'N', '4194304');
        IF p_apps_release IN ('11.5.5', '11.5.6', '11.5.7') THEN
          /* These events should only be used if you are using Oracle Applications release 11.5.7 or prior*/
          ins('9.2.0.X', 'event="10932 trace name context level 32768"', 'Y', 'N', 'N', 'N', NULL);
          ins('9.2.0.X', 'event="10933 trace name context level 512"',   'Y', 'N', 'N', 'N', NULL);
          ins('9.2.0.X', 'event="10943 trace name context level 16384"', 'Y', 'N', 'N', 'N', NULL);
        END IF;
        ins('9.2.0.X', 'optimizer_features_enable',       'Y', 'Y', 'N', 'Y', '9.2.0');
        ins('9.2.0.X', '_index_join_enabled',             'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('9.2.0.X', '_b_tree_bitmap_plans',            'Y', 'Y', 'N', 'Y', 'FALSE');
        /* Removal list for 9iR2 (9.2.0.X) */
        ins('9.2.0.X', 'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', 'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', 'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('9.2.0.X', 'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('9.2.0.X', 'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('9.2.0.X', 'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('9.2.0.X', 'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', 'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', 'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', 'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', 'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('9.2.0.X', 'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        IF p_apps_release NOT IN ('11.5.1', '11.5.2', '11.5.3', '11.5.4', '11.5.5', '11.5.6', '11.5.7') THEN
        /* Remove the following events only if you are using Oracle Applications release 11.5.8 or later. */
          ins('9.2.0.X', 'event="10932 trace name context level 32768"', 'N', 'N', 'N', 'N', NULL);
          ins('9.2.0.X', 'event="10933 trace name context level 512"',   'N', 'N', 'N', 'N', NULL);
          ins('9.2.0.X', 'event="10943 trace name context level 16384"', 'N', 'N', 'N', 'N', NULL);
        END IF;
        /* Release-specific database initialization parameters for 10gR1 (10.1.X) */
        ins('10.1.X',  'compatible',                      'Y', 'Y', 'N', 'N', '10.1.0');
        ins('10.1.X',  'sga_target',                      'Y', 'N', 'Y', 'N', '1-14G');
        ins('10.1.X',  'shared_pool_size',                'Y', 'N', 'Y', 'N', '400-3000M');
        ins('10.1.X',  'shared_pool_reserved_size',       'Y', 'N', 'Y', 'N', '40-300M');
        ins('10.1.X',  'nls_length_semantics',            'Y', 'Y', 'N', 'N', 'BYTE');
        ins('10.1.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('10.1.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('10.1.X',  'pga_aggregate_target',            'Y', 'N', 'Y', 'Y', '1-20G');
        ins('10.1.X',  'workarea_size_policy',            'Y', 'Y', 'N', 'Y', 'AUTO');
        ins('10.1.X',  'olap_page_pool_size',             'Y', 'N', 'N', 'N', '4194304');
        ins('10.1.X',  'open_cursors',                    'Y', 'N', 'N', 'N', '600');
        ins('10.1.X',  'session_cached_cursors',          'Y', 'N', 'N', 'N', '500');
        ins('10.1.X',  'plsql_optimize_level',            'Y', 'Y', 'N', 'N', '2');
        ins('10.1.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'INTERPRETED');
        ins('10.1.X',  'plsql_native_library_dir',        'Y', 'N', 'N', 'N', '?/prod11i/plsql_nativelib (if using NATIVE PL/SQL)');
        ins('10.1.X',  'plsql_native_library_subdir_count', 'Y', 'N', 'N', 'N', '149 (if using NATIVE PL/SQL)');
        ins('10.1.X',  '_b_tree_bitmap_plans',            'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('10.1.X',  'aq_tm_processes',                 'Y', 'N', 'N', 'N', '1');
        /* Removal list for 10gR1 (10.1.X) */
        ins('10.1.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('10.1.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('10.1.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        /* Release-specific database initialization parameters for 10gR2 (10.2.X) */
        ins('10.2.X',  'compatible',                      'Y', 'Y', 'N', 'N', '10.2.0');
        ins('10.2.X',  'sga_target',                      'Y', 'N', 'Y', 'N', '1-14G');
        ins('10.2.X',  'shared_pool_size',                'Y', 'N', 'Y', 'N', '400-3000M');
        ins('10.2.X',  'shared_pool_reserved_size',       'Y', 'N', 'Y', 'N', '40-300M');
        ins('10.2.X',  'nls_length_semantics',            'Y', 'Y', 'N', 'N', 'BYTE');
        ins('10.2.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('10.2.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('10.2.X',  'pga_aggregate_target',            'Y', 'N', 'Y', 'Y', '1-20G');
        ins('10.2.X',  'workarea_size_policy',            'Y', 'Y', 'N', 'Y', 'AUTO');
        ins('10.2.X',  'olap_page_pool_size',             'Y', 'N', 'N', 'N', '4194304');
        ins('10.2.X',  'open_cursors',                    'Y', 'N', 'N', 'N', '600');
        ins('10.2.X',  'session_cached_cursors',          'Y', 'N', 'N', 'N', '500');
        ins('10.2.X',  'plsql_optimize_level',            'Y', 'Y', 'N', 'N', '2');
        ins('10.2.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'INTERPRETED');
        ins('10.2.X',  'plsql_native_library_dir',        'Y', 'N', 'N', 'N', '?/prod11i/plsql_nativelib (if using NATIVE PL/SQL)');
        ins('10.2.X',  'plsql_native_library_subdir_count', 'Y', 'N', 'N', 'N', '149 (if using NATIVE PL/SQL)');
        ins('10.2.X',  '_b_tree_bitmap_plans',            'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('10.2.X',  'optimizer_secure_view_merging',   'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('10.2.X',  '_kks_use_mutex_pin',              'Y', 'N', 'N', 'N', 'FALSE (only HP-UX PA-RISC)');
        ins('10.2.X',  'aq_tm_processes',                 'Y', 'N', 'N', 'N', '1');
        /* Removal list for 10gR2 (10.2.X) */
        ins('10.2.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_kks_use_mutex_pin',              'N', 'N', 'N', 'N', 'Unless using HP-UX PA-RISC');
        ins('10.2.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'db_file_multiblock_read_count',   'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'enqueue_resources',               'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'undo_retention',                  'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        /* Release-specific database initialization parameters for 11gR1 (11.1.X) */
        ins('11.1.X',  'compatible',                      'Y', 'Y', 'N', 'N', '11.1.0');
        ins('11.1.X',  'diagnostic_dest',                 'Y', 'N', 'N', 'N', '?/prod11i');
        ins('11.1.X',  'sga_target',                      'Y', 'N', 'Y', 'N', '1-14G');
        ins('11.1.X',  'shared_pool_size',                'Y', 'N', 'Y', 'N', '400-3000M');
        ins('11.1.X',  'shared_pool_reserved_size',       'Y', 'N', 'Y', 'N', '40-300M');
        ins('11.1.X',  'nls_length_semantics',            'Y', 'Y', 'N', 'N', 'BYTE');
        ins('11.1.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('11.1.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('11.1.X',  'pga_aggregate_target',            'Y', 'N', 'Y', 'Y', '1-20G');
        ins('11.1.X',  'workarea_size_policy',            'Y', 'Y', 'N', 'Y', 'AUTO');
        ins('11.1.X',  'olap_page_pool_size',             'Y', 'N', 'N', 'N', '4194304');
        ins('11.1.X',  'open_cursors',                    'Y', 'N', 'N', 'N', '600');
        ins('11.1.X',  'session_cached_cursors',          'Y', 'N', 'N', 'N', '500');
        ins('11.1.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'NATIVE (if you want to use NATIVE compilation)');
        ins('11.1.X',  '_b_tree_bitmap_plans',            'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('11.1.X',  'optimizer_secure_view_merging',   'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('11.1.X',  '_optimizer_autostats_job',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('11.1.X',  'sec_case_sensitive_logon',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('11.1.X',  'aq_tm_processes',                 'Y', 'N', 'N', 'N', '1');
        /* Removal list for 11gR1 (11.1.X) */
        ins('11.1.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_kks_use_mutex_pin',              'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_sqlexec_progression_cost',       'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'background_dump_dest',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'core_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'db_file_multiblock_read_count',   'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'enqueue_resources',               'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'nls_language',                    'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'plsql_optimize_level',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'plsql_native_library_dir',        'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'plsql_native_library_subdir_count', 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'rollback_segments',               'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'sql_trace',                       'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'timed_statistics',                'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'undo_retention',                  'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'user_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        /* Release-specific database initialization parameters for 11gR2 (11.2.X) */
        ins('11.2.X',  'compatible',                      'Y', 'Y', 'N', 'N', '11.2.0');
        ins('11.2.X',  'diagnostic_dest',                 'Y', 'N', 'N', 'N', '?/prod11i');
        ins('11.2.X',  'sga_target',                      'Y', 'N', 'Y', 'N', '1-14G');
        ins('11.2.X',  'shared_pool_size',                'Y', 'N', 'Y', 'N', '400-3000M');
        ins('11.2.X',  'shared_pool_reserved_size',       'Y', 'N', 'Y', 'N', '40-300M');
        ins('11.2.X',  'nls_length_semantics',            'Y', 'Y', 'N', 'N', 'BYTE');
        ins('11.2.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('11.2.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('11.2.X',  'pga_aggregate_target',            'Y', 'N', 'Y', 'Y', '1-20G');
        ins('11.2.X',  'workarea_size_policy',            'Y', 'Y', 'N', 'Y', 'AUTO');
        ins('11.2.X',  'olap_page_pool_size',             'Y', 'N', 'N', 'N', '4194304');
        ins('11.2.X',  'open_cursors',                    'Y', 'N', 'N', 'N', '600');
        ins('11.2.X',  'session_cached_cursors',          'Y', 'N', 'N', 'N', '500');
        ins('11.2.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'NATIVE (if you want to use NATIVE compilation)');
        ins('11.2.X',  '_b_tree_bitmap_plans',            'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('11.2.X',  'optimizer_secure_view_merging',   'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('11.2.X',  '_optimizer_autostats_job',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('11.2.X',  'sec_case_sensitive_logon',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('11.2.X',  'aq_tm_processes',                 'Y', 'N', 'N', 'N', '1');
        /* Removal list for 11gR2 (11.2.X) */
        ins('11.2.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_kks_use_mutex_pin',              'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_sqlexec_progression_cost',       'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'background_dump_dest',            'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'core_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'db_file_multiblock_read_count',   'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'enqueue_resources',               'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'nls_language',                    'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'plsql_optimize_level',            'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'plsql_native_library_dir',        'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'plsql_native_library_subdir_count', 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'rollback_segments',               'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'sql_trace',                       'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'timed_statistics',                'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'undo_retention',                  'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'user_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'drs_start',                       'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'sql_version',                     'N', 'N', 'N', 'N', NULL);
        
        /* Release-specific database initialization parameters for 12cR1 (12.1.X) */
        ins('12.1.X',  'compatible',                      'Y', 'Y', 'N', 'N', '12.1.0'); -- changed in 12cR1
        ins('12.1.X',  'diagnostic_dest',                 'Y', 'N', 'N', 'N', '?/prod11i');
        ins('12.1.X',  'sga_target',                      'Y', 'N', 'Y', 'N', '1-14G');
        ins('12.1.X',  'shared_pool_size',                'Y', 'N', 'Y', 'N', '400-3000M');
        ins('12.1.X',  'shared_pool_reserved_size',       'Y', 'N', 'Y', 'N', '40-300M');
        ins('12.1.X',  'nls_length_semantics',            'Y', 'Y', 'N', 'N', 'BYTE');
        ins('12.1.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('12.1.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('12.1.X',  'pga_aggregate_target',            'Y', 'N', 'Y', 'Y', '1-20G');
        ins('12.1.X',  'workarea_size_policy',            'Y', 'Y', 'N', 'Y', 'AUTO');
        ins('12.1.X',  'olap_page_pool_size',             'Y', 'N', 'N', 'N', '4194304');
        ins('12.1.X',  'open_cursors',                    'Y', 'N', 'N', 'N', '600');
        ins('12.1.X',  'session_cached_cursors',          'Y', 'N', 'N', 'N', '500');
        ins('12.1.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'NATIVE (if you want to use NATIVE compilation)');
        ins('12.1.X',  '_b_tree_bitmap_plans',            'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('12.1.X',  'optimizer_secure_view_merging',   'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('12.1.X',  '_optimizer_autostats_job',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('12.1.X',  'parallel_force_local',            'Y', 'Y', 'N', 'Y', 'TRUE');  -- new in 12cR1
        ins('12.1.X',  'pga_aggregate_limit',             'Y', 'N', 'Y', 'Y', '0');     -- new in 12cR1
        ins('12.1.X',  'temp_undo_enabled',               'Y', 'N', 'N', 'Y', 'TRUE');  -- new in 12cR1
        ins('12.1.X',  'sec_case_sensitive_logon',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('12.1.X',  'aq_tm_processes',                 'Y', 'N', 'N', 'N', '1');
        /* Removal list for 12cR1 (12.1.X) */
        ins('12.1.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_kks_use_mutex_pin',              'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_sqlexec_progression_cost',       'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'background_dump_dest',            'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'core_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'db_file_multiblock_read_count',   'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'enqueue_resources',               'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'nls_language',                    'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'plsql_optimize_level',            'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'plsql_native_library_dir',        'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'plsql_native_library_subdir_count', 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'rollback_segments',               'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'sql_trace',                       'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'timed_statistics',                'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'undo_retention',                  'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'user_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'drs_start',                       'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'sql_version',                     'N', 'N', 'N', 'N', NULL);
        
      ELSIF p_apps_release LIKE '12%' THEN
        /*  version    name                               set  mp   sz   cbo  value                               */
        /*  ========== =============================      ===  ===  ===  ===  =================================== */
        ins('COMMON',  'db_name',                         'Y', 'N', 'N', 'N', 'prodr12');
        ins('COMMON',  'control_files',                   'Y', 'N', 'N', 'N', 'three copies of control file');
        ins('COMMON',  'db_block_size',                   'Y', 'Y', 'N', 'N', '8192');
        ins('COMMON',  '_system_trig_enabled',            'Y', 'Y', 'N', 'N', 'TRUE');
        ins('COMMON',  'o7_dictionary_accessibility',     'Y', 'Y', 'N', 'N', 'FALSE');
        ins('COMMON',  'nls_language',                    'Y', 'N', 'N', 'N', 'AMERICAN');
        ins('COMMON',  'nls_territory',                   'Y', 'N', 'N', 'N', 'AMERICA');
        ins('COMMON',  'nls_date_format',                 'Y', 'Y', 'N', 'N', 'DD-MON-RR');
        ins('COMMON',  'nls_numeric_characters',          'Y', 'N', 'N', 'N', '".,"');
        ins('COMMON',  'nls_sort',                        'Y', 'Y', 'N', 'N', 'BINARY');
        ins('COMMON',  'nls_comp',                        'Y', 'Y', 'N', 'N', 'BINARY');
        ins('COMMON',  'nls_length_semantics',            'Y', 'Y', 'N', 'N', 'BYTE');
        ins('COMMON',  'audit_trail',                     'Y', 'N', 'N', 'N', 'TRUE (optional)');
        ins('COMMON',  'user_dump_dest',                  'Y', 'N', 'N', 'N', '/ebiz/prodr12/udump');
        ins('COMMON',  'background_dump_dest',            'Y', 'N', 'N', 'N', '/ebiz/prodr12/bdump');
        ins('COMMON',  'core_dump_dest',                  'Y', 'N', 'N', 'N', '/ebiz/prodr12/cdump');
        ins('COMMON',  'max_dump_file_size',              'Y', 'N', 'N', 'N', '20480');
        ins('COMMON',  '_trace_files_public',             'Y', 'N', 'N', 'N', 'TRUE');
        ins('COMMON',  'processes',                       'Y', 'N', 'Y', 'N', '200-2500');
        ins('COMMON',  'sessions',                        'Y', 'N', 'Y', 'N', '400-5000');
        ins('COMMON',  'db_files',                        'Y', 'N', 'N', 'N', '512');
        ins('COMMON',  'dml_locks',                       'Y', 'N', 'N', 'N', '10000');
        ins('COMMON',  'cursor_sharing',                  'Y', 'Y', 'N', 'Y', 'EXACT');
        ins('COMMON',  'open_cursors',                    'Y', 'N', 'N', 'N', '600');
        ins('COMMON',  'session_cached_cursors',          'Y', 'N', 'N', 'N', '500');
        ins('COMMON',  'sga_target',                      'Y', 'N', 'Y', 'N', '2-14G');
        ins('COMMON',  'db_block_checking',               'Y', 'N', 'N', 'N', 'FALSE');
        ins('COMMON',  'db_block_checksum',               'Y', 'N', 'N', 'N', 'TRUE');
        ins('COMMON',  'log_checkpoint_timeout',          'Y', 'N', 'N', 'N', '1200');
        ins('COMMON',  'log_checkpoint_interval',         'Y', 'N', 'N', 'N', '100000');
        ins('COMMON',  'log_buffer',                      'Y', 'N', 'N', 'N', '10485760');
        ins('COMMON',  'log_checkpoints_to_alert',        'Y', 'N', 'N', 'N', 'TRUE');
        ins('COMMON',  'shared_pool_size',                'Y', 'N', 'Y', 'N', '600-3000M');
        ins('COMMON',  'shared_pool_reserved_size',       'Y', 'N', 'Y', 'N', '60-300M');
        ins('COMMON',  '_shared_pool_reserved_min_alloc', 'Y', 'N', 'N', 'N', '4100');
        ins('COMMON',  'cursor_space_for_time',           'Y', 'N', 'N', 'N', 'FALSE (default)');
        ins('COMMON',  'utl_file_dir',                    'Y', 'N', 'N', 'N', '/ebiz/prodr12/utl_file_dir');
        ins('COMMON',  'aq_tm_processes',                 'Y', 'N', 'N', 'N', '1');
        ins('COMMON',  'job_queue_processes',             'Y', 'N', 'N', 'N', '2');
        ins('COMMON',  'log_archive_start',               'Y', 'N', 'N', 'N', 'TRUE (optional)');
        ins('COMMON',  'parallel_max_servers',            'Y', 'N', 'N', 'N', '8 (up to 2*CPUs)');
        ins('COMMON',  'parallel_min_servers',            'Y', 'N', 'N', 'N', '0');
        ins('COMMON',  '_sort_elimination_cost_ratio',    'Y', 'Y', 'N', 'Y', '5');
        ins('COMMON',  '_like_with_bind_as_equality',     'Y', 'Y', 'N', 'Y', 'TRUE');
        ins('COMMON',  '_fast_full_scan_enabled',         'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('COMMON',  '_b_tree_bitmap_plans',            'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('COMMON',  'optimizer_secure_view_merging',   'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('COMMON',  '_sqlexec_progression_cost',       'Y', 'Y', 'N', 'Y', '2147483647');
        ins('COMMON',  'cluster_database',                'Y', 'Y', 'N', 'N', 'TRUE (if using RAC)');
        ins('COMMON',  'instance_groups',                 'Y', 'N', 'N', 'N', 'appsN (N is inst_id if using RAC)');
        ins('COMMON',  'parallel_instance_group',         'Y', 'N', 'N', 'N', 'appsN (N is inst_id if using RAC)');
        ins('COMMON',  'pga_aggregate_target',            'Y', 'N', 'Y', 'Y', '1-20G');
        ins('COMMON',  'workarea_size_policy',            'Y', 'Y', 'N', 'Y', 'AUTO');
        ins('COMMON',  'olap_page_pool_size',             'Y', 'N', 'N', 'N', '4194304');
        /* Release-specific database initialization parameters for 10gR2 (10.2.X) */
        ins('10.2.X',  'compatible',                      'Y', 'Y', 'N', 'N', '10.2.0');
        ins('10.2.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('10.2.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('10.2.X',  'plsql_optimize_level',            'Y', 'Y', 'N', 'N', '2');
        ins('10.2.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'NATIVE');
        ins('10.2.X',  'plsql_native_library_dir',        'Y', 'N', 'N', 'N', '/ebiz/prodr12/plsql_nativelib');
        ins('10.2.X',  'plsql_native_library_subdir_count', 'Y', 'N', 'N', 'N', '149');
        ins('10.2.X', '_kks_use_mutex_pin',               'Y', 'N', 'N', 'N', 'TRUE (FALSE only on HP-UX PA-RISC)');
        /* Removal list for 10gR2 (10.2.X) */
        ins('10.2.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'db_file_multiblock_read_count',   'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'enqueue_resources',               'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('10.2.X',  'undo_retention',                  'N', 'N', 'N', 'N', NULL);
        ins('10.2.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        /* Release-specific database initialization parameters for 11gR1 (11.1.X) */
        ins('11.1.X',  'compatible',                      'Y', 'Y', 'N', 'N', '11.1.0');
        ins('11.1.X',  'diagnostic_dest',                 'Y', 'N', 'N', 'N', '?/prod12');
        ins('11.1.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('11.1.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('11.1.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'NATIVE');
        ins('11.1.X',  '_optimizer_autostats_job',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('11.1.X',  'sec_case_sensitive_logon',        'Y', 'Y', 'N', 'N', 'FALSE');
        /* Removal list for 11gR1 (11.1.X) */
        ins('11.1.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_kks_use_mutex_pin',              'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_sqlexec_progression_cost',       'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'background_dump_dest',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'core_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'db_file_multiblock_read_count',   'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'enqueue_resources',               'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'nls_language',                    'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'plsql_optimize_level',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'plsql_native_library_dir',        'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'plsql_native_library_subdir_count', 'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'plsql_optimize_level',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'rollback_segments',               'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.1.X',  'sql_trace',                       'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'timed_statistics',                'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'undo_retention',                  'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        ins('11.1.X',  'user_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        /* Release-specific database initialization parameters for 11gR2 (11.2.X) */
        ins('11.2.X',  'compatible',                      'Y', 'Y', 'N', 'N', '11.2.0');
        ins('11.2.X',  'diagnostic_dest',                 'Y', 'N', 'N', 'N', '?/prod12');
        ins('11.2.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('11.2.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('11.2.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'NATIVE');
        ins('11.2.X',  '_optimizer_autostats_job',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('11.2.X',  'sec_case_sensitive_logon',        'Y', 'Y', 'N', 'N', 'FALSE');
        /* Removal list for 11gR1 (11.2.X) */
        ins('11.2.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_kks_use_mutex_pin',              'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_sqlexec_progression_cost',       'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'background_dump_dest',            'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'core_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'db_file_multiblock_read_count',   'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'drs_start',                       'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'enqueue_resources',               'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'nls_language',                    'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'parallel_force_local',            'Y', 'Y', 'N', 'Y', 'TRUE (if using RAC)');
        ins('11.2.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'plsql_native_library_dir',        'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'plsql_native_library_subdir_count', 'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'plsql_optimize_level',            'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'rollback_segments',               'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('11.2.X',  'sql_trace',                       'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'sql_version',                     'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'timed_statistics',                'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'undo_retention',                  'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        ins('11.2.X',  'user_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        
        /* Release-specific database initialization parameters for 12cR1 (12.1.X) */
        ins('12.1.X',  'compatible',                      'Y', 'Y', 'N', 'N', '12.1.0'); -- changed in 12cR1
        ins('12.1.X',  'diagnostic_dest',                 'Y', 'N', 'N', 'N', '?/prod11i');
        ins('12.1.X',  'sga_target',                      'Y', 'N', 'Y', 'N', '1-14G');
        ins('12.1.X',  'shared_pool_size',                'Y', 'N', 'Y', 'N', '400-3000M');
        ins('12.1.X',  'shared_pool_reserved_size',       'Y', 'N', 'Y', 'N', '40-300M');
        ins('12.1.X',  'nls_length_semantics',            'Y', 'Y', 'N', 'N', 'BYTE');
        ins('12.1.X',  'undo_management',                 'Y', 'Y', 'N', 'N', 'AUTO');
        ins('12.1.X',  'undo_tablespace',                 'Y', 'Y', 'N', 'N', 'APPS_UNDOTS1');
        ins('12.1.X',  'pga_aggregate_target',            'Y', 'N', 'Y', 'Y', '1-20G');
        ins('12.1.X',  'workarea_size_policy',            'Y', 'Y', 'N', 'Y', 'AUTO');
        ins('12.1.X',  'olap_page_pool_size',             'Y', 'N', 'N', 'N', '4194304');
        ins('12.1.X',  'open_cursors',                    'Y', 'N', 'N', 'N', '600');
        ins('12.1.X',  'session_cached_cursors',          'Y', 'N', 'N', 'N', '500');
        ins('12.1.X',  'plsql_code_type',                 'Y', 'N', 'N', 'N', 'NATIVE (if you want to use NATIVE compilation)');
        ins('12.1.X',  '_b_tree_bitmap_plans',            'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('12.1.X',  'optimizer_secure_view_merging',   'Y', 'Y', 'N', 'Y', 'FALSE');
        ins('12.1.X',  '_optimizer_autostats_job',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('12.1.X',  'parallel_force_local',            'Y', 'Y', 'N', 'Y', 'TRUE');  -- new in 12cR1
        ins('12.1.X',  'pga_aggregate_limit',             'Y', 'N', 'Y', 'Y', '0');     -- new in 12cR1
        ins('12.1.X',  'temp_undo_enabled',               'Y', 'N', 'N', 'Y', 'TRUE');  -- new in 12cR1
        ins('12.1.X',  'sec_case_sensitive_logon',        'Y', 'Y', 'N', 'N', 'FALSE');
        ins('12.1.X',  'aq_tm_processes',                 'Y', 'N', 'N', 'N', '1');
        /* Removal list for 12cR1 (12.1.X) */
        ins('12.1.X',  '_always_anti_join',               'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_always_semi_join',               'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_complex_view_merging',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_index_join_enabled',             'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_kks_use_mutex_pin',              'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  '_new_initial_join_orders',        'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_optimizer_cost_based_transformation', 'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_optimizer_cost_model',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_optimizer_mode_force',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_optimizer_undo_changes',         'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_or_expand_nvl_predicate',        'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_ordered_nested_loop',            'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_push_join_predicate',            'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_push_join_union_view',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_shared_pool_reserved_min_alloc', 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  '_sortmerge_inequality_join_off',  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_sqlexec_progression_cost',       'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_table_scan_cost_plus_one',       'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_unnest_subquery',                'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  '_use_column_stats_for_function',  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'always_anti_join',                'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'always_semi_join',                'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'background_dump_dest',            'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'core_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'db_block_buffers',                'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'db_file_multiblock_read_count',   'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'db_cache_size',                   'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'enqueue_resources',               'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="10932 trace name context level 32768"',      'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="10933 trace name context level 512"',        'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="10943 trace name context forever, level 2"', 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="10943 trace name context level 16384"',      'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'event="38004 trace name context forever, level 1"', 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'hash_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'java_pool_size',                  'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'job_queue_interval',              'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'large_pool_size',                 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'max_enabled_roles',               'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'nls_language',                    'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'optimizer_dynamic_sampling',      'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_features_enable',       'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_index_caching',         'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_index_cost_adj',        'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_max_permutations',      'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_mode',                  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'optimizer_percent_parallel',      'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'plsql_optimize_level',            'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'plsql_compiler_flags',            'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'plsql_native_library_dir',        'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'plsql_native_library_subdir_count', 'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'query_rewrite_enabled',           'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'rollback_segments',               'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'row_locking',                     'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'sort_area_size',                  'N', 'N', 'N', 'Y', NULL);
        ins('12.1.X',  'sql_trace',                       'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'timed_statistics',                'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'undo_retention',                  'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'undo_suppress_errors',            'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'user_dump_dest',                  'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'drs_start',                       'N', 'N', 'N', 'N', NULL);
        ins('12.1.X',  'sql_version',                     'N', 'N', 'N', 'N', NULL);
          
      END IF;
    
      COMMIT;
    END chk$ebs$parameters;
    /
    SHOW ERRORS;
    
    TRUNCATE TABLE chk$cbo$parameter_apps;
    EXEC chk$ebs$parameters(:v_rdbms_version, :v_apps_release);
    DROP PROCEDURE chk$ebs$parameters;
    
    /******************************************************************************/
    
    SET ECHO OFF;
    SPO bde_chk_cbo_report.html;
    PRO <html>
    PRO <!-- $Header: 174605.1 bde_chk_cbo.sql 12.1.04 2013/11/11 csierra $ -->
    PRO <!-- Copyright (c) 2000-2012, Oracle Corporation. All rights reserved. -->
    PRO <!-- AUTHOR: carlos.sierra@oracle.com -->
    PRO <head>
    PRO <title>bde_chk_cbo_report.html</title>
    PRO <style type="text/css">
    PRO body {font:8pt Arial,Helvetica,Verdana,Geneva,sans-serif; color:black; background:white;}
    PRO a {font-weight:bold; color:#663300;}
    PRO h1 {font-size:16pt; font-weight:bold; color:#336699;}
    PRO h2 {font-size:14pt; font-weight:bold; color:#336699;}
    PRO h3 {font-size:12pt; font-weight:bold; color:#336699;}
    PRO table {font-size:8pt; color:black; background:white;}
    PRO th {font-weight:bold; background:#cccc99; color:#336699; vertical-align:bottom; padding-left:3pt; padding-right:3pt; padding-top:1pt; padding-bottom:1pt;}
    PRO td {background:#fcfcf0; vertical-align:top; padding-left:3pt; padding-right:3pt; padding-top:1pt; padding-bottom:1pt;}
    PRO td.left {text-align:left;} /* left */
    PRO td.right {text-align:right;} /* right */
    PRO td.center {text-align:center;} /* center */
    PRO td.title {font-weight:bold; color:#336699; background:#cccc99; text-align:right;} /* right title */
    PRO font.footer {font-size:8pt; font-weight:italic; color:#999999;} /* footnote in gray */
    PRO </style>
    PRO </head>
    PRO <body>
    PRO <h1>174605.1 bde_chk_cbo 12.1.04</h1>
    PRO <h3>Identification</h3>
    PRO <table>
    PRO <tr><td class="title">Date:</td><td class="left">&&p_sysdate</td></tr>
    PRO <tr><td class="title">Host:</td><td class="left">&&p_host</td></tr>
    PRO <tr><td class="title">Platform:</td><td class="left">&&p_platform</td></tr>
    PRO <tr><td class="title">Database:</td><td class="left">&&p_database</td></tr>
    PRO <tr><td class="title">Instance:</td><td class="left">&&p_instance</td></tr>
    PRO <tr><td class="title">RDBMS Release:</td><td class="left">&&p_rdbms_release(&&p_rdbms_version)</td></tr>
    PRO <tr><td class="title">User:</td><td class="left">&&p_user</td></tr>
    PRO <tr><td class="title">APPS Release:</td><td class="left">&&p_apps_release</td></tr>
    PRO <tr><td class="title">CPU Count:</td><td class="left">&&p_cpu_count</td></tr>
    PRO </table>
    
    /******************************************************************************/
    
    PRO <h3>Common database initialization parameters</h3>
    PRO <table>
    PRO <tr>
    PRO <th>Parameter</th>
    PRO <th>Current Value</th>
    PRO <th>Required Value</th>
    PRO <th>CBO</th>
    PRO <th>MP</th>
    PRO <th>SZ</th>
    PRO </tr>
    SELECT
    '<tr>'||
    '<td class="left">'||b.name||'</td>'||
    '<td class="left">'||DECODE(v.name, NULL, '<i>(NOT FOUND)</i>', v.value||DECODE(v.isdefault, 'TRUE', ' <i>(NOT SET)</i>'))||'</td>'||
    '<td class="left">'||DECODE(b.set_flag, 'N', '<i>DO NOT SET</i>', b.value)||'</td>'||
    '<td class="center">'||DECODE(b.cbo_flag, 'Y', 'Y')||'</td>'||
    '<td class="center">'||DECODE(b.mp_flag, 'Y', 'Y')||'</td>'||
    '<td class="center">'||DECODE(b.sz_flag, 'Y', 'Y')||'</td>'||
    '</tr>' line
    FROM chk$cbo$parameter_apps b, v$parameter2 v
    WHERE b.release = :v_apps_release
    AND b.version = 'COMMON'
    AND b.name = LOWER(v.name(+))
    ORDER BY b.id, v.value;
    PRO </table>
    PRO CBO: Cost-based Optimizer Parameter.<br>
    PRO MP: Mandatory Parameter and Value<br>
    PRO SZ: For recommended values according to particular environment size, refer to Notes 216205.1 and 396009.1<br>
    
    /******************************************************************************/
    
    PRO <h3>Release-specific database initialization parameters for &&p_rdbms_version</h3>
    PRO <table>
    PRO <tr>
    PRO <th>Parameter</th>
    PRO <th>Current Value</th>
    PRO <th>Required Value</th>
    PRO <th>CBO</th>
    PRO <th>MP</th>
    PRO <th>SZ</th>
    PRO </tr>
    SELECT
    '<tr>'||
    '<td class="left">'||b.name||'</td>'||
    '<td class="left">'||DECODE(v.name, NULL, '<i>(NOT FOUND)</i>', v.value||DECODE(v.isdefault, 'TRUE', ' <i>(NOT SET)</i>'))||'</td>'||
    '<td class="left">'||b.value||'</td>'||
    '<td class="center">'||DECODE(b.cbo_flag, 'Y', 'Y')||'</td>'||
    '<td class="center">'||DECODE(b.mp_flag, 'Y', 'Y')||'</td>'||
    '<td class="center">'||DECODE(b.sz_flag, 'Y', 'Y')||'</td>'||
    '</tr>' line
    FROM chk$cbo$parameter_apps b, v$parameter2 v
    WHERE b.release = :v_apps_release
    AND b.version = :v_rdbms_version
    AND b.name = LOWER(v.name(+))
    AND b.set_flag = 'Y'
    ORDER BY b.id, v.value;
    PRO </table>
    PRO CBO: Cost-based Optimizer Parameter.<br>
    PRO MP: Mandatory Parameter and Value<br>
    PRO SZ: For recommended values according to particular environment size, refer to Notes 216205.1 and 396009.1<br>
    
    /******************************************************************************/
    
    PRO <h3>Removal list for &&p_rdbms_version</h3>
    PRO <table>
    PRO <tr>
    PRO <th>Parameter</th>
    PRO <th>Current Value</th>
    PRO <th>CBO</th>
    PRO </tr>
    SELECT
    '<tr>'||
    '<td class="left">'||b.name||'</td>'||
    --'<td class="left">'||NVL(DECODE(v.isdefault, 'TRUE', '<!--(NOT SET)-->', v.value), '<!--(NOT FOUND)-->')||'</td>'||
    '<td class="left">'||NVL(DECODE(v.isdefault, 'TRUE', '<i><font color="gray">(NOT SET)</font></i><!--TRUE-->', v.value), '<i><font color="gray">(NOT SET)</font></i><!--NULL-->')||'</td>'||
    '<td class="center">'||DECODE(b.cbo_flag, 'Y', 'Y')||'</td>'||
    '</tr>' line
    FROM chk$cbo$parameter_apps b, v$parameter2 v
    WHERE b.release = :v_apps_release
    AND b.version = :v_rdbms_version
    AND b.name = LOWER(v.name(+))
    AND b.set_flag = 'N'
    ORDER BY b.id, v.value;
    PRO </table>
    PRO CBO: Cost-based Optimizer Parameter.<br>
    
    /******************************************************************************/
    
    PRO <h3>Additional initialization parameters with non-default values</h3>
    PRO <table>
    PRO <tr>
    PRO <th>Parameter</th>
    PRO <th>Current Value</th>
    PRO </tr>
    SELECT
    '<tr>'||
    '<td class="left">'||v.name||'</td>'||
    '<td class="left">'||v.value||'</td>'||
    '</tr>' line
    FROM v$parameter2 v
    WHERE v.isdefault = 'FALSE'
    AND NOT EXISTS (SELECT NULL FROM chk$cbo$parameter_apps b WHERE b.name = LOWER(v.name))
    ORDER BY v.name, v.value;
    PRO </table>
    
    /******************************************************************************/
    
    PRO <br><hr size="1">
    SELECT '<font class="footer">174605.1 bde_check_cbo 12.1.04 '||TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI')||'</font>' FROM DUAL;
    PRO </body>
    PRO </html>
    SPO OFF
    
    DROP TABLE chk$cbo$parameter_apps;
    
    SET TERM ON;
    PRO
    PRO Spool file bde_chk_cbo_report.html has been generated.
    
    /******************************************************************************/
    

    报表

    174605.1 bde_chk_cbo 12.1.04

    Identification

    Date: 10-DEC-14 16:19
    Host: erp
    Platform: Linux 64bit Production
    Database: PROD(272800234)
    Instance: PROD(1)
    RDBMS Release: 11.2.0.3.0(11.2.X)
    User: APPS
    APPS Release: 12.1.3
    CPU Count: 16

    Common database initialization parameters

    Parameter Current Value Required Value CBO MP SZ
    db_name PROD prodr12      
    control_files /u01/prod/db/apps_st/data/cntrl01.dbf three copies of control file      
    control_files /u01/prod/db/apps_st/data/cntrl02.dbf three copies of control file      
    control_files /u01/prod/db/apps_st/data/cntrl03.dbf three copies of control file      
    db_block_size 8192 8192   Y  
    _system_trig_enabled TRUE TRUE   Y  
    o7_dictionary_accessibility FALSE FALSE   Y  
    nls_territory AMERICA AMERICA      
    nls_date_format DD-MON-RR DD-MON-RR   Y  
    nls_numeric_characters ., ".,"      
    nls_sort BINARY BINARY   Y  
    nls_comp BINARY BINARY   Y  
    nls_length_semantics BYTE BYTE   Y  
    audit_trail NONE (NOT SET) TRUE (optional)      
    max_dump_file_size 20480 20480      
    _trace_files_public FALSE TRUE      
    processes 1000 200-2500     Y
    sessions 1536 400-5000     Y
    db_files 512 512      
    dml_locks 10000 10000      
    cursor_sharing EXACT EXACT Y Y  
    open_cursors 600 600      
    session_cached_cursors 500 500      
    sga_target 1073741824 2-14G     Y
    db_block_checking FALSE FALSE      
    db_block_checksum TRUE TRUE      
    log_checkpoint_timeout 1200 1200      
    log_checkpoint_interval 100000 100000      
    log_buffer 10485760 10485760      
    log_checkpoints_to_alert TRUE TRUE      
    shared_pool_size 419430400 600-3000M     Y
    shared_pool_reserved_size 41943040 60-300M     Y
    cursor_space_for_time FALSE (NOT SET) FALSE (default)      
    utl_file_dir /u01/prod/db/tech_st/11.2.0/appsutil/outbound/PROD_erp /ebiz/prodr12/utl_file_dir      
    utl_file_dir /u01/prod/temp /ebiz/prodr12/utl_file_dir      
    utl_file_dir /usr/tmp /ebiz/prodr12/utl_file_dir      
    utl_file_dir /usr/tmp /ebiz/prodr12/utl_file_dir      
    aq_tm_processes 1 1      
    job_queue_processes 2 2      
    log_archive_start FALSE (NOT SET) TRUE (optional)      
    parallel_max_servers 8 8 (up to 2*CPUs)      
    parallel_min_servers 0 0      
    _sort_elimination_cost_ratio 5 5 Y Y  
    _like_with_bind_as_equality TRUE TRUE Y Y  
    _fast_full_scan_enabled FALSE FALSE Y Y  
    _b_tree_bitmap_plans FALSE FALSE Y Y  
    optimizer_secure_view_merging FALSE FALSE Y Y  
    cluster_database FALSE (NOT SET) TRUE (if using RAC)   Y  
    instance_groups (NOT SET) appsN (N is inst_id if using RAC)      
    parallel_instance_group (NOT SET) appsN (N is inst_id if using RAC)      
    pga_aggregate_target 1073741824 1-20G Y   Y
    workarea_size_policy AUTO AUTO Y Y  
    olap_page_pool_size 4194304 4194304      
    CBO: Cost-based Optimizer Parameter.
    MP: Mandatory Parameter and Value
    SZ: For recommended values according to particular environment size, refer to Notes 216205.1 and 396009.1

    Release-specific database initialization parameters for 11.2.X

    Parameter Current Value Required Value CBO MP SZ
    compatible 11.2.0 11.2.0   Y  
    diagnostic_dest /u01/prod/db/tech_st/11.2.0/admin/PROD_erp ?/prod12      
    undo_management AUTO AUTO   Y  
    undo_tablespace APPS_UNDOTS1 APPS_UNDOTS1   Y  
    plsql_code_type INTERPRETED NATIVE      
    _optimizer_autostats_job FALSE FALSE   Y  
    sec_case_sensitive_logon FALSE FALSE   Y  
    parallel_force_local FALSE (NOT SET) TRUE (if using RAC) Y Y  
    CBO: Cost-based Optimizer Parameter.
    MP: Mandatory Parameter and Value
    SZ: For recommended values according to particular environment size, refer to Notes 216205.1 and 396009.1

    Removal list for 11.2.X

    Parameter Current Value CBO
    _always_anti_join (NOT SET) Y
    _always_semi_join (NOT SET) Y
    _complex_view_merging (NOT SET) Y
    _index_join_enabled (NOT SET) Y
    _kks_use_mutex_pin (NOT SET)  
    _new_initial_join_orders (NOT SET) Y
    _optimizer_cost_based_transformation (NOT SET) Y
    _optimizer_cost_model (NOT SET) Y
    _optimizer_mode_force (NOT SET) Y
    _optimizer_undo_changes (NOT SET) Y
    _or_expand_nvl_predicate (NOT SET) Y
    _ordered_nested_loop (NOT SET) Y
    _push_join_predicate (NOT SET) Y
    _push_join_union_view (NOT SET) Y
    _shared_pool_reserved_min_alloc (NOT SET)  
    _sortmerge_inequality_join_off (NOT SET) Y
    _sqlexec_progression_cost (NOT SET) Y
    _table_scan_cost_plus_one (NOT SET) Y
    _unnest_subquery (NOT SET) Y
    _use_column_stats_for_function (NOT SET) Y
    always_anti_join (NOT SET) Y
    always_semi_join (NOT SET) Y
    background_dump_dest (NOT SET)  
    core_dump_dest (NOT SET)  
    db_block_buffers (NOT SET)  
    db_cache_size (NOT SET)  
    db_file_multiblock_read_count (NOT SET) Y
    drs_start (NOT SET)  
    enqueue_resources (NOT SET)  
    event="10932 trace name context level 32768" (NOT SET)  
    event="10933 trace name context level 512" (NOT SET)  
    event="10943 trace name context forever, level 2" (NOT SET)  
    event="10943 trace name context level 16384" (NOT SET)  
    event="38004 trace name context forever, level 1" (NOT SET)  
    hash_area_size (NOT SET) Y
    java_pool_size (NOT SET)  
    job_queue_interval (NOT SET)  
    large_pool_size (NOT SET)  
    max_enabled_roles (NOT SET)  
    nls_language (NOT SET)  
    optimizer_dynamic_sampling (NOT SET) Y
    optimizer_features_enable (NOT SET) Y
    optimizer_index_caching (NOT SET) Y
    optimizer_index_cost_adj (NOT SET) Y
    optimizer_max_permutations (NOT SET) Y
    optimizer_mode (NOT SET) Y
    optimizer_percent_parallel (NOT SET) Y
    plsql_compiler_flags (NOT SET)  
    plsql_native_library_dir (NOT SET)  
    plsql_native_library_subdir_count (NOT SET)  
    plsql_optimize_level 2  
    query_rewrite_enabled (NOT SET) Y
    rollback_segments (NOT SET)  
    row_locking (NOT SET)  
    sort_area_size (NOT SET) Y
    sql_trace (NOT SET)  
    sql_version (NOT SET)  
    timed_statistics (NOT SET)  
    undo_retention (NOT SET)  
    undo_suppress_errors (NOT SET)  
    user_dump_dest (NOT SET)  
    CBO: Cost-based Optimizer Parameter.

    Additional initialization parameters with non-default values

    Parameter Current Value
    audit_sys_operations TRUE
    ifile /u01/prod/db/tech_st/11.2.0/dbs/PROD_erp_ifile.ora
    local_listener PROD_LOCAL
    log_archive_dest_1 LOCATION=/u01/prod/db/apps_st/data/archive
    log_archive_format %t_%s_%r.dbf
    os_authent_prefix  
    sql92_security TRUE

  • 相关阅读:
    关于系统中账号注册登录的一些想法
    关于Data URLs svg图片显示出错和浏览器URL hash #
    我的Spring Boot学习记录(一):自动配置的大致调用过程
    Java工具类——通过配置XML验证Map
    关于HTTPS的简要内容
    Effective Java目录
    Java 初始化a=2 打印a+++a++为5
    Spring SpringMVC MyBatis配置笔记
    Debian8 部署 laravel 5.3 (php7.0 + nginx)
    Intellij idea配置springMvc4.2.6
  • 原文地址:https://www.cnblogs.com/wanghang/p/6299025.html
Copyright © 2020-2023  润新知