List of parameters should be removed in oracle database 19c

 

List of database parameters that should be removed from database initialization parameter file in oracle 19c

 Following are the parameters that can be removed if found present in a parameter file.

kks_use_mutex_pin _shared_pool_reserved_min_alloc _sqlexec_progression_cost always_anti_join always_semi_join background_dump_dest core_dump_dest db_block_buffers db_cache_size db_file_multiblock_read_count drs_start enqueue_resources event="10932 trace name context level 32768" event="10933 trace name context level 512" event="10943 trace name context forever, level 2" event="10943 trace name context level 16384" event="38004 trace name context forever, level 1" exafusion_enabled exclude_seed_cdb_view global_context_pool_size hash_area_size instance_groups java_pool_size job_queue_interval large_pool_size max_enabled_roles o7_dictionary_accessibility olap_page_pool_size optimizer_adaptive_features optimizer_dynamic_sampling optimizer_features_enable optimizer_index_caching optimizer_index_cost_adj optimizer_max_permutations optimizer_mode optimizer_percent_parallel parallel_automatic_tuning parallel_instance_group parallel_degree_level parallel_io_cap_enabled parallel_server parallel_server_instances plsql_compiler_flags plsql_native_library_dir plsql_native_library_subdir_count plsql_optimize_level query_rewrite_enabled rollback_segments row_locking sort_area_size standby_archive_dest sql_trace sql_version timed_statistics undo_retention undo_suppress_errors use_indirect_data_buffers user_dump_dest utl_file_dir

Reference:- Doc ID 396009.1