Oracle changes fast
Oracle各个版本的变动还是挺大的，不管大版本和小版本每次都能够引入很多新的功能，和新的bug。这说明Oracle还在积极的invovation和customer focus.
从obsoleted和deprecated的参数就可以看到，新的来，旧的去。不变的是升级再升级。
当Instance设置了过期或旧的参数的时候，日志文件会由提示。
workarea_size_policy = “manual”
optimizer_dynamic_sampling= 2
statistics_level = “BASIC”
diagnostic_dest = “/dump/oracle”
max_dump_file_size = “4000000″
Obsolete system parameters with specified values:
mts_servers
End of obsolete system parameter listing
Deprecated system parameters with specified values:
standby_archive_dest
remote_os_authent
End of deprecated system parameter listing
Mon Aug 30 21:48:08 2010
上百个参数。
11.2.0.1.0@SQL> SELECT name FROM v$parameter WHERE isdeprecated = ‘TRUE’;
NAME
——————————————————————————–
lock_name_space
instance_groups
resource_manager_cpu_allocation
active_instance_count
buffer_pool_keep
buffer_pool_recycle
log_archive_start
standby_archive_dest
log_archive_local_first
parallel_server
parallel_server_instances
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
sql_trace
parallel_automatic_tuning
parallel_io_cap_enabled25 rows selected.
ORACLE@ADGLG1: SQL> select * from V$OBSOLETE_PARAMETER;
NAME ISSPE
—————————————————————- —–
spin_count FALSE
use_ism FALSE
lock_sga_areas FALSE
instance_nodeset FALSE
large_pool_min_alloc FALSE
shared_pool_reserved_min_alloc FALSE
_kspptbl_mem_usage FALSE
enqueue_resources FALSE
lgwr_io_slaves FALSE
arch_io_slaves FALSE
backup_disk_io_slaves FALSE
ops_interconnects FALSE
lm_procs FALSE
ogms_home FALSE
parallel_transaction_resource_timeout FALSE
_lm_statistics FALSE
lm_locks FALSE
lm_ress FALSE
lm_procs FALSE
_lm_multiple_receivers FALSE
_lm_direct_sends FALSE
_lm_rcv_buffer_size FALSE
_dlm_send_timeout FALSE
db_block_max_dirty_target FALSE
db_block_lru_latches FALSE
db_block_checkpoint_batch FALSE
db_block_lru_statistics FALSE
db_block_lru_extended_statistics FALSE
max_commit_propagation_delay FALSE
_compatible_no_recovery FALSE
remote_archive_enable FALSE
_log_archive_buffer_size FALSE
_average_dirties_half_life FALSE
log_block_checksum FALSE
log_small_entry_max_size FALSE
log_simultaneous_copies FALSE
log_parallelism FALSE
db_file_simultaneous_writes FALSE
log_files FALSE
_db_no_mount_lock FALSE
standby_preserves_names FALSE
gc_lck_procs FALSE
gc_releasable_locks FALSE
gc_files_to_locks FALSE
gc_latches FALSE
gc_rollback_locks FALSE
gc_defer_time FALSE
_fast_start_instance_recovery_target FALSE
freeze_DB_for_fast_instance_recovery FALSE
logmnr_max_persistent_sessions FALSE
temporary_table_locks FALSE
ddl_wait_for_locks FALSE
row_locking FALSE
serializable FALSE
delayed_logging_block_cleanouts FALSE
max_rollback_segments FALSE
transaction_auditing FALSE
cleanup_rollback_entries FALSE
undo_suppress_errors FALSE
discrete_transactions_enabled FALSE
sequence_cache_entries FALSE
sequence_cache_hash_buckets FALSE
_seq_process_cache_const FALSE
row_cache_cursors FALSE
_kgl_latch_count FALSE
text_enable FALSE
dblink_encrypt_login FALSE
distributed_transactions FALSE
max_transaction_branches FALSE
distributed_recovery_connection_hold_time FALSE
mts_dispatchers FALSE
mts_servers TRUE
mts_max_servers FALSE
mts_max_dispatchers FALSE
mts_circuits FALSE
mts_sessions FALSE
mts_service FALSE
mts_listener_address FALSE
mts_multiple_listeners FALSE
plsql_compiler_flags FALSE
plsql_native_c_compiler FALSE
plsql_native_linker FALSE
plsql_native_library_dir FALSE
plsql_native_make_utility FALSE
plsql_native_make_file_name FALSE
plsql_native_library_subdir_count FALSE
_plsql_conditional_compilation FALSE
job_queue_interval FALSE
job_queue_keep_connections FALSE
snapshot_refresh_processes FALSE
snapshot_refresh_interval FALSE
snapshot_refresh_keep_connections FALSE
parallel_default_max_instances FALSE
cache_size_threshold FALSE
parallel_server_idle_time FALSE
allow_partial_sn_results FALSE
ops_admin_group FALSE
parallel_min_message_pool FALSE
hash_join_enabled FALSE
hash_multiblock_io_count FALSE
oracle_trace_enable FALSE
oracle_trace_facility_path FALSE
oracle_trace_collection_path FALSE
oracle_trace_facility_name FALSE
oracle_trace_collection_name FALSE
oracle_trace_collection_size FALSE
_oracle_trace_events FALSE
_oracle_trace_facility_version FALSE
close_cached_open_cursors FALSE
sort_direct_writes FALSE
sort_write_buffers FALSE
sort_write_buffer_size FALSE
sort_spacemap_size FALSE
sort_read_fac FALSE
sort_multiblock_read_count FALSE
always_anti_join FALSE
partition_view_enabled FALSE
b_tree_bitmap_plans FALSE
complex_view_merging FALSE
push_join_predicate FALSE
fast_full_scan_enabled FALSE
parallel_broadcast_enabled FALSE
always_semi_join FALSE
optimizer_max_permutations FALSE
sql_version FALSE
_optimizer_choose_permutation FALSE
optimizer_percent_parallel FALSE
optimizer_search_limit FALSE
_aw_row_source_enabled FALSE
drs_start FALSE130 rows selected.
跟不上了,,md