Hidden Parameters in Oracle AI Database 26ai H.4 Diagnostics / monitoring (255)

 

Name	Type	Value	At default?	Level	PDB	RAC inst.	Flags	Description
_ash_disk_filter_ratio	Integer	10	yes	STATIC	N	N		Ratio of the number of in-memory samples to the number of samples actually written to disk
_ash_disk_write_enable	Boolean	TRUE	yes	SYSTEM imm.	N	Y		To enable or disable Active Session History flushing
_ash_dummy_test_param	Integer	0	yes	SYSTEM imm.	N	Y		Oracle internal dummy ASH parameter used ONLY for testing!
_ash_eflush_trigger	Integer	66	yes	SYSTEM imm.	N	Y		The percentage above which if the in-memory ASH is full the emergency flusher will be triggered
_ash_enable	Boolean	TRUE	yes	SYSTEM imm.	N	Y		To enable or disable Active Session sampling and flushing
_ash_min_mmnl_dump	Big integer	90	yes	SYSTEM imm.	N	Y		Minimum Time interval passed to consider MMNL Dump
_ash_progressive_flush_interval	Integer	300	yes	SYSTEM imm.	N	Y		ASH Progressive Flush interval in secs
_ash_sample_all	Boolean	FALSE	yes	SYSTEM imm.	N	Y		To enable or disable sampling every connected session including ones waiting for idle waits
_ash_sampling_interval	Integer	1000	yes	STATIC	N	N		Time interval between two successive Active Session samples in millisecs
_ash_size	Big integer	1048618	yes	STATIC	N	N		To set the size of the in-memory Active Session History buffers
_awr_adg_flush_method	String	SYSTEM_DEFINED	yes	SYSTEM imm.	N	Y		AWR ADG Flush Method
_awr_cdbperf_threshold	Integer	21	yes	SYSTEM imm.	N	Y		Setting for AWR CDBPERF Threshold
_awr_colored_app_enabled	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		Enable/Disable AWR Colored Application functionality
_awr_corrupt_mode	Boolean	FALSE	yes	STATIC	N	N		AWR Corrupt Mode
_awr_data_masking	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Enable/Disable AWR data masking functionality
_awr_disabled_flush_tables	String		yes	SYSTEM imm.	N	Y		Disable flushing of specified AWR tables
_awr_disabled_purge_tables	String		yes	SYSTEM imm.	N	Y		Disable purging of specified AWR tables
_awr_enable_pdb_snapshots	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Enable/Disable AWR PDB level snapshots
_awr_flush_threshold_metrics	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Enable/Disable Flushing AWR Threshold Metrics
_awr_flush_workload_metrics	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Enable/Disable Flushing AWR Workload Metrics
_awr_hub_autoimp_inline	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		Enable/Disable AutoIMP in the same session handling requests
_awr_hub_consumer_group	String	ORA$AUTOTASK	yes	SYSTEM imm.	Y	Y		Setting of Hub Consumer Group
_awr_hub_num_conc_imp	Integer	2	yes	SYSTEM imm.	Y	Y		Setting for the number of concurrent IMP tasks at a Hub Server
_awr_incremental_flush_enabled	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		Enable/Disable AWR automatic incremental flushing
_awr_max_registrations	Integer	1024	yes	SYSTEM imm.	Y	Y		maximum number of registered dbids in AWR
_awr_metrics_use_mmnl	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Use MMNL or other background process for AWR metrics
_awr_mmon_cpuusage	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Enable/disable AWR MMON CPU Usage Tracking
_awr_mmon_deep_purge_all_expired	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Allows deep purge to purge AWR data for all expired snapshots
_awr_mmon_deep_purge_extent	Integer	7	yes	SYSTEM imm.	N	Y		Set extent of rows to check each deep purge run
_awr_mmon_deep_purge_interval	Integer	7	yes	SYSTEM imm.	N	Y		Set interval for deep purge of AWR contents
_awr_mmon_deep_purge_numrows	Integer	5000	yes	SYSTEM imm.	N	Y		Set max number of rows per table to delete each deep purge run
_awr_overflow_enabled	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		Enable/Disable AWR Overflow functionality
_awr_partition_interval	Integer	0	yes	SYSTEM imm.	N	Y		Setting for AWR Partition Interval
_awr_pdb_registration_enabled	Boolean	FALSE	yes	SESSION	Y	Y	deprecated	Parameter to enable/disable AWR PDB Registration
_awr_report_gen_method	String	ADVANCED	yes	SYSTEM imm.	N	Y		AWR Report Generation Method
_awr_report_group_select	String		yes	SYSTEM imm.	N	Y		AWR Report Select Groups
_awr_restrict_mode	Boolean	FALSE	yes	STATIC	N	N		AWR Restrict Mode
_awr_snapshot_level	String	BESTFIT	yes	SYSTEM imm.	Y	Y		Set Default AWR snapshot level
_awr_sql_child_limit	Integer	200	yes	SYSTEM imm.	N	Y		Setting for AWR SQL Child Limit
_awr_sqltext_redaction	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		Enable/Disable AWR SQL Text Redaction
_awr_warehouse_enabled	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		Enable/Disable AWR warehouse functionality
_awrextr_include_sqlmon	Boolean	FALSE	yes	SESSION	N	N		Enable/disable including SQLMon data in AWR Extract
_dbg_proc_startup	Boolean	FALSE	yes	STATIC	N	N		debug process startup
_dbg_scan	Integer	0	yes	SESSION	Y	Y		generic scan debug
_dbg_scan_ext	Integer	0	yes	SESSION	Y	Y		generic scan debug extension
_diag_adl_dyn_alloc	Boolean	TRUE	yes	STATIC	N	N		Enable Diag Alert Dynamic Allocation
_diag_adr_auto_purge	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Enable/disable ADR MMON Auto Purging
_diag_adr_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Parameter to enable/disable Diag ADR
_diag_adr_test_param	Integer	0	yes	SYSTEM imm.	N	Y		Test parameter for Diagnosability
_diag_adr_trace_dest	String	/u01/app/oracle/diag/rdbms/orcl23/orcl23/trace	yes	STATIC	N	N		diagnosability trace directory path
_diag_alert_log_enable_attention_prefix	Boolean	TRUE	yes	STATIC	N	N		Enable/Disable attention prefix for alert log entries
_diag_alert_root_annotate	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Enable annotation for alert log entries from root
_diag_arb_before_kill	Boolean	FALSE	yes	SESSION	N	Y		dump diagnostics before killing unresponsive ARBs
_diag_attn_log_enable_fc	Boolean	TRUE	yes	STATIC	N	N		Enable/Disable attention log flood control
_diag_attn_log_format_error	String		yes	SYSTEM imm.	N	Y		Attention Log Error Entry format
_diag_attn_log_format_standard	String		yes	SYSTEM imm.	N	Y		Attention Log Standard Entry format
_diag_backward_compat	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Backward Compatibility for Diagnosability
_diag_cc_enabled	Boolean	TRUE	yes	STATIC	N	N		Parameter to enable/disable Diag Call Context
_diag_cdb_logging	String	short	yes	SYSTEM imm.	N	Y		Format for CDB Annotation
_diag_conf_cap_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Parameter to enable/disable Diag Configuration Capture
_diag_crashdump_level	Integer	10	yes	SYSTEM imm.	N	Y		parameter for systemstate dump level, used by DIAG during crash
_diag_css_lock_wait_retry_count	Integer	100	yes	SYSTEM imm.	N	Y		DIAG process kjzm lock wait retry count
_diag_css_lock_wait_timeout	Integer	5	yes	SYSTEM imm.	N	Y		DIAG process kjzm lock wait timeout centisecs
_diag_daemon	Boolean	TRUE	yes	STATIC	N	N		start DIAG daemon
_diag_dd_global_blockers_dump	Boolean	FALSE	yes	SYSTEM imm.	N	Y		if TRUE enables Global blockers dump
_diag_dde_async_age_limit	Integer	300	yes	SYSTEM imm.	N	Y		diag dde async actions: message age limit (in seconds)
_diag_dde_async_cputime_limit	Integer	300	yes	SYSTEM imm.	N	Y		diag dde async actions: action cputime limit (in seconds)
_diag_dde_async_mode	Integer	1	yes	SYSTEM imm.	N	Y		diag dde async actions: dispatch mode
_diag_dde_async_msg_capacity	Integer	1024	yes	STATIC	N	N		diag dde async actions: message buffer capacity
_diag_dde_async_msgs	Integer	50	yes	STATIC	N	N		diag dde async actions: number of preallocated message buffers
_diag_dde_async_process_rate	Integer	5	yes	SYSTEM imm.	N	Y		diag dde async actions: message processing rate - per loop
_diag_dde_async_runtime_limit	Integer	900	yes	SYSTEM imm.	N	Y		diag dde async actions: action runtime limit (in seconds)
_diag_dde_async_slaves	Integer	5	yes	SYSTEM imm.	N	Y		diag dde async actions: max number of concurrent slave processes
_diag_dde_enabled	Boolean	TRUE	yes	STATIC	N	N		enable DDE handling of critical errors
_diag_dde_fc_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Parameter to enable/disable Diag Flood Control
_diag_dde_fc_implicit_time	Integer	0	yes	STATIC	N	N		Override Implicit Error Flood Control time parameter
_diag_dde_fc_macro_time	Integer	0	yes	STATIC	N	N		Override Macro Error Flood Control time parameter
_diag_dde_inc_proc_delay	Integer	1	yes	STATIC	N	N		The minimum delay between two MMON incident sweeps (minutes)
_diag_deadlock_detection_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Deadlock detection enabled in diag
_diag_diagnostics	Boolean	TRUE	yes	SESSION	Y	Y		Turn off diag diagnostics
_diag_dump_request_debug_level	Integer	1	yes	STATIC	N	N		DIAG dump request debug level (0-2)
_diag_dump_timeout	Integer	30	yes	STATIC	N	N		timeout parameter for SYNC dump
_diag_enable_startup_events	Boolean	FALSE	yes	STATIC	N	N		enable events in instance startup notifiers
_diag_hang_analyze_default_dump_level	Integer	0	yes	SYSTEM imm.	N	Y		Diag Hang Analyze default dump level
_diag_hang_analyze_elapsed_time_limit	Integer	1800	yes	SYSTEM imm.	N	Y		Diag Hang Analyze elapsed time limit in seconds
_diag_hm_rc_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Parameter to enable/disable Diag HM Reactive Checks
_diag_hm_tc_enabled	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Parameter to enable/disable Diag HM Test(dummy) Checks
_diag_kjzcmsg_limit	Big integer	8400000	yes	SYSTEM imm.	N	Y		If non-zero value, upper limit of allocation of kjzcmsg in bytes
_diag_kjzcmsg_send_time_out	Big integer	600000	yes	SYSTEM imm.	N	Y		Time limit for sends to wait until they are cancelled
_diag_large_packets	Boolean	TRUE	yes	STATIC	N	N		DIA* large packets support
_diag_patch_cap_enabled	Boolean	TRUE	yes	STATIC	N	N		Parameter to enable/disable Diag Patch Configuration Capture
_diag_pdb_control	Integer	0	yes	SYSTEM imm.	N	Y		DIAG PDB Space Management Control Parameter
_diag_pdb_purge_target	Integer	90	yes	SYSTEM imm.	Y	Y		Controls target percentage for ADR PDB Auto Purge Operation
_diag_pdb_purge_threshold	Integer	97	yes	SYSTEM imm.	Y	Y		Controls threshold for ADR PDB Auto Purge Operation
_diag_proc_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		enable hung process diagnostic API
_diag_proc_max_time_ms	Integer	30000	yes	SYSTEM imm.	N	Y		hung process diagnostic API max wait time in milliseconds
_diag_proc_stack_capture_type	Integer	1	yes	SYSTEM imm.	N	Y		hung process diagnostic API stack capture type
_diag_test_seg_reinc_mode	Boolean	FALSE	yes	STATIC	N	N		Sets trace segmentation to be in reincarnation mode
_diag_uts_control	Integer	0	yes	SESSION	N	Y		UTS control parameter
_diag_verbose_error_on_init	Integer	0	yes	STATIC	N	N		Allow verbose error tracing on diag init
_diag_xm_enabled	Boolean	FALSE	yes	STATIC	N	N		If TRUE, DIAG allows message exchanges across DB/ASM boundary
_dump_10261_level	Integer	0	yes	SYSTEM imm.	N	Y		Dump level for event 10261, 1=>minimal dump 2=>top pga dump
_dump_common_subexpressions	Boolean	FALSE	yes	SESSION	Y	Y		dump common subexpressions
_dump_connect_by_loop_data	Boolean	FALSE	yes	SESSION	Y	Y		dump connect by loop error message into trc file
_dump_diag_audrec_fail_tab	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Dump diagnostics on failure of audit record write to table
_dump_interval_limit	Integer	120	yes	STATIC	N	N		trace dump time interval limit (in seconds)
_dump_max_limit	Integer	5	yes	STATIC	N	N		max number of dump within dump interval
_dump_qbc_tree	Integer	0	yes	SESSION	Y	N		dump top level query parse tree to trace
_dump_rcvr_ipc	Boolean	TRUE	yes	SYSTEM imm.	N	Y		if TRUE enables IPC dump at instance eviction time
_dump_scheduler_inmemory_trace_on_error	Boolean	TRUE	yes	SESSION	Y	Y		autodump scheduler imt on error
_dump_scheduler_inmemory_trace_on_timeout	Boolean	TRUE	yes	SESSION	Y	Y		autodump scheduler imt on timeout
_dump_scn_increment_stack	String		yes	SYSTEM imm.	N	Y		Dumps scn increment stack per session
_dump_system_state_scope	String	local	yes	STATIC	N	N		scope of sysstate dump during instance termination
_dump_trace_scope	String	global	yes	STATIC	N	N		scope of trace dump during a process crash
_hang_aggressive_cloud_mode_enabled	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver aggressive cloud mode enabled
_hang_allow_resolution_on_single_nonrac	String	DBRM	yes	SYSTEM imm.	N	Y		Blocker Resolver allow resolution on single non-RAC instances
_hang_analysis_num_call_stacks	Integer	3	yes	SYSTEM imm.	N	Y		hang analysis num call stacks
_hang_analyze_dump_session_summary	Boolean	FALSE	yes	SYSTEM imm.	N	Y		if TRUE, dump session summary
_hang_analyze_elapsed_time_limit	Integer	1800	yes	SYSTEM imm.	N	Y		Hang Analyze elapsed time limit in seconds
_hang_analyze_oradebug_time_limit	Integer	900	yes	SYSTEM imm.	N	Y		timeout for oradebug invoked hang analysis
_hang_analyze_session_summary_interval	Integer	60	yes	SYSTEM imm.	N	Y		Hang dump session summary frequency
_hang_appl_issue_session_threshold	Integer	0	yes	SYSTEM imm.	N	Y		Blocker Resolver application issue session threshold
_hang_application_hang_resolution_enabled	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver application related hang resolution enabled
_hang_asm_hang_resolution_enabled	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver ASM blocker resolution enabled
_hang_base_file_count	Integer	5	yes	SYSTEM imm.	N	Y		Number of trace files for the normal base trace file
_hang_base_file_space_limit	Integer	100000000	yes	SYSTEM imm.	N	Y		File space limit for current normal base trace file
_hang_blocked_session_percent_threshold	Integer	20	yes	SYSTEM imm.	N	Y		Blocker Resolver fast-track blocked session percent threshold
_hang_bool_spare1	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver bool 1
_hang_bool_spare2	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver bool 2
_hang_bool_spare3	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver bool 3
_hang_bool_spare4	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver bool 4
_hang_complex_scenarios_flood_control_interval	Integer	900	yes	SYSTEM imm.	N	Y		Blocker Resolver Complex Scenarios flood control interval
_hang_cpu_hung_thresh_sec	Integer	120	yes	SYSTEM imm.	N	Y		Hang Manager threshold for resmgr:cpu quantum
_hang_cross_boundary_hang_detection_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver Cross Boundary detection enabled
_hang_cross_boundary_ssd_flood_control_interval	Integer	300	yes	SYSTEM imm.	N	Y		Blocker Resolver Cross Boundary SSD flood control interval
_hang_cross_cluster_hang_detection_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver Cross Cluster detection enabled
_hang_deadlock_resolution_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver deadlock resolution enabled
_hang_delay_lsr_hang_resolution_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver delays Triggering LSR and hang resolution
_hang_delay_resolution_for_libcache	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver delays hang resolution for library cache
_hang_detection_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver detection enabled
_hang_enable_processstate	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Enable Process State Dumping
_hang_fast_track_critical_database_processes_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver fast-track critical database processes enabled
_hang_fast_track_progressing_sessions	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver fast-track progressing sessions enabled
_hang_fast_tracked_hang_verification_interval	Integer	10	yes	SYSTEM imm.	N	Y		Blocker Resolver fast-track hang verification interval
_hang_fb_high_wait_count_percentage	Integer	30	yes	SYSTEM imm.	N	Y		Blocker Resolver final blocker high wait count percentage
_hang_ft_min_degrading_samples_percent_threshold	Integer	60	yes	SYSTEM imm.	N	Y		Blocker Resolver fast-track minimum degrading samples threshold
_hang_hang_analyze_output_hang_chains	Boolean	TRUE	yes	SYSTEM imm.	N	Y		if TRUE hang manager outputs hang analysis hang chains
_hang_hang_blocked_session_delta_percent_threshold	Integer	20	yes	SYSTEM imm.	N	Y		Blocker Resolver hang's blocked session delta percent threshold
_hang_hiload_promoted_ignored_hang_count	Integer	2	yes	SYSTEM imm.	N	Y		Blocker Resolver high load or promoted ignored hang count
_hang_hiprior_session_attribute_list	String		yes	SYSTEM imm.	N	Y		Blocker Resolver high priority session attribute list
_hang_hs_hang_metrics_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver Hang Specific hang metrics enabled
_hang_hung_session_ewarn_percent	Integer	34	yes	SYSTEM imm.	N	Y		Blocker Resolver hung session early warning percentage
_hang_ignore_hngmtrc_interval	Integer	150	yes	SYSTEM imm.	N	Y		Blocker Resolver ignore hang metric dependent hang interval
_hang_ignored_hang_count	Integer	1	yes	SYSTEM imm.	N	Y		Blocker Resolver ignored hang count
_hang_ignored_hangs_interval	Integer	300	yes	SYSTEM imm.	N	Y		Time in seconds ignored hangs must persist after verification
_hang_int_spare1	Integer	0	yes	SYSTEM imm.	N	Y		Blocker Resolver int 1
_hang_int_spare2	Integer	0	yes	SYSTEM imm.	N	Y		Blocker Resolver int 2
_hang_int_spare3	Integer	0	yes	SYSTEM imm.	N	Y		Blocker Resolver int 3
_hang_int_spare4	Integer	0	yes	SYSTEM imm.	N	Y		Blocker Resolver int 4
_hang_intersecting_chains_scanning_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver intersecting chains scanning is allowed
_hang_log_high_load_to_alert	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver log high load to alert log
_hang_log_important_hangs_to_alert	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver log important hangs to alert log
_hang_log_io_hung_sessions_to_alert	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver log sessions hung on IO to alert log
_hang_log_verified_hangs_to_alert	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver log verified hangs to alert log
_hang_long_file_operations_detection_delay	Integer	1800	yes	SYSTEM imm.	N	Y		Blocker Resolver long file operations hang detection delay secs
_hang_low_wait_time_cutoff	Integer	6	yes	SYSTEM imm.	N	Y		Blocker Resolver low wait time cutoff in seconds
_hang_lsr_trigger_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver lsr trigger enabled
_hang_lws_file_count	Integer	5	yes	SYSTEM imm.	N	Y		Number of trace files for long waiting sessions
_hang_lws_file_space_limit	Integer	100000000	yes	SYSTEM imm.	N	Y		File space limit for current long waiting session trace file
_hang_mark_some_idle_waits_terminal	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver mark some wait events as terminal waits
_hang_max_instance_allow_node_eviction	Integer	1	yes	SYSTEM imm.	N	Y		Blocker Resolver maximum instance count to allow node eviction
_hang_max_local_db_clients_allowed	Integer	0	yes	SYSTEM imm.	N	Y		Blocker Resolver maximum local db clients allowed
_hang_max_session_hang_time	Integer	96	yes	SYSTEM imm.	N	Y		Blocker Resolver maximum session hang time in seconds
_hang_metrics_older_bitmap_threshold	Integer	25	yes	SYSTEM imm.	N	Y		Blocker Resolver Hang Metric older bitmap threshold
_hang_metrics_recent_bitmap_threshold	Integer	50	yes	SYSTEM imm.	N	Y		Blocker Resolver Hang Metric recent bitmap threshold
_hang_monitor_archiving_related_hang_interval	Integer	300	yes	SYSTEM imm.	N	Y		Time in seconds ignored hangs must persist after verification
_hang_msg_checksum_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		enable hang graph message checksum
_hang_nested_wait_handling_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver nested wait event handling enabled
_hang_parsing_hangs_resolution_interval	Integer	0	yes	SYSTEM imm.	N	Y		Blocker Resolver parsing hangs resolution interval
_hang_prog_ft_critical_db_proc_verification_interval	Integer	900	yes	SYSTEM imm.	N	Y		Blocker Resolver progressing, fast-tracked critical db process verification interval
_hang_promote_process_termination_interval	Integer	70	yes	SYSTEM imm.	N	Y		Blocker Resolver promote process termination interval in seconds
_hang_px_resolution_on_asm_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver px resolution on ASM enabled
_hang_resolution_allow_archiving_issue_termination	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver hang resolution allow archiving issue termination
_hang_resolution_confidence_promotion	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver hang resolution confidence promotion enabled
_hang_resolution_global_hang_confidence_promotion	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver hang resolution global hang confidence promotion
_hang_resolution_partial_hangs_on_asm_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver resolution of partial hangs on ASM enabled
_hang_resolution_partial_hangs_on_db_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver resolution of partial hangs on DB enabled
_hang_resolution_percent_hung_sessions_threshold	Integer	300	yes	SYSTEM imm.	N	Y		Blocker Resolver hang resolution percent hung sessions threshold
_hang_resolution_percent_hung_sessions_threshold2	Integer	5000	yes	SYSTEM imm.	N	Y		Blocker Resolver hang resolution percent hung sessions threshold2
_hang_resolution_policy	String	HIGH	yes	SYSTEM imm.	N	Y		Blocker Resolver hang resolution policy
_hang_resolution_promote_process_termination	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver hang resolution promote process termination
_hang_resolution_scope	String	INSTANCE	yes	SYSTEM imm.	N	Y		Blocker Resolver hang resolution scope
_hang_root_ha_phase_trigger_time	Integer	300	yes	SYSTEM imm.	N	Y		Blocker Resolver root HA phase trigger time
_hang_running_in_lrg	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver running in lrg
_hang_sess_enq_wait_blocked_session_threshold	Integer	5	yes	SYSTEM imm.	N	Y		Blocker Resolver session enqueue wait blocked session threshold
_hang_sess_enq_wait_resltn_trig_time	Integer	0	yes	SYSTEM imm.	N	Y		Blocker Resolver session enqueue wait resolution trigger time
_hang_session_scan_update_hb_interval	Integer	6000	yes	SYSTEM imm.	N	Y		Blocker Resolver session scan update heartbeat interval
_hang_short_stacks_output_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		if TRUE hang manager outputs short stacks
_hang_signature_list_match_output_frequency	Integer	10	yes	SYSTEM imm.	N	Y		Hang Signature List matched output frequency
_hang_singleton_detection_rw_enabled	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver singleton detection enabled for read-write
_hang_singleton_resolution_rw_enabled	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Blocker Resolver singleton resolution enabled for read-write
_hang_statistics_collection_interval	Integer	15	yes	SYSTEM imm.	N	Y		Blocker Resolver statistics collection interval in seconds
_hang_statistics_collection_ma_alpha	Integer	30	yes	SYSTEM imm.	N	Y		Blocker Resolver statistics collection moving average alpha
_hang_statistics_high_io_percentage_threshold	Integer	25	yes	SYSTEM imm.	N	Y		Blocker Resolver statistics high IO percentage threshold
_hang_terminate_session_replay_enabled	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Blocker Resolver terminates sessions allowing replay
_hang_trace_interval	Integer	32	yes	SYSTEM imm.	N	Y		Blocker Resolver trace interval in seconds
_hang_verification_interval	Integer	46	yes	SYSTEM imm.	N	Y		Blocker Resolver verification interval in seconds
_hanganalyze_strip_offset	Boolean	TRUE	yes	SYSTEM imm.	N	Y		if TRUE, strips offsets from short stack from HA wait chains
_kse_alt_stack_sig_syms	Integer	25	yes	SESSION	Y	Y		The number of top symbols used for the alternate stack signature
_kse_auto_core	Boolean	FALSE	yes	STATIC	N	N		generate core for unexpected SIGSEGV/SIGBUS
_kse_die_timeout	Integer	60000	yes	SYSTEM imm.	N	Y		amount of time a dying process is spared by PMON (in centi-secs)
_kse_pc_table_size	Integer	256	yes	SYSTEM imm.	N	Y		kse pc table cache size
_kse_signature_entries	Integer	0	yes	SYSTEM imm.	N	Y		number of entries in the kse stack signature cache
_kse_signature_limit	Integer	7	yes	SYSTEM imm.	N	Y		number of stack frames to cache per kse signature
_kse_snap_ring_disable	Boolean	FALSE	yes	SESSION	Y	Y		set to TRUE or FALSE to disable or enable error logging
_kse_snap_ring_record_min	String		yes	STATIC	N	N		minimize recorded information in error stack history
_kse_snap_ring_record_stack	Boolean	FALSE	yes	SESSION	Y	Y		should error snap ring entries show a short stack trace
_kse_snap_ring_size	Integer	100	yes	STATIC	N	N		ring buffer to debug internal error 17090
_kse_snap_ring_suppress	String	942 1403	yes	SESSION	Y	Y		List of error numbers to suppress in the snap error history
_kse_ssnt	Boolean	FALSE	yes	SESSION	Y	Y		disables symbol translation in short stacks to make them faster
_kse_trace_int_msg_clear	Boolean	FALSE	yes	SESSION	Y	Y		enables soft assert of KGECLEAERERROR is cleares an interrupt message
_sqlmon_all_rows_numpdb_threshold	Big integer	10	yes	SESSION	Y	Y		Return 100% of rows if active PDB count is below this cutoff.
_sqlmon_binds_xml_format	String	default	yes	SESSION	Y	Y		format of column binds_xml in [G]V$SQL_MONITOR
_sqlmon_conitr_row_cache_size	Integer	50	yes	SESSION	Y	Y		Cache size for rows from keomnRefreshCacheFromPdbSwitchCbk()
_sqlmon_entry_cutoff_end_time	Big integer	0	yes	SESSION	Y	Y		Cutoff end time offset (in seconds) for monitored entries during scan of [G]V$RECENT_SQL_MONITOR
_sqlmon_entry_cutoff_start_time	Big integer	3600	yes	SESSION	Y	Y		Cutoff start time offset (in seconds) for monitored entries during scan of [G]V$RECENT_SQL_MONITOR
_sqlmon_max_active_idle	Integer	0	yes	SESSION	Y	Y		Time (in sec) after which a SQL Monitor entry can be reclaimed
_sqlmon_max_plan	Integer	80	yes	SESSION	Y	Y		Maximum number of plans entry that can be monitored. Defaults to 20 per CPU
_sqlmon_max_planlines	Integer	1000	yes	SESSION	Y	Y		Number of plan lines beyond which a plan cannot be monitored
_sqlmon_max_recent_rows_per_pdb	Big integer	0	yes	SESSION	Y	Y		Max rows fetched from PDB during scan of [G]V$RECENT_SQL_MONITOR
_sqlmon_recent_query_max_time	Big integer	2	yes	SESSION	Y	Y		Time limit for CDB-optimized scan of [G]V$RECENT_SQL_MONITOR
_sqlmon_recycle_time	Integer	5	yes	SESSION	Y	Y		Minimum time (in s) to wait before a plan entry can be recycled
_sqlmon_threshold	Integer	5	yes	SESSION	Y	Y		CPU/IO time threshold before a statement is monitored. 0 is disabled
_trace_buffer_wait_timeouts	Integer	0	yes	SESSION	Y	Y		trace buffer busy wait timeouts
_trace_buffers	String	ALL:256	yes	STATIC	N	N		trace buffer sizes per process
_trace_dump_all_procs	Boolean	FALSE	yes	SYSTEM imm.	N	Y		if TRUE on error buckets of all processes will be dumped to the current trace file
_trace_dump_client_buckets	Boolean	TRUE	yes	SYSTEM imm.	N	Y		if TRUE dump client (ie. non-kst) buckets
_trace_dump_cur_proc_only	Boolean	FALSE	yes	SYSTEM imm.	N	Y		if TRUE on error just dump our process bucket
_trace_dump_static_only	Boolean	FALSE	yes	SYSTEM imm.	N	Y		if TRUE filter trace dumps to always loaded dlls
_trace_events	String		yes	SYSTEM imm.	N	Y		trace events enabled at startup
_trace_files_public	Boolean	FALSE	yes	STATIC	N	N		Create publicly accessible trace files
_trace_kqlidp	Boolean	FALSE	yes	SESSION	Y	Y		trace kqlidp0 operation
_trace_ktds	Boolean	FALSE	yes	SESSION	Y	Y		Trace block reuse
_trace_ktfs	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		Trace ILM Stats Tracking
_trace_ktfs_mem	Boolean	FALSE	yes	SESSION	Y	Y		Debug memleak
_trace_logging_from_root	Boolean	FALSE	yes	SESSION	N	N		true if object store write is allowed from root
_trace_logging_uri	String		yes	SESSION	N	N		object store uri where trace is uploaded
_trace_navigation_scope	String	global	yes	STATIC	N	N		enabling trace navigation linking
_trace_pin_time	Boolean	FALSE	yes	STATIC	N	N		trace how long a current pin is held
_trace_pool_size	Big integer		yes	STATIC	N	N		trace pool size in bytes
_trace_processes	String	ALL	yes	STATIC	N	N		enable KST tracing in process
_trace_suppress	String		yes	SESSION	Y	Y		suppresses matching trace for a given substring(prefix)
_trace_suppress_disable	Boolean	FALSE	yes	STATIC	N	N		Disable trace suppress feature
_trace_temp	Boolean	FALSE	yes	SESSION	Y	Y		Trace Tempspace Management
_trace_virtual_columns	Boolean	FALSE	yes	SESSION	Y	Y		trace virtual columns exprs