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
Leave a Reply