V$OBSOLETE_PARAMETER

If you would like to know the obsolete initialization parameter you can use V$obsolete_parameter. If any row in the ISSPECIFIED column true then you should examine why.

 

select * from V$obsolete_parameter where

lower(name) like '%dump%';

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

_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

cell_partition_large_extents

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

FALSE

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

FALSE

 

Comments