This is the 2nd posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.
- New SPFILE Parameters in Oracle Database 12.2.0.1
- Obsolete SPFILE Parameters in Oracle Database 12.2.0.1
- Deprecated SPFILE Parameters in Oracle Database 12.2.0.1
- Default SPFILE Parameter changes between Oracle Database 11.2.0.4, 12.1.0.2 and 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
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
Thank you!
Yes, I agree, and now they make it worse with an underscore parameter.
Please see my post tomorrow (July 21) 🙂
And thanks again for the hint!
Cheers
Mike