Friday 12 April 2013

How to find deprecated parameters in Oracle?



SQL> select name from v$database;

NAME
---------
PROD

SQL>

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production




Below are the list of deprecated parameters in 11g.
====================================

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

NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
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

NAME
--------------------------------------------------------------------------------
fast_start_io_target
serial_reuse
max_enabled_roles
remote_os_authent
global_context_pool_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest
commit_write

NAME
--------------------------------------------------------------------------------
sql_trace
parallel_automatic_tuning
sql_version
drs_start

26 rows selected.

Below  command is not displaying the deprecated parameters.
=======================================


SQL> select name from v$obsolete_parameter where isspecified='TRUE';

no rows selected

SQL>



Note:Parameters which are replaced in 11g.

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)

1 comment: