Oracle 11g Deprecated Initialization Parameters

2 Jan

How to Check Deprecated Initialization Parameters:

Run the following command on your SQL Prompt, it will give you the list of Deprecated Initialization Parameters in your installed Oracle Version, Our concern is to check it for Oeacle 11g Release 1 (11.1).

SQL> SELECT name FROM v$parameter WHERE isdeprecated = ‘TRUE’;

Check the List of Deprecated Initialization Parameters

Initialization Parameters Deprecated in Oracle Database 11g Release 1 (11.1):

1. BACKGROUND_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
2. OMMIT_WRITE
3. CORE_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
4. INSTANCE_GROUPS
5. LOG_ARCHIVE_LOCAL_FIRST
6. PLSQL_DEBUG (replaced by PLSQL_OPTIMIZE_LEVEL)
7. PLSQL_V2_COMPATIBILITY
8. REMOTE_OS_AUTHENT
9. STANDBY_ARCHIVE_DEST
10. TRANSACTION_LAG (attribute of the CQ_NOTIFICATION$_REG_INFO object)
11. USER_DUMP_DEST (replaced by DIAGNOSTIC_DEST)

Initialization Parameters Deprecated in Oracle Database 10g Release 2 (10.2) :

LOGMNR_MAX_PERSISTENT_SESSIONS
MAX_COMMIT_PROPAGATION_DELAY
REMOTE_ARCHIVE_ENABLE
SERIAL_REUSE
SQL_TRACE

Compatibility Issues with Initialization Parameters:

The lists of deprecated and obsolete initialization parameters earlier in this page show changes to initialization parameters across Oracle 11g and Oracle 10g Releases of oracle database. However, certain initialization parameter changes require special attention because they might raise compatibility issues for your database. These parameter changes are described in the following sections.

Compatibility Issues Introduced in Oracle Database 11g Release 1 (11.1)

New Default Value for UNDO_MANAGEMENT
Starting with Oracle Database 11g Release 1 (11.1), the default value of the UNDO_MANAGEMENT parameter is AUTO so that automatic undo management is enabled by default. You must set the parameter to MANUAL to turn off automatic undo management, if required. Compatibility Issues Introduced in Oracle Database 10g

Change in Behavior for SESSION_CACHED_CURSORS
Starting with Oracle Database 10g Release 1 (10.1), the number of cached cursors is determined by the SESSION_CACHED_CURSORS initialization parameter. In previous Oracle Database releases, the number of SQL cursors cached by PL/SQL was determined by the OPEN_CURSORS initialization parameter.

New Default Value for DB_BLOCK_SIZE
Starting with Oracle Database 10g Release 1 (10.1), the default value of DB_BLOCK_SIZE is operating system specific, but is typically 8 KB (8192 bytes). In previous Oracle Database releases, the default value was 2 KB (2048 bytes). If DB_BLOCK_SIZE is not specified in the parameter file when upgrading from Oracle Database9i Release 2 (9.2), then you receive an error when attempting to start up your database. Add the following to your parameter file:

DB_BLOCK_SIZE = 2048

If DB_BLOCK_SIZE is specified in the parameter file, then Oracle Database uses this value instead of the default value of 8 KB.

4 Responses to “Oracle 11g Deprecated Initialization Parameters”

  1. Henry March 26, 2010 at 8:23 pm #

    Mas Chinmi,

    saya coba nanya ke forum, katanya CORE_DUMP_DEST masih baik2 aja koq.

    http://forums.oracle.com/forums/thread.jspa?threadID=1049322&tstart=15

    SQL> select name from v$parameter where isdeprecated = ‘TRUE’;

    NAME
    ——————————————————————————–

    lock_name_space
    instance_groups
    buffer_pool_keep
    buffer_pool_recycle
    max_commit_propagation_delay
    log_archive_start
    standby_archive_dest
    log_archive_local_first
    parallel_server
    parallel_server_instances
    fast_start_io_target

    NAME
    ——————————————————————————–

    serial_reuse
    max_enabled_roles
    remote_os_authent
    global_context_pool_size
    plsql_v2_compatibility
    plsql_debug
    background_dump_dest
    user_dump_dest
    commit_write
    sql_trace
    parallel_automatic_tuning

    NAME
    ——————————————————————————–

    sql_version
    drs_start

    24 rows selected.

    mohon pencerahannya

    http://hgdba.wordpress.com/

  2. Jack Nicholson April 12, 2010 at 2:18 pm #

    Nice information about deprecated parameters in Oracle 11g. Can you tell me how many more parameters are being introduced

  3. Suresh Kumar Gogune June 30, 2010 at 12:06 am #

    Nice info. about deprecated parameters………Thx

  4. Mathan Kumar January 10, 2012 at 10:36 pm #

    Hi Jack,

    In 10g there are 258 prameters, in 11g it is 344..

    Mathan Kumar

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: