Obsolete SPFILE Parameters in Oracle Database 12.2.0.1

This is the 2nd posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.

Find the list of the 159 obsoleted parameters here (and of course in V$OBSOLETE_PARAMETERS):

_app_ctx_vers
_average_dirties_half_life
_aw_row_source_enabled
_compatible_no_recovery
_data_transfer_cache_size
_db_no_mount_lock
_dlm_send_timeout
_dtree_bintest_id
_dtree_compressbmp_enabled
_evolve_plan_baseline_report_level
_fast_start_instance_recovery_target
_fic_max_length
_fic_outofmem_candidates
_idl_conventional_index_maintenance
_kgl_latch_count
_kks_free_cursor_stat_pct
_kspptbl_mem_usage
_lm_direct_sends
_lm_multiple_receivers
_lm_rcv_buffer_size
_lm_statistics
_log_archive_buffer_size
_log_io_size
_max_log_write_io_parallelism
_module_action_old_length
_optimizer_adaptive_plans
_optimizer_choose_permutation
_oracle_trace_events
_oracle_trace_facility_version
_plan_verify_local_time_limit
_plsql_conditional_compilation
_px_async_getgranule
_px_slaves_share_cursors
_seq_process_cache_const
_spr_use_hash_table
_sqlexec_progression_cost
_use_hidden_partitions
_very_large_partitioned_table
allow_partial_sn_results
always_anti_join
always_semi_join
arch_io_slaves
b_tree_bitmap_plans
backup_disk_io_slaves
cache_size_threshold
cell_partition_large_extents
cleanup_rollback_entries
close_cached_open_cursors
complex_view_merging
db_block_checkpoint_batch
db_block_lru_extended_statistics
db_block_lru_latches
db_block_lru_statistics
db_block_max_dirty_target
db_file_simultaneous_writes
dblink_encrypt_login
ddl_wait_for_locks
delayed_logging_block_cleanouts
discrete_transactions_enabled
distributed_recovery_connection_hold_time
distributed_transactions
drs_start
enqueue_resources
exclude_seed_cdb_view
fast_full_scan_enabled
freeze_DB_for_fast_instance_recovery
gc_defer_time
gc_files_to_locks
gc_latches
gc_lck_procs
gc_releasable_locks
gc_rollback_locks
hash_join_enabled
hash_multiblock_io_count
instance_nodeset
job_queue_interval
job_queue_keep_connections
large_pool_min_alloc
lgwr_io_slaves
lm_locks
lm_procs
lm_procs
lm_ress
lock_sga_areas
log_block_checksum
log_files
log_parallelism
log_simultaneous_copies
log_small_entry_max_size
logmnr_max_persistent_sessions
max_commit_propagation_delay
max_rollback_segments
max_transaction_branches
mts_circuits
mts_dispatchers
mts_listener_address
mts_max_dispatchers
mts_max_servers
mts_multiple_listeners
mts_servers
mts_service
mts_sessions
ogms_home
ops_admin_group
ops_interconnects
optimizer_adaptive_features
optimizer_max_permutations
optimizer_percent_parallel
optimizer_search_limit
oracle_trace_collection_name
oracle_trace_collection_path
oracle_trace_collection_size
oracle_trace_enable
oracle_trace_facility_name
oracle_trace_facility_path
parallel_automatic_tuning
parallel_broadcast_enabled
parallel_default_max_instances
parallel_degree_level
parallel_io_cap_enabled
parallel_min_message_pool
parallel_server
parallel_server_idle_time
parallel_server_instances
parallel_transaction_resource_timeout
partition_view_enabled
plsql_compiler_flags
plsql_native_c_compiler
plsql_native_library_dir
plsql_native_library_subdir_count
plsql_native_linker
plsql_native_make_file_name
plsql_native_make_utility
push_join_predicate
remote_archive_enable
row_cache_cursors
row_locking
sequence_cache_entries
sequence_cache_hash_buckets
serializable
shared_pool_reserved_min_alloc
snapshot_refresh_interval
snapshot_refresh_keep_connections
snapshot_refresh_processes  
sort_direct_writes
sort_multiblock_read_count
sort_read_fac
sort_spacemap_size
sort_write_buffer_size
sort_write_buffers
spin_count
sql_version
standby_preserves_names
temporary_table_locks
text_enable
transaction_auditing
undo_suppress_errors
use_indirect_data_buffers
use_ism

–Mike

5 thoughts on “Obsolete SPFILE Parameters in Oracle Database 12.2.0.1

  1. Hello Mike,
    do you know what happened to exclude_seed_cdb_view in 12.2? How can I see, if a patch is installed in my PDB$SEED now for example, as I cannot set it any more?

    > show parameter seed
    NAME TYPE VALUE
    —- —- —–

    > select CON_ID,PATCH_ID,VERSION,STATUS,ACTION,DESCRIPTION from cdb_registry_sqlpatch order by action_time;

    CON_ID PATCH_ID VERSION STATUS ACTION DESCRIPTION
    ———- ———- ——————– ————— ————— —————————————————————————————————-
    1 26123830 12.2.0.1 SUCCESS APPLY DATABASE RELEASE UPDATE 12.2.0.1.170718
    3 26123830 12.2.0.1 SUCCESS APPLY DATABASE RELEASE UPDATE 12.2.0.1.170718
    4 26123830 12.2.0.1 SUCCESS APPLY DATABASE RELEASE UPDATE 12.2.0.1.170718

    • Hi Dagmar,

      it became an underscore – and you deliver a perfect use case why it should be changed (and why the default of “excluding” is nonsense).

      Please set:
      alter system set “_exclude_seed_cdb_view”=FALSE scope=both;

      Then you’ll see all of them again.

      Cheers
      Mike

  2. Pingback: exclude_seed_cdb_view is now _exclude_seed_cdb_view in Oracle 12.2

Leave a Reply

Your email address will not be published. Required fields are marked *