2020. 10. 20. 23:51 오라클
19c Hidden Parameter 조회
Oracle 19c Hidden Parameter 조회 (19.8 기준)
5412 rows selected.
SET LINES 120
COL KSPPINM for A40
COL KSPPSTVL FOR A30
select ksppinm, ksppstvl
from x$ksppi x, x$ksppcv y
where (x.indx = y.indx)
and (translate(ksppinm,'_','#') like '%&1%');
----------------------------------------------------------
_appqos_qt 10
_appqos_po_multiplier 1000
_appqos_cdb_setting 0
_ior_serialize_fault 0
_shutdown_completion_timeout_mins 60
_inject_startup_fault 0
_wait_outlier_detection_enable OFF
_wait_outlier_event_names
_wait_outlier_lambda_x1000 1500
_wait_outlier_dump_flags 0
_wait_outlier_min_waits 10
_wait_outlier_num_outliers 600
_spin_count 1
_latch_miss_stat_sid 0
_max_sleep_holding_latch 4
_max_exponential_sleep 0
_other_wait_threshold 0
_other_wait_event_exclusion
_use_vector_post TRUE
_latch_class_0
_latch_class_1
_latch_class_2
_latch_class_3
_latch_class_4
_latch_class_5
_latch_class_6
_latch_class_7
_latch_classes
_ultrafast_latch_statistics TRUE
_enable_reliable_latch_waits TRUE
_latch_wait_list_pri_sleep_secs 1
_wait_breakup_time_csecs 300
_wait_breakup_threshold_csecs 600
_disable_wait_state
_wait_tracker_num_intervals 0
_wait_tracker_interval_secs 10
_wait_samples_max_time_secs 120
_wait_samples_max_sections 40
_wait_yield_mode yield
_wait_yield_hp_mode yield
_wait_yield_sleep_time_msecs 1
_wait_yield_sleep_freq 100
_wait_yield_yield_freq 20
_post_wait_queues_num_per_class
_super_shared_enable FALSE
_super_shared_conversion_threshold 300
_super_shared_max_exclusive_conversions 4
__wait_test_param 0
__latch_test_param 0
_latch_pause_mode static
_latch_pause_count 0
lock_name_space
processes 300
sessions 472
_min_sys_process 2
_enable_dynamic_sessions FALSE
_dynamic_sessions_inc_count 1000
_dynamic_sessions_force_timeout 30
_dynamic_sessions_min_force_timeout 5
_dynamic_sessions_wait_timeout 100
_max_dynamic_sessions 472
_dynamic_sessions_max_oom_timeout 300
_session_prediction_failover_buffer 0
_so_percent_upper_bound_strt 70
_so_percent_upper_bound_final 90
_so_percent_lower_bound_strt 60
_so_percent_lower_bound_final 80
_session_percent_rampup_start 472
_session_percent_rampup_end 472
_so_max_inc 20000
timed_statistics TRUE
timed_os_statistics 0
resource_limit TRUE
license_max_sessions 0
license_sessions_warning 0
_session_idle_bit_latches 0
_ksu_diag_kill_time 5
_ksuitm_dont_kill_dumper FALSE
_disable_image_check FALSE
_num_longop_child_latches 1
_longops_per_latch 64
_longops_enabled TRUE
_test_ksusigskip 5
long_module_action TRUE
_disable_kcbhxor_osd FALSE
_disable_kgghshcrc32_osd FALSE
_disable_system_state 4294967294
_system_state_runtime_limit 4294967294
_system_state_cputime_limit 4294967294
_disable_system_state_wait_samples FALSE
_session_wait_history 10
_pkt_enable FALSE
_pkt_start FALSE
_pkt_pmon_interval 50
_collapse_wait_history FALSE
_short_stack_timeout_ms 30000
_sga_early_trace 0
_kill_session_dump FALSE
_logout_storm_rate 0
_logout_storm_timeout 5
_logout_storm_retrycnt 600
_ksuitm_addon_trccmd
_timeout_actions_enabled TRUE
_idle_session_kill_enabled TRUE
_session_allocation_latches 1
standby_db_preserve_states NONE
_suspended_session_timeout 300
_wait_for_busy_session 10
_process_allocation_slots 100
instance_abort_delay_time 0
_show_login_pdb_sessions FALSE
_disable_highres_ticks FALSE
_disable_os_time_page FALSE
_timer_precision 10
_dbrm_quantum
_highres_drift_allowed_sec 1
_lowres_drift_allowed_sec 5
_vktm_assert_thresh 30
_iorm_tout 1000
__oracle_base /oracle/app
_rman_roundrobin_placement
_process_heartbeat_range 3
_max_shutdown_abort_secs 10
_cpu_count_startup 0
cpu_count 1
cpu_min_count 1
_disable_cpu_check FALSE
_available_core_count 0
_cpu_eff_thread_multiplier
_single_process FALSE
_dbg_proc_startup FALSE
_enqueue_deadlock_time_sec 5
_enqueue_sync_retry_attempts 15
_enqueue_sync_sim_mem_error FALSE
_number_cached_attributes 10
instance_groups
_number_cached_group_memberships 2048
_number_group_memberships_per_cache_line 6
_ksim_time_monitor auto
_group_membership_bucket_scan_timeout 5
_group_membership_bucket_batch_size 8
_group_membership_entries_per_bucket 100
_kss_quiet TRUE
_kss_callstack_type
event
_oradebug_force FALSE
_ksdxdocmd_default_timeout_ms 30000
_ksdxdocmd_enabled TRUE
_ksdx_charset_ratio 0
_oradebug_cmds_at_startup
_disable_oradebug_commands none
_watchpoint_on FALSE
_ksdxw_num_sgw 10
_ksdxw_num_pgw 10
_ksdxw_stack_depth 4
_ksdxw_stack_readable FALSE
_ksdxw_cini_flg 0
_ksdxw_nbufs 1000
_hw_watchpoint_on TRUE
sga_max_size 1610612736
_enable_shared_pool_durations TRUE
_NUMA_pool_size Not specified
_enable_NUMA_optimization FALSE
_enable_NUMA_support FALSE
_enable_NUMA_interleave TRUE
_touch_sga_pages_during_allocation FALSE
use_large_pages TRUE
_max_largepage_alloc_time_secs 10
_use_hugetlbfs_for_SGA FALSE
_hugetlbfs_mount_point_for_sga
_use_hugetlbfs_per_granule FALSE
_dump_10261_level 0
_numa_shift_enabled TRUE
_numa_shift_value 0
_freeze_kgh_timestamp FALSE
pre_page_sga TRUE
shared_memory_address 0
hi_shared_memory_address 0
_use_ism TRUE
lock_sga FALSE
_NUMA_instance_mapping Not specified
_simulator_upper_bound_multiple 2
_simulator_pin_inval_maxcnt 16
_simulator_lru_rebalance_thresh 10240
_simulator_lru_rebalance_sizthr 5
_simulator_bucket_mindelta 8192
_simulator_lru_scan_count 8
_simulator_internal_bound 10
_simulator_reserved_obj_count 1024
_simulator_reserved_heap_count 4096
_simulator_sampling_factor 2
_realfree_heap_max_size 32768
_realfree_heap_pagesize 65536
_realfree_pq_heap_pagesize 65536
_realfree_heap_mode 0
_use_realfree_heap TRUE
_pga_large_extent_size 1048576
_uga_cga_large_extent_size 262144
_total_large_extent_memory 0
_use_ism_for_pga TRUE
_private_memory_address
_kgh_restricted_trace 0
_kgh_restricted_subheaps 180
_kgh_free_list_min_effort 12
_ksm_shared_pool_stats_num_pdb 8
_ksm_shared_pool_stats_minsz 524288
_ksm_sp_rcr_hits 10
_mem_annotation_sh_lev 0
_mem_annotation_pr_lev 0
_mem_annotation_scale 1
_mem_annotation_store FALSE
_4031_dump_bitvec 67194879
_4031_max_dumps 100
_4031_dump_interval 300
_4031_sga_dump_interval 3600
_4031_sga_max_dumps 10
_4030_dump_bitvec 4095
_numa_trace_level 0
_mem_std_extent_size 4096
_kgsb_threshold_size 16777216
_endprot_chunk_comment chk 10235 dflt
_endprot_heap_comment hp 10235 dflt
_endprot_subheaps TRUE
_alloc_perm_as_free FALSE
_ksm_pre_sga_init_notif_delay_secs 0
_ksm_post_sga_init_notif_delay_secs 0
_defer_sga_enabled FALSE
_defer_sga_min_total_defer_segs_sz 107374182400
_defer_sga_alloc_chunk_size 1073741824
_defer_sga_min_spsz_at_startup 53687091200
_defer_sga_test_alloc_intv 0
_sga_alloc_slaves_term_timeout_secs 120
_ksmlsaf 0
processor_group_name
_pga_limit_target_perc 200
_pga_limit_watch_perc 50
_pga_limit_time_to_interrupt 2
_pga_limit_interrupt_smaller FALSE
_pga_limit_time_until_idle 15
_pga_limit_time_until_killed 15
_pga_limit_use_immediate_kill TRUE
_pga_limit_dump_summary TRUE
_pga_limit_watch_size 104857600
_pga_limit_min_req_size 4194304
_pga_limit_check_wait_time 1000000
_pga_limit_simulated_physmem_size 0
_pga_limit_physmem_perc 90
_max_physmem_perc_sga 80
_max_physmem_perc_mmt 90
_pga_limit_per_process_minimum 3145728
_pga_auto_snapshot_threshold 524288000
_pga_auto_snapshot_percentage 20
_pga_detail_combine_auto FALSE
_memory_adi_enabled TRUE
_memory_adi_precise_errors FALSE
_sga_heap_chunk_alignment FALSE
_sga_heap_chunk_alignment_disabled FALSE
_memory_adi_bytes_per_alloc 0
_memory_adi_extend FALSE
_memory_adi_heap_mask 610
_memory_adi_module_mask 0
_NUMA_bind_mode default
_pdb_vm_max_size
allow_group_access_to_sga FALSE
_gas_partition_size 0
_suspend_4036_timeout 14400
_suspend_4031_timeout 14400
_heap_dump_timeout 60
_pga_in_sga_param1
_pga_in_sga_param2
_pga_in_sga_param3
_pga_in_sga_param4
_pga_in_sga_param5
sga_min_size 0
__sga_current_size 0
__shared_pool_size 369098752
shared_pool_size 0
__large_pool_size 16777216
large_pool_size 0
__java_pool_size 0
java_pool_size 0
__streams_pool_size 0
streams_pool_size 0
__unified_pga_pool_size 0
_unified_pga_pool_size 0
_large_pool_min_alloc 65536
shared_pool_reserved_size 18454937
_shared_pool_reserved_pct 5
_shared_pool_reserved_min_alloc 4400
java_soft_sessionspace_limit 0
java_max_sessionspace_size 0
_kghdsidx_count 1
pga_aggregate_limit 2147483648
_pga_limit_tracing 0
_force_java_pool_zero FALSE
_pga_aggregate_xmem_limit 0
_parameter_spfile_sync FALSE
_test_param_1 25
_test_param_2
_test_param_3
_test_param_4
_test_param_5 25
_test_param_6 0
_test_param_7 100, 1100, 2100, 3100, 4100
_test_param_8 20
_test_param_9
_test_param_9_1 0
_test_param_9_2 0_startup
_test_param_9_3 1_startup, 2_startup, 3_startu
p
_test_param_10
_test_param_10_bi 10
_test_param_10_i
_test_param_11_base 3
_test_param_11_dep 0_STARTUP, 1_STARTUP, 2_STARTU
P
_test_param_12 0
spfile /oracle/app/oracle/product/19.
3.0/dbs/spfileTEST.ora
instance_type RDBMS
_disable_instance_params_check FALSE
_parameter_table_block_size 2048
_high_priority_processes LMS*|LM1*|LM2*|LM3*|LM4*|LM5*|
LM6*|LM7*|LM8*|LM9*
_highest_priority_processes VKTM
_os_sched_high_priority 1
_os_sched_highest_priority 1
_ksb_restart_clean_time 30000
_ksb_restart_policy_times 0, 60, 120, 240
_bg_spawn_diag_opts 0
_static_backgrounds
_mpmt_enabled_backgrounds *
_background_process_opts 0
_ksd_test_param 999
uniform_log_timestamp_format TRUE
_kse_die_timeout 60000
_stack_guard_level 0
_kse_pc_table_size 256
_kse_signature_entries 0
_kse_signature_limit 7
_kse_snap_ring_size 0
_kse_snap_ring_record_stack FALSE
_kse_snap_ring_suppress 942 1403
_kse_snap_ring_disable FALSE
_kse_trace_int_msg_clear FALSE
_system_api_interception_debug FALSE
_kse_ssnt FALSE
_kse_alt_stack_sig_syms 25
_kse_auto_core FALSE
_messages 600
_enqueue_locks 5580
_enqueue_resources 2296
_enqueue_hash 979
_enqueue_debug_multi_instance FALSE
_enqueue_hash_chain_latches 1
_enqueue_deadlock_scan_secs 0
_enqueue_deadlock_detect_all_global_lock FALSE
s
_enqueue_paranoia_mode_enabled FALSE
_ksi_trace
_ksi_trace_bucket SHARED
_ksi_trace_bucket_size LCK1:1048576-REST:8192
_ksi_clientlocks_enabled TRUE
_ksi_pdb_checks TRUE
_trace_processes ALL
_trace_events
_trace_buffers ALL:256
_trace_dump_static_only FALSE
_trace_dump_all_procs FALSE
_trace_dump_cur_proc_only FALSE
_trace_dump_client_buckets TRUE
_cdmp_diagnostic_level 2
nls_language AMERICAN
nls_territory AMERICA
nls_sort
nls_date_language
nls_date_format
nls_currency
nls_numeric_characters
nls_iso_currency
nls_calendar
nls_time_format
nls_timestamp_format
nls_time_tz_format
nls_timestamp_tz_format
nls_dual_currency
nls_comp BINARY
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
_nchar_imp_cnv TRUE
_nls_parameter_sync_enabled TRUE
_ioslave_issue_count 500
_ioslave_batch_count 1
disk_asynch_io TRUE
tape_asynch_io TRUE
_io_slaves_disabled FALSE
dbwr_io_slaves 0
_lgwr_io_slaves 0
_arch_io_slaves 0
_backup_disk_io_slaves 0
backup_tape_io_slaves FALSE
_fg_iorm_slaves 1
_backup_io_pool_size 1048576
_disable_file_locks FALSE
_ksfd_verify_write FALSE
_disable_odm FALSE
_enable_fast_file_zero TRUE
_enable_kernel_io_outliers FALSE
fileio_network_adapters
_enable_list_io FALSE
filesystemio_options none
dnfs_batch_size 4096
_dnfs_rdma_max 1048576
_dnfs_rdma_min 8192
_dnfs_rdma_enable rman
_omf enabled
_aiowait_timeouts 100
_io_shared_pool_size 4194304
_max_io_size 1048576
_io_statistics TRUE
_disk_sector_size_override FALSE
_simulate_disk_sectorsize 0
_simulate_logical_sectorsize 0
_enable_asyncvio FALSE
_iocalibrate_max_ios 0
_iocalibrate_init_ios 2
clonedb FALSE
instant_restore FALSE
_io_outlier_threshold 500
_io_internal_test 0
_lgwr_io_outlier 0
_io_osd_param 1
_fob_dgaalloc TRUE
_fob_ospshare TRUE
_ksfd_fob_pct 0
_disksize_binary_search FALSE
_instant_file_create FALSE
http_proxy
ssl_wallet
_db_file_direct_io_count 1048576
_cell_fast_file_create TRUE
_cell_fast_file_restore TRUE
_file_size_increase_increment 67108864
ofs_threads 4
_ofs_write_buffer_size 1048576
_reset_maxcap_history 10
_use_dynamic_shares 1
_dynamic_share_range_factor 2
_cpu_util_adj_force 0
_cpu_util_adj_target 0
_low_server_threshold 0
_high_threshold_delta 65535
_min_lwt_lt 24
_max_lwt_cpu_ratio 2
_active_session_idle_limit 5
_active_session_legacy_behavior FALSE
resource_manager_cpu_allocation 1
_resource_manager_plan
resource_manager_plan
_vkrm_schedule_interval 10
_dbrm_dynamic_threshold 989922280
_rm_superlong_threshold 0
_resource_manager_always_off FALSE
_io_resource_manager_always_on FALSE
_enable_os_cpu_rm FALSE
_max_small_io 0
_max_large_io 0
_auto_assign_cg_for_sessions FALSE
_rm_numa_simulation_pgs 0
_rm_numa_simulation_cpus 0
_rm_numa_sched_enable TRUE
_dbrm_runchk 32769000
_dbrm_short_wait_us 300
_dbrm_num_runnable_list 0
_db_check_cell_hints FALSE
_pqq_enabled TRUE
db_performance_profile
_rm_force_caging FALSE
_min_sys_percentage
_min_autotask_percentage
max_iops 0
max_mbps 0
_db_cache_max_sz 0
_shared_pool_max_sz 0
max_idle_time 0
max_idle_blocker_time 0
_rm_exadata_pdb_cpu_cnt FALSE
_rm_exadata_partition_fc FALSE
_rm_exadata_pdb_cpu_cnt_mult 2
_rm_atp_cpu_cnt_scale 1
_pqq_debug_txn_act FALSE
_ksr_unit_test_processes 0
_ksv_spawn_control_all FALSE
_ksv_max_spawn_fail_limit 5
_ksv_pool_wait_timeout 600
_ksv_pool_hang_kill_to 0
_ksvppktmode 0
_ksv_static_flags1 0
_ksv_dynamic_flags1 0
_ksv_slave_exit_timeout 120
_result_cache_rac_rolling 0
_bug27355984_xt_preproc_timeout 100
_third_spare_parameter
_session_modp_list 2
_smart_log_threshold_usec 100
_bug29825525_bct_public_dba_buffer_dynre 3600
size_delay
_asm_max_kfsg_free_heap_size 524288000
_asm_max_kfsg_free_heap_perc 10
_ninth_spare_parameter
_bug30346330_hang_sess_enq_wait_blocked_ 5
session_threshold
_eleventh_spare_parameter
_kswsas_pdb_auto_close_timeout 600
_thirteenth_spare_parameter
_fourteenth_spare_parameter
_bug30186319_lm_hb_lgio_timeout 70
_bug30352623_asm_enable_vfreloc_on_rm 0
_bug30346330_hang_sess_enq_wait_resltn_t 0
rig_time
_bug28322973_asm_ownerid_trace_timeout 600
_nineteenth_spare_parameter
_twentieth_spare_parameter
_twenty-first_spare_parameter
_bug29290173_securefiles_dealloc_cfs 0
_twenty-third_spare_parameter
_twenty-fourth_spare_parameter
_twenty-fifth_spare_parameter
_twenty-sixth_spare_parameter
_twenty-seventh_spare_parameter
_twenty-eighth_spare_parameter
_twenty-ninth_spare_parameter
_thirtieth_spare_parameter
_thirty-first_spare_parameter
_thirty-second_spare_parameter
_thirty-third_spare_parameter
_thirty-fourth_spare_parameter
_thirty-fifth_spare_parameter
_thirty-sixth_spare_parameter
_thirty-seventh_spare_parameter
_thirty-eighth_spare_parameter
_thirty-ninth_spare_parameter
_fortieth_spare_parameter
_forty-first_spare_parameter
_forty-second_spare_parameter
_forty-third_spare_parameter
_forty-fourth_spare_parameter
_forty-fifth_spare_parameter
_forty-sixth_spare_parameter
_forty-seventh_spare_parameter
_forty-eighth_spare_parameter
_forty-ninth_spare_parameter
_fiftieth_spare_parameter
_fifty-first_spare_parameter
_fifty-second_spare_parameter
_fifty-third_spare_parameter
_fifty-fourth_spare_parameter
_fifty-fifth_spare_parameter
_fifty-sixth_spare_parameter
_fifty-seventh_spare_parameter
_fifty-eighth_spare_parameter
_fifty-ninth_spare_parameter
_sixtieth_spare_parameter
_sixty-first_spare_parameter
_sixty-second_spare_parameter
_sixty-third_spare_parameter
_sixty-fourth_spare_parameter
_sixty-fifth_spare_parameter
_sixty-sixth_spare_parameter
_sixty-seventh_spare_parameter
_sixty-eighth_spare_parameter
_sixty-ninth_spare_parameter
_seventieth_spare_parameter
_seventy-first_spare_parameter
_seventy-second_spare_parameter
_seventy-third_spare_parameter
_seventy-fourth_spare_parameter
_seventy-fifth_spare_parameter
_seventy-sixth_spare_parameter
_seventy-seventh_spare_parameter
_seventy-eighth_spare_parameter
_seventy-ninth_spare_parameter
_eightieth_spare_parameter
optimizer_session_type NORMAL
_eighty-second_spare_parameter
_eighty-third_spare_parameter
_bug30196629_dbopen_breakpoint none
_eighty-fifth_spare_parameter
_eighty-sixth_spare_parameter
_eighty-seventh_spare_parameter
_eighty-eighth_spare_parameter
_eighty-ninth_spare_parameter
_ninetieth_spare_parameter
_ninety-first_spare_parameter
_ninety-second_spare_parameter
_ninety-third_spare_parameter
_ninety-fourth_spare_parameter
_ninety-fifth_spare_parameter
_ninety-sixth_spare_parameter
_ninety-seventh_spare_parameter
_ninety-eighth_spare_parameter
_ninety-ninth_spare_parameter
_one-hundredth_spare_parameter
_one-hundred-and-first_spare_parameter
_one-hundred-and-second_spare_parameter
_one-hundred-and-third_spare_parameter
_one-hundred-and-fourth_spare_parameter
_one-hundred-and-fifth_spare_parameter
_one-hundred-and-sixth_spare_parameter
_one-hundred-and-seventh_spare_parameter
_one-hundred-and-eighth_spare_parameter
_one-hundred-and-ninth_spare_parameter
_one-hundred-and-tenth_spare_parameter
_one-hundred-and-eleventh_spare_paramete
r
_one-hundred-and-twelfth_spare_parameter
_one-hundred-and-thirteenth_spare_parame
ter
_one-hundred-and-fourteenth_spare_parame
ter
_one-hundred-and-fifteenth_spare_paramet
er
_one-hundred-and-sixteenth_spare_paramet
er
_one-hundred-and-seventeenth_spare_param
eter
_one-hundred-and-eighteenth_spare_parame
ter
_one-hundred-and-nineteenth_spare_parame
ter
_one-hundred-and-twentieth_spare_paramet
er
_one-hundred-and-twenty-first_spare_para
meter
_one-hundred-and-twenty-second_spare_par
ameter
_one-hundred-and-twenty-third_spare_para
meter
_one-hundred-and-twenty-fourth_spare_par
ameter
_one-hundred-and-twenty-fifth_spare_para
meter
_one-hundred-and-twenty-sixth_spare_para
meter
_one-hundred-and-twenty-seventh_spare_pa
rameter
_one-hundred-and-twenty-eighth_spare_par
ameter
_one-hundred-and-twenty-ninth_spare_para
meter
_one-hundred-and-thirtieth_spare_paramet
er
ignore_session_set_param_errors
_one-hundred-and-thirty-second_spare_par
ameter
_one-hundred-and-thirty-third_spare_para
meter
_one-hundred-and-thirty-fourth_spare_par
ameter
_one-hundred-and-thirty-fifth_spare_para
meter
_one-hundred-and-thirty-sixth_spare_para
meter
_one-hundred-and-thirty-seventh_spare_pa
rameter
_one-hundred-and-thirty-eighth_spare_par
ameter
_one-hundred-and-thirty-ninth_spare_para
meter
_one-hundred-and-fortieth_spare_paramete
r
_grant_unlimited_tablespace_role FALSE
_disable_inheritpriv_grant_public FALSE
_bug29274428_modsvc_call_out_enabled FALSE
_bug29394014_allow_triggers_on_vpd_table FALSE
_bug29386835_enable_per_container_acl FALSE
_bug29302220_tcpinfo_statistics_save_ate FALSE
xit
_one-hundred-and-forty-seventh_spare_par FALSE
ameter
_one-hundred-and-forty-eighth_spare_para FALSE
meter
_one-hundred-and-forty-ninth_spare_param FALSE
eter
_one-hundred-and-fiftieth_spare_paramete FALSE
r
_one-hundred-and-fifty-first_spare_param FALSE
eter
_one-hundred-and-fifty-second_spare_para FALSE
meter
_bug29903454_ksws_enable_alb TRUE
_enable_ptime_update_for_sys FALSE
_bug30224950_kjac_direct_path_enabled TRUE
_path_prefix_create_dir TRUE
_one-hundred-and-fifty-seventh_spare_par FALSE
ameter
_one-hundred-and-fifty-eighth_spare_para FALSE
meter
_pdb_datapatch_violation_restricted FALSE
_link_ts_force_online TRUE
_one-hundred-and-sixty-first_spare_param FALSE
eter
_bug30382982_keep_relocated_source_pdb FALSE
_bug30316897_allow_fallback_to_dbkey FALSE
_bigdata_offload_flag FALSE
_cell_offload_vector_groupby_external TRUE
_kks_always_check_bind_equivalence FALSE
_one-hundred-and-sixty-seventh_spare_par FALSE
ameter
_one-hundred-and-sixty-eighth_spare_para FALSE
meter
_disable_ilm_internal FALSE
_bug30624792_hang_px_resolution_on_asm_e TRUE
nabled
_ignore_svc_name_conv_mismatch FALSE
_one-hundred-and-seventy-second_spare_pa FALSE
rameter
_one-hundred-and-seventy-third_spare_par FALSE
ameter
_one-hundred-and-seventy-fourth_spare_pa FALSE
rameter
_one-hundred-and-seventy-fifth_spare_par FALSE
ameter
_one-hundred-and-seventy-sixth_spare_par FALSE
ameter
_one-hundred-and-seventy-seventh_spare_p FALSE
arameter
_one-hundred-and-seventy-eighth_spare_pa FALSE
rameter
_one-hundred-and-seventy-ninth_spare_par FALSE
ameter
_one-hundred-and-eightieth_spare_paramet FALSE
er
_one-hundred-and-eighty-first_spare_para FALSE
meter
_one-hundred-and-eighty-second_spare_par FALSE
ameter
_one-hundred-and-eighty-third_spare_para FALSE
meter
_one-hundred-and-eighty-fourth_spare_par FALSE
ameter
_one-hundred-and-eighty-fifth_spare_para FALSE
meter
_one-hundred-and-eighty-sixth_spare_para FALSE
meter
_one-hundred-and-eighty-seventh_spare_pa FALSE
rameter
_one-hundred-and-eighty-eighth_spare_par FALSE
ameter
_one-hundred-and-eighty-ninth_spare_para FALSE
meter
_one-hundred-and-ninetieth_spare_paramet FALSE
er
_one-hundred-and-ninety-first_spare_para FALSE
meter
_one-hundred-and-ninety-second_spare_par FALSE
ameter
_one-hundred-and-ninety-third_spare_para FALSE
meter
_one-hundred-and-ninety-fourth_spare_par FALSE
ameter
_one-hundred-and-ninety-fifth_spare_para FALSE
meter
_one-hundred-and-ninety-sixth_spare_para FALSE
meter
_one-hundred-and-ninety-seventh_spare_pa FALSE
rameter
_one-hundred-and-ninety-eighth_spare_par FALSE
ameter
_one-hundred-and-ninety-ninth_spare_para FALSE
meter
_two-hundredth_spare_parameter FALSE
_two-hundred-and-first_spare_parameter FALSE
_two-hundred-and-second_spare_parameter FALSE
_two-hundred-and-third_spare_parameter FALSE
_two-hundred-and-fourth_spare_parameter FALSE
_two-hundred-and-fifth_spare_parameter FALSE
_two-hundred-and-sixth_spare_parameter FALSE
_two-hundred-and-seventh_spare_parameter FALSE
_two-hundred-and-eighth_spare_parameter FALSE
_two-hundred-and-ninth_spare_parameter FALSE
_two-hundred-and-tenth_spare_parameter FALSE
_two-hundred-and-eleventh_spare_paramete FALSE
r
_two-hundred-and-twelfth_spare_parameter FALSE
_two-hundred-and-thirteenth_spare_parame FALSE
ter
_two-hundred-and-fourteenth_spare_parame FALSE
ter
_two-hundred-and-fifteenth_spare_paramet FALSE
er
_two-hundred-and-sixteenth_spare_paramet FALSE
er
_two-hundred-and-seventeenth_spare_param FALSE
eter
_two-hundred-and-eighteenth_spare_parame FALSE
ter
_two-hundred-and-nineteenth_spare_parame FALSE
ter
_two-hundred-and-twentieth_spare_paramet FALSE
er
_ksipc_mode 0
_inet_cluster_interconnects
_ksipc_loopback_ips
_ksipc_service_level
_ksipc_window_size
_ksipc_cksum_level
_ksipc_common_sl
_ksipc_service_mask 1
_ksipc_heap_extent 1048576
_ksipc_mga_segment_size 268435456
_ksipc_group_sz 1024
_ksipcsnsrv
_ipc_aggr_limit_percentage 40
_ksipc_trace_bucket PRIVATE
_ksipc_trace_bucket_size IPC0:1048576-REST:8192
_ksipc_libipc_path
_ksipc_wait_flags 0
_ksipc_spare_param1 0
_ksipc_spare_param2
_ksipc_spare_param3 0
_ksipc_spare_param4 0
_ksipc_spare_param5 0
_ksipc_skgxp_library_path
_ksipc_skgxp_compat_library_path
_ksipc_ipclw_library_path
_ksipc_ipclw_enable_param
_ksipc_ipclw_conn_dump 0
_ksipc_ipclw_cksum_enable 0
_ksipc_ipclw_spare_param1
_ksipc_ipclw_spare_param2
_ksipc_ipclw_spare_param3
_ksipc_ipclw_spare_param4
_ksipc_ipclw_spare_param5
_ksipc_ipclw_spare_param6
_ksipc_ipclw_spare_param7
_ksipc_ipclw_spare_param8
_ksipc_aspc_enabled FALSE
_ksxp_send_timeout 300
_ksxp_ping_enable TRUE
_ksxp_ping_polling_time 0
_ksxp_disable_dynamic_loading FALSE
_ksxp_disable_rolling_migration FALSE
_skgxp_udp_use_tcb TRUE
_ksxp_disable_ipc_stats FALSE
_ksxp_max_stats_bkts 0
_ksxp_init_stats_bkts 0
_ksxp_stats_mem_lmt 0
cluster_interconnects
_rm_cluster_interconnects
_ksxp_disable_clss 0
_ksxp_dump_timeout 20
_ksxp_diagmode OFF
_skgxp_reaping 1000
_ksxp_reaping 50
_ksxp_wait_flags 0
_ksxp_lw_post_flags 0
_ksxp_control_flags 0
_skgxp_udp_hiwat_warn 1000
_skgxp_udp_ach_reaping_time 120
_skgxp_udp_timed_wait_seconds 5
_skgxp_udp_timed_wait_buffering 1024
_skgxp_udp_keep_alive_ping_timer_secs 300
_disable_duplex_link TRUE
_diag_diagnostics TRUE
_disable_interface_checking FALSE
_skgxp_udp_interface_detection_time_secs 60
_skgxp_udp_lmp_on FALSE
_skgxp_udp_lmp_mtusize 0
_skgxp_udp_enable_dynamic_credit_mgmt 0
_skgxp_udp_ack_delay 0
_skgxp_gen_ant_ping_misscount 3
_skgxp_gen_rpc_no_path_check_in_sec 5
_skgxp_gen_rpc_timeout_in_sec 300
_skgxp_gen_ant_off_rpc_timeout_in_sec 30
_skgxp_min_zcpy_len 0
_skgxp_min_rpc_rcv_zcpy_len 0
_skgxp_zcpy_flags 0
_skgxp_ctx_flags1 0
_skgxp_ctx_flags1mask 0
_skgxp_dynamic_protocol 0
_skgxp_inets
_ksxp_skgxp_inets
_skgxp_ant_options
_ksxp_skgxp_ant_options
_skgxp_rgn_ports 0
_ksxp_skgxp_ctx_flags1 0
_ksxp_skgxp_ctx_flags1mask 0
_ksxp_skgxp_dynamic_protocol 4096
_ksxp_skgxp_rgn_ports 0
_ksxp_dynamic_skgxp_param
_ksxp_if_config 0
_ksxp_exa_ip_config 0
_ksxp_ksmsq_ip_config 0
_ksxp_compat_flags 0
_ksxp_spare_param1
_ksxp_validate_cnh_life_cycle 0
_skgxp_spare_param1
_ksxp_skgxp_spare_param1
_skgxp_spare_param2
_ksxp_skgxp_spare_param2
_skgxp_spare_param3
_ksxp_skgxp_spare_param3
_skgxp_spare_param4
_ksxp_xrc_cm_port
_skgxp_spare_param5
_skgxpg_last_parameter 27
_ksxp_skgxpg_last_parameter 27
_ksxp_testing 0
_ksxp_reporting_process LMD0
_ksxp_unit_test_byte_transformation FALSE
_ksxp_ipclw_enabled 1
_ipc_config_opts_stat 0
_ipc_config_opts_dyn 0
_ksipc_efchecks 3
_ksxp_save_sockets 0
_ksxp_save_sockets_pattern *
_ksxp_ipclw_ptswinsz 8
_ksmd_protect_mode off
_ksmd_trace 0
_ksmg_granule_size 16777216
file_mapping FALSE
_filemap_dir
_object_statistics TRUE
_object_stats_max_entries 3072
_datapump_conv_pga_lim 0
_datapump_metadata_buffer_size 131072
_datapump_tabledata_buffer_size 262144
_datapump_compressbas_buffer_size 0
max_datapump_jobs_per_pdb 100
max_datapump_parallel_per_job 50
_datapump_gather_stats_on_load FALSE
service_names TEST
__dg_broker_service_names
_enable_rlb TRUE
_enable_midtier_affinity TRUE
_midtier_affinity_cluswait_prc_threshold 6
_midtier_affinity_goodness_threshold 2000
_service_cleanup_timeout 30
_disable_modsvc_refresh
_max_services 8200
_kswsas_ht_log_size 7
_ksws_java_patching 999
_kswsas_db_svc_mapping
_kswsas_num_jp_slaves 0
_kswsas_drain_kill_batch_size 5
_ksws_goodness_control 1
_kswsas_close_pdb_on_lstsvc TRUE
_enable_plcmnt_pol_usage FALSE
_plcmnt_template_svc_name
_disable_health_check FALSE
threaded_execution FALSE
_mpmt_enabled FALSE
_mpmt_prefer_enabled TRUE
_mpmt_single_process_instance FALSE
_mpmt_procs_per_osp 100
_mpmt_use_fthread FALSE
_mpmt_fthread_mode 0
_prespawn_enabled FALSE
_prespawn_min_count 10
_prespawn_batch_count 20
_prespawn_fg_init_count 0
_prespawn_bg_init_count 0
_proc_grp_enabled 3
_proc_grp_numa_map
_spawn_diag_thresh_secs 30
_spawn_diag_opts 0
_sched_delay_sample_interval_ms 1000
_sched_delay_max_samples 4
_sched_delay_sample_collection_thresh_ms 200
_sched_delay_measurement_sleep_us 1000
_sched_delay_os_tick_granularity_us 16000
_min_time_between_psp0_diag_secs 300
_NUMA_float_spawner FALSE
_accept_versions
_disable_rolling_patch 0
_rolling_patchlevel
_hang_analysis_num_call_stacks 3
_local_hang_analysis_interval_secs 3
_deadlock_resolution_level 1
_deadlock_resolution_incidents_enabled TRUE
_deadlock_resolution_incidents_always FALSE
_deadlock_resolution_min_wait_timeout_se 60
cs
_deadlock_resolution_signal_process_thre 60
sh_secs
_heur_deadlock_resolution_secs 0
_deadlock_diagnostic_level 2
_deadlock_record_to_alert_log TRUE
_blocking_sess_graph_cache_size
_diag_proc_enabled TRUE
_diag_proc_stack_capture_type 1
_diag_proc_max_time_ms 30000
_hang_msg_checksum_enabled TRUE
_kspol_tac_timeout 5
_disable_12751 FALSE
_diskmon_pipe_name
_dskm_health_check_cnt 20
_dskm_single_instance FALSE
_exadata_feature_on FALSE
_ksmb_debug 0
_pmon_enable_dead_blkrs TRUE
_pmon_dead_blkrs_scan_rate_secs 3
_pmon_dead_blkrs_alive_chk_rate_secs 3
_pmon_dead_blkrs_max_cleanup_attempts 5
_pmon_dead_blkrs_max_blkrs 50
_pmon_cleanup_max_dfs 100
_pmon_max_consec_posts 5
_dead_process_scan_interval 60
_main_dead_process_scan_interval 0
_pmon_idle_scan_interval 60
_cleanup_timeout 150
_cleanup_timeout_flags 0
_pmon_min_slaves 0
_pmon_max_slaves 10
_pmon_slaves_arr_size 150
_pmon_trees_per_slave 10
_pmon_new_slave_secs 30
_pmon_slave_stop_secs 60
_pmon_incr_slaves 3
_pmon_exitnfy_enabled FALSE
_use_platform_compression_lib TRUE
_use_platform_encryption_lib TRUE
_use_hybrid_encryption_mode FALSE
_xengem_diagmode OFF
_xengem_devname DEFAULT
_xengem_enabled TRUE
_ksmsq_hintmaxinst 1024
_ksmsq_hintmaxproc 300
_lthread_cleanup_intv_secs 1
_lthread_enabled TRUE
_lthread_debug FALSE
_lthread_max_spawn_time_csecs 12000
_lthread_spawn_check_intv_ms 10
_lthread_clnup_pmon_softkill_wait_secs 1
_lthread_clnup_spawner_sk_wait_secs 30
_lthread_clnup_hk_wait_secs 3
_lthread_step_debugging FALSE
_lthread_idle_timeout_secs 600
clonedb_dir
_maxrpop_files_inst 4
_maxrpop_instances 8
_use_large_pages_for_mga FALSE
_use_fallocate_for_mga FALSE
_mga_large_page_path
_ksgl_max_dyn_latches 1024
_ksgl_ltchs_held_ctxt 8
_ksrma_enabled off
_ksrma_gsm_base_addr
_gsm_pool_size 134217728
enable_dnfs_dispatcher FALSE
_force_cloud_on FALSE
_cloud_service_sim 0
_oracle_employee_testing FALSE
_quarantine_enabled TRUE
_quarantine_max_objs 10000
_quarantine_max_mem 1
_quarantine_per_hour 60
_test_xmem_alloc_size 0
_use_platform_hash_function TRUE
_dbnest_enable NONE
_instance_dbnest_name
_dbnest_pdb_scm_level STRICT1
_dbnest_pdb_fs_type DEFAULT
_dbnest_pdb_fs_conf
_dbnest_pdb_scm_conf
_dbnest_stage_dir
_capability_simulate
_cstats_enabled FALSE
_enable_nvm_dispatcher FALSE
_nvm_dispatchers 3
_nvm_dispatcher_bind_policy 1
_enable_tcpinfo_statistics 238
_session_fast_lrg_prediction FALSE
_session_prediction_interval 10080
_session_use_periodic_prediction TRUE
_session_use_linear_prediction TRUE
_session_save_prediction FALSE
_session_max_pred_increase 20000
_connect_string_params_after_logon_trigg 0
ers
_connect_string_params_unalterable 0
_workload_attributes_spare_param 0
_workload_attributes
_diag_daemon TRUE
_dump_system_state_scope local
_dump_trace_scope global
_dump_interval_limit 120
_dump_max_limit 5
_diag_dump_timeout 30
_diag_dump_request_debug_level 1
_diag_crashdump_level 10
_full_diag_on_rim FALSE
_diag_large_packets TRUE
_hang_detection_enabled TRUE
_hang_deadlock_resolution_enabled TRUE
_hang_cross_boundary_hang_detection_enab TRUE
led
_hang_cross_cluster_hang_detection_enabl TRUE
ed
_hang_asm_hang_resolution_enabled FALSE
_hang_application_hang_resolution_enable FALSE
d
_hang_singleton_detection_rw_enabled FALSE
_hang_singleton_resolution_rw_enabled FALSE
_hang_trace_interval 32
_hang_root_ha_phase_trigger_time 300
_hang_hung_session_ewarn_percent 34
_hang_max_session_hang_time 96
_hang_hang_blocked_session_delta_percent 20
_threshold
_hang_blocked_session_percent_threshold 0
_hang_ft_min_degrading_samples_percent_t 60
hreshold
_hang_resolution_scope OFF
_hang_allow_resolution_on_single_nonrac FALSE
_hang_max_instance_allow_node_eviction 1
_hang_resolution_policy HIGH
_hang_resolution_confidence_promotion FALSE
_hang_resolution_global_hang_confidence_ FALSE
promotion
_hang_resolution_allow_archiving_issue_t TRUE
ermination
_hang_resolution_promote_process_termina TRUE
tion
_hang_promote_process_termination_interv 70
al
_hang_resolution_percent_hung_sessions_t 300
hreshold
_hang_resolution_percent_hung_sessions_t 5000
hreshold2
_hang_signature_list_match_output_freque 10
ncy
_hang_hang_analyze_output_hang_chains TRUE
_hang_short_stacks_output_enabled TRUE
_hm_analysis_oradebug_sys_dump_level 0
_global_hang_analysis_interval_secs 10
_hang_verification_interval 46
_hang_intersecting_chains_scanning_enabl TRUE
ed
_hang_log_verified_hangs_to_alert FALSE
_hang_log_io_hung_sessions_to_alert FALSE
_hang_log_important_hangs_to_alert TRUE
_hang_appl_issue_session_threshold 0
_hang_ignored_hangs_interval 300
_hang_ignored_hang_count 1
_hang_ignore_hngmtrc_interval 150
_hang_hs_hang_metrics_enabled TRUE
_hang_metrics_recent_bitmap_threshold 50
_hang_metrics_older_bitmap_threshold 25
_hang_monitor_archiving_related_hang_int 300
erval
_hang_hiload_promoted_ignored_hang_count 2
_hang_delay_resolution_for_libcache TRUE
_hang_terminate_session_replay_enabled TRUE
_hang_long_wait_time_threshold 0
_hang_lws_file_count 5
_hang_lws_file_space_limit 100000000
_hang_base_file_count 5
_hang_base_file_space_limit 100000000
_hang_running_in_lrg FALSE
_hang_mark_some_idle_waits_terminal FALSE
_hang_bool_spare2 TRUE
_hang_int_spare1 0
_hang_int_spare2 0
_hang_hiprior_session_attribute_list
_hang_enable_processstate TRUE
_hang_enable_nodeeviction TRUE
_diag_xm_enabled FALSE
_hm_xm_enabled TRUE
_trace_navigation_scope global
_max_protocol_support 10000
_lm_check_ges_resource 0
_lm_optmode_switch 0
_lm_hash_control 1
_lm_lms 0
gcs_server_processes 0
_lm_dynamic_lms FALSE
_lm_max_lms 0
_ges_server_processes 1
_lm_activate_lms_threshold 100
_lm_lmd_waittime 8
_lm_lms_waittime 3
_lm_procs 1088
_lm_lms_priority_dynamic TRUE
_lm_lms_rt_threshold
_lm_lms_opt_priority TRUE
_lm_lms_priority_check_frequency 60000
_lm_db_rank 6
_lm_db_ranks
_lm_ress 6000
_lm_locks 12000
_lm_master_weight 1
active_instance_count
_active_instance_count
_active_standby_fast_reconfiguration TRUE
_lm_enq_rcfg TRUE
_lm_asm_enq_hashing TRUE
_lm_xids 1196
_lm_res_part 128
_lm_drm_window 0
_lm_drm_max_requests 100
_lm_drm_xlatch 0
_lm_drm_disable 0
_lm_drm_disable_kjfc FALSE
_lm_contiguous_res_count 128
_lm_num_pt_buckets 8192
_lm_num_pt_latches 128
_lm_node_join_opt FALSE
_lm_no_sync TRUE
_lm_non_fault_tolerant FALSE
_lm_cache_res_cleanup 25
_lm_cache_allocated_res_ratio 50
_lm_cache_res_skip_cleanup 20
_lm_cache_res_cleanup_tries 10
_lm_cache_res_type TMHWHVDI
_lm_cache_enqueue
_lm_reloc_use_mhint FALSE
_lm_cache_lvl0_cleanup 0
_lm_cache_res_options 0
_ogms_home
_lm_sync_timeout 163
_lm_ticket_active_sendback 50
_lm_rcfg_timeout 489
_lm_rcfg_kjcdump_time 60
_lm_enq_lock_freelist
_lm_enqueue_freelist 3
_lm_dd_interval 10
_lm_dd_scan_interval 5
_lm_dd_search_cnt 3
_lm_dd_max_search_time 180
_lm_dd_maxdump 50
_lm_dd_ignore_nodd FALSE
_lm_enqueue_blocker_dump_timeout 120
_lm_enqueue_blocker_dump_timeout_cnt 30
_lm_enqueue_blocker_kill_timeout 0
_dlmtrace
_lm_tx_delta 16
_lm_proc_freeze_timeout 70
_lm_deferred_msg_timeout 163
_lm_use_new_defmsgtmo_action TRUE
_lm_dump_null_lock FALSE
_lm_file_affinity
_lm_file_read_mostly
_lm_enable_aff_benefit_stats FALSE
_lm_num_bnft_stats_buckets 1
_lm_drm_banned_objs
_lm_drm_max_banned_objs 235
_lm_share_lock_opt TRUE
_lm_share_lock_pdbisolation TRUE
_lm_enq_iso_enabled TRUE
_lm_res_hash_bucket 0
_lm_res_tm_hash_bucket 0
_ges_diagnostics TRUE
_fair_remote_cvt FALSE
_lm_rcvr_hang_check_frequency 20
_lm_rcvr_hang_allow_time 70
_lm_rcvr_hang_kill TRUE
_lm_rcvr_hang_check_system_load TRUE
_lm_rcvr_hang_systemstate_dump_level 0
_lm_rcvr_hang_cfio_kill FALSE
_lm_lmon_nowait_latch TRUE
_ges_dd_debug 1
_lm_global_posts TRUE
_rcfg_parallel_replay TRUE
_parallel_replay_msg_limit 4000
_rcfg_parallel_fixwrite TRUE
_parallel_fixwrite_bucket 1000
_rcfg_parallel_verify FALSE
_rcfg_disable_verify TRUE
_drm_parallel_freeze TRUE
_dump_rcvr_ipc TRUE
_ges_health_check 0
_kill_enqueue_blocker 2
_lm_psrcfg TRUE
_lm_single_inst_affinity_lock FALSE
_lm_preregister_css_restype CF
_inquiry_retry_interval 3
_lm_drm_object_scan TRUE
_lm_spare_threads 0
_lm_spare_undo 0
_lm_rcvinst TRUE
_lm_use_gcr TRUE
_lm_use_tx_tsn TRUE
_lm_local_hp_enq TRUE
_lm_broadcast_res enable_broadcast
_gcs_testing 0
_gcs_pkey_history 16384
_lm_drm_we_size 2000
_lm_drm_we_interval 60
_read_mostly_instance FALSE
_read_mostly_instance_qa_control 0
_read_mostly_slave_timeout 20
_read_only_slave_timeout 30
_read_mostly_enable_logon FALSE
_ges_designated_master TRUE
_lm_big_cluster_optimizations TRUE
_ges_lmd_mapping *
_ges_hash_groups *
_ges_default_lmds *
_ges_nres_divide 0
_lm_lms_spin FALSE
_lm_freeze_kill_time 30
_lm_no_lh_check FALSE
_lm_drmopt12 56
_lm_drm_filters 3
_lm_drm_duration_limit
_lm_drm_duration_limit_type 2
_lm_fdrm_stats FALSE
_lm_drm_filter_history_window
_lm_drm_filter_history_window_type 2
_lm_lhupd_interval 5
_lm_high_load_threshold 5
_lm_high_load_sysload_percentage 90
_lm_low_load_percentage 75
_lm_drm_hiload_percentage 200
_lm_drm_lowload_percentage 200
_lm_drm_min_interval 600
_lm_drm_batch_time 10
_lm_inherited_max_requests 100
_lm_adrm_options 3
_lm_adrm_scan_timeout 50
_lm_adrm_interval 300
_lm_adrm_time_out 120
_lm_enqueue_timeout 360
_lm_resend_open_convert_timeout 30
_lm_process_lock_q_scan_limit 100
_ges_direct_free FALSE
_ges_resource_memory_opt 4
_ges_gather_res_reuse_stats FALSE
_ges_direct_free_res_type
_lm_domain_hash_buckets 64
_ges_fggl TRUE
_ges_freeable_res_chunk_free FALSE
_ges_freeable_res_chunk_free_interval 180
_lm_share_lock_restype
_lm_nonisolated_restype TOTTUL
_ges_dump_open_locks FALSE
_lm_exadata_fence_type TRUE
_rond_test_mode 0
instance_mode READ-WRITE
_lm_pdb_domains_enable 7
_lm_singleton_pdb_opt TRUE
_lm_uid_default_lookup_value TRUE
_lm_enable_translation FALSE
_lm_chk_inv_domenq_ops TRUE
_lm_rm_object_bypass TRUE
_cluster_instances_number 4
_reconfiguration_opt_level 109
_lm_lazy_recovery_member_timeout 300
_lm_lazy_domain_timeout 600
_enqueue_scan_interval 0
_parallel_lmd_reconfig 1
_rac_dbtype_reset FALSE
_lm_recovery_set 1
_reader_farm_isolation_enable FALSE
_reader_farm_isolation_time_threshold 200
_lm_wait_for_hub_rcv_timeout 300000
_lm_pdb_wait_all_gone FALSE
_lm_rcvinst_sga_threshold 85
_lm_rcvinst_atp_opt TRUE
_adg_distributed_lockmaster FALSE
_ges_mseq_demo 0
__maintenance_is_planned 0
_defer_while_patching 0
_lm_dynamic_sga_target
_lm_better_ddvictim TRUE
_kjdd_call_stack_dump_enabled FALSE
_kjdd_wfg_dump_cntrl 0
_dd_validate_remote_locks TRUE
_omni_enqueue_enable 1
_lm_omni_ack_timeout 60
_dlm_stats_collect 1
_dlm_stats_collect_mode 6
_dlm_stats_collect_slot_interval 60
_dlm_stats_collect_du_limit 3000
_dlm_cache_warmup_slaves 2
_lm_msg_batch_size 0
_lm_tickets 1000
_lm_ticket_min 50
_lm_msg_cleanup_interval 3000
_lm_throttle_time_interval 60
_lm_idle_connection_check TRUE
_lm_idle_connection_load_check TRUE
_lm_idle_connection_check_interval 140
_lm_idle_connection_kill TRUE
_lm_idle_connection_kill_max_skips 1
_lm_idle_connection_instance_check_callo TRUE
ut
_lm_idle_connection_quorum_threshold 50
_lm_idle_connection_action kill
_lm_send_mode auto
_lm_postevent_buffer_size 256
_lm_msg_pool_dump_threshold 20000
_lm_msg_pool_user_callstack_dump FALSE
_lm_num_msg_pools_per_type 1
_lm_ticket_check_inject FALSE
_lm_ticket_low_limit_warning 10
_lm_kill_fg_on_timeout TRUE
_lm_idle_connection_max_ignore_kill_coun 2
t
_lm_send_queue_length 5000
_lm_send_queue_batching TRUE
_lm_process_batching TRUE
_lm_sq_batch_factor 2
_lm_sq_batch_type auto
_lm_sq_batch_waittick 3
_lm_sendproxy_reserve 25
_lm_checksum_batch_msg 0
_lm_batch_compression_threshold 0
_lm_compression_scheme zlib
_lm_validate_pbatch FALSE
_lm_watchpoint_maximum 3
_lm_watchpoint_timeout 3600
_lm_free_queue_threshold 0
_lm_mp_avail_queue_threshold 0
_lm_mp_bulk_mbuf_free FALSE
_lm_mp_latch_trigger 4000
_lm_mp_latch_trigger_soft 40000
_lm_wait_pending_send_queue TRUE
_lm_hashtable_bkt_low 3
_lm_hashtable_bkt_high 5
_lm_hashtable_bkt_thr 70
_lm_comm_tkts_adaptive TRUE
_lm_comm_tkts_calc_period_length 1000
_lm_comm_tkts_max_periods 10
_lm_comm_tkts_min_increase_wait 10
_lm_comm_tkts_min_decrease_wait 120
_lm_comm_tkts_nullreq_threshold 1
_lm_comm_tkts_mult_factor 1
_lm_comm_tkts_sub_factor 10
_lm_comm_tkts_max_add 5
_lm_comm_msgq_fixed_buffers FALSE
_lm_comm_msgq_copy_buffers FALSE
_lm_comm_msgq_bufr_multiple 8
_lm_comm_channel msgq
_lm_comm_msgq_busywait 0
_lm_comm_reap_count 1
_lm_comm_slow_op_stat_dump_threshold 5
_lm_comm_slow_op_loop_threshold 15
_lm_comm_rcv_msg_history_slots 50
_lm_comm_sync_seq_on_send_failure TRUE
_lm_tkt_leak_check_count 5
_lm_tkt_leak_check_seconds 300
_lm_gl_hash_scheme 1
_abort_recovery_on_join FALSE
_send_ast_to_foreground AUTO
_reliable_block_sends TRUE
_blocks_per_cache_server 16
_object_reuse_bast 2
_cluster_flash_cache_slave_file
_cluster_flash_cache_slave_size 0
__persistent_cl2_slave_size 0
_gcs_trace_bucket FALSE
_gcs_trace_bucket_size LMS:1048576-RMV:1048576-CRV:10
48576-DBW:524288
_lms_rollbacks 1000
_gcs_enable_private_iterator TRUE
_rf_blocks_per_entity 5
_gcs_cluster_flash_cache_persistency FALSE
_gcs_track_reliable_block_sends FALSE
_gcs_freelists_alloc_percent 0
_send_close_with_block TRUE
_gcs_fast_reconfig TRUE
_cr_grant_global_role TRUE
_cr_grant_local_role AUTO
_cr_grant_only FALSE
_skip_assume_msg TRUE
_gcs_resources 0
_gcs_latches 128
_gcs_process_in_recovery TRUE
_scatter_gcs_resources FALSE
_gcs_res_per_bucket 4
_gcs_res_hash_buckets
_gcs_reserved_resources 400
_gcs_cr_master_ping_remote TRUE
_cr_multiblock_grant_only FALSE
_gcs_partial_open_mode 0
_gcs_dynamic_sga FALSE
_gcs_integrity_checks 1
_gcs_shadow_locks 0
_scatter_gcs_shadows FALSE
_gcs_disable_remote_handles FALSE
_gcs_disable_skip_close_remastering FALSE
_gcs_min_slaves 0
_gcs_min_cr_slaves 0
_gcs_dynamic_slaves TRUE
_gcs_reserved_shadows 400
_gcs_crslave_longq_cnt 2000
_gcs_crslave_longq_us 1000
_gcs_crslave_check_time 10
_gcs_recoverable_asserts 1
_gcs_lsr_frequency 60
_gcs_disable_imc_preallocation FALSE
_side_channel_batch_size 240
_side_channel_batch_timeout 6
_side_channel_batch_timeout_ms 500
_broadcast_scn_wait_timeout 10
_broadcast_scn_mode 1
_hb_redo_msg_interval 100
_master_direct_sends 63
_read_mostly_lock_mitigation TRUE
_nameservice_consistency_check TRUE
_nameservice_request_batching TRUE
_cgs_send_timeout 300
_cgs_ticket_sendback 50
_cgs_msg_batch_size 4096
_cgs_msg_batching TRUE
_cgs_comm_readiness_check 1
_imr_active TRUE
_imr_max_reconfig_delay 75
_imr_splitbrain_res_wait 0
_imr_disk_voting_interval 3
_imr_systemload_check TRUE
_imr_device_type controlfile
_imr_highload_threshold
_imr_evicted_member_kill TRUE
_imr_evicted_member_kill_wait 20
_imr_avoid_double_voting TRUE
_imr_diskvote_implementation auto
_imr_extra_reconfig_wait 10
_imr_controlfile_access_wait_time 10
_imr_rr_holder_kill_time 300
_imr_check_css_incarnation_number TRUE
_imr_rim_mount_device FALSE
_imr_largest_hub_membership TRUE
_imr_non_blocking_device_driver TRUE
_imr_dd_slave_wait_time 30
_imr_mount_retry_wait_time 20
_imr_remount_retry_wait_time 60
_cluster_library clss
_cgs_reconfig_timeout 0
_cgs_node_kill_escalation TRUE
_cgs_node_kill_escalation_wait 0
_cgs_zombie_member_kill_wait 20
_cgs_reconfig_extra_wait 3
_cgs_health_check_in_reconfig FALSE
_cgs_memberkill_from_rim_instance FALSE
_cgs_os_level_connection_check 1
_cgs_os_level_connection_reqno 0
_cgs_os_level_connection_dynamicthread TRUE
_cgs_combine_css_events 7
_cgs_publish_netinfo_collect_event_haip TRUE
_cgs_publish_netinfo_collect_event_chm rcfg-half-timeout,rcfg-timeout
,rcfg-done,idleconn-half-timeo
ut,idleconn-timeout-imr,idleco
nn-cln
_cgs_tickets 1000
_cgs_dball_group_registration local
_cgs_dbgroup_poll_time 600
_cgs_allgroup_poll_time 20000
_cgs_big_group_enabled FALSE
_cgs_support_rim_disc TRUE
_ipc_switch_reconfig_needed FALSE
_lm_dynamic_load TRUE
_lm_rm_slaves 1
_lm_sp_slaves 0
_lm_timed_statistics_level 0
_shutdown_sync_enable TRUE
_lm_lms_no_yield FALSE
_lm_max_lms_block_time 5
_lm_sndq_flush_int 5
_lm_watchpoint_kjmddp
_rmv_dynamic_priority TRUE
_lm_use_us_timer FALSE
_notify_crs FALSE
_crs_2phase bypass
_kill_diagnostics_timeout 60
_ges_diagnostics_asm_dump_level 11
_ges_num_blockers_to_kill 1
_ges_vbfreelists 0
_lm_hb_callstack_collect_time 5
_lm_hb_callstack_collect_time_long 60
_lm_hb_disable_check_list ARC*
_lm_hb_enable_acl_check TRUE
_lm_hb_acceptable_hang_condition default
_lm_hb_maximum_hang_report_count 20
_lm_hb_exponential_hang_time_factor 2
_lm_hb_cfio_timeout 70
_lm_hb_per_proc_timeout default
_lm_hb_per_proc_behavior default
_lm_hb_timeout_extension
_lm_hwc_disabled FALSE
_lmhb_procstate_dump_runtime_limit 60
_lmhb_procstate_dump_cputime_limit 60
_hang_statistics_collection_interval 15
_hang_statistics_collection_ma_alpha 30
_hang_statistics_high_io_percentage_thre 25
shold
_gcr_enable_high_cpu_kill FALSE
_gcr_enable_high_memory_kill FALSE
_gcr_enable_high_cpu_rm TRUE
_gcr_enable_high_cpu_rt TRUE
_gcr_high_cpu_threshold 10
_gcr_high_memory_threshold 10
_gcr_min_free_memory_hard_limit 1073741824
_gcr_cpu_min_hard_limit 2560
_gcr_cpu_min_free 10
_gcr_mem_min_free 10
_gcr_use_css TRUE
_gcr_css_use_2group_lock TRUE
_gcr_css_group_try_lock_delay
_gcr_css_group_query_boost
_gcr_css_group_update_interval
_gcr_css_group_update2_interval
_gcr_css_group_large
_gcr_tick
_gcr_enable_statistical_cpu_check TRUE
_gcr_enable_new_drm_check FALSE
_gcr_max_rt_procs
_gcr_enable_kill_inst_diags FALSE
_increase_lms_process 0
_size_of_log_table 30
_size_of_status_table 100
_gcr_dump_cpu_consumers FALSE
_gcr_cpu_consumer_dump_level 0
_kjac_force_outcome_current_session FALSE
_lm_rac_spare_p1 0
_lm_rac_spare_p2 0
_lm_rac_spare_p3 0
_lm_rac_spare_p4 0
_lm_rac_spare_p5 0
_lm_rac_spare_p6
_lm_rac_spare_p7
_lm_rac_spare_p8
_lm_rac_spare_p9
_lm_rac_spare_p10
_lm_rac_spare_dp1 0
_lm_rac_spare_dp2 0
_lm_rac_spare_dp3 0
_lm_rac_spare_dp4 0
_lm_rac_spare_dp5 0
_lm_rac_spare_dp6
_lm_rac_spare_dp7
_lm_rac_spare_dp8
_lm_rac_spare_dp9
_lm_rac_spare_dp10
_lm_rac_spare_p11 0
_lm_rac_spare_p12 0
_lm_rac_spare_p13 0
_lm_rac_spare_p14
_lm_rac_spare_p15
_lm_rac_spare_p16
_ka_enabled FALSE
_ka_mode 0
_ka_locks_per_sector 4
_ka_msg_reap_count 40
_ka_compatibility_requirement all
_ka_allow_reenable FALSE
_ka_pbatch_messages TRUE
_ka_doorbell 0
_ka_scn_enabled FALSE
_ka_scn_accel_shrmem TRUE
_ka_scn_use_ka_msgs TRUE
_ka_grant_policy AUTO
_ka_msg_wait_count 20
_ka_max_wait_delay 1000
_kjlton FALSE
_kjltmaxgt 1000
_kjltmaxht 1000
_ipddb_enable FALSE
_gcs_cluster_flash_cache_mode 0
_gcs_flash_cache_mode 0
_node_instcnt_average_interval 1800
_node_instcnt_sample_frequency 60
_node_instcnt_update_frequency 300
_high_priority_node_instcnt_cap FALSE
sga_target 1610612736
__sga_target 1610612736
memory_target 0
memory_max_target 0
_disable_streams_pool_auto_tuning FALSE
_sga_shrink_allow FALSE
_sga_grow_batch_size 2147483648
_memory_management_tracing 0
_memory_mgmt_immreq_timeout 150
_memory_checkinuse_timeintv 30
_memory_mgmt_fail_immreq FALSE
_memory_sanity_check 0
_init_granule_interval 10
_shared_pool_max_size 0
_shared_pool_minsize_on FALSE
_streams_pool_max_size 0
_simulate_mem_transfer FALSE
_memory_nocancel_defsgareq FALSE
_memory_imm_mode_without_autosga TRUE
_max_defer_gran_xfer_atonce 10
_asm_allow_small_memory_target FALSE
_memory_broker_stat_interval 30
_automemory_broker_interval 3
_memory_broker_shrink_heaps 15
_memory_broker_shrink_java_heaps 900
_memory_broker_shrink_streams_pool 900
_memory_broker_shrink_timeout 60000000
_memory_broker_log_stat_entries 5
_memory_initial_sga_split_perc 60
_memory_broker_marginal_utility_sp 7
_memory_broker_marginal_utility_bc 12
_memory_broker_sga_shrink_chunked TRUE
_memory_broker_sga_shrink_chunk_size 20
_memory_broker_sga_grow_split TRUE
_memory_broker_sga_grow_splitif_size 20
_dump_scn_increment_stack
_big_scn_test_mode 2
control_files /oracle/oradata/TEST/control01
.ctl, /oracle/oradata/TEST/con
trol02.ctl
_controlfile_enqueue_timeout 900
_controlfile_enqueue_holding_time 120
_controlfile_enqueue_holding_time_tracki 0
ng_size
_controlfile_update_check OFF
_controlfile_enqueue_dump FALSE
_controlfile_block_size 0
_controlfile_section_init_size
_controlfile_section_max_expand
db_file_name_convert
log_file_name_convert
control_file_record_keep_time 7
_kill_controlfile_enqueue_blocker TRUE
_controlfile_backup_copy_check TRUE
_controlfile_cell_flash_caching 3
_controlfile_split_brain_check TRUE
_controlfile_auto_convert_behaviour AUTO_CONVERT
_controlfile_verify_on_mount FALSE
db_block_buffers 0
_db_block_buffers 131186
_db_block_cache_protect false
_db_block_cache_protect_internal 0
db_block_checksum TYPICAL
db_ultra_safe OFF
db_block_size 8192
_dbwr_tracing 0
_tsenc_tracing 0
_disable_multiple_block_sizes FALSE
_db_fast_obj_truncate TRUE
_db_fast_obj_ckpt TRUE
_enable_obj_queues TRUE
_db_obj_enable_ksr TRUE
_small_table_threshold 2623
_very_large_object_threshold 500
_dbwr_async_io TRUE
_recovery_percentage 50
_db_lost_write_checking 2
_db_lost_write_tracing FALSE
__db_cache_size 1124073472
db_cache_size 0
_db_block_numa 1
db_2k_cache_size 0
db_4k_cache_size 0
db_8k_cache_size 0
db_16k_cache_size 0
db_32k_cache_size 0
db_keep_cache_size 0
db_recycle_cache_size 0
memoptimize_pool_size 0
__shared_io_pool_size 83886080
_shared_io_pool_size 83886080
_db_hot_block_tracking FALSE
_db_block_bad_write_check FALSE
db_big_table_cache_percent_target 0
_db_full_db_cache_diff_pct 5
_db_cache_xmem_size 0
__db_cache_xmem_size_metadata 0
_db_keep_cache_xmem_size 0
__db_keep_cache_xmem_size_metadata 0
_db_recycle_cache_xmem_size 0
__db_recycle_cache_xmem_size_metadata 0
_db_2k_cache_xmem_size 0
__db_2k_cache_xmem_size_metadata 0
_db_4k_cache_xmem_size 0
__db_4k_cache_xmem_size_metadata 0
_db_8k_cache_xmem_size 0
__db_8k_cache_xmem_size_metadata 0
_db_16k_cache_xmem_size 0
__db_16k_cache_xmem_size_metadata 0
_db_32k_cache_xmem_size 0
__db_32k_cache_xmem_size_metadata 0
_memoptimize_xmem_pool_size 0
__memoptimize_xmem_pool_size_metadata 0
encrypt_new_tablespaces CLOUD_ONLY
_disable_system_tablespaces_enc_enforcem FALSE
ent
_cell_object_expiration_hours 24
_db_block_lru_latches 9
_db_percpu_create_cachesize 2
_db_initial_cachesize_create_mb 256
_db_num_evict_waitevents 64
_db_todefer_cache_create TRUE
_db_minimum_auxsize_percent 10
_db_imoltp_hashidx_force_nonctg 0
db_writer_processes 1
_db_block_known_clean_pct 2
_db_block_max_scan_pct 40
_db_large_dirty_queue 25
_db_writer_max_writes 0
_db_writer_chunk_writes 0
_db_block_med_priority_batch_size 0
_db_block_hi_priority_batch_size 0
_db_writer_histogram_statistics FALSE
_dbwr_scan_interval 300
_db_writer_flush_imu TRUE
_db_writer_coalesce_write_limit 131072
_db_writer_coalesce_encrypted_buffers TRUE
_db_writer_coalesce_area_size 4194304
_db_writer_nomemcopy_coalesce FALSE
_selftune_checkpoint_write_pct 3
_db_writer_verify_writes FALSE
_dbwr_stall_write_detection_interval 900
_dbwr_flashlock_shrink_limit 0
_enable_dbwr_auto_tracing 0
_dbwr_nowrite_assert_interval 7200
_dbwr_nwp_assert_interval 1800
_remessage_dbwrs 0
_db_block_prefetch_quota 10
_db_block_prefetch_wasted_threshold_perc 2
_db_block_prefetch_limit 0
_db_block_prefetch_override 0
_rbr_ckpt_tracing 0
_db_cache_pre_warm TRUE
buffer_pool_keep
buffer_pool_recycle
_db_percent_hot_default 50
_db_percent_hot_keep 0
_db_percent_hot_recycle 0
_db_aging_hot_criteria 2
_db_xmem_hot_switch_criteria 4
_db_aging_stay_count 0
_db_aging_cool_count 1
_db_aging_touch_time 3
_db_aging_freeze_cr FALSE
_db_block_hash_buckets 524288
_db_block_hash_latches 4096
_db_blocks_per_hash_latch
_db_handles_cached 10
_db_handles 3000
_wait_for_sync TRUE
_db_block_vlm_check FALSE
_db_block_vlm_leak_threshold 4
_db_block_trace_protect FALSE
_db_flash_cache_slow_io_adjustment_inter 3600
val
_db_cache_miss_check_les FALSE
_db_block_max_cr_dba 6
_write_clones 3
_db_cache_silicon_secured_memory TRUE
_check_block_after_checksum FALSE
_trace_pin_time FALSE
_pin_time_statistics FALSE
_db_fast_obj_check FALSE
_db_block_temp_redo FALSE
_db_block_adjchk_level 0
_db_block_adjcheck TRUE
_db_required_percent_fairshare_usage 10
_db_block_check_objtyp TRUE
_db_block_do_full_mbreads FALSE
_shared_iop_max_size 134217728
_shared_io_pool_buf_size 1048576
_siop_flashback_scandepth 20
_shared_io_pool_debug_trc 0
_shared_io_set_value FALSE
_trace_buffer_wait_timeouts 0
_buffer_busy_wait_timeout 100
_influx_scn_wait_timeout 1
_influx_scn_waits 100000
_db_cache_crx_check FALSE
_db_cache_mman_latch_check FALSE
_db_block_cache_history_lru FALSE
_db_flash_cache_encryption FALSE
_db_xmem_cache_encryption TRUE
_db_block_header_guard_level 0
_db_block_table_scan_buffer_size 4194304
_db_cache_process_cr_pin_max 2147483647
_db_block_corruption_recovery_threshold 5
_db_block_chunkify_ncmbr FALSE
_db_cache_wait_debug 0
_db_full_caching TRUE
_fastpin_enable 1
_bps_sanity_checks FALSE
_db_prefetch_histogram_statistics FALSE
_flush_undo_after_tx_recovery TRUE
_enable_buffer_header_history TRUE
_db_block_iterations_for_rm 2000
_db_block_scandepth_for_rm 20
_spare_test_parameter 0
db_flash_cache_file
db_flash_cache_size 0
_db_2k_flash_cache_file
_db_2k_flash_cache_size 0
_db_4k_flash_cache_file
_db_4k_flash_cache_size 0
_db_8k_flash_cache_file
_db_8k_flash_cache_size 0
_db_16k_flash_cache_file
_db_16k_flash_cache_size 0
_db_32k_flash_cache_file
_db_32k_flash_cache_size 0
_db_flash_cache_keep_limit 80
_db_flash_cache_write_limit 1
_db_flash_cache_force_replenish_limit 8
_db_l2_tracing 0
_db_flash_cache_max_read_retry 3
_db_flash_cache_max_latency 400
_db_flash_cache_max_slow_io 3
_db_flash_cache_max_outstanding_writes 32
_db_flash_cache_disable_write_batchsize 4096
_db_dump_from_disk_and_efc 0
_numa_buffer_cache_stats 0
_switch_current_scan_scn TRUE
_cleanout_shrcur_buffers TRUE
_avoid_scn_growth 1
_fast_cr_clone TRUE
_clone_during_split TRUE
_db_cache_block_read_stack_trace 0
_child_read_ahead_dba_check FALSE
_data_warehousing_scan_buffers TRUE
_data_warehousing_scan_flash_buffers FALSE
_data_warehousing_serial_scan TRUE
_db_dw_scan_obj_cooling_policy CACHE_SIZE
_db_dw_scan_obj_cooling_interval 100
_db_dw_scan_obj_cooling_factor 500
_db_dw_scan_obj_warming_increment 1000
_db_dw_scan_adaptive_cooling FALSE
_db_dw_scan_max_shadow_count 5
_pq_numa_working_set_affinity TRUE
_db_bt_cache_only_readmostly_obj_on_roi FALSE
_auto_bmr_noretry_window 1800
_sga_clear_dump FALSE
_clear_buffer_before_reuse FALSE
_disable_adp_adj_buf_check FALSE
_db_cache_block_read_stack_trace_where1 0
_db_cache_block_read_stack_trace_where2 0
_db_cache_block_read_stack_trace_where3 0
_override_datafile_encrypt_check FALSE
_disable_data_block_check_after_decrypt FALSE
_assert_encrypted_tablespace_blocks TRUE
_verify_encrypted_tablespace_keys TRUE
_tablespace_encryption_default_algorithm AES128
_inject_simulated_error_period 131072
db_cache_advice ON
_db_cache_advice_sample_factor 4
_db_cache_advice_max_size_factor 2
_db_cache_advice_sanity_check FALSE
_db_cache_advice_hash_latch_multiple 16
_db_mttr_advice ON
_db_mttr_sim_target
_db_mttr_sample_factor 64
_db_mttr_partitions 0
_db_mttr_sim_trace_size 256
_db_mttr_trace_to_alert FALSE
_obj_ckpt_tracing 0
_immediate_commit_propagation TRUE
_external_scn_rejection_threshold_hours 24
_c3_external_scn_rejection_threshold_hou 4464
rs
_max_reasonable_scn_rate 32768
_external_scn_logging_threshold_seconds 86400
_external_scn_rejection_delta_threshold_ 0
minutes
_low_scn_headroom_warning_threshold_days 90
_high_intrinsic_scn_growth_alert 1440
compatible 19.0.0
_redo_compatibility_check FALSE
_db_block_check_for_debug FALSE
_db_always_check_system_ts TRUE
_skip_unconverted_change_vector FALSE
_log_checkpoint_recovery_check 0
_two_pass TRUE
_recovery_verify_writes FALSE
_disable_recovery_read_skip FALSE
_buddy_instance 1
_buddy_instance_start_rba_timeout 9
_buddy_instance_num_read_buffers 4
_buddy_instance_scan_phase_threshold 3
_instance_recovery_bloom_filter_size 83886080
_instance_recovery_bloom_filter_fprate 0
_fatalprocess_redo_dump_time_limit 0
_nonfatalprocess_redo_dump_time_limit 3600
_redo_transport_stream_writes TRUE
_redo_transport_stream_test TRUE
_redo_transport_vio_size_req 1048576
log_archive_dest_1
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_10
log_archive_dest_11
log_archive_dest_12
log_archive_dest_13
log_archive_dest_14
log_archive_dest_15
log_archive_dest_16
log_archive_dest_17
log_archive_dest_18
log_archive_dest_19
log_archive_dest_20
log_archive_dest_21
log_archive_dest_22
log_archive_dest_23
log_archive_dest_24
log_archive_dest_25
log_archive_dest_26
log_archive_dest_27
log_archive_dest_28
log_archive_dest_29
log_archive_dest_30
log_archive_dest_31
log_archive_dest_state_1 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_dest_state_10 enable
log_archive_dest_state_11 enable
log_archive_dest_state_12 enable
log_archive_dest_state_13 enable
log_archive_dest_state_14 enable
log_archive_dest_state_15 enable
log_archive_dest_state_16 enable
log_archive_dest_state_17 enable
log_archive_dest_state_18 enable
log_archive_dest_state_19 enable
log_archive_dest_state_20 enable
log_archive_dest_state_21 enable
log_archive_dest_state_22 enable
log_archive_dest_state_23 enable
log_archive_dest_state_24 enable
log_archive_dest_state_25 enable
log_archive_dest_state_26 enable
log_archive_dest_state_27 enable
log_archive_dest_state_28 enable
log_archive_dest_state_29 enable
log_archive_dest_state_30 enable
log_archive_dest_state_31 enable
log_archive_start FALSE
log_archive_dest
log_archive_duplex_dest
log_archive_min_succeed_dest 1
_arch_sim_mode 0
_dg_corrupt_redo_log 0
_local_arc_assert_on_wait FALSE
_defer_eor_orl_arch_for_so TRUE
fal_client
fal_server
_enable_ffw TRUE
log_archive_trace 0
_log_archive_trace_pids
_redo_transport_sanity_check 0
_fix_fuzzy_scn FALSE
_dg_cf_check_timer 15
_bypass_srl_for_so_eor FALSE
_redo_transport_redo_log_management
_rta_sync_wait_timeout 10
_log_archive_prot_auto_demote FALSE
_serialize_lgwr_sync_io FALSE
data_guard_sync_latency 0
_mgd_rcv_handle_orphan_datafiles FALSE
_standby_auto_flashback TRUE
_real_time_apply_sim 0
_defer_rcv_during_sw_to_sby FALSE
_skip_trstamp_check TRUE
_show_mgd_recovery_state FALSE
log_archive_config
_log_archive_buffers 10
_redo_transport_compress_all TRUE
_rtc_infeasible_threshold 25
log_archive_format %t_%s_%r.dbf
data_guard_max_io_time 240
data_guard_max_longio_time 240
_disable_thread_snapshot TRUE
_redo_log_record_life 168
_redo_log_debug_config 0
_redo_log_check_backup 10
_log_archive_avoid_memcpy TRUE
_async_rta_broadcast FALSE
_rtabnd_update_offload TRUE
_redo_transport_async_mode 0
_log_archive_strong_auth TRUE
_redo_transport_max_kbytes_sec 0
_redo_transport_min_kbytes_sec 10
_redo_transport_catch_up_bandwidth_perce 50
ntage
_redo_transport_resource_management FALSE
redo_transport_user
_lgwr_ns_nl_min 500
_lgwr_ns_nl_max 1000
_redo_transport_stall_time 360
_redo_transport_stall_time_long 3600
log_archive_max_processes 4
_max_lns_shutdown_archival_time 30
_ta_lns_wait_for_arch_log 20
_lgwr_max_ns_wt 1
_ns_max_flush_wt 1
_ns_max_send_delay 15
_lgwr_ta_sim_err 0
_lgwr_ns_sim_err 0
_log_archive_network_redo_size 10
_switchover_to_standby_switch_log FALSE
_max_async_wait_for_catch_up 20
_redo_transport_evict_threshold 10
_num_rlslaves 2
_lgwr_delay_write FALSE
_enable_redo_global_post FALSE
_cache_orl_during_open ALL
_image_redo_gen_delay 0
_simulate_dax_storage DISABLE
log_buffer 7536640
_log_silicon_secured_memory TRUE
_target_log_write_size 0
_target_log_write_size_timeout 0
_target_log_write_size_spinwait 0
_target_log_write_size_percent_for_poke 100
log_checkpoint_interval 0
log_checkpoint_timeout 1800
_log_switch_timeout 0
archive_lag_target 0
_log_buffers_debug FALSE
_log_buffers_corrupt FALSE
_log_simultaneous_copies 2
_use_single_log_writer TRUE
_max_outstanding_log_writes 1
_log_write_worker_task_prefetch EARLY
_log_write_worker_task_spinwait 0
_log_write_worker_post_spinwait 0
_adaptive_scalable_log_writer_enable_wor 200
ker_threshold
_adaptive_scalable_log_writer_disable_wo 50
rker_threshold
_adaptive_scalable_log_writer_sampling_c 128
ount
_adaptive_scalable_log_writer_sampling_t 3
ime
_adaptive_scalable_log_writer_enable_wor 999900
ker_aging
_log_parallelism_max 1
_log_parallelism_dynamic TRUE
_max_log_write_parallelism 1
_lost_write_parallelism_change_tracking 2
_serial_log_write_worker_io FALSE
_parallel_log_write_cleanup FALSE
_log_private_parallelism_mul 10
_log_private_mul 5
_lightweight_hdrs TRUE
_redo_read_from_memory TRUE
_desired_readmem_rate 90
_log_read_buffer_size 8
_validate_readmem_redo HEADER_ONLY
_mirror_redo_buffers FALSE
_fg_log_checksum TRUE
_verify_fg_log_checksum FALSE
_disable_logging FALSE
_simulated_log_write_usecs 0
_log_buffer_coalesce FALSE
_redo_write_coalesce_all_threshold 0
_redo_write_coalesce_slave_threshold 0
_redo_write_sync_single_io TRUE
_fg_sync_sleep_usecs 0
_fg_fast_sync_sleep_usecs 0
_fg_fast_sync_spin_usecs 100
_fg_fast_sync_slack_usecs 1
_fg_fast_sync_sleep_target_pct 50
_log_file_sync_timeout 10
_use_adaptive_log_file_sync TRUE
_adaptive_log_file_sync_use_polling_thre 110
shold
_adaptive_log_file_sync_use_postwait_thr 50
eshold
_adaptive_log_file_sync_use_postwait_thr 1001
eshold_aging
_adaptive_log_file_sync_sampling_count 128
_adaptive_log_file_sync_sampling_time 3
_adaptive_log_file_sync_sched_delay_wind 60
ow
_adaptive_log_file_sync_poll_aggressiven 0
ess
_adaptive_log_file_sync_high_switch_freq 3
_threshold
_max_pending_scn_bcasts 8
_lgwr_posts_for_pending_bcasts FALSE
_long_log_write_warning_threshold 500
_long_bcast_ack_warning_threshold 500
_enable_flash_logging TRUE
_check_pdbid_in_redo FALSE
_log_write_info_size 4096
_cache_fusion_pipelined_updates TRUE
_rac_propagate_last_rba TRUE
_log_writer_worker_dlm_hearbeat_update_f 5000
req
_hb_redo_interval 1000
db_files 200
db_file_multiblock_read_count 128
_db_file_exec_read_count 128
_db_file_optimizer_read_count 8
_db_file_noncontig_mblock_read_count 11
read_only_open_delayed FALSE
cluster_database FALSE
cluster_database_instances 1
db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5
db_recovery_file_dest
db_recovery_file_dest_size 0
_db_recovery_temporal_file_dest
standby_file_management MANUAL
_standby_switchover_timeout 120
_hard_protection FALSE
_datafile_cow FALSE
_max_filestat_tries 10
_disable_file_resize_logging FALSE
_file_set_enqueue_timeout 1200
_file_offline_sync_timeout 900
_allow_error_simulation FALSE
_roi_first_open_wait 120
_db_file_format_io_buffers 4
_disable_read_only_open_dict_check FALSE
_standby_flush_mode SLFLUSH
_causal_standby_wait_timeout 20
_online_file_conversion_batchsize 16
_gc_undo_affinity TRUE
_gc_disable_s_lock_brr_ping_check TRUE
_gc_policy_time 20
_gc_policy_rm_dirty_percent 1
_gc_policy_minimum 1500
_gc_affinity_ratio 50
_gc_transfer_ratio 75
_gc_anti_lock_ratio 66
_recovery_asserts FALSE
_gc_vector_read TRUE
_gc_element_percent 105
_gc_latches 32
_gc_keep_recovery_buffers TRUE
_gc_keep_undo_recovery_buffers TRUE
_recovery_read_limit 1024
_gc_dump_remote_lock TRUE
_gc_drm_windows 8
_gc_defer_time 0
_gc_defer_ping_index_only TRUE
_gc_delay_ping TRUE
_kcl_debug TRUE
_kcl_index_split TRUE
_fairness_threshold 2
_gc_interconnect_checksum FALSE
_cr_server_log_flush TRUE
_gc_log_flush TRUE
_async_recovery_reads TRUE
_async_recovery_claims TRUE
_bwr_for_flushed_pi TRUE
_send_requests_to_pi TRUE
_gc_check_bscn TRUE
_gc_global_lru AUTO
_gc_global_lru_touch_count 5
_gc_global_lru_touch_time 60
_gc_statistics TRUE
_gc_coalesce_recovery_reads TRUE
_gc_global_checkpoint_scn TRUE
_gc_undo_block_disk_reads TRUE
_gc_affinity_locking TRUE
_gc_affinity_locks TRUE
_gc_read_mostly_locking TRUE
_gc_persistent_read_mostly TRUE
_gc_bypass_readers TRUE
_gc_max_downcvt 2048
_gc_fusion_compression 1024
_gc_down_convert_after_keep TRUE
_gc_flush_during_affinity TRUE
_gc_cr_server_read_wait TRUE
_gc_read_mostly_flush_check FALSE
_gc_override_force_cr TRUE
_gc_bg_merge TRUE
_gc_fg_merge TRUE
_gc_first_dirty_merge TRUE
_gc_no_fairness_for_clones TRUE
_gc_sanity_check_cr_buffers FALSE
_gc_save_cleanout TRUE
_gc_temp_affinity FALSE
_gc_fg_spin_time 0
_gc_object_queue_max_length 0
_gc_async_send TRUE
_gc_async_receive FALSE
_gc_try_to_skip_imc_flush TRUE
_gc_msgq_buffers 0
_gc_serve_from_flash_cache FALSE
_gc_trace_freelist_empty FALSE
_gc_skip_undo_disk_read TRUE
_gc_blocking_pins FALSE
_gc_trace_blocking_pins FALSE
_gc_enable_cr_bypass TRUE
_gc_numa_lock_elements FALSE
_gc_buckets_per_latch 0
_gc_integrity_checks 1
_light_work_rule_debug FALSE
_gc_fast_index_split_wait 0
_gc_max_reg_sz 68719476736
_gc_partial_cleanout TRUE
_gc_undo_rdma_read FALSE
_gc_lease_time 10000
_gc_spin_time 16
_gc_xmem_rdma FALSE
_adaptive_direct_read TRUE
_adaptive_direct_write TRUE
_db_block_align_direct_read TRUE
_db_noarch_disble_optim FALSE
_db_disable_temp_encryption FALSE
db_unrecoverable_scn_tracking TRUE
_kcbl_assert_reset_slot TRUE
_direct_io_slots 0
_direct_io_skip_cur_slot_on_error TRUE
_direct_io_wslots 0
thread 0
_thread_state_change_timeout_pnp 1800
_disable_incremental_checkpoints FALSE
_disable_thread_internal_disable FALSE
_disable_selftune_checkpointing FALSE
_selftune_checkpointing_lag 300
_target_rba_max_lag_percentage 81
_no_recovery_through_resetlogs FALSE
enabled_PDBs_on_standby *
_auto_rekey_during_mrcv TRUE
_auto_rcv_pdb_open 1
fast_start_io_target 0
fast_start_mttr_target 0
_log_blocks_during_backup TRUE
_allow_resetlogs_corruption FALSE
_allow_terminal_recovery_corruption FALSE
_allow_read_only_corruption FALSE
_allow_file_1_offline_error_1245 FALSE
_recovery_skip_cfseq_check FALSE
log_checkpoints_to_alert FALSE
db_lost_write_protect NONE
_db_shadow_lost_write_protect NOT_SET
_db_lost_write_corrupt_block FALSE
_flush_log_buffer_timeout 0
_flush_log_buffer_force FALSE
_switchover_to_standby_option OPEN_ALL_IGNORE_SESSIONS
_switchover_timeout 0
_switchover_through_cascade TRUE
_auto_bmr_file_header TRUE
_fast_psby_conversion TRUE
_adg_instance_recovery TRUE
_ac_enable_dscn_in_rac FALSE
_ac_strict_SCN_check FALSE
_allow_convert_to_standby FALSE
_early_flush_delta 0
_flush_redo_to_standby 0
_disable_dict_check_pdb_open FALSE
_clear_preserved_buffers TRUE
_datafile_create_wait_time 0
_datafile_create_min_wait_time 0
_skip_pdb_recovery_if_keystore_not_open FALSE
recovery_parallelism 0
_serial_recovery FALSE
_coord_message_buffer 0
_multiple_instance_recovery FALSE
_backup_compress FALSE
_backup_kgc_scheme ZLIB
_backup_kgc_medium_scheme DEFAULT
_backup_kgc_bz2_bufsz 0
_backup_kgc_bz2_type 0
_backup_kgc_bz2_niters 0
_backup_kgc_lzo_bufsz 262144
_backup_kgc_zlib_complevel 1
_backup_kgc_zlib_windowbits 15
_backup_kgc_zlib_memlevel 8
_backup_kgc_bzip2_blksiz 9
_backup_kgc_zstd_complevel 3
_backup_kgc_zstd_bufsz 262144
_backup_ksfq_bufmem_max 268435456
_backup_ksfq_bufsz 0
_backup_ksfq_bufcnt 0
_backup_disk_bufsz 0
_backup_disk_bufcnt 0
_backup_seq_bufsz 0
_backup_seq_bufcnt 0
_backup_file_bufsz 0
_backup_file_bufcnt 0
_restore_maxopenfiles 8
_backup_max_gap_size 4294967294
_backup_min_ct_unused_optim 2097152
_unused_block_compression TRUE
_restore_spfile
_dummy_instance FALSE
_rman_io_priority 3
_backup_encrypt_opt_mode 4294967294
_disable_initial_block_compression FALSE
_undo_block_compression TRUE
_update_datafile_headers_with_space_info FALSE
rmation
_disable_cell_optimized_backups FALSE
_backup_align_write_io TRUE
_backup_dynamic_buffers TRUE
_backup_automatic_retry 10
_krb_trace_buffer_size 131072
_sparse_backing_file AVM
_catalog_foreign_restore FALSE
_restore_create_directory TRUE
_backup_max_wallet_session 50
_backup_block0 default
_restore_block0 on
_backup_int_spare1 4294967294
_backup_int_spare2 4294967294
_backup_int_spare3 4294967294
_backup_int_spare4 4294967294
_backup_text_spare1
_backup_text_spare2
_backup_text_spare3
_backup_text_spare4
_backup_bool_spare1 FALSE
_backup_bool_spare2 FALSE
_backup_bool_spare3 FALSE
_backup_bool_spare4 FALSE
_krb_check_osd_block_endianess TRUE
_controlfile_autobackup_delay 300
_deferred_log_dest_is_valid TRUE
_log_deletion_policy mandatory
_prefered_standby
_auto_bmr enabled
_auto_bmr_req_timeout 60
_auto_bmr_sess_threshold 30
_auto_bmr_pub_timeout 10
_auto_bmr_fc_time 60
_auto_bmr_bg_time 3600
_auto_bmr_sys_threshold 100
_auto_bmr_max_rowno 1024
_krbabr_trace_buffer_size 131072
_preplugin_backup enabled
_auto_export_preplugin_backup TRUE
_backup_appliance_enabled FALSE
_ba_container_filesystem_ausize 4194304
_ba_max_groups 0
_ba_max_containers 0
_ba_max_seg_bytes 4000
_ba_cf_trace_buffer_size 131072
_ba_timeouts_enabled TRUE
enable_goldengate_replication FALSE
_tts_allow_charset_mismatch FALSE
_xtts_allow_pre10 FALSE
_xtts_set_platform_info FALSE
_bypass_xplatform_error FALSE
_aux_dfc_keep_time 1440
_forced_endian_type UNKNOWN
_allow_cross_endian_dictionary FALSE
_query_on_physical TRUE
_recoverable_recovery_batch_percent 50
_undo_tbs_slave_percent 0
_recoverable_recovery_max_influx_buffers 100000
_disable_incremental_recovery_ckpt FALSE
_clone_one_pdb_recovery FALSE
_incremental_recovery_ckpt_min_batch 500
_time_based_rcv_ckpt_target 180
_time_based_rcv_hdr_update_interval 180
_multi_instance_pmr TRUE
_disable_active_influx_move FALSE
_abort_on_mrp_crash FALSE
_keep_19907_during_recovery FALSE
_defer_log_boundary_ckpt TRUE
_defer_log_count 100
_transient_logical_clear_hold_mrp_bit FALSE
_log_max_optimize_threads 128
_reduce_sby_log_scan TRUE
_sync_primary_wait_time 5
_standby_implicit_rcv_timeout 1
_readable_standby_sync_timeout 10
_readable_standby_sync_interval 0
_adg_parselock_timeout 0
_adg_influx_qscn_gap 0
_adg_parselock_timeout_sleep 100
_adg_objectlock_timeout 0
_adg_objectlock_attempts 2
_adg_objectlock_maxnum 1000
_adg_count_beyond_limit 0
_adg_defer_segstat TRUE
inmemory_adg_enabled TRUE
_adg_adt_redirect_catchup_wait_time 12000
_adg_adt_redirect_apply_lag_threshold 12000
_read_only_violation_max_count 500
_read_only_violation_max_count_per_modul 100
e
_read_only_violation_dump_to_trace FALSE
_adg_redirect_upd_to_primary_max_retries 500
_media_recovery_read_batch 32
_standby_causal_heartbeat_timeout 2
_use_pdb_parselock TRUE
_snapshot_recovery_enabled TRUE
_adg_auto_close_pdb TRUE
_bct_public_dba_buffer_size 0
_bct_initial_private_dba_buffer_size 0
_bct_bitmaps_per_file 8
_bct_file_block_size 0
_bct_file_extent_size 0
_bct_chunk_size 0
_bct_crash_reserve_size 262144
_bct_buffer_allocation_size 2097152
_bct_buffer_allocation_max 104857600
_bct_buffer_allocation_min_extents 1
_bct_fixtab_file
_disable_primary_bitmap_switch FALSE
_bct_health_check_interval 60
_bct_public_dba_buffer_dynresize 2
_bct_public_dba_buffer_maxsize 0
_bct_mrp_timeout 600
_krc_trace_buffer_size 131072
_kra_trace_buffer_size 131072
_kra_cfile_compaction TRUE
db_flashback_retention_target 1440
_validate_flashback_database FALSE
_flashback_allow_noarchivelog FALSE
_verify_flashback_redo TRUE
_flashback_verbose_info FALSE
_flashback_dynamic_enable_failure 0
_flashback_dynamic_enable TRUE
_allow_drop_snapshot_standby_grsp FALSE
_flashback_marker_cache_size 328
_flashback_marker_cache_enabled TRUE
_flashback_database_test_only FALSE
_allow_drop_ts_with_grp FALSE
_df_hist_offl_override FALSE
_propogate_restore_point TRUE
_flashback_logfile_enqueue_timeout 600
_flashback_barrier_interval 1800
_flashback_standby_barrier_interval 1
_flashback_stby_support_mira TRUE
_flashback_standby_check_barrier_MIRA 20
_flashback_standby_check_minpfh_MIRA 15
_flashback_max_standby_sync_span 300
_flashback_fuzzy_barrier TRUE
_disable_kcb_flashback_blocknew_opt FALSE
_disable_kcbl_flashback_blocknew_opt FALSE
_disable_flashback_wait_callback FALSE
_check_block_new_invariant_for_flashback FALSE
_allow_compatibility_adv_w_grp FALSE
_minimum_db_flashback_retention 60
_flashback_delete_chunk_MB 128
_flashback_11_1_block_new_opt FALSE
_flashback_marker_for_every_grp FALSE
_flashback_log_size 1000
_flashback_log_min_size 100
_db_flashback_log_min_size 16777216
_db_flashback_log_min_total_space 0
_flashback_copy_latches 10
_flashback_n_log_per_thread 128
_flashback_max_n_log_per_thread 2048
_flashback_generation_buffer_size 4194304
_allocate_flashback_buffer FALSE
_flashback_max_log_size 0
_flashback_log_io_error_behavior 0
_flashback_prepare_log TRUE
_flashback_size_based_on_redo TRUE
_flashback_validate_controlfile FALSE
_flashback_format_chunk_mb 4
_flashback_format_chunk_mb_dwrite 16
_flashback_log_rac_balance_factor 10
_flashback_write_max_loop_limit 10
_flashback_hint_barrier_percent 20
_drop_flashback_logical_operations_enq FALSE
_percent_flashback_buf_partial_full 50
_flashback_reclaim_monitor_window 7
_flashback_reclaim_speed_up FALSE
_tdb_debug_mode 16
_log_read_buffers 8
_change_vector_buffers 1
_change_vector_read_sample_ratio 0
_kcfis_spawn_debugger FALSE
_kcfis_trace_bucket_size 131072
_kcfis_fault_control 0
_kcfis_caching_enabled TRUE
_kcfis_large_payload_enabled FALSE
_kcfis_automem_level 1
_kcfis_cell_passthru_enabled FALSE
_kcfis_cell_passthru_dataonly TRUE
_kcfis_dump_corrupt_block TRUE
_kcfis_kept_in_cellfc_enabled TRUE
_kcfis_nonkept_in_cellfc_enabled FALSE
_kcfis_rdbms_blockio_enabled FALSE
_kcfis_fast_response_enabled TRUE
_kcfis_fast_response_threshold 1048576
_kcfis_fast_response_initiosize 2
_kcfis_fast_response_iosizemult 4
_kcfis_max_out_translations 5000
_kcfis_max_cached_sessions 10
_kcfis_storageidx_disabled FALSE
_kcfis_disable_platform_decryption FALSE
_kcfis_storageidx_diag_mode 0
_kcfis_storageidx_set_membership_disable FALSE
d
_kcfis_byteswap_opt_disabled FALSE
_kcfis_cellcache_disabled FALSE
_kcfis_test_control1 0
_kcfis_stats_level 0
_kcfis_io_prefetch_size 8
_kcfis_block_dump_level 0
_kcfis_ioreqs_throttle_enabled TRUE
_kcfis_qm_prioritize_sys_plan TRUE
_kcfis_qm_user_plan_name
_kcfis_control1 0
_kcfis_control2 0
_kcfis_control3 0
_kcfis_control4 0
_kcfis_control5 0
_kcfis_control6 0
_kcfis_oss_io_size 0
_kcfis_read_buffer_limit 0
_cell_file_format_chunk_size 0
_cell_offload_capabilities_enabled 1
_kcfis_cell_passthru_fromcpu_enabled TRUE
_kcfis_celloflsrv_usage_enabled TRUE
_kcfis_celloflsrv_passthru_enabled FALSE
_kcfis_fastfileinit_disabled FALSE
_kcfis_xtgran_prefetch_count 1
_kcfis_storageidx_xtss_disabled FALSE
_kcfis_pmem_enabled TRUE
_db_block_prefetch_skip_reading_enabled TRUE
_db_block_prefetch_fast_longjumps_enable TRUE
d
_db_block_prefetch_private_cache_enabled TRUE
_datafile_write_errors_crash_instance TRUE
_datafile_open_errors_crash_instance TRUE
_siop_perc_of_bc_x100 625
_siop_init_mem_gradually TRUE
_db_flashback_iobuf_size 1
_db_flashback_num_iobuf 64
_flashback_enable_ra TRUE
_nologging_sendbuf_ratio 90
_nologging_slots 20
_nologging_load_slotsz 1048576
_nologging_block_cleanout_delay 300
_force_logging_in_upgrade TRUE
_nologging_mode_override 0
_nologging_txn_history_to_sessions_perce 100
nt
_nologging_fetch_slv_wt 600
_nologging_progress_keep_alive 10
_nologging_kcnbuf_hash_buckets 1024
_nologging_kcnbuf_hash_latches 256
_nologging_standby_hot_buffer_timeout 500
_nologging_standby_cold_buffer_timeout 500
_nbr_recovery_timeout 60
_nbr_recovery_max_request_size 8
_nbr_recovery_target_bufs 0
_nologging_apply_stall_time 1000
_nologging_standby_fetch_disable FALSE
_nologging_standby_refetch_disable FALSE
_nologging_standby_dtc_expire 600
_nologging_sdcl_append_wait 200
_nologging_txn_cmt_wait 1500
_max_data_transfer_cache_size 536870912
_data_transfer_cache_bc_perc_x100 500
data_transfer_cache_size 0
__data_transfer_cache_size 0
_nologging_fetch_retry_interval_hot 60
_nologging_fetch_retry_interval_cold 1800
_nologging_fetch_demote_count 10
_nologging_fetch_initial_interval 2
_max_kcnibr_ranges 1048576
_mira_mark_archivelog_timeout 60
enable_imc_with_mira FALSE
_mira_num_receive_buffers 25
_mira_num_local_buffers 25
_mira_sender_process 2
_mira_rcv_max_buffers 500
_krpm_trace_buffer_size 262144
_mira_rcv_catchup_buffers 5
_mira_free_unused_buffers TRUE
_dbcomp_msg_ver 1
_dbcomp_maxdump 100
_shadow_lost_write_found 118
_shadow_lost_write_tracing 0
adg_account_info_tracking LOCAL
adg_redirect_dml FALSE
_alter_adg_redirect_behavior none
dml_locks 2076
_row_locking always
_serializable FALSE
_scn_wait_interface_max_timeout_secs 2147483647
_scn_wait_interface_max_backoff_time_sec 600
s
replication_dependency_tracking TRUE
_ktb_debug_flags 8
_log_committime_block_cleanout FALSE
_ktc_latches 0
_prescomm FALSE
_recursive_imu_transactions FALSE
_ktc_debug 0
_enable_minscn_cr TRUE
_txn_control_trace_buf_size 4096
transactions 519
transactions_per_rollback_segment 5
_ktu_latches 0
_transaction_auditing TRUE
_smu_error_simulation_site 0
_smu_error_simulation_type 0
_imtxn_table_enable TRUE
_imtxn_table_max_undo_segs 1024
_imtxn_table_max_slts_per_seg 34
_imtxn_table_max_inc_per_slt 1
_imtxn_table_flags 3
_temp_undo_disable_adg FALSE
temp_undo_enabled FALSE
_temp_undo_optimal_extents 0
_rollback_stopat 0
_discrete_transactions_enabled FALSE
_in_memory_undo TRUE
_imu_pools 3
_branch_tagging TRUE
_row_cr TRUE
_enable_block_level_transaction_recovery TRUE
_cleanup_rollback_entries 100
rollback_segments
_rollback_segment_initial 1
undo_management AUTO
_offline_rollback_segments
_corrupted_rollback_segments
_rollback_segment_count 0
undo_tablespace UNDOTBS1
_smu_timeouts
_smu_debug_mode 0
_undo_debug_mode 0
_tablespaces_per_transaction 10
_verify_undo_quota FALSE
_in_memory_tbs_search TRUE
_highthreshold_undoretention 4294967294
_undo_autotune TRUE
undo_retention 900
_collect_undo_stats TRUE
_collect_tempundo_stats TRUE
_indoubt_pdb_transactions_force_outcome COMMIT
_min_undosegs_for_parallel_fptr 100
_number_of_undo_blocks_to_prefetch 8
_imtxnrma_table_enable FALSE
_transaction_recovery_servers 0
fast_start_parallel_rollback LOW
_parallel_recovery_stopat 32767
resumable_timeout 0
_resumable_critical_alert 0
_cr_trc_buf_size 8192
_max_cr_rollbacks 1000
_disable_txn_alert 0
_undo_debug_usage 0
_db_change_notification_enable TRUE
_minact_timeout 180
_disable_flashback_archiver 0
_disable_fba_qrw 0
_disable_fba_wpr 0
_flashback_archiver_partition_size 0
_fbda_busy_percentage 0
_fbda_inline_percentage 0
_fbda_debug_mode 0
_fbda_debug_assert 0
_fbda_global_bscn_lag 0
_fbda_rac_inactive_limit 0
_fbda_tcrv_cleanup_lag 3600
_securefile_log_num_latches 0
_securefile_log_shared_pool_size 0
_cli_cachebktalloc 100
_ilm_mem_limit 10
_ktilmsc_exp 600
_ktilm_uga_off FALSE
_inmemory_check_prot_meta FALSE
_inmemory_private_journal_quota 100
_inmemory_txnpjrnl_debug 0
_inmemory_private_journal_sharedpool_quo 20
ta
_inmemory_private_journal_numbkts 512
_inmemory_private_journal_numgran 255
_inmemory_private_journal_maxexts 5000000
_inmemory_journal_scan 0
_inmemory_journal_format 1
_inmemory_journal_scan_format TRUE
_inmemory_journal_cla_stride 4
_inmemory_partrowlock_threshold 10
_inmemory_pin_hist_mode 16
_inmemory_txn_checksum 0
_inmemory_buffer_waittime 100
_inmemory_retention_time 120
_inmemory_cudrop_timeout 1000
_inmemory_exclto_timeout 100
_inmemory_num_hash_latches 256
_inmemory_strdlxid_timeout 0
_inmemory_incremental_repopulation TRUE
_inmemory_repopulate_optimize TRUE
_inmemory_transaction_options 2806
_inmemory_waitinvis_count 8
_inmemory_lock_for_smucreate FALSE
_inmemory_relimcusz_thresh 25
_inmemory_shared_journal_maxexts 1024
_inmemory_shared_journal_minexts_repop 256
_inmemory_direct_reads 1
_inmemory_grpcolinv_buffer_size 131072
_inmemory_grpcolinv_granularity 1
_inmemory_crclone_buffer_size 131072
_inmemory_crclone_threshold_rows 100
_inmemory_crclone_min_clones 6
_inmemory_crclone_min_space_percent 50
_inmemory_patch_threshold_blocks 25
_inmemory_patch_background_blocks 200
_inmemory_patch_commit_path FALSE
_inmemory_smu_patch_options 7
_inmemory_adg_quiesce_timeout 2
_inmemory_adg_periodic_sort FALSE
_inmemory_adg_batched_flush TRUE
_inmemory_adg_parallel_flush TRUE
_inmemory_adg_journal_quota FALSE
_ktst_rss_min 100
_ktst_rss_max 1000
_ktst_rss_retry 5
_force_temp_space_cleanup TRUE
_partition_large_extents TRUE
_index_partition_large_extents FALSE
_force_local_temp FALSE
_prefer_local_temp FALSE
instance_number 0
_allocate_creation_order FALSE
_log_space_errors TRUE
_assm_low_gsp_threshold 10000
_assm_high_gsp_threshold 11024
_simulate_io_wait 0
_bump_highwater_mark_count 0
_assm_segment_extension_percent 100
_old_extent_scheme FALSE
_trace_temp FALSE
_concurrency_chosen 10
_no_small_file FALSE
_assm_default TRUE
_enable_hwm_sync TRUE
_hwm_sync_threshold 10
_enable_check_truncate TRUE
_enable_tablespace_alerts TRUE
_disable_temp_tablespace_alerts FALSE
_disable_undo_tablespace_alerts FALSE
_disable_lostwrite_tablespace_alerts FALSE
_last_allocation_period 5
_securefiles_forceflush FALSE
_securefiles_concurrency_estimate 12
_securefiles_increase_hbb FALSE
_securefiles_memory_percentofSGA 8
_inst_locking_period 5
_allocation_update_interval 3
_minimum_blocks_to_shrink 0
_minimum_extents_to_shrink 1
_index_partition_shrink_opt TRUE
_use_best_fit FALSE
_step_down_limit_in_pct 20
_assm_test_force_rej 0
_assm_test_force_rej2 0
_assm_test_reentrant_gsp FALSE
_enable_space_preallocation 3
_ktspsrch_maxsc 1024
_ktspsrch_scexp 60
_ktspsrch_scchk 60
_ktspsrch_maxskip 5
_max_sys_next_extent 0
_assm_force_fetchmeta FALSE
_max_fsu_segments 1024
_max_fsu_sgapcent 10
_max_fsu_exptime 7200
_max_fsu_stale_time 600
_disable_flashback_recyclebin_opt TRUE
_max_shrink_obj_stats 0
_check_ts_threshold 0
_async_ts_threshold 1
_enable_securefile_flashback_opt FALSE
_disable_def_seg_update 0
_use_cached_asm_free_space FALSE
_ena_storage_lmt DEFAULT
_kttext_warning 5
_ktt_tsid_reuse_threshold 60000
_enable_verbose_gdr FALSE
_enable_sysaux_gdr FALSE
_gdr_clear_inactive_only FALSE
_gdr_clear_active_only FALSE
_drop_tablespace_objects 0
_smon_internal_errlimit 100
_smon_undo_seg_rescan_limit 10
_enable_12g_bft TRUE
_space_align_size 1048576
_undotbs_stepdown_pcent 75
_undotbs_regular_tables FALSE
_enable_spacebg TRUE
_max_spacebg_slaves 1024
_minmax_spacebg_slaves 8
_min_spacebg_slaves 2
_max_spacebg_tasks 8192
_max_spacebg_msgs_percentage 50
_ktslj_segext_warning 10
_ktslj_segext_warning_mb 0
_ktslj_segext_max_mb 0
_ktslj_segext_retry 5
_securefiles_fg_retry 100
_securefiles_breakreten_retry 5
_securefiles_bulkclnout TRUE
_securefiles_bulkinsert FALSE
_securefiles_bgtimeout 0
_securefiles_spcutl FALSE
_spacebg_sync_segblocks TRUE
_trace_ktfs FALSE
_trace_ktfs_mem FALSE
heat_map OFF
_enable_ilm_flush_stats TRUE
_enable_ilm_testflush_stats FALSE
_disable_12cbigfile FALSE
_enable_heatmap_internal FALSE
_heatmap_format_1block FALSE
_test_hm_extent_map FALSE
_ilmset_stat_limit 0
_ilmflush_stat_limit 0
_heatmap_min_maxsize 0
_ilmstat_memlimit 5
_flush_ilm_stats 0
_create_stat_segment 0
_drop_stat_segment 0
_print_stat_segment 0
_print_inmem_heatmap 0
_blockhm_flush_period 3600
_inmemory_auto_distribute TRUE
_inmemory_autodist_2safe FALSE
_inmemory_distribute_timeout 300
_inmemory_distribute_ondemand_timeout 300
_inmemory_granule_size 134217728
inmemory_size 0
inmemory_xmem_size 0
_inmemory_64k_percent 30
_inmemory_expressions_area_percent 10
_inmemory_min_ima_defersize 0
_inmemory_memprot TRUE
__inmemory_ext_rwarea 0
_inmemory_ext_rwarea 0
__inmemory_ext_roarea 0
_inmemory_ext_roarea 0
inmemory_prefer_xmem_memcompress
inmemory_prefer_xmem_priority
_inmemory_xmem_size 0
_inmemory_prefer_xmem_memcompress
_inmemory_prefer_xmem_priority
_inmemory_drcancel_cu_percent 80
_trace_ktds FALSE
_track_space_reuse FALSE
_track_space_reuse_rac FALSE
_spacereuse_track_memlimit 10
_print_inmem_srmap 0
_enable_rejection_cache TRUE
_assm_space_cache_hb_expire 3
_assm_l1cleanout_throttle_time 3
_assm_examination_time_threshold 60
_assm_examination_blocks_threshold 8196
_assm_examination_enable_sla FALSE
_assm_space_cache_max_segments 1024
_assm_segment_repair_fg 0
_assm_segment_repair_bg TRUE
_assm_segment_repair_maxblks 4294967294
_assm_latency_sampling_frequency 0
_assm_segment_repair_timelimit 60
_atp_block_size_default TRUE
allow_rowid_column_type FALSE
_db_row_overlap_checking TRUE
_db_index_block_checking TRUE
_kdi_avoid_block_checking FALSE
db_block_checking FALSE
_disable_block_checking FALSE
_kd_symtab_chk TRUE
_sage_block_checking FALSE
_kd_rows_chk TRUE
recyclebin on
_suppress_identifiers_on_dupkey FALSE
_compression_compatibility 19.0.0
_check_column_length TRUE
_oltp_compression TRUE
_inplace_update_retry TRUE
_widetab_comp_enabled TRUE
_partial_comp_enabled TRUE
_limit_itls 20
_force_hsc_compress FALSE
_force_oltp_compress FALSE
_force_partial_compress FALSE
_force_sys_compress TRUE
_force_oltp_update_opt TRUE
_force_arch_compress 0
_compression_advisor 0
_compression_chain 90
_compression_above_cache 0
_oltp_compress_dbg 0
_oltp_compression_gain 10
_arch_compression TRUE
_arch_comp_dbg_scan 0
_oltp_comp_dbg_scan 0
_dbg_scan 0
_arch_comp_dec_block_check_dump 1
_alternate_iot_leaf_block_split_points TRUE
_kdu_array_depth 16
_cell_offload_hybridcolumnar TRUE
_disable_implicit_row_movement FALSE
_cu_row_locking 0
_oltp_spill FALSE
_delete_ghost_data FALSE
_kd_dbg_control 0
_block_dump_assert FALSE
_release_insert_threshold 5
_walk_insert_threshold 0
_enable_hash_overflow FALSE
_kdtgsp_retries 1024
_rowlen_for_chaining_threshold 1000
_minfree_plus 0
_disable_hcc_array_insert FALSE
_extra_lmn_enabled TRUE
_use_seq_process_cache TRUE
_pdb_use_sequence_cache TRUE
_sequence_scale_noextend FALSE
_sequence_scale_extend FALSE
_dynamic_sequence_cache TRUE
_dynamic_sequence_cache_scale 10
_dynamic_sequence_cache_max 1000000
_analyze_comprehensive FALSE
_disable_index_block_prefetching FALSE
_index_scan_check_skip_corrupt FALSE
_index_scan_check_stopkey FALSE
_index_max_inc_trans_pct 20
_index_split_chk_cancel 5
_advanced_index_compression_trace 0
_gdr_control_flags 0
db_index_compression_inheritance NONE
_index_alert_key_not_found FALSE
_reuse_index_loop 5
_kdis_reject_limit 5
_kdis_reject_level 24
_kdis_reject_ops FALSE
_kdis_split_xid_prune TRUE
_kdbl_enable_post_allocation FALSE
_ldr_io_size 1048576
_ldr_pga_lim 0
_ldr_tempseg_threshold 8388608
_reclaim_lob_index_scan_limit 0
_dbfs_symlink_path_prefix TRUE
_lmn_invalidlkr_enabled TRUE
_ignore_desc_in_index FALSE
_kdic_segarr_sz 0
_keep_remote_column_size FALSE
_kdli_trace 0
_kdli_sort_dbas FALSE
_kdli_safe_callbacks TRUE
_kdli_inode_preference data
_kdli_reshape FALSE
_kdli_cache_inode TRUE
_kdli_cache_verify FALSE
_kdli_cache_size 8
_kdli_memory_protect FALSE
_kdli_rci_lobmap_entries 255
_kdli_readahead_strategy contig
_kdli_readahead_limit 0
_kdli_sio_on TRUE
_kdli_sio_min_read 0
_kdli_sio_min_write 0
_kdli_sio_async TRUE
_kdli_sio_fgio TRUE
_kdli_sio_nbufs 8
_kdli_sio_niods 8
_kdli_sio_strategy extent
_kdli_sio_fileopen none
_kdli_sio_flush FALSE
_kdli_sio_bps 0
_kdli_sio_pga FALSE
_kdli_sio_pga_top FALSE
_kdli_sio_dop 2
_kdli_sio_free TRUE
_kdli_sio_backoff FALSE
_kdli_inline_xfm TRUE
_kdli_timer_trc FALSE
_kdli_timer_dmp FALSE
_kdli_cacheable_length 0
_kdli_small_cache_limit 32
_kdli_inject_assert 0
_kdli_inject_crash 0
_kdli_space_cache_limit 2048
_kdli_force_cr TRUE
_kdli_force_cr_meta TRUE
_kdli_recent_scn FALSE
_kdli_itree_entries 0
_kdli_cache_read_threshold 0
_kdli_cache_write_threshold 0
_kdli_full_readahead_threshold 0
_kdli_force_storage none
_kdli_allow_corrupt TRUE
_kdli_squeeze TRUE
_kdli_buffer_inject TRUE
_kdli_inject_batch 0
_kdli_flush_injections TRUE
_kdli_flush_cache_reads FALSE
_kdli_checkpoint_flush FALSE
_kdli_delay_flushes TRUE
_kdli_dbc none
_kdli_preallocation_pct 0
_kdli_preallocation_mode length
_kdli_inplace_overwrite 0
_kdli_sio_write_pct 100
_kdli_sio_fbwrite_pct 35
_kdli_vll_direct TRUE
_kdli_descn_adj FALSE
_kdli_oneblk FALSE
_kdli_mts_so TRUE
_kdli_ralc_length 10485760
_kdli_ralc_rounding 1048576
_kdli_space_cache_segments 16
_kdli_icache_entries 3
_kdli_full_vll FALSE
_kdli_small_append_redo TRUE
_kdli_STOP_tsn 0
_kdli_STOP_dba 0
_kdli_STOP_fsz 0
_kdli_STOP_bsz 0
_kdli_STOP_nio 0
_kdlw_enable_write_gathering TRUE
_kdlw_enable_ksi_locking FALSE
_kdlwp_flush_threshold 4194304
_kdlxp_cmp_subunit_size 262144
_kdlxp_minxfm_size 32768
_kdlxp_lobcompress FALSE
_kdlxp_lobcmplevel 2
_kdlxp_lobcmprciver 1
_kdlxp_lobencrypt FALSE
_kdlxp_xfmcache TRUE
_kdlxp_lobcmpadp FALSE
_kdlxp_uncmp FALSE
_kdlxp_mincmplen 200
_kdlxp_mincmp 20
_sf_default_enabled TRUE
db_securefile PREFERRED
_kdlf_read_flag 0
_kdlxp_lobdeduplicate FALSE
_kdlxp_lobdedupvalidate TRUE
_kdlxp_dedup_hash_algo SHA1
_kdlxp_dedup_flush_threshold 8388608
_kdlxp_dedup_prefix_threshold 1048576
_kdlxp_dedup_inl_pctfree 5
_kdlxp_dedup_wapp_len 0
_kdlxp_spare1 0
_kdlxp_no_dedup_on_insert FALSE
_securefile_timers FALSE
_kdlu_trace_system 0
_kdlu_trace_layer 0
_kdlu_max_bucket_size 4194304
_kdlu_max_bucket_size_mts 131072
_kdz_hcc_track_upd_rids FALSE
_kdz_hcc_flags 0
_kdz_pcode_flags 0
_enable_columnar_cache 1
_kdz_proj_nrows 1024
_kdz_pred_nrows 32767
_kdzk_enable_init_trace FALSE
_kdzk_load_specialized_library 3
_kdzk_specialized_library_name
_kdzk_trace_level 0
_hpk_project_cost_weighting 20
_hpk_throughput_range 5
_hpk_compression_range 5
_inmemory_analyzer_optimize_for 0
_kdz_clear_analysis_percent 60
_dbfs_modify_implicit_fetch TRUE
_ILM_FILTER_TIME 0
_ILM_FILTER_TIME_LOWER 0
_ILM_POLICY_NAME FALSE
_inmemory_default_flags 8459
_inmemory_default_new FALSE
inmemory_clause_default
inmemory_force DEFAULT
inmemory_query ENABLE
_inmemory_default_svc 0
_inmemory_default_svcname
inmemory_expressions_usage ENABLE
inmemory_virtual_columns MANUAL
_inmemory_disable_selective_vircols FALSE
_inmemory_expression_count 20
_inmemory_max_expressions_table 50
_inmemory_expressions_mark_unused FALSE
_inmemory_ime_increpop_threshold 1
_inmemory_query_scan TRUE
_inmemory_scan_override FALSE
_inmemory_small_segment_threshold 65536
_inmemory_query_fetch_by_rowid FALSE
_inmemory_pruning ON
_inmemory_subcusize 512
_inmemory_subcu_histsize 0
_inmemory_enable_sys FALSE
_inmemory_populate_fg FALSE
_inmemory_pga_per_server 536870912
inmemory_max_populate_servers 0
_inmemory_servers_throttle_pgalim_percen 55
t
inmemory_trickle_repopulate_servers_perc 1
ent
_inmemory_populate_wait FALSE
_inmemory_populate_wait_max 600
_inmemory_imco_cycle 120
_inmemory_disable_alter_imco_cycle FALSE
_inmemory_enable_population_verify 1
_inmemory_log_level 0
_inmemory_fs_verify FALSE
_inmemory_force_fs FALSE
_inmemory_force_fs_tbs SYSAUX
_inmemory_force_fs_tbs_size 1073741824
_inmemory_fs_raise_error FALSE
_inmemory_fs_nodml FALSE
_inmemory_fs_enable TRUE
_inmemory_fsdw_enable TRUE
_inmemory_fsdw_populate_threshold_multip 10
lier
_inmemory_faststart_control_flags 0
_inmemory_fsdw_on_populate TRUE
_inmemory_fsdw_penalty_threshold 20
_inmemory_fsdw_inline FALSE
_inmemory_fs_enable_blk_lvl_inv TRUE
_inmemory_fsdw_cnt 2147483647
_inmemory_fsdw_maxcnt 10
_inmemory_fsdw_maxmem 104755200
_inmemory_fsdw_threshold 300
_inmemory_fsdw_priority_population_perce 100
nt
_inmemory_fsdw_priority_repopulation_per 90
cent
_inmemory_fsdw_priority_penalty_percent 10
_inmemory_fsdw_schedlrtm 1
_inmemory_fsdw_scheduler_dedicated FALSE
_inmemory_fs_blk_inv_blkcnt
_inmemory_fs_blk_inv_blk_percent 50
_inmemory_fs_prune_pct 10
_inmemory_fs_dmlverify_read_ahead_cnt 10
_inmemory_fsdw_task_timeout 20
_inmemory_fs_tbsmaxsz
_inmemory_enable_stat_alert FALSE
_inmemory_imcu_align TRUE
_inmemory_max_populate_retry 3
_inmemory_imcu_target_rows 0
_inmemory_imcu_target_bytes 0
_inmemory_imcu_source_extents 0
_inmemory_imcu_source_blocks 0
_inmemory_imcu_source_minbytes 1048576
_inmemory_imcu_populate_minbytes 5242880
_inmemory_imcu_source_analyze_bytes 134217728
_inmemory_imcu_target_maxrows 8388608
_inmemory_imcu_source_maxbytes 536870912
_inmemory_max_queued_tasks 0
_inmemory_repopulate_threshold_rows
_inmemory_repopulate_threshold_blocks
_inmemory_pct_inv_rows_invalidate_imcu 50
_inmemory_pct_inv_blocks_invalidate_imcu 100
_inmemory_repopulate_threshold_mintime_f 5
actor
_inmemory_repopulate_threshold_mintime 0
_inmemory_repopulate_threshold_scans 0
_inmemory_repopulate_priority_scale_fact 100
or
_inmemory_repopulate_invalidate_rate_per 0
cent
_inmemory_repopulate_priority_threshold_ 160
row
_inmemory_repopulate_priority_threshold_ 320
block
_inmemory_repopulate_threshold_rows_perc 5
ent
_inmemory_repopulate_threshold_blocks_pe 10
rcent
_inmemory_repopulate_disable 2
_inmemory_checksum FALSE
_inmemory_cu_checksum FALSE
_inmemory_validate_fetch FALSE
_inmemory_journal_row_logging FALSE
inmemory_optimized_arithmetic DISABLE
_inmemory_prefix_encode_dsbs FALSE
_inmemory_vector_encode_override FALSE
_inmemory_journal_check 0
_inmemory_rows_check_interrupt 1000
_inmemory_enable_readonly TRUE
_inmemory_repopulate_flags 2
_inmemory_hwm_expansion 0
_inmemory_dbg_scan 0
_inmemory_query_check 0
_inmemory_test_verification 0
_inmemory_invalidate_cursors TRUE
_inmemory_prepopulate_fg 0
_inmemory_format_compatible 19.0.0
_inmemory_prepopulate TRUE
_inmemory_trickle_repopulate TRUE
_inmemory_trickle_repopulate_threshold_d 0
irty_ratio
_inmemory_trickle_repopulate_min_interva 300
l
_inmemory_trickle_repopulate_fg 0
_inmemory_max_delta 5
_inmemory_delta_population 0
_inmemory_min_delta_blocks 50
_inmemory_min_delta_rows 255
_inmemory_scan_invalid_percent 30
_inmemory_external_table TRUE
_inmemory_parallel_load_ext TRUE
_inmemory_dynamic_scans AUTO
_inmemory_dynamic_scans_batch_size 500
_inmemory_dynamic_scans_analyze_batch_si 5
ze
_inmemory_dynamic_scan_disable_threshold 10
_inmemory_dynamic_scans_dbg 0
_inmemory_suppress_vsga_ima FALSE
_inmemory_force_non_engineered FALSE
_inmemory_hwm_expand_percent 20
_globaldict_enable 2
_globaldict_chunk_minalloc FALSE
_globaldict_use_ndv TRUE
_globaldict_dbg 0
_globaldict_reprobe_limit 1
_globaldict_chain_limit 32
_globaldict_check 0
_globaldict_analyzer_pct 100
_globaldict_max_gdsize 1073741824
inmemory_automatic_level OFF
_imado_diagtasks_log_period 5
_imado_diagtasks_purge_period 30
_imado_sysaux_usage_limit 90
_imado_disable_bg FALSE
_imado_mem_threshold 98
_imado_optim_algo GREEDY
_imado_optimize_period 0
_imado_verification 0
_imado_evict_sf 2
_cellcache_default_flags 2
_cellcache_default_new FALSE
_cellcache_clause_default
_index_load_buf_oltp_sacrifice_pct 10
_index_load_buf_oltp_under_pct 85
_index_load_buf_oltp_over_retry 0
_index_load_last_leaf_comp 85
_index_load_min_key_count 10
_index_load_analysis_frequency 4
_kdizoltp_uncompsentinal_freq 16
_kdfs_trace 1
_kdfs_trace_size 131072
_kdfs_timer_dmp FALSE
_kdfs_fix_control 0
_worker_threads 0
_advanced_index_compression_umem_options 2147483647
_advanced_index_compression_options 0
_advanced_index_compression_cmp_options 0
_advanced_index_compression_tst_options 0
_advanced_index_compression_opt_options 0
_advanced_index_compression_options_valu 0
e
_advanced_index_compression_recmp_cusz 90
_advanced_index_compression_recmp_crsz 10
_advanced_index_compression_recmp_nprg 10
_column_level_stats OFF
_column_stats_mem_limit 10
_column_stats_flush_interval 60
_column_stats_max_entries_per_stat 5
_kdkv_trace FALSE
_kdkv_force_fastpath FALSE
_kdkv_index_lossy TRUE
_kdkv_index_relocate FALSE
_kdkv_fg_populate FALSE
_kdkv_fg_no_memopt FALSE
_kdkv_fg_drop_memopt TRUE
_kdkv_fg_repopulate FALSE
_kdkv_indexinvalid FALSE
_kdkv_force_samehash FALSE
_kdfip_flush_nrows 2147483647
_kdfip_flush_rowsz 1048576
_kdfip_flush_rowtm 60
_kdfip_cmap_nbkt 16
_kdfip_iga_bufsz 1048576
_kdfip_iga_maxsz 2147483648
_kdfip_iga_minsz 268435456
_kdfip_par_flush TRUE
_kdfip_trace FALSE
_kdfip_debug 0
_kdfip_elem_nclatch 64
_kdfip_bufl_nbkt 128
_kdfip_drain_sleeps 60
_kqr_optimistic_reads TRUE
_kqr_enable_conservative_logging TRUE
_max_row_cache_dumps 1000
_row_cache_dump_interval 0
_row_cache_dump_cooling_period 10
_row_cache_cursors 20
_kqdsn_instance_digits 2
_kqdsn_cpu_digits 3
_kgl_cluster_lock TRUE
_kgl_cluster_pin TRUE
_kgl_cluster_lock_read_mostly FALSE
_kgl_latch_count 0
_kgl_heap_size 4096
_kgl_fixed_extents TRUE
_kgl_bucket_count 9
_library_cache_advice TRUE
_kglsim_maxmem_percent 5
_kgl_hash_collision FALSE
_kgl_time_to_wait_for_locks 15
_kgl_large_heap_warning_threshold 52428800
_kgl_large_heap_assert_threshold 524288000
_synonym_repoint_tracing FALSE
_ignore_fg_deps
_trace_kqlidp FALSE
_force_standard_compile FALSE
_disable_fast_validate FALSE
_kgl_message_locks 0
_kql_clientlocks_enabled 15
_kgl_debug
_mutex_wait_time 1
_mutex_spin_count 255
_mutex_wait_scheme 2
_kgl_min_cached_so_count 1
_kgl_hot_object_copies 0
_kgl_kqr_cap_so_stacks 0
_invalidate_upon_revoke TRUE
_pseudo_bootstrap FALSE
_kgl_iterator_action SKIP
_max_library_cache_dumps 1000
_library_cache_dump_interval 0
_library_cache_dump_cooling_period 10
_enable_kqf_purge TRUE
create_stored_outlines
_object_number_cache_size 5
_enable_Front_End_View_Optimization 1
_max_remote_tool_requests 10
serial_reuse disable
_cursor_features_enabled 2
_session_page_extent 2048
_cursor_runtimeheap_memlimit 5242880
_kgx_latches 1024
_cursor_stats_enabled TRUE
_enable_editions_for_users FALSE
_disable_actualization_for_grant FALSE
_ignore_edition_enabled_for_EV_creation FALSE
_cvw_examine_tables_in_from_list_subqry TRUE
ldap_directory_access NONE
_ldap_password_oneway_auth FALSE
ldap_directory_sysauth no
os_roles FALSE
rdbms_server_dn
_lock_dc_users_time 120
_enable_secure_sub_role FALSE
remote_os_authent FALSE
remote_os_roles FALSE
_case_sensitive_logon TRUE
sec_case_sensitive_logon TRUE
_VIEW_DICTIONARY_ACCESSIBILITY FALSE
_restrict_become_user TRUE
_enable_http_digest_generation TRUE
_nls_binary TRUE
_passwordfile_enqueue_timeout 900
remote_login_passwordfile EXCLUSIVE
license_max_users 0
_iat_frequency_short FALSE
_dynamic_rls_policies TRUE
_virtual_column_access_control TRUE
_allow_insert_with_update_check FALSE
_session_context_size 10000
audit_sys_operations TRUE
_default_encrypt_alg 0
_tsenc_obfuscate_key BOTH
_db_discard_lost_masterkey FALSE
_db_generate_dummy_masterkey FALSE
_use_fips_mode FALSE
DBFIPS_140 FALSE
one_step_plugin_for_pdb_with_tde FALSE
external_keystore_credential_location
_heartbeat_period_multiplier 0
_heartbeat_config NONE
_redo_log_key_reuse_count 0
_stats_encryption_enabled FALSE
_REMOVE_INACTIVE_STANDBY_TDE_MASTER_KEY FALSE
_standby_newkey_keystore_location
_REMOVE_STDBY_OLD_KEY_AFTER_CHECKPOINT_S TRUE
CN
_ols_cleanup_task TRUE
_sys_logon_delay 1
_pbkdf2_sder_count 3
_resource_includes_unlimited_tablespace FALSE
_priv_for_set_current_schema FALSE
_xs_cleanup_task TRUE
_xs_logon_grant FALSE
_xds_max_child_cursors 100
_fusion_security TRUE
_radm_enabled TRUE
_strict_redaction_semantics TRUE
_xs_dispatcher_only FALSE
_unified_audit_policy_disabled FALSE
unified_audit_sga_queue_size 1048576
_unified_audit_flush_threshold 85
_unified_audit_flush_interval 3
_asm_audit_sp_param
_disable_asm_audit_feat 0
_ldap_config_ssl_for_sasl_md5 TRUE
_ldap_config_force_sync_up FALSE
_ldap_reset_user_account_flc TRUE
_ldap_no_nested_group_search FALSE
_ldap_adaptive_to_no_nested_group_search TRUE
wallet_root
tde_configuration
_purge_idcs_access_token FALSE
db_domain
global_names FALSE
distributed_lock_timeout 60
_distributed_recovery_connection_hold_ti 200
me
_reco_sessions_max_percentage 50
commit_point_strength 1
_k2q_latches 0
_clusterwide_global_transactions TRUE
global_txn_processes 1
_autotune_gtx_threshold 60
_forwarded_2pc_threshold 10
_disable_autotune_gtx FALSE
_autotune_gtx_interval 5
_autotune_gtx_idle_time 600
_enable_separable_transactions FALSE
_xa_internal_retries 600
_restrict_db_link_user_entries 10000
_db_link_sources_tracking TRUE
_external_scn_activity_tracking TRUE
instance_name TEST
dispatchers (PROTOCOL=TCP) (SERVICE=TESTXD
B)
shared_servers 1
max_shared_servers
max_dispatchers
circuits
shared_server_sessions
_pmon_load_constants 300,192,64,3,10,10,0,0
_dispatcher_rate_ttl
_dispatcher_rate_scale
_enable_shared_server_vector_io FALSE
_shared_server_load_balance 0
_enable_shared_server_sizing TRUE
_enable_shared_server_sizing_slope FALSE
_shared_server_sizing_coeff 1000
_shared_servers_performance 0
_dispatcher_listen_on_vip FALSE
_shared_server_num_queues 1
_kernel_message_network_driver FALSE
_dedicated_server_poll_count 10
_dedicated_server_post_wait_call FALSE
_dedicated_server_post_wait FALSE
use_dedicated_broker FALSE
_mpmt_fg_enabled FALSE
_bequeath_via_broker FALSE
connection_brokers ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
_cp_num_hash_latches 1
_connection_broker_host localhost
_connection_broker_handout_accept FALSE
local_listener
forward_listener
remote_listener
listener_networks
__reload_lsnr
_disable_duplicate_service_warning FALSE
_pdb_service_on_root_listener FALSE
_fast_cursor_reexecute FALSE
cursor_space_for_time FALSE
session_cached_cursors 50
_cursor_obsolete_threshold 8192
_disable_cursor_sharing FALSE
_cursor_reload_failure_threshold 0
_cursor_diagnostic_node_agedout_count 100
_max_sql_stmt_length 0
_monitor_sql_stmt_length FALSE
_kks_cached_parse_errors 0
_kks_obsolete_dump_threshold 1
_kks_parse_error_warning 100
_dump_qbc_tree 0
_sql_alias_scope TRUE
remote_dependencies_mode TIMESTAMP
smtp_out_server
_plsql_dump_buffer_events
plsql_v2_compatibility FALSE
_ncomp_shared_objects_dir
plsql_warnings DISABLE:ALL
plsql_code_type INTERPRETED
_plsql_anon_block_code_type INTERPRETED
plsql_debug FALSE
plsql_optimize_level 2
plsql_ccflags
_inline_sql_in_plsql FALSE
plscope_settings IDENTIFIERS:NONE
_plsql_native_frame_threshold 4294967294
_plsql_nvl_optimize FALSE
_plsql_icd_arg_dump FALSE
_plsql_max_stack_size 0
permit_92_wrap_format TRUE
_EnableShadowTypes FALSE
java_jit_enabled TRUE
java_restrict none
job_queue_processes 20
_job_queue_interval 5
scheduler_follow_pdbtz FALSE
_redef_on_statement FALSE
_duplicated_table_complete_refresh_perce 50
nt
_dbms_sql_security_level 1
parallel_min_percent 0
_parallel_default_max_instances 1
_system_trig_enabled TRUE
_AllowMultInsteadofDDLTrigger 0
_kktAllowInsteadOfDDLTriggeronDDL 0
_EnableDDLTtriggerTracing FALSE
create_bitmap_area_size 8388608
bitmap_merge_area_size 1048576
_kkfi_trace FALSE
_lock_ref_constraint_count 50
_lock_next_constraint_count 3
cursor_sharing EXACT
_adjust_literal_replacement FALSE
_kolfuseslf FALSE
_lock_ref_descendants_count 50
_kkpogpi_nocpy 1
_system_partition_with_default FALSE
_autotbs_management_enabled FALSE
_create_idx_from_constraint FALSE
_kkpo_ctb_allow_vpd FALSE
result_cache_mode MANUAL
_result_cache_auto_size_threshold 100
_result_cache_auto_time_threshold 1000
_result_cache_auto_execution_threshold 1
_result_cache_deterministic_plsql FALSE
_max_string_size_bypass 0
_qkslvc_extended_bind_sz 1
_qkslvc_47510_test 0
_qkslvc_47510_sys 1
_utl32k_mv_query FALSE
_STFTranslateDynamicSQL FALSE
_bigdata_external_table TRUE
_external_table_hive_partition_restricte TRUE
d
_qksfgi_disable_action_mask 0
_qksfgi_disable_oct_mask 0
_qksfgi_dynamic_partitions
_qksfgi_feature_level 0
_qksfgi_dix_val FALSE
_session_cached_instantiations 60
_protect_frame_heaps FALSE
_frame_cache_time 0
_cursor_cache_time 900
_aged_out_cursor_cache_time 300
_kxscio_cap_stacks FALSE
_plsql_share_instantiation TRUE
_px_trace none
_xt_trace none
_xt_coverage none
_ku_trace none
_optimizer_trace none
parallel_min_servers 2
parallel_max_servers 20
_parallel_server_idle_time 30000
_parallel_server_sleep_time 1
_px_send_timeout 300
_dynamic_stats_threshold 30
parallel_instance_group
_px_execution_services_enabled TRUE
_parallel_fake_class_pct 0
_px_load_publish_interval 200
_px_proactive_slave_alloc_threshold 2
_px_load_balancing_policy UNIFORM
_px_dp_array_size 32767
_px_parallel_spawn_min_count 2
_px_increase_join_frag_size TRUE
parallel_execution_message_size 16384
_parallel_execution_message_align FALSE
_PX_use_large_pool FALSE
_parallel_min_message_pool 491520
_px_buffer_ttl 30
_tq_dump_period 0
_affinity_on TRUE
_enable_default_affinity 0
_px_max_map_val 32
_dss_cache_flush FALSE
_dss_cache_flush_threshold 1
_hash_join_enabled TRUE
hash_area_size 131072
_hash_multiblock_io_count 0
_cursor_db_buffers_pinned 435
_old_connect_by_enabled FALSE
_table_lookup_prefetch_size 40
_multi_join_key_table_lookup TRUE
_table_lookup_prefetch_thresh 2
_adaptive_fetch_enabled TRUE
_query_execution_cache_max_size 131072
_fast_dual_enabled TRUE
_newsort_enabled TRUE
_newsort_type 0
_newsort_ordered_pct 63
_recursive_with_max_recursion_level 0
_sort_spill_threshold 0
_queue_buffer_max_dump_len 65536
_force_hash_join_spill FALSE
_nlj_batching_ae_flag 2
_sort_sync_min_spillsize 262144
_sort_sync_min_spill_threshold 90
_sqlexec_cache_aware_hash_join_enabled TRUE
_sqlexec_encoding_aware_hj_enabled TRUE
_sqlexec_sort_uses_xmem TRUE
_sqlexec_hash_join_uses_xmem FALSE
_sqlexec_encoding_aware_hj_min_compressi 8
on_ratio
_sqlexec_join_group_aware_hj_enabled TRUE
_sqlexec_join_group_aware_hj_unencoded_r 50
owsets_tolerated
_sqlexec_cache_aware_hash_aggr_enabled TRUE
_sqlexec_bitmap_options 0
_sqlexec_bitmap_sparse_size 100
_sysdate_at_dbtimezone FALSE
_in_memory_cdt LIMITED
_in_memory_ts_only OFF
_in_memory_memory_threshold 40
_in_memory_cdt_maxpx 4
_ptt_max_num 16
private_temp_table_prefix ORA$PTT_
_in_memory_cleanup_wait_timeout 10000
_fix_control
_sdiag_crash NONE
result_cache_max_size 8060928
result_cache_max_result 5
result_cache_remote_expiration 0
_result_cache_block_size 1024
_result_cache_copy_block_count 1
_result_cache_global TRUE
_result_cache_per_pdb TRUE
_result_cache_timeout 10
_result_cache_white_list
_result_cache_black_list
_result_cache_latch_free_reads ADMIN
_result_cache_auto_time_distance 300
_result_cache_auto_dml_monitoring_slots 4
_result_cache_auto_dml_monitoring_durati 15
on
_result_cache_auto_dml_threshold 16
_result_cache_auto_dml_trend_threshold 20
_parallel_queuing_max_waitingtime
_cell_offload_expressions TRUE
_cell_materialize_virtual_columns TRUE
_cell_materialize_all_expressions FALSE
_cell_offload_sys_context TRUE
_gby_vector_aggregation_enabled TRUE
_key_vector_max_size 0
_key_vector_predicate_enabled TRUE
_key_vector_predicate_threshold 0
_key_vector_offload predicate
_vector_operations_control 0
_vector_serialize_temp_threshold 1000
_always_vector_transformation FALSE
_vector_aggregation_max_size 0
_vector_dense_accum_max 100
_key_vector_create_pushdown_threshold 20000
_key_vector_alternate_dictionary TRUE
_key_vector_force_alternate_dictionary FALSE
_key_vector_shared_dgk_ht TRUE
_key_vector_double_enabled TRUE
_key_vector_timestamp_enabled TRUE
_cell_offload_vector_groupby_withnojoin TRUE
_key_vector_join_pushdown_enabled TRUE
_cell_offload_grand_total TRUE
_ptf_max_rows 1024
_qesma_mvob_lru_sz 25
_qesma_bo_lru_sz 25
_qesmasc_trc 0
_ptf_enable_objects FALSE
_oss_skgxp_udp_dynamic_credit_mgmt
shadow_core_dump partial
background_core_dump partial
background_dump_dest /oracle/app/oracle/product/19.
3.0/rdbms/log
user_dump_dest /oracle/app/oracle/product/19.
3.0/rdbms/log
core_dump_dest /oracle/app/diag/rdbms/test/TE
ST/cdump
_oradbg_pathname
_shmprotect 0
_crash_domain_on_exception 0
_online_patch_disable_stack_check FALSE
_vendor_lib_loc
_disable_sun_rsm TRUE
_ipc_test_failover 0
_ipc_test_mult_nets 0
_ipc_fail_network 0
audit_file_dest /oracle/app/admin/TEST/adump
audit_syslog_level
unified_audit_systemlog
unified_audit_common_systemlog
_enable_event_ports TRUE
_event_port_opts
_enable_thr_kill TRUE
_sem_per_semid
_ops_per_semop
_use_futex_ipc FALSE
_posix_spawn_enabled TRUE
_datapump_inherit_svcname TRUE
_disable_streams_diagnostics 0
resource_manage_goldengate FALSE
_max_aq_persistent_queue_memory 10
object_cache_optimal_size 10240000
object_cache_max_size_percent 10
_no_objects FALSE
lob_signature_enable FALSE
_kokli_cache_size 128
_kokln_current_read FALSE
session_max_open_files 10
_domain_index_batch_size 2000
_domain_index_dml_batch_size 200
_odci_aggregate_save_space FALSE
_odci_index_pmo_rebuild FALSE
_nchar_imp_conv TRUE
_insert_enable_hwm_brokered TRUE
_pgactx_cap_stacks FALSE
open_links 4
open_links_per_instance 4
_all_shared_dblinks
_disttxn_for_queries TRUE
_close_cached_open_cursors FALSE
_disable_savepoint_reset FALSE
commit_write
commit_wait
commit_logging
_init_sql_file ?/rdbms/admin/sql.bsq
optimizer_features_enable 19.1.0
fixed_date
audit_trail DB
sort_area_size 65536
sort_area_retained_size 0
_sort_multiblock_read_count 2
_shrunk_aggs_enabled TRUE
_sql_ncg_mode OFF
_cell_storidx_mode EVA
_cell_storidx_minmax_enabled TRUE
_deferred_constant_folding_mode DEFAULT
_rdbms_internal_fplib_raise_errors FALSE
_rdbms_internal_fplib_enabled FALSE
_cell_index_scan_enabled TRUE
_cell_range_scan_enabled TRUE
_cell_offload_virtual_columns TRUE
_cell_offload_predicate_reordering_enabl FALSE
ed
_cell_offload_timezone TRUE
_direct_read_decision_statistics_driven TRUE
cell_offload_processing TRUE
_cell_offload_hybrid_processing TRUE
_cell_offload_complex_processing TRUE
cell_offload_decryption TRUE
cell_offload_parameters
cell_offload_compaction ADAPTIVE
cell_offload_plan_display AUTO
_cell_offload_vector_groupby TRUE
_cell_offload_vector_groupby_force FALSE
_shrunk_aggs_disable_threshold 60
_gby_onekey_enabled TRUE
db_name TEST
db_unique_name TEST
open_cursors 300
ifile
sql_trace FALSE
os_authent_prefix ops$
_sql_connect_capability_table
optimizer_mode ALL_ROWS
_optimizer_mode_force TRUE
_explain_rewrite_mode FALSE
_query_rewrite_or_error FALSE
_sort_elimination_cost_ratio 0
sql92_security TRUE
_grant_secure_role FALSE
_sql_connect_capability_override 0
blank_trimming FALSE
_always_anti_join CHOOSE
_optimizer_null_aware_antijoin TRUE
_optimizer_partial_join_eval TRUE
_partition_view_enabled TRUE
_always_star_transformation FALSE
_b_tree_bitmap_plans TRUE
star_transformation_enabled FALSE
_column_elimination_off FALSE
_cpu_to_io 0
_optimizer_extended_cursor_sharing UDO
_optimizer_extended_cursor_sharing_rel SIMPLE
_optimizer_adaptive_cursor_sharing TRUE
_optimizer_cost_model CHOOSE
_optimizer_undo_cost_change 19.1.0
_optimizer_system_stats_usage TRUE
_optimizer_cache_stats FALSE
_new_sort_cost_estimate TRUE
_complex_view_merging TRUE
_simple_view_merging TRUE
_unnest_subquery TRUE
_optimizer_unnest_all_subqueries TRUE
_optimizer_unnest_scalar_sq TRUE
_eliminate_common_subexpr TRUE
_pred_move_around TRUE
_convert_set_to_join FALSE
_px_bind_peek_sharing TRUE
_px_ual_serial_input TRUE
_px_minus_intersect TRUE
_remove_aggr_subquery TRUE
_distinct_view_unnesting FALSE
_optimizer_push_down_distinct 0
_optimizer_cost_based_transformation LINEAR
_optimizer_squ_bottomup TRUE
_optimizer_cbqt_factor 50
_push_join_predicate TRUE
_push_join_union_view TRUE
_push_join_union_view2 TRUE
_fast_full_scan_enabled TRUE
_optimizer_skip_scan_enabled TRUE
_optimizer_join_sel_sanity_check TRUE
_optim_enhance_nnull_detection TRUE
_enable_cscn_caching FALSE
_parallel_broadcast_enabled TRUE
_px_broadcast_fudge_factor 100
_px_kxib_tracing 0
_px_granule_size 1000000
_px_chunk_size 1000000
_px_xtgranule_size 10000
_xtbigdata_max_buffersize 10240
_xtbuffer_size 0
parallel_degree_policy MANUAL
_px_min_granules_per_slave 13
_px_split_batches_per_slave 7
_px_split_use_single_list TRUE
_px_split_multi_msg TRUE
_px_max_granules_per_slave 100
_px_no_stealing FALSE
_px_no_granule_sort FALSE
_px_proc_constrain TRUE
_px_freelist_latch_divisor 2
parallel_adaptive_multi_user FALSE
parallel_threads_per_cpu 1
_parallel_adaptive_max_users 4
_parallel_cluster_cache_policy ADAPTIVE
_parallel_load_balancing TRUE
_parallel_load_bal_unit 0
_parallel_slave_acquisition_wait 1
_px_io_system_bandwidth 0
_px_io_process_bandwidth 200
_pdml_slaves_diff_part TRUE
_pdml_gim_sampling 5000
_pdml_gim_staggered FALSE
_px_dynamic_opt TRUE
_px_dynamic_sample_size 50
_px_rownum_pd TRUE
_predicate_elimination_enabled TRUE
_groupby_nopushdown_cut_ratio 3
_groupby_orderby_combine 5000
_temp_tran_block_threshold 100
_temp_tran_cache TRUE
_ordered_semijoin TRUE
_always_semi_join CHOOSE
_ordered_nested_loop TRUE
_nested_loop_fudge 100
_project_view_columns TRUE
_no_or_expansion FALSE
_optimizer_max_permutations 2000
optimizer_index_cost_adj 100
optimizer_index_caching 0
_system_index_caching 0
_serial_direct_read auto
_disable_datalayer_sampling FALSE
_disable_sample_io_optim FALSE
_sample_rows_per_block 4
_ncmb_readahead_enabled 0
_ncmb_readahead_tracing 0
_nlj_batching_enabled 1
_nlj_batching_misses_enabled 1
_ioq_fanin_multiplier 2
_index_prefetch_factor 100
query_rewrite_enabled TRUE
query_rewrite_integrity enforced
_query_cost_rewrite TRUE
_query_rewrite_2 TRUE
_query_rewrite_1 TRUE
_query_rewrite_fudge 90
_query_rewrite_expression TRUE
_query_rewrite_jgmigrate TRUE
_query_rewrite_fpc TRUE
_query_rewrite_drj FALSE
_query_rewrite_maxdisjunct 257
_query_rewrite_vop_cleanup TRUE
_mmv_query_rewrite_enabled TRUE
_bt_mmv_query_rewrite_enabled TRUE
_add_stale_mv_to_dependency_list TRUE
_max_rwgs_groupings 8192
_full_pwise_join_enabled TRUE
_partial_pwise_join_enabled TRUE
_slave_mapping_enabled TRUE
_slave_mapping_group_size 0
_local_communication_costing_enabled TRUE
_local_communication_ratio 50
_parallelism_cost_fudge_factor 350
_left_nested_loops_random TRUE
_improved_row_length_enabled TRUE
_px_object_sampling 200
_px_object_sampling_multiplier 2
_index_join_enabled TRUE
_use_nosegment_indexes FALSE
_enable_type_dep_selectivity TRUE
_improved_outerjoin_card TRUE
_optimizer_adjust_for_nulls TRUE
_optimizer_degree 0
_use_column_stats_for_function TRUE
_subquery_pruning_cost_factor 20
_subquery_pruning_reduction 50
_subquery_pruning_enabled TRUE
_subquery_pruning_mv_enabled FALSE
_parallel_txn_global FALSE
_or_expand_nvl_predicate TRUE
_like_with_bind_as_equality FALSE
_table_scan_cost_plus_one TRUE
_cost_equality_semi_join TRUE
_default_non_equality_sel_check TRUE
_new_initial_join_orders TRUE
_oneside_colstat_for_equijoins TRUE
_column_tracking_level 53
_optim_peek_user_binds TRUE
_mv_refresh_selections TRUE
_cursor_plan_enabled TRUE
_minimal_stats_aggregation TRUE
_mv_complete_refresh_conventional FALSE
_mv_refresh_eut TRUE
_mav_refresh_consistent_read TRUE
_mav_refresh_opt 0
_mav_refresh_unionall_tables 3
_mv_refresh_delta_fraction 10
_mv_expression_extend_size 4096
_force_temptables_for_gsets FALSE
pga_aggregate_target 536870912
__pga_aggregate_target 536870912
_pga_max_size 209715200
workarea_size_policy AUTO
_smm_auto_min_io_size 56
_smm_auto_max_io_size 248
_smm_auto_cost_enabled TRUE
_smm_control 0
_smm_trace 0
_smm_min_size 524
_smm_max_size_static 102400
_smm_px_max_size_static 262144
_smm_max_size 102400
_smm_px_max_size 262144
_smm_retain_size 0
_smm_bound 0
_smm_advice_log_size 0
_smm_advice_enabled TRUE
_gs_anti_semi_join_allowed TRUE
_mv_refresh_use_stats FALSE
_mv_refresh_use_no_merge TRUE
_mv_refresh_use_hash_sj TRUE
_no_stale_joinback_rewrite FALSE
_mv_refresh_no_idx_rebuild FALSE
_mv_deferred_no_log_age_val TRUE
_mv_add_log_placeholder TRUE
_optim_new_default_join_sel TRUE
_optimizer_dyn_smp_blks 32
optimizer_dynamic_sampling 2
_pre_rewrite_push_pred TRUE
_optimizer_new_join_card_computation TRUE
_mav_refresh_double_count_prevented FALSE
_pct_refresh_double_count_prevented TRUE
_mv_refresh_new_setup_disabled FALSE
_load_without_compile none
_precompute_gid_values TRUE
_union_rewrite_for_gs YES_GSET_MVS
_nested_mv_fast_oncommit_enabled TRUE
_generalized_pruning_enabled TRUE
_rowsource_execution_statistics FALSE
_rowsource_profiling_statistics TRUE
_rowsource_statistics_sampfreq 128
_bitmap_or_improvement_enabled TRUE
_intrapart_pdml_enabled TRUE
_force_tmp_segment_loads FALSE
_force_slave_mapping_intra_part_loads FALSE
_intrapart_pdml_randomlocal_enabled TRUE
_optim_adjust_for_part_skews TRUE
_optimizer_compute_index_stats TRUE
_optimizer_autostats_job TRUE
_optimizer_push_pred_cost_based TRUE
_optimizer_extend_jppd_view_types TRUE
_optimizer_filter_pred_pullup TRUE
_optimizer_connect_by_cost_based TRUE
_optimizer_connect_by_combine_sw TRUE
_optimizer_connect_by_elim_dups TRUE
_connect_by_use_union_all TRUE
_force_datefold_trunc FALSE
statistics_level TYPICAL
_array_update_vector_read_enabled FALSE
_two_pass_reverse_polish_enabled TRUE
_expand_aggregates TRUE
_dump_common_subexpressions FALSE
_spr_use_AW_AS TRUE
_dump_connect_by_loop_data FALSE
_column_compression_factor 0
_dml_monitoring_enabled TRUE
_fic_algorithm_set automatic
_fic_area_size 131072
_fic_min_bmsize 1024
_dtree_area_size 131072
_dtree_pruning_enabled TRUE
_dtree_binning_enabled TRUE
_dtree_max_surrogates 1
_right_outer_hash_enable TRUE
_optimizer_mjc_enabled TRUE
_optimizer_sortmerge_join_enabled TRUE
_cursor_bind_capture_area_size 400
cursor_bind_capture_destination memory+disk
_flush_plan_in_awr_sql 0
_cursor_bind_capture_interval 900
_dump_cursor_heap_sizes FALSE
_projection_pushdown TRUE
_projection_pushdown_debug 0
_px_compilation_debug 0
_px_compilation_trace 0
_trace_virtual_columns FALSE
_replace_virtual_columns TRUE
_virtual_column_overload_allowed TRUE
_kdt_buffering TRUE
_disable_parallel_conventional_load FALSE
_ltc_trace 0
_print_refresh_schedule false
_optimizer_undo_changes FALSE
_optimizer_percent_parallel 101
_optimizer_search_limit 5
skip_unusable_indexes TRUE
_mv_refresh_costing rule
_mv_refresh_ana 0
_cache_stats_monitor FALSE
_sta_control 0
_enable_automatic_sqltune TRUE
_sql_analyze_enable_auto_txn FALSE
_ds_enable_auto_txn FALSE
_sql_analyze_parse_model 2
_ds_parse_model 2
_kes_parse_model 2
_ds_iocount_iosize 6553664
_ds_xt_split_count 1
_ds_progressive_no_matches_min_sample_si 50
ze
_ds_progressive_initial_samples 2
_ds_sampling_method PROGRESSIVE
_ds_enable_view_sampling TRUE
_mv_refsched_timeincr 300000
_spr_push_pred_refspr TRUE
_optimizer_block_size 8192
_spr_max_rules 10000
_idxrb_rowincr 100000000
_hj_bit_filter_threshold 50
_optimizer_save_stats TRUE
_optimizer_cost_filter_pred FALSE
_optimizer_correct_sq_selectivity TRUE
_allow_commutativity TRUE
_mv_refresh_rebuild_percentage 10
_qa_control 0
_qa_lrg_type 0
_mv_refresh_force_parallel_query 0
_enable_fast_ref_after_mv_tbs FALSE
_optim_dict_stats_at_db_cr_upg TRUE
_utlmmig_table_stats_gathering TRUE
_remove_exf_component TRUE
_optimizer_dim_subq_join_sel TRUE
_optimizer_disable_strans_sanity_checks 0
_allow_level_without_connect_by FALSE
optimizer_ignore_hints FALSE
_optimizer_random_plan 0
_optimizer_ceil_cost TRUE
_delay_index_maintain TRUE
_query_rewrite_setopgrw_enable TRUE
_cursor_plan_hash_version 1
_disable_function_based_index FALSE
_optimizer_invalidation_period 18000
_px_net_msg_cost 10000
_px_loc_msg_cost 1000
_smm_freeable_retain 5120
_cursor_plan_unparse_enabled TRUE
_kill_java_threads_on_eoc FALSE
_optimizer_join_order_control 3
_px_nss_planb TRUE
_bloom_filter_enabled TRUE
_bloom_filter_debug 0
_bloom_filter_size 0
_bloom_predicate_enabled TRUE
_bloom_predicate_offload TRUE
_bloom_folding_enabled TRUE
_bloom_folding_density 16
_bloom_folding_min 0
_bloom_pushing_max 512
_bloom_max_size 262144
_bloom_pushing_total_max 262144
_bloom_minmax_enabled TRUE
_bloom_rm_filter FALSE
_bloom_sm_enabled TRUE
_bloom_serial_filter ON
_enable_refresh_schedule TRUE
_optimizer_cartesian_enabled TRUE
_optimizer_starplan_enabled TRUE
_optimizer_join_elimination_enabled TRUE
_gby_hash_aggregation_enabled TRUE
_extended_pruning_enabled TRUE
_globalindex_pnum_filter_enabled TRUE
_sql_model_unfold_forloops RUN_TIME
_enable_dml_lock_escalation TRUE
_plsql_cache_enable TRUE
_disable_fast_aggregation FALSE
_disable_adaptive_shrunk_aggregation FALSE
_plsql_minimum_cache_hit_percent 20
_plan_outline_data TRUE
_outline_bitmap_tree TRUE
_drop_table_optimization_enabled TRUE
_drop_table_granule 256
_xpl_trace 0
_dm_max_shared_pool_pct 1
_optimizer_multiple_cenv
_kql_subheap_trace 0
_optimizer_cost_hjsmj_multimatch TRUE
_optimizer_transitivity_retain TRUE
optimizer_secure_view_merging TRUE
_px_pwg_enabled TRUE
_sql_hash_debug 0
_mv_rolling_inv FALSE
_smm_isort_cap 102400
_optimizer_cbqt_no_size_restriction TRUE
_windowfunc_optimization_settings 0
_truncate_optimization_enabled TRUE
_optimizer_enhanced_filter_push TRUE
_compilation_call_heap_extent_size 16384
_xpl_peeked_binds_log_size 8192
_rowsrc_trace_level 0
_optimizer_rownum_pred_based_fkr TRUE
_optimizer_better_inlist_costing ALL
_optimizer_self_induced_cache_cost FALSE
_optimizer_min_cache_blocks 10
_enable_exchange_validation_using_check TRUE
_optimizer_or_expansion DEPTH
_optimizer_outer_to_anti_enabled TRUE
_optimizer_order_by_elimination_enabled TRUE
_optimizer_star_tran_in_with_clause TRUE
_optimizer_sortmerge_join_inequality TRUE
_selfjoin_mv_duplicates TRUE
_dimension_skip_null TRUE
_force_rewrite_enable FALSE
_optimizer_complex_pred_selectivity TRUE
_build_deferred_mv_skipping_mvlog_update TRUE
_bloom_pruning_enabled TRUE
_query_mmvrewrite_maxpreds 10
_query_mmvrewrite_maxintervals 5
_query_mmvrewrite_maxinlists 5
_query_mmvrewrite_maxdmaps 10
_query_mmvrewrite_maxcmaps 20
_query_mmvrewrite_maxregperm 512
_row_shipping_threshold 100
_row_shipping_explain FALSE
_query_mmvrewrite_maxqryinlistvals 500
_first_k_rows_dynamic_proration TRUE
_optimizer_aw_stats_enabled TRUE
_enable_row_shipping TRUE
_optimizer_skip_scan_guess FALSE
_optimizer_distinct_elimination TRUE
_add_col_optim_enabled TRUE
_optimizer_multi_level_push_pred TRUE
ddl_lock_timeout 0
_enable_ddl_wait_lock TRUE
deferred_segment_creation TRUE
_optimizer_group_by_placement TRUE
_optimizer_distinct_placement TRUE
_optimizer_coalesce_subqueries TRUE
_optimizer_enable_density_improvements TRUE
_optimizer_rownum_bind_default 10
_enable_query_rewrite_on_remote_objs TRUE
_enable_scn_wait_interface TRUE
optimizer_use_pending_statistics FALSE
_optimizer_improve_selectivity TRUE
_optimizer_aw_join_push_enabled TRUE
_cvw_enable_weak_checking TRUE
optimizer_capture_sql_plan_baselines FALSE
optimizer_use_sql_plan_baselines TRUE
_enable_online_index_without_s_locking TRUE
_dbop_enabled 1
_sqlmon_threshold 5
_sqlmon_max_plan 20
_sqlmon_max_planlines 300
_sqlmon_recycle_time 5
_sqlmon_binds_xml_format default
_optimizer_native_full_outer_join FORCE
_optimizer_ansi_join_lateral_enhance TRUE
_optimizer_multi_table_outerjoin TRUE
_optimizer_null_accepting_semijoin TRUE
_optimizer_ansi_rearchitecture TRUE
_optimizer_aggr_groupby_elim TRUE
_optimizer_enable_extended_stats TRUE
_direct_path_insert_features 0
_optimizer_free_transformation_heap TRUE
_pivot_implementation_method CHOOSE
_optimizer_use_subheap TRUE
_optimizer_or_expansion_subheap TRUE
_optimizer_star_trans_min_cost 0
_optimizer_star_trans_min_ratio 0
_with_subquery OPTIMIZER
_optimizer_reuse_cost_annotations TRUE
_optimizer_interleave_jppd TRUE
_optimizer_fkr_index_cost_bias 10
_px_dump_12805_source TRUE
parallel_min_time_threshold AUTO
_parallel_time_unit 10
parallel_degree_limit CPU
parallel_force_local FALSE
_parallel_scalability 50
_parallel_syspls_obey_force TRUE
_optimizer_nested_rollup_for_gset 100
_plan_verify_improvement_margin 150
_statistics_based_srf_enabled TRUE
_selectivity_for_srf_enabled FALSE
optimizer_use_invisible_indexes FALSE
_optimizer_extended_stats_usage_control 192
_sql_plan_management_control 0
_optimizer_fast_pred_transitivity TRUE
_optimizer_fast_access_pred_analysis TRUE
_optimizer_multiple_cenv_report result
_optimizer_multiple_cenv_stmt query
_parallel_cluster_cache_pct 80
_px_granule_batch_size 26
_optimizer_instance_count 0
_block_sample_readahead_prob_threshold 10
_mv_generalized_oj_refresh_opt TRUE
_parallel_optimization_phase_for_local FALSE
_enable_schema_synonyms FALSE
_enable_rename_user FALSE
_mv_refresh_enhanced_dml_detection ON_RC
_mv_refresh_pkfk_relationship_opt TRUE
_mv_refresh_pkfk_data_units_opt auto
_optimizer_unnest_disjunctive_subq TRUE
_optimizer_unnest_corr_set_subq TRUE
_optimizer_distinct_agg_transform TRUE
_aggregation_optimization_settings 0
_arch_compress_checksums FALSE
_optimizer_eliminate_filtering_join TRUE
dst_upgrade_insert_conv TRUE
_create_table_in_any_cluster FALSE
_dsc_feature_level 0
_parallel_statement_queuing FALSE
_parallel_conservative_queuing FALSE
parallel_servers_target 8
_px_load_factor 300
_dml_frequency_tracking FALSE
_dml_frequency_tracking_advance TRUE
_dml_frequency_tracking_slots 4
_dml_frequency_tracking_slot_time 15
_px_gim_factor 100
_add_trim_for_nlssort TRUE
_optimizer_connect_by_cb_whr_only FALSE
_optimizer_join_factorization TRUE
_optimizer_force_CBQT
_optimizer_use_cbqt_star_transformation TRUE
_rep_base_path
_optimizer_table_expansion TRUE
_and_pruning_enabled TRUE
_dml_batch_error_limit 0
_noseg_for_unusable_index_enabled TRUE
_slave_mapping_skew_ratio 2
_px_index_sampling_objsize TRUE
_sql_compatibility 0
_optimizer_use_feedback TRUE
_optimizer_gather_feedback TRUE
_optimizer_feedback_control
_optimizer_try_st_before_jppd TRUE
_parallel_blackbox_size 16384
_parallel_blackbox_enabled TRUE
_parallel_load_publish_threshold 10
_px_partition_scan_enabled TRUE
_px_partition_scan_threshold 64
_parallel_heartbeat_snapshot_interval 2
_parallel_heartbeat_snapshot_max 128
_optimizer_false_filter_pred_pullup TRUE
_px_granule_randomize TRUE
_optimizer_purge_stats_iteration_row_cou 10000
nt
_mv_refresh_update_analysis TRUE
_mv_cleanup_orphaned_metadata TRUE
_mv_refresh_insert_no_append TRUE
_part_redef_global_index_update TRUE
_ptn_cache_threshold 1
_optimizer_enable_table_lookup_by_nl TRUE
_px_max_message_pool_pct 40
_px_chunklist_count_ratio 32
_px_hold_time 0
_optimizer_generate_transitive_pred TRUE
_optimizer_cube_join_enabled TRUE
_optimizer_filter_pushdown TRUE
max_string_size STANDARD
_dm_enable_legacy_dmf_output_types FALSE
_dm_dmf_details_compatibility 12.1.0
_cdc_subscription_owner
_optimizer_outer_join_to_inner TRUE
_optimizer_hybrid_fpwj_enabled TRUE
_px_message_compression TRUE
_px_object_sampling_enabled TRUE
_px_concurrent TRUE
_px_back_to_parallel OFF
_scalar_type_lob_storage_threshold 4000
_px_replication_enabled TRUE
_px_round_robin_rowcnt 1000
_zonemap_use_enabled TRUE
_zonemap_staleness_tracking 1
_zonemap_control 0
_zonemap_usage_tracking TRUE
_sql_plan_directive_mgmt_control 67
_optimizer_full_outer_join_to_outer TRUE
_px_filter_parallelized TRUE
_px_filter_skew_handling TRUE
_px_groupby_pushdown FORCE
_partition_advisor_srs_active true
_px_parallelize_expression TRUE
_fast_index_maintenance TRUE
_optimizer_gather_stats_on_load TRUE
_multi_transaction_optimization_enabled TRUE
_optimizer_batch_table_access_by_rowid TRUE
optimizer_adaptive_reporting_only FALSE
_optimizer_ads_max_table_count 0
_optimizer_ads_time_limit 0
_optimizer_ads_use_result_cache TRUE
_optimizer_ads_result_cache_life 3600
_optimizer_ads_use_spd_cache TRUE
_optimizer_ads_spd_cache_owner_limit 64
_px_wif_dfo_declumping CHOOSE
_px_wif_extend_distribution_keys TRUE
_px_wif_min_ndv_per_slave 2
_px_join_skew_handling TRUE
_px_join_skew_ratio 10
_px_join_skew_minfreq 30
_px_join_skew_use_histogram TRUE
_px_join_skew_sampling_time_limit 50
_px_join_skew_sampling_percent 0
_px_adaptive_dist_method CHOOSE
_px_adaptive_dist_method_threshold 0
_px_adaptive_dist_bypass_enabled TRUE
_px_adaptive_dist_bypass_optimization 1
_parallel_fault_tolerance_enabled FALSE
_parallel_fault_tolerance_threshold 3
_px_partial_rollup_pushdown ADAPTIVE
_sql_diag_repo_retain
_sql_diag_repo_origin all
_optimizer_dsdir_usage_control 0
_px_cpu_autodop_enabled TRUE
_px_cpu_process_bandwidth 200
_px_cpu_operator_bandwidth
_px_single_server_enabled TRUE
_optimizer_use_gtt_session_stats TRUE
optimizer_adaptive_plans TRUE
_optimizer_adaptive_plan_control 0
_optimizer_adaptive_random_seed 0
_optimizer_strans_adaptive_pruning TRUE
_optimizer_proc_rate_level BASIC
_px_hybrid_TSM_HWMB_load TRUE
_optimizer_use_histograms TRUE
_disable_directory_link_check FALSE
_add_nullable_column_with_default_optim TRUE
_emx_max_sessions 128
_emx_session_timeout 3600
_emx_control 0
_parallel_blackbox_sga TRUE
_rowsets_enabled TRUE
_rowsets_target_maxsize 524288
_rowsets_max_rows 256
_rowsets_use_encoding TRUE
_rowsets_max_enc_rows 64
_px_load_monitor_threshold 10000
_px_numa_support_enabled FALSE
_px_numa_stealing_enabled TRUE
_px_adaptive_offload_threshold 10
_px_adaptive_offload_percentage 30
_modify_column_index_unusable FALSE
_adaptive_window_consolidator_enabled TRUE
_sql_hvshare_threshold 0
_px_tq_rowhvs TRUE
_sql_hvshare_debug 1
_sql_show_expreval FALSE
_parallel_ctas_enabled TRUE
_optimizer_performance_feedback OFF
_optimizer_proc_rate_source DEFAULT
_hashops_prefetch_size 4
_stat_aggs_one_pass_algorithm FALSE
_px_onepass_slave_acquisition TRUE
_part_access_version_by_number TRUE
_online_ctas_diag 0
_upddel_dba_hash_mask_bits 0
_px_pwmr_enabled TRUE
_px_cdb_view_enabled TRUE
_optimizer_cluster_by_rowid TRUE
_optimizer_cluster_by_rowid_control 129
_partition_cdb_view_enabled TRUE
_common_data_view_enabled TRUE
_optimizer_cbqt_or_expansion ON
_pred_push_cdb_view_enabled TRUE
_rowsets_cdb_view_enabled TRUE
_distinct_agg_optimization_gsets CHOOSE
_array_cdb_view_enabled TRUE
_mv_refresh_pipe_timeout 600
_mv_refresh_truncate_log FALSE
_rc_sys_obj_enabled TRUE
_px_scalable_invdist TRUE
_indexable_con_id TRUE
_optimizer_reduce_groupby_key TRUE
_optimizer_cluster_by_rowid_batched TRUE
_optimizer_cluster_by_rowid_batch_size 100
_object_link_fixed_enabled TRUE
_optimizer_synopsis_min_size 2
_merge_monitor_threshold 10000
optimizer_inmemory_aware TRUE
_optimizer_inmemory_table_expansion TRUE
_optimizer_inmemory_gen_pushable_preds TRUE
_optimizer_inmemory_autodop TRUE
_optimizer_inmemory_access_path TRUE
_optimizer_inmemory_quotient 0
_optimizer_inmemory_pruning_ratio_rows 100
_parallel_inmemory_min_time_threshold AUTO
_parallel_inmemory_time_unit 1
_px_external_table_default_stats TRUE
_optimizer_nlj_hj_adaptive_join TRUE
_px_autodop_pq_overhead TRUE
_px_overhead_init_slavealloc 1000
_px_overhead_init_endpoints 4
_px_overhead_exec_ctrlmesg 4
_px_overhead_teardown 600
_grant_read_instead_of_select FALSE
_optimizer_inmemory_bloom_filter TRUE
_optimizer_inmemory_cluster_aware_dop TRUE
_optimizer_inmemory_minmax_pruning TRUE
_cdb_cross_container 65535
_cdb_view_parallel_degree 65535
_optimizer_hll_entry 4096
_cross_con_row_count FALSE
_cdb_view_prefetch_batch_size 200
_cdb_view_rc_shelflife 30
_approx_cnt_distinct_gby_pushdown choose
_approx_cnt_distinct_optimization 0
_px_cdb_view_join_enabled TRUE
_external_table_smart_scan HADOOP_ONLY
_optimizer_db_blocks_buffers 0
_composite_interval_partition_creation_o TRUE
pt_enabled
_optimizer_bushy_join off
_optimizer_bushy_fact_dim_ratio 20
_optimizer_bushy_fact_min_size 100000
_optimizer_bushy_cost_factor 100
_query_rewrite_use_on_query_computation TRUE
_mv_access_compute_fresh_data ON
_px_min_ndv_per_slave_perc_func 2
_px_scalable_invdist_mcol TRUE
_rmt_for_table_redef_enabled TRUE
_query_execution_time_limit 0
_optimizer_ads_use_partial_results TRUE
_optimizer_eliminate_subquery TRUE
cursor_invalidation IMMEDIATE
_sqlexec_hash_based_distagg_enabled FALSE
_sqlexec_disable_hash_based_distagg_tiv FALSE
_sqlexec_hash_based_distagg_ssf_enabled TRUE
_sqlexec_distagg_optimization_settings 0
approx_for_aggregation FALSE
approx_for_count_distinct FALSE
_optimizer_union_all_gsets TRUE
_optimizer_enhanced_join_elimination TRUE
_optimizer_multicol_join_elimination TRUE
_optimizer_enable_plsql_stats TRUE
_recursive_with_parallel TRUE
_recursive_with_using_temp_table FALSE
_recursive_with_branch_iterations 7
_recursive_with_control 0
_partition_read_only TRUE
_px_dist_agg_partial_rollup_pushdown ADAPTIVE
_mv_refresh_shrink_log TRUE
_pwise_distinct_enabled TRUE
_approx_perc_sampling_err_rate 2
_vector_encoding_mode MANUAL
_optimizer_use_table_scanrate HADOOP_ONLY
_optimizer_use_xt_rowid TRUE
_xt_sampling_scan_granules ON
_xt_sampling_scan_granules_min_granules 1
_xt_def_compression_ratio 4
_xt_legacy_debug_flags 0
_xt_enable_columnar_fetch TRUE
_sqlexec_use_rwo_aware_expr_analysis TRUE
_monitor_workload_interval 24
_optimizer_band_join_aware TRUE
_optimizer_vector_transformation TRUE
_optimizer_vector_fact_dim_ratio 10
_optimizer_vector_min_fact_rows 10000000
_optimizer_key_vector_aggr_factor 75
_optimizer_vector_cost_adj 100
_optimizer_key_vector_pruning_enabled TRUE
_optimizer_vector_base_dim_fact_factor 200
approx_for_percentile none
_approx_percentile_optimization 0
_optimizer_adaptive_plans_continuous FALSE
_optimizer_adaptive_plans_iterative FALSE
_optimizer_generate_ptf_implied_preds TRUE
_optimizer_inmemory_capture_stored_stats TRUE
_optimizer_inmemory_use_stored_stats AUTO
_shard_sql_use_chunk_ids 0
_expression_tracking_latch_count 16
_expression_tracking_elem_per_bucket 30
_bloom_filter_ratio 35
_optimizer_control_shard_qry_processing 65528
_optimizer_interleave_or_expansion TRUE
_px_partition_load_dist_threshold 64
optimizer_adaptive_statistics FALSE
_optimizer_use_feedback_for_join FALSE
_optimizer_ads_for_pq FALSE
_px_slave_parse_first_with_outline_hints TRUE
_px_join_skewed_values_count 0
_bloom_max_wait_time 50
_bloom_wait_on_rac FALSE
_bloom_extent_size 0
_read_optimized_table_lookup TRUE
_optimizer_key_vector_payload TRUE
_optimizer_vector_fact_payload_ratio 20
_bloom_pruning_setops_enabled TRUE
_bloom_filter_setops_enabled TRUE
_px_pwise_wif_enabled TRUE
_sqlexec_reorder_wif_enabled TRUE
_px_partition_skew_threshold 80
_sqlexec_pwiseops_with_sqlfuncs_enabled TRUE
_sqlexec_pwiseops_with_binds_enabled TRUE
optimizer_ignore_parallel_hints FALSE
_px_shared_hash_join FALSE
_px_reuse_server_groups MULTI
_px_join_skew_null_handling TRUE
_px_tq_memcpy_threshold 100
_bloom_use_shared_pool FALSE
_enable_parallel_dml FALSE
_px_nlj_bcast_rr_threshold 10
parallel_min_degree 1
_sqlexec_use_kgghash3 TRUE
_optimizer_gather_stats_on_load_all FALSE
_optimizer_gather_stats_on_load_hist FALSE
_px_granule_alignment 1024
_optimizer_allow_all_access_paths TRUE
_lob_use_locator_varying_width FALSE
_optimizer_answering_query_using_stats FALSE
_cell_offload_vector_groupby_fact_key TRUE
_px_scalable_gby_invdist TRUE
_xt_preproc_timeout 100
_px_dynamic_granules TRUE
_px_dynamic_granules_adjust 10
_px_hybrid_partition_execution_enabled TRUE
_px_hybrid_partition_skew_threshold 10
_optimizer_key_vector_use_max_size 1048576
_optimizer_non_blocking_hard_parse TRUE
_optimizer_track_hint_usage TRUE
_optimizer_compare_plans_control 0
_group_partition_data_for_impdp_ok FALSE
_optimizer_key_vector_payload_dim_aggs FALSE
_optimizer_quarantine_sql TRUE
_optimizer_use_auto_indexes AUTO
_optimizer_gather_stats_on_load_index TRUE
_optimizer_stats_on_conventional_dml_sam 100
ple_rate
_optimizer_gather_stats_on_conventional_ TRUE
dml
_optimizer_use_stats_on_conventional_dml TRUE
_optimizer_use_stats_on_conventional_con 0
fig
_optimizer_gather_stats_on_conventional_ 0
config
_dmm_ipp_cutoff 0
_dmm_nobin_threshold 200
_dmm_force_treetop_merge 0
_dmm_cnt_arr_size_threshold 500000
_dmm_sample_lower_threshold 10000
_dmm_sample_upper_threshold 500000
_dmm_auto_max_features 500
_dmm_max_memory_size 1000000
_dmm_memory_size 64000000
_dmsqr_qr_chunk_rows 10000
_dm_max_chunk_size 2000
_dm_inmemory_threshold 1000000
_bigram_dependency_percentage 5
_dmm_inc_cholesky_rows 50000
_dmm_kmean_dense_threshold 500
_dmm_blas_library
_dmm_ts_lapack 1
_dmm_reduction_rate 4
_dmm_pga_load_threshold 3
_dmm_details_filter_weight 1
_alter_upgrade_signature_only FALSE
sec_protocol_error_trace_action TRACE
sec_protocol_error_further_action (DROP,3)
_spadr YES
sec_max_failed_login_attempts 3
sec_return_server_release_banner FALSE
_sec_enable_test_rpcs FALSE
_use_zero_copy_io TRUE
enable_ddl_logging FALSE
_tstz_localtime_bypass FALSE
_client_tstz_error_check TRUE
client_result_cache_size 0
client_result_cache_lag 3000
_client_result_cache_bypass FALSE
_client_result_cache_ramthreshold
_client_result_set_threshold
_emon_regular_ntfn_slaves 4
_emon_outbound_connect_timeout 7200000
_emon_send_timeout 7200000
_emon_max_active_connections 256
_client_ntfn_pingtimeout 30000
_client_ntfn_pinginterval 75
_client_ntfn_pingretries 6
_client_enable_auto_unregister FALSE
_srvntfn_q_msgcount 50
_srvntfn_q_msgcount_inc 100
_srvntfn_jobsubmit_interval 3
_srvntfn_max_concurrent_jobs 20
_srvntfn_job_deq_timeout 60
_client_ntfn_cleanup_interval 2400
_max_clients_per_emon 8
_emon_pool_inc 4
_emon_pool_min 4
_emon_pool_max 16
_tsm_connect_string
_sscr_dir
_sscr_osdir
_tsm_disable_auto_cleanup 1
_enable_nativenet_tcpip FALSE
_client_features_tracking_enable TRUE
outbound_dblink_protocols ALL
allow_global_dblinks FALSE
_async_scn_sync OFF
_share_drcp_proxy_sessions TRUE
_request_boundaries 3
_spfoc OFF
_spfdc OFF
_spfei
client_statistics_level TYPICAL
_close_deq_by_cond_curs FALSE
_deq_maxwait_time 0
_deq_max_fetch_count 10
_deq_execute_reset_time 30
_aq_streaming_threshold 10485760
_aq_dly_bkt 2
_aq_retry_timeouts 0
_aq_scrambled_deqlog 1
_aq_dqblocks_in_cache 0
_aq_uncached_stats 0
_aq_free_list_pools 10
aq_tm_processes 1
_aq_tm_statistics_duration 0
_orph_cln_interval 1200
_aq_max_scan_delay 1500
_aq_tm_scanlimit 0
_aq_tm_deqcountinterval 0
_disable_gvaq_cache FALSE
_rule_max_dnfp_cnt 1024
_re_fast_sql_operator all
_re_result_cache_keysiz 20
_re_result_cache_size 20
_re_independent_expression_cache_size 20
_enable_iee_stats TRUE
_re_num_complex_operator 1000
_re_num_rowcache_load 2
_prop_old_enabled FALSE
_bufq_stop_flow_control FALSE
_capture_publisher_flow_control_threshol 0
d
_buffered_publisher_flow_control_thresho 0
ld
_buffered_message_spill_age 300
_deq_log_array_size 10000
_deq_ht_max_elements 100000
_deq_ht_child_latches 8
_deq_large_txn_size 25000
_aqsharded_cache_limit 0
_aq_Txn_ht_sz 1024
_aq_shard_bitmap_child_latches 32
_aq_shard_retry_child_latches 32
_aq_shard_txn_child_latches 128
_aq_shard_sub_child_latches 512
_aq_shard_sub_child_Elem_latches 1024
_aq_shard_child_latches 512
_aq_shard_prty_latches 16
_aq_init_shards 5
_aq_x_mode 1
_aq_latency_relative_threshold 100
_aq_latency_absolute_threshold 300
_aq_max_pdb_close_msg 1
_aq_lb_subht_bkt_ltch 32
_aq_lb_subht_elm_ltch 128
_aq_lb_garbage_col_interval 600
_aq_x_msg_size 32768
_aq_stop_backgrounds FALSE
_aq_lb_cycle 120
_aq_lb_stats_collect_cycle 45
_aq_pt_processes 10
_aq_subshard_Size 20000
_aq_subshards_per_qpartition 1
_aq_subshards_per_dqpartition 1
_aq_lookback_size 60
_aq_qt_prefetch_Size 5
_aq_dq_prefetch_Siz 5
_aq_pt_statistics_window 60
_aq_pt_shrink_frequency 1450
_aq_addpt_batch_size 1
_aq_truncpt_batch_size 1
_aq_droppt_batch_size 5
_shrd_que_tm_processes 1
_shrd_que_tm_statistics_duration 0
_aq_ipc_max_slave 10
_aq_opt_stat_window 21600
_aq_opt_stop_stat FALSE
_aq_opt_enabled TRUE
_aq_opt_background_enabled TRUE
_aq_opt_fudge_factor 500
_aq_opt_prefetch_horizon 60
_aq_opt_min_evict_memory 0
_aq_opt_prefetch_dop 3
_aq_opt_preevict_dop 3
hs_autoregister TRUE
_ctx_doc_policy_stems FALSE
_nonce_history_buffer_size 0
xml_db_events enable
dg_broker_start FALSE
dg_broker_config_file1 /oracle/app/oracle/product/19.
3.0/dbs/dr1TEST.dat
dg_broker_config_file2 /oracle/app/oracle/product/19.
3.0/dbs/dr2TEST.dat
_dg_broker_trace_level
_olapi_history_retention FALSE
_olapi_session_history 300
_olapi_session_history_retention FALSE
_olapi_iface_object_history 1000
_olapi_iface_object_history_retention FALSE
_olapi_interface_operation_history 1000
_olapi_iface_operation_history_retention FALSE
_olapi_memory_operation_history 1000
_olapi_memory_operation_history_retentio FALSE
n
_olapi_memory_operation_history_pause_at 0
_seqno
olap_page_pool_size 0
_olap_continuous_trace_file false
_olap_table_function_statistics FALSE
_olap_parallel_update_threshold 1000
_olap_parallel_update_small_threshold 1000
_olap_parallel_update_server_num 0
_olap_aggregate_buffer_size 1048576
_olap_aggregate_min_buffer_size 1024
_olap_aggregate_work_per_thread 1024
_olap_aggregate_min_thread_status 64
_olap_aggregate_statlen_thresh 1024
_olap_aggregate_worklist_max 5000
_olap_aggregate_max_thread_tuples 5000
_olap_aggregate_function_cache_enabled TRUE
_olap_aggregate_multipath_hier FALSE
_olap_aggregate_flags 0
_olap_allocate_errorlog_header Dim Source Basis
%-8d %-8s %-8b Description
-------- -------- -------- ---
--------
_olap_allocate_errorlog_format %8p %8y %8z %e (%n)
_olap_dbgoutfile_echo_to_eventlog FALSE
_olap_eif_export_lob_size 2147483647
_olap_sort_buffer_size 262144
_olap_sort_buffer_pct 10
_olap_sesscache_enabled TRUE
_olap_object_hash_class 3
_olap_dimension_corehash_size 30
_olap_dimension_corehash_pressure 90
_olap_dimension_corehash_large 50000
_olap_dimension_corehash_force FALSE
_olap_page_pool_low 262144
_olap_page_pool_hi 50
_olap_page_pool_expand_rate 20
_olap_page_pool_shrink_rate 50
_olap_page_pool_hit_target 100
_olap_page_pool_pressure 90
_olap_statbool_threshold 8100
_olap_statbool_corebits 20000000
_olap_lmgen_dim_size 100
_olap_lmgen_meas_size 1000
_olap_wrap_errors FALSE
_olap_analyze_max 10000
_olap_adv_comp_stats_max_rows 100000
_olap_adv_comp_stats_cc_precomp 20
_olap_row_load_time_precision DEFAULT
_olap_disable_loop_optimized FALSE
_xsolapi_fetch_type PARTIAL
_xsolapi_dimension_group_creation OVERFETCH
_xsolapi_sql_auto_measure_hints TRUE
_xsolapi_sql_auto_dimension_hints FALSE
_xsolapi_sql_hints
_xsolapi_sql_measure_hints
_xsolapi_sql_dimension_hints
_xsolapi_sql_top_measure_hints
_xsolapi_sql_top_dimension_hints
_xsolapi_sql_all_non_base_hints
_xsolapi_sql_all_multi_join_non_base_hin
ts
_xsolapi_densify_cubes TABULAR
_xsolapi_sql_optimize TRUE
_xsolapi_sql_remove_columns TRUE
_xsolapi_sql_symmetric_predicate TRUE
_xsolapi_sql_use_bind_variables TRUE
_xsolapi_sql_prepare_stmt_cache_size 16
_xsolapi_sql_result_set_cache_size 32
_xsolapi_sql_minus_threshold 1000
_xsolapi_debug_output SUPPRESS
_xsolapi_materialize_sources TRUE
_xsolapi_load_at_process_start NEVER
_xsolapi_fix_vptrs TRUE
_xsolapi_auto_materialization_type PRED_AND_RC
_xsolapi_auto_materialization_bound 20
_xsolapi_materialization_rowcache_min_ro 1
ws_for_use
_xsolapi_source_trace FALSE
_xsolapi_dml_trace
_xsolapi_build_trace FALSE
_xsolapi_metadata_reader_mode DEFAULT
_xsolapi_odbo_mode FALSE
_xsolapi_set_nls TRUE
_xsolapi_stringify_order_levels FALSE
_xsolapi_suppression_chunk_size 4000
_xsolapi_suppression_aw_mask_threshold 1000
_xsolapi_share_executors TRUE
_xsolapi_hierarchy_value_type unique
_xsolapi_use_models TRUE
_xsolapi_use_olap_dml TRUE
_xsolapi_use_olap_dml_for_rank TRUE
_xsolapi_remove_columns_for_materializat TRUE
ion
_xsolapi_precompute_subquery TRUE
_xsolapi_optimize_suppression TRUE
_xsolapi_generate_with_clause FALSE
_xsolapi_sql_enable_aw_join TRUE
_xsolapi_sql_enable_aw_qdr_merge TRUE
_xsolapi_opt_aw_position TRUE
_xsolapi_support_mtm FALSE
_asm_runtime_capability_volume_support FALSE
_asm_disable_multiple_instance_check FALSE
_asm_disable_amdu_dump FALSE
_asmsid asm
_asm_global_dump_level 267
_remote_asm
_ios_root_directory IOS
_apx_root_directory APX
_asm_node_site_guid
_asm_reloc_cic FALSE
_asm_oda_type
_asm_access auto
_asm_allow_system_alias_rename FALSE
_asm_instlock_quota 0
_asm_relocation_trace FALSE
asm_diskstring
_asm_disk_repair_time 14400
asm_preferred_read_failure_groups
_asm_disable_profilediscovery FALSE
_asm_relocation_ignore_hard_failure 0
_asm_max_parallelios 256
_asm_auto_online_interval
_asm_imbalance_tolerance 3
_asm_shadow_cycle 3
_asm_primary_load_cycles TRUE
_asm_primary_load 1
_asm_secondary_load_cycles FALSE
_asm_secondary_load 10000
_kffmop_chunks 42
_kffmap_hash_size 1024
_kffmop_hash_size 2048
_kffmlk_hash_size 512
_kffmspw_hash_size 128
asm_diskgroups
_asm_diskgroups2
_asm_diskgroups3
_asm_diskgroups4
asm_power_limit 1
_asm_zero_power_limit
_disable_rebalance_space_check FALSE
_asm_log_scale_rebalance FALSE
_asm_sync_rebalance FALSE
_diag_arb_before_kill FALSE
_asm_ausize 1048576
_asm_blksize 4096
_asm_acd_chunks 1
_asm_partner_target_disk_part 8
_asm_partner_target_fg_rel 4
_asm_automatic_rezone TRUE
_asm_rebalance_plan_size 120
_asm_rebalance_space_errors 1000
_asm_relocation_scheme alloc_p2 alloc_s3 reb_p2 reb_s
1 bal_p2 bal_s3 prep_p2 prep_s
3
_asm_disable_dangerous_failgroup_checkin FALSE
g
_asm_rebalance_estimates_process TRUE
_asm_disable_failgroup_size_checking FALSE
_asm_disable_failgroup_count_checking FALSE
_asm_allow_foreign_siteguids
_asm_allow_dgname_special_chars FALSE
_asm_libraries ufs
_asm_maxio 1048576
_asm_allow_only_raw_disks TRUE
_asm_disable_vtoc_check FALSE
_asm_fob_tac_frequency 9
_asm_emulate_nfs_disk FALSE
_asm_allow_lvm_resilvering TRUE
_asm_lsod_bucket_size 67
_asm_iostat_latch_count 31
_asm_diskerr_traces 2
_asm_procs_trace_diskerr 5
_asm_trace_limit_timeout 30000
_asm_fd_cln_on_fg TRUE
_asm_fd_cln_idle_sess_twait 60000000
_asm_skip_dbfile_ios FALSE
_asm_offload_all FALSE
_asm_read_cancel AUTO
_asm_read_cancel_back_out 5000
_asm_write_cancel AUTO
_asm_cancel_delta 75000
_asm_cancel_alert_time 600
_asm_enable_kfks FALSE
_kfm_disable_set_fence FALSE
_asm_disable_smr_creation FALSE
_afd_disable_fence FALSE
_asm_network_timeout 1
_asm_wait_time 18
_asm_skip_diskval_check FALSE
_asm_skip_resize_check FALSE
_asm_skip_rename_check FALSE
_asm_direct_con_expire_time 120
_asm_check_for_misbehaving_cf_clients FALSE
_asm_diag_dead_clients FALSE
_asm_disable_ufg_dump FALSE
_asm_reserve_slaves TRUE
_asm_kill_unresponsive_clients TRUE
_asm_disable_async_msgs FALSE
_asm_remote_client_timeout 300
_asm_allow_unsafe_reconnect TRUE
_asm_disable_ufgmemberkill FALSE
_asm_disable_proact_client_cleanup FALSE
_asm_nodekill_escalate_time 180
_asm_healthcheck_timeout 180
_asm_cclient_cleanup_timeout 300
_asm_allow_older_clients FALSE
_asm_enable_multiple_asmb TRUE
_asm_disable_vxn_map_messages FALSE
_asm_asmb_rcvto 10
_asm_asmb_max_wait_timeout 6
_asm_tcp_user_timeout 1
_asm_ufg_nw_wait_timeout 10
_asm_resyncCkpt 1024
_asm_relocation_async_lock_count 128
_asm_stripewidth 8
_asm_stripesize 131072
_disable_fastopen FALSE
_asm_random_zone FALSE
_asm_serialize_volume_rebalance FALSE
_asm_force_quiesce FALSE
_asm_dba_threshold 0
_asm_dba_batch 500000
_asm_force_paritycheck_rebalance FALSE
_asm_dba_spcchk_thld 100000
_asm_usd_batch 64
_asm_fail_random_rx FALSE
_relocation_commit_batch_size 8
_asm_max_redo_buffer_size 2097152
_asm_max_cod_strides 10
_asm_max_aux_cods 5
_asm_evenread 2
_asm_evenread_alpha 0
_asm_evenread_alpha2 0
_asm_evenread_faststart 0
_asm_noevenread_diskgroups
_asm_disable_request_tracer TRUE
_asm_force_parity_extent_check FALSE
_asm_enable_kfios FALSE
_asm_networks
_asm_access_assume_local FALSE
_asm_iosconnect_timeout 0
_asm_br_listener_port 51521
_asm_ios_network_domains 0
_asm_ios_network_processes 0
_asm_netp_factor 0
_asm_idn_processes 0
_asm_iowp_max_async 0
asm_io_processes 20
_asm_max_clients 1000
_asm_netp_iosize 0
_asm_brfuzz_ios_lsnrport 0
_asm_dbmsdg_nohdrchk FALSE
_asm_root_directory ASM
_asm_odapremchk TRUE
_asm_pstonpartners TRUE
_asm_allowdegeneratemounts FALSE
_asm_hbeatiowait 120
_asm_hbeatwaitquantum 2
_asm_repairquantum 60
_asm_emulmax 10000
_asm_emultimeout 0
_asm_kfdpevent 0
_asm_storagemaysplit FALSE
_asm_avoid_pst_scans TRUE
_disable_storage_type FALSE
_asm_min_compatibility 11.2.0.2
_asm_compatibility 11.2.0.2
_rdbms_compatibility 10.1
_kfi_version_patchmap
_kfi_software_patchmap
_asm_disable_patch_compat FALSE
_asm_proxy_startwait 60
_asm_allow_dangerous_unprotected_volumes FALSE
_asm_proxy_online_restart 0
_allow_cell_smart_scan_attr TRUE
_asm_admin_with_sysdba FALSE
_asm_allow_appliance_dropdisk_noforce FALSE
_disable_appliance_check FALSE
_disable_appliance_partnering FALSE
_asm_appliance_config_file
_asm_appliance_ignore_oak FALSE
_dirty_appliance_mode FALSE
_asm_appliance_slot_from_path FALSE
_asm_appliance_disable_fg_check FALSE
_asm_write_badfdata_in_contentcheck FALSE
_asm_scrub_disable_cod FALSE
_asm_scrub_strict FALSE
_asm_scrub_async TRUE
_asm_scrub_limit AUTO
_asm_scrub_unmatched_dba 1024
_asm_enable_parity_scrub FALSE
_asm_async_scrub_reap_wait 100000
_asm_enable_batch_scrub FALSE
_asm_enable_lostwrite_scrub FALSE
_asm_enable_repair_lostwrite_scrub FALSE
_memory_max_tgt_inc_cnt 0
_asm_enable_xrov FALSE
_asm_xrov_single FALSE
_asm_xrov_rsnmod 2
_asm_xrov_nvios 24
_asm_xrov_nstats 0
_skip_acfs_checks FALSE
_asm_force_vam FALSE
_usd_recent_read TRUE
_usd_preload_blks 4
_asm_dependency_under_cfenqueue TRUE
_asm_max_connected_clients 3
__asm_max_connected_clients 3
_asm_enable_parityfile_creation TRUE
_asm_enable_parity_datafile_creation FALSE
_enable_multiple_fgprepares FALSE
_enable_single_dgprepare FALSE
_asm_allow_prepare_split TRUE
_enable_ios_spm FALSE
control_management_pack_access DIAGNOSTIC+TUNING
_alert_expiration 604800
_alert_message_cleanup 1
_alert_message_purge 1
_alert_post_background 1
_swrf_test_action 0
_sysaux_test_param 1
_swrf_mmon_flush TRUE
_remote_awr_enabled FALSE
_awr_corrupt_mode FALSE
_awr_restrict_mode FALSE
_swrf_mmon_metrics TRUE
_swrf_metric_frequent_mode FALSE
_awr_flush_threshold_metrics TRUE
_awr_flush_workload_metrics FALSE
_awr_disabled_flush_tables
_awr_disabled_purge_tables
_awr_snapshot_level BESTFIT
_swrf_on_disk_enabled TRUE
_awr_pdb_registration_enabled FALSE
_swrf_mmon_dbfus TRUE
_awr_mmon_cpuusage TRUE
_swrf_test_dbfus FALSE
_adr_migrate_runonce TRUE
_awr_sql_child_limit 200
_awr_enable_pdb_snapshots TRUE
awr_pdb_autoflush_enabled FALSE
awr_pdb_max_parallel_slaves 10
_awr_incremental_flush_enabled TRUE
_awr_warehouse_enabled FALSE
awr_snapshot_time_offset 0
_awr_mmon_deep_purge_interval 7
_awr_mmon_deep_purge_extent 7
_awr_mmon_deep_purge_numrows 5000
_awr_mmon_deep_purge_all_expired FALSE
_awr_cdbperf_threshold 21
_awr_partition_interval 0
_incremental_purge_size 200
_awr_metrics_use_mmnl FALSE
sqltune_category DEFAULT
_sqltune_category_parsed DEFAULT
_ash_sampling_interval 1000
_ash_size 1048618
_ash_enable TRUE
_ash_disk_write_enable TRUE
_ash_disk_filter_ratio 10
_ash_eflush_trigger 66
_ash_sample_all FALSE
_ash_dummy_test_param 0
_ash_min_mmnl_dump 90
_ash_compression_enable TRUE
_ash_progressive_flush_interval 300
_kebm_nstrikes 3
_kebm_suspension_time 104400
_kebm_sanity_check_enabled FALSE
_kebm_max_parallel_autotasks AUTO
_kebm_autotask_nstrikes 3
_timemodel_collection TRUE
_disable_metrics_group 0
_kewm_simulate_oer4031 0
_enable_metrics_allpdb TRUE
_enable_metrics_pdb FALSE
_validate_metric_groups FALSE
_track_metrics_memory TRUE
_kewm_trace_sga FALSE
_threshold_alerts_enable 1
_enable_default_undo_threshold TRUE
_enable_default_temp_threshold TRUE
_addm_auto_enable TRUE
_addm_version_check TRUE
_addm_skiprules
_addm_auto_actions_enabled TRUE
_automatic_maintenance_test 0
_autotask_min_window 15
_autotask_max_window 480
_enable_automatic_maintenance 1
_autotask_test_name N/A
autotask_max_active_pdbs 2
enable_automatic_maintenance_pdb TRUE
_autotask_test_action 0
_bsln_adaptive_thresholds_enabled TRUE
_wcr_control 0
_dbreplay_feature_control
_capture_buffer_size 65536
_wcr_seq_cache_size 65535
_wcr_grv_cache_size 65535
_wcr_test_action 0
_max_queued_report_requests 300
_report_capture_cycle_time 60
_report_capture_dbtime_percent_cutoff 50
_report_capture_timeband_length 1
_report_capture_recharge_window 10
_max_report_flushes_percycle 5
_report_request_ageout_minutes 60
_kecap_cache_size 10240
_rtaddm_trigger_enabled TRUE
_rtaddm_trigger_args
_mwin_schedule TRUE
_umf_remote_target_dblink
_umf_remote_enabled FALSE
_dbmsumf$$nn
_dbmsumf$$p
_dbmsumf$$1x
_dbmsumf$$2x
_dbmsumf$$3x
_umf_test_action 0
_iut_enable TRUE
_iut_max_entries 30000
_iut_stat_collection_type SAMPLED
_sqlset_hash_max_size 100000
_component_timing
spatial_vector_acceleration FALSE
_diag_verbose_error_on_init 0
_diag_hm_rc_enabled TRUE
_diag_hm_tc_enabled FALSE
diagnostic_dest /oracle/app
_diag_adr_enabled TRUE
_diag_adr_auto_purge TRUE
_diag_backward_compat TRUE
_diag_adr_test_param 0
_diag_adr_trace_dest /oracle/app/diag/rdbms/test/TE
ST/trace
_diag_pdb_purge_threshold 97
_diag_pdb_purge_target 90
_diag_pdb_control 0
_dra_enable_offline_dictionary FALSE
_dra_bmr_number_threshold 1000
_dra_bmr_percent_threshold 10
_diag_conf_cap_enabled TRUE
_diag_patch_cap_enabled TRUE
_log_segment_dump_parameter TRUE
_log_segment_dump_patch TRUE
_diag_adl_dyn_alloc TRUE
_diag_cdb_logging short
_diag_alert_root_annotate FALSE
_dde_flood_control_init TRUE
_diag_dde_fc_enabled TRUE
_diag_dde_fc_implicit_time 0
_diag_dde_fc_macro_time 0
_diag_cc_enabled TRUE
_diag_dde_inc_proc_delay 1
_diag_dde_async_msgs 50
_diag_dde_async_msg_capacity 1024
_diag_dde_async_slaves 5
_diag_dde_async_mode 1
_diag_dde_async_age_limit 300
_diag_dde_async_process_rate 5
_diag_dde_async_runtime_limit 900
_diag_dde_async_cputime_limit 300
_diag_dde_enabled TRUE
tracefile_identifier
_trace_files_public FALSE
max_dump_file_size unlimited
_max_incident_file_size
_uts_trace_segment_size 0
_uts_trace_segments 5
_uts_first_segment_size 0
_uts_first_segment_retain TRUE
_diag_uts_control 0
_uts_trace_disk_threshold 0
_diag_test_seg_reinc_mode FALSE
_uts_trace_files_nopurge FALSE
_uts_trace_buffer_size 0
_uts_inc_inmem_trace 0
_uts_enable_alltrc_stats FALSE
_trace_pool_size
trace_enabled TRUE
_evt_system_event_propagation TRUE
_diag_enable_startup_events FALSE
_diag_attn_log_format_standard
_diag_attn_log_format_error
_auto_manage_exadata_disks TRUE
_auto_manage_ioctl_bufsz 8192
_auto_manage_num_tries 2
_auto_manage_enable_offline_check TRUE
_auto_manage_max_online_tries 3
_auto_manage_online_tries_expire_time 86400
_auto_manage_num_pipe_msgs 1000
_auto_manage_enable_smart_rebalance TRUE
_auto_manage_smart_rebalance_grace_perio 0
d_in_min
_auto_manage_smart_rebalance_space_thres 0
hold
_auto_manage_infreq_tout 0
cell_offloadgroup_name
_kxdbio_ctx_init_count 32
_kxdbio_offena_timeout 7200000
_kxdbio_disable_offload_opcode 0
_kxdbio_enable_ds_opcode 0
_enable_offloaded_writes FALSE
_block_level_offload_high_lat_thresh 40000
_kxdbio_hca_loadavg_thresh 74
_kxdbio_ut_ctl 0
_cell_offload_backup_compression TRUE
_enable_pluggable_database FALSE
enable_pluggable_database FALSE
_oracle_script FALSE
_pdb_first_script FALSE
_discard_cmn_ddl_in_pdb_err FALSE
pdb_os_credential
pdb_file_name_convert
_pluggable_database_debug 0
_pdb_failure_testing 0
noncdb_compatible FALSE
_cdb_compatible TRUE
_deferred_seg_in_seed TRUE
common_user_prefix C##
_common_user_prefix C##
_relocate_pdb FALSE
_set_container_service DEFAULT
_multiple_char_set_cdb TRUE
_cdb_spfile_inherit FALSE
_enable_pdb_close_abort TRUE
_enable_pdb_close_noarchivelog FALSE
target_pdbs 0
max_pdbs 254
_pdb_cluster_database TRUE
_enable_pdb_isolation FALSE
_auto_dismount_on_pdb_close FALSE
_pdb_mask_cdb_info FALSE
_split_file_copy TRUE
_test_offload_pdb_sga_init FALSE
cdb_cluster FALSE
cdb_cluster_name
_save_afns_on_subset_pdb_creation FALSE
_multiple_name_convert_patterns FALSE
standby_pdb_source_file_directory
standby_pdb_source_file_dblink
_pdb_hash_table_size 255
_pdb_hash_table_latches 16
_pdb_lrg_auto_undots_create FALSE
_pdb_auto_undots_create_off FALSE
remote_recovery_file_dest
disable_pdb_feature 0
_proxy_connect_after_set_container TRUE
_pdb_seed_mcsc FALSE
_pdb_strict_plugin_compat FALSE
_enable_pdb_process_limit TRUE
_pdb_inherit_cfd FALSE
_auto_start_pdb_services FALSE
_seed_root_undo_ratio 30
_cdb_disable_pdb_limit FALSE
_slow_kill_on_pdb_close_immediate FALSE
_edition_enable_oracle_users
_pdb_name_case_sensitive FALSE
_restrict_local_user_dml TRUE
_pdb_max_diag_size 0
_pdb_max_audit_size 0
_reuse_dropped_pdbid_time 180
_pdb_auto_save_state FALSE
_next_pdbid 3
_cloud_service_type
_pdb_ignore_table_clauses TRUE
_no_catalog
_pdb_max_size_discount 10
_non_app_ignore_errors TRUE
_app_ignore_errors TRUE
_app_default_containers FALSE
_exclude_seed_cdb_view TRUE
_disable_cdb_view_rc_invalidation FALSE
_object_linked_remote FALSE
_cdb_rac_affinity TRUE
_cdb_view_recursive_px_enabled TRUE
_cdb_view_no_skip_migrate FALSE
_cdb_special_old_xplan TRUE
containers_parallel_degree 65535
_disable_con_recurse_queuing TRUE
_disable_dblink_optim TRUE
_cdb_view_no_skip_restricted FALSE
_intra_cdb_dblink FALSE
_partition_by_con_name FALSE
_error_row_predicate_evaluation AUTO
_cross_con_collection FALSE
_predicate_validity_execution FALSE
_containers_multiple_ptn_key TRUE
_enable_view_pdb TRUE
_enable_guid_endpoint_service TRUE
_enable_proxy_distr_txn TRUE
_federation_max_root_clones 5
_application_purge_enabled TRUE
_federation_script FALSE
_application_script FALSE
default_sharing metadata
_enable_partial_sync FALSE
_enable_drop_clone FALSE
_disable_destructive_patch_operation TRUE
_upgrade_optim TRUE
_upgrade_capture_noops TRUE
_app_replay_silent_errors FALSE
_capture_pgadep 0
_sync_app_pdb_first_open FALSE
_disable_ptl_replay FALSE
_enable_module_match TRUE
_lrgdbcz6_ignore_restrictions FALSE
_enable_system_app 2
_modify_other_app_object FALSE
_enable_cdb_upgrade_capture FALSE
_skip_app_object_check FALSE
_session_aware_replay TRUE
_strict_dml_data_link FALSE
_skip_app_unconverted_check FALSE
_enable_auto_upgrade FALSE
_app_container_debug 0
_enable_pmo_outside_begin_end TRUE
_record_module_name TRUE
_no_snapshot_root_clone FALSE
_root_clone_state_from_root TRUE
_apppdb_multi_slave_sync FALSE
_enable_replay_upgrade_diag FALSE
_max_stmt_tries_sync 2
_suppress_migration_errors TRUE
pdb_lockdown
_pdb_ldp_cascade 0
_pdb_lockdown_bypass_sr 0
_default_pct_free 0
_pdb_lockdown_ddl_clauses 0
_enable_containers_subquery TRUE
_force_containers_subquery FALSE
_cdb_fleet_sync_timeout 10
pdb_template
_cdb_port 0
_pdb_isolation_class NONE
_con_map_sql_enforcement TRUE
_uniq_cons_sql_enforcement TRUE
_ref_cons_sql_enforcement TRUE
_xt_http_wscl FALSE
_disable_sensitive_internal FALSE
_restrict_pdb_gv FALSE
_enable_sensitive_trace FALSE
_sensitive_common_as_local FALSE
_sensitive_common_users
_link_ts_name
_gsm
shrd_dupl_table_refresh_rate 60
_gsm_region_list
_cloud_name
_dbpool_name
_region_name
_db_num_gsm 0
_gsm_config_vers 0
_gsm_max_instances_per_db 8
_gsm_max_num_regions 10
_gsm_drv_interval 30
_gsm_srlat_thresh 20
_gsm_cpu_thresh 75
_gsm_thresh_zone 10
_gsm_thresh_respct 50
_gsm_svcrgnmax 100
_gds_chunk_num 0
_gds_max_chunk_num 0
_gds_allow_nullkey 0
_skip_pset_col_chk 0
_gds_lddlid 0
_shardgroup_name
_gwm_db_unique_name
_gds_shardgroup_id 0
_shardspace_name
_shd_reptype 0
_gws_deployed 0
_gws_sharding_method 0
_gws_cache_version 0
_gwm_database_flags
_user_defined_sharding 0
_dupt_noupdate 0
_shd_atomic_move 0
multishard_query_data_consistency strong
multishard_query_partial_results not allowed
_gwm_int_dbnum 0
_gwm_autoons_ha_subscription
_gwm_autoons_rlb_subscription
_oracle_special_license_1_granted
_gwm_spare2 0
_gwm_spare3 0
_rq_shm_max_size 1024
_hcs_enable_all_distinct FALSE
_hcs_disable_exists_distinct FALSE
_hcs_disable_filter_hierarchies FALSE
_hcs_disable_hier_join_map_nonnull FALSE
_hcs_disable_level_ord FALSE
_hcs_disable_level_prune FALSE
_hcs_disable_level_prune_gby FALSE
_hcs_disable_level_prune_hier_join FALSE
_hcs_disable_level_prune_hier_qry FALSE
_hcs_disable_level_prune_hierarchize FALSE
_hcs_disable_level_prune_in_qry FALSE
_hcs_disable_level_prune_mbr_lookup FALSE
_hcs_disable_level_prune_vis_lvs FALSE
_hcs_disable_level_prune_calc_data_joins FALSE
_hcs_logging SUMMARY
_hcs_disable_materialize FALSE
_hcs_disable_opt_estimate FALSE
_hcs_enable_parallel_hint FALSE
_hcs_disable_result_cache_hint FALSE
_hcs_disable_smooth_descendants FALSE
_hcs_disable_smooth_drill_all FALSE
_hcs_disable_smooth_hierarchize FALSE
_hcs_disable_smooth_remove_all FALSE
_hcs_disable_pushed_preds_in_gen_sql FALSE
_hcs_disable_vis_totals FALSE
_hcs_enable_unsupported_calcs FALSE
_hcs_query_hint
_hcs_disable_bd_agg_opt FALSE
_hcs_disable_sp_jback_opt FALSE
_hcs_disable_av_jback_opt FALSE
_hcs_disable_all_prune FALSE
_hcs_enable_dynamic_cache FALSE
_hcs_disable_hord_in_oby_prune FALSE
_hcs_disable_jback_opt_for_hord_in_oby FALSE
_hcs_disable_mv_rewrite_check FALSE
_hcs_disable_cell_qry_tmpls FALSE
_hcs_disable_opt_cell_qry FALSE
_hcs_disable_cell_qry_meas_prune_opt FALSE
_hcs_disable_cell_qry_lvl_prune_opt FALSE
_hcs_disable_cell_qry_no_calc_nav_opt FALSE
_hcs_disable_cell_qry_mv_cache_opt FALSE
_hcs_disable_latest_compat_check FALSE
_hcs_disable_col_prune_optz FALSE
_hcs_disable_rm_unused_withs_optz FALSE
_hcs_disable_rm_like_withs_optz FALSE
_hcs_enable_auto_av_cache FALSE
_hcs_enable_parse_auto_av_cache FALSE
_hcs_disable_mdx_cache_hint FALSE
_hcs_enable_mdx_cache_name_col FALSE
_hcs_enable_multi_parent_gen FALSE
_hcs_enable_mdx_sleep_after_pin FALSE
_hcs_stats_max_card 2000000
_hcs_disable_cell_qry_no_out_data_opt FALSE
_hcs_disable_inline_tmpl_opt FALSE
_hcs_disable_rmv_unref_top_opt FALSE
_hcs_disable_cell_qry_atr_prune_opt FALSE
_hcs_disable_calc_dtm_to_out_opt FALSE
_hcs_disable_fltr_hier_star_opt FALSE
_hcs_disable_fltr_fact_opt FALSE
_hcs_enable_aggr_opt_estimate FALSE
_hcs_disable_tgt_depths_opt FALSE
_hcs_disable_dup_src_tbl_opt FALSE
_hcs_enable_in_mem_cdt_hint FALSE
_hcs_enable_expose_with_expr FALSE
_hcs_enable_pred_push TRUE
_hcs_disable_dup_nav_calc_opt FALSE
_hcs_disable_calc_opt FALSE
_hcs_disable_obj_cache_name FALSE
_hcs_disable_fltr_below_fltr_star_opt FALSE
_hcs_disable_vector_transform FALSE
_hcs_enable_no_expand FALSE
_hcs_disable_unnest FALSE
_hcs_enable_mdx_mv_gen FALSE
_hcs_enable_mem_trck FALSE
_hcs_disable_view_merge FALSE
_reg_cache_status FALSE
5412 rows selected.
