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

No comments:

Post a Comment