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
