Obsolete Database Parameters

Oracle provides the view V$OBSOLETE_PARAMETER to display all obsolete and underscored parameters. This view contains the name of the parameter and a flag ISSPECIFIED indicating if the parameter has actually been set in the init.ora file. Keep in mind that Oracle has not really retired all of the parameters contained in V$OBSOLETE_PARAMETER, some of them have been underscored. Underscored parameters are ones that Oracle wants to keep around, but does not want you to use them unless absolutely necessary. These underscored parameters are better know as hidden parameters. They are not documented and they all start with an _, like _lgwr_io_slaves in Oracle8i.

SQL> SELECT name, isspecified
2 FROM v$obsolete_parameter;

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
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

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
_lm_direct_sends 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
_compatible_no_recovery 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_latches FALSE
gc_rollback_locks FALSE
gc_defer_time FALSE

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
freeze_DB_for_fast_instance_recovery FALSE
temporary_table_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
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 FALSE

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
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_native_c_compiler FALSE
plsql_native_linker FALSE
plsql_native_make_utility FALSE
plsql_native_make_file_name 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

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
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

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
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
optimizer_percent_parallel FALSE
optimizer_search_limit FALSE

113 rows selected

SQL>

SQL> SELECT kspponm,
2 DECODE(ksppoflg, 1,'Obsolete', 2, 'Underscored')
3 FROM x$ksppo
4 ORDER BY kspponm;