Wednesday, June 15, 2011

New initialization parameters and Obsolete parameter in Oracle 11gR1


The best way to find new parameters is to create a database link between the two versions and run a set query using MINUS.Here are the new initialization parameter which was introduce in oracle 11gr1(11.1.0.6).

asm_preferred_read_failure_groups
client_result_cache_lag
client_result_cache_size
commit_logging
commit_wait
control_management_pack_access
db_lost_write_protect
db_securefile
db_ultra_safe
ddl_lock_timeout
diagnostic_dest
enable_ddl_logging
global_txn_processes
java_jit_enabled
ldap_directory_sysauth
memory_max_target
memory_target
optimizer_capture_sql_plan_baselines
optimizer_use_invisible_indexes
optimizer_use_pending_statistics
optimizer_use_sql_plan_baselines
parallel_io_cap_enabled
plscope_settings
redo_transport_user
resource_manager_cpu_allocation
result_cache_max_result
result_cache_max_size
result_cache_mode
result_cache_remote_expiration
sec_case_sensitive_logon
sec_max_failed_login_attempts
sec_protocol_error_further_action
sec_protocol_error_trace_action
sec_return_server_release_banner
xml_db_events

The list of obsolete parameter in oracle 11gr1(11.1.0.6) are :

_dlm_send_timeout
_fast_start_instance_recovery_target
_lm_rcv_buffer_size
_log_archive_buffer_size
ddl_wait_for_locks
logmnr_max_persistent_sessions
plsql_compiler_flags
remote_archive_enable


Enjoy    :-)


No comments: