행위

12c hidden parameter

DB CAFE

Admin (토론 | 기여)님의 2020년 3월 5일 (목) 18:58 판 (새 문서: 12c hidden undocumented parameter list Oracle Database Tips by Donald BurlesonJune 30, 2013 Here is how to list all of the Oracle 12c hidden undocumented parameters: <source la...)
(차이) ← 이전 판 | 최신판 (차이) | 다음 판 → (차이)
thumb_up 추천메뉴 바로가기


12c hidden undocumented parameter list Oracle Database Tips by Donald BurlesonJune 30, 2013


Here is how to list all of the Oracle 12c hidden undocumented parameters:


select ksppinm,
       ksppdesc
  from x$ksppi
 where subsur(ksppinm,1,1) = '_'
 order by 1,2;




_4030_dump_bitvec bitvec to specify dumps prior to 4030 error

_4031_dump_bitvec bitvec to specify dumps prior to 4031 error

_4031_dump_interval Dump 4031 error once for each n-second interval

_4031_max_dumps Maximum number of 4031 dumps for this process

_4031_sga_dump_interval Dump 4031 SGA heapdump error once for each n-second interval

_4031_sga_max_dumps Maximum number of SGA heapdumps

_ILM_FILTER_TIME Upper filter time for ILM block compression

_ILM_FILTER_TIME_LOWER Lower filter time for ILM block compression

_ILM_POLICY_NAME User specified ILM policy name

_NUMA_instance_mapping Set of nodes that this instance should run on

_NUMA_pool_size aggregate size in bytes of NUMA pool

_PX_use_large_pool Use Large Pool as source of PX buffers

__data_transfer_cache_size Actual size of data transfer cache

__db_cache_size Actual size of DEFAULT buffer pool for standard block size buffers

__dg_broker_service_names service names for broker use

__java_pool_size Actual size in bytes of java pool

__large_pool_size Actual size in bytes of large pool

__oracle_base ORACLE_BASE

__pga_aggregate_target Current target size for the aggregate PGA memory consumed

__sga_target Actual size of SGA

__shared_io_pool_size Actual size of shared IO pool

__shared_pool_size Actual size in bytes of shared pool

__streams_pool_size Actual size in bytes of streams pool

_abort_on_mrp_crash abort database instance when MRP crashes

_abort_recovery_on_join if TRUE, abort recovery on join reconfigurations

_ac_enable_dscn_in_rac Enable Dependent Commit SCN tracking

_accept_versions List of parameters for rolling operation

_active_instance_count number of active instances in the cluster database

_active_session_idle_limit active session idle limit

_active_session_legacy_behavior active session legacy behavior

_active_standby_fast_reconfiguration if TRUE optimize dlm reconfiguration for active/standby OPS

_adaptive_direct_read Adaptive Direct Read

_adaptive_direct_write Adaptive Direct Write

_adaptive_fetch_enabled enable/disable adaptive fetch in parallel group by

_adaptive_log_file_sync_high_switch_freq Threshold for frequent log file sync mode switches (per minute)

_threshold


_adaptive_log_file_sync_poll_aggressiven Polling interval selection bias (conservative=0, aggressive=100)

ess


_adaptive_log_file_sync_sched_delay_wind Window (in seconds) for measuring average scheduling delay

ow


_adaptive_log_file_sync_use_polling_thre Ratio of redo synch time to expected poll time as a percentage

shold


_adaptive_log_file_sync_use_postwait_thr Percentage of foreground load from when post/wait was last used

eshold


_adaptive_scalable_log_writer_disable_wo Percentage of overlap across multiple outstanding writes

rker_threshold


_adaptive_scalable_log_writer_enable_wor Increase in redo generation rate as a percentage

ker_threshold


_adaptive_window_consolidator_enabled enable/disable adaptive window consolidator PX plan

_add_col_optim_enabled Allows new add column optimization

_add_nullable_column_with_default_optim Allows add of a nullable column with default optimization

_add_stale_mv_to_dependency_list add stale mv to dependency list

_add_trim_for_nlssort add trimming for fixed char semantics

_addm_auto_enable governs whether ADDM gets run automatically after every AWR snapshot

_addm_skiprules comma-separated list of ADDM nodes to skip

_addm_version_check governs whether ADDM checks the input AWR snapshot version

_adg_buffer_wait_timeout Active Dataguard buffer wait time in cs

_adg_instance_recovery enable ADG instance recovery

_adjust_literal_replacement If TRUE, we will adjust the SQL/PLUS output

_adr_migrate_runonce Enable/disable ADR Migrate Runonce action

_advanced_index_compression_options advanced index compression options

_advanced_index_compression_options_valu advanced index compression options2

e


_advanced_index_compression_trace advanced index compression trace

_affinity_on enable/disable affinity at run time

_aged_out_cursor_cache_time number of seconds an aged out session cached cursor stay in cache

_aggregation_optimization_settings settings for aggregation optimizations

_aiowait_timeouts Number of aiowait timeouts before error is reported

_alert_expiration seconds before an alert message is moved to exception queue

_alert_message_cleanup Enable Alert Message Cleanup

_alert_message_purge Enable Alert Message Purge

_alert_post_background Enable Background Alert Posting

_all_shared_dblinks treat all dblinks as shared

_allocate_creation_order should files be examined in creation order during allocation

_allocation_update_interval interval at which successful search in L1 should be updated

_allow_cell_smart_scan_attr Allow checking smart_scan_capable Attr

_allow_commutativity allow for commutativity of +, * when comparing expressions

_allow_compatibility_adv_w_grp allow advancing DB compatibility with guaranteed restore points

_allow_drop_snapshot_standby_grsp Allow dropping snapshot standby guaranteed restore point

_allow_drop_ts_with_grp Allow drop Tablespace with guaranteed restore points

_allow_error_simulation Allow error simulation for testing

_allow_file_1_offline_error_1245 don't signal ORA-1245 due to file 1 being offline

_allow_level_without_connect_by allow level without connect by

_allow_read_only_corruption allow read-only open even if database is corrupt

_allow_resetlogs_corruption allow resetlogs even if it will cause corruption

_allow_terminal_recovery_corruption Finish terminal recovery even if it may cause corruption

_alternate_iot_leaf_block_split_points enable alternate index-organized table leaf-block split-points

_always_anti_join always use this method for anti-join when possible

_always_semi_join always use this method for semi-join when possible

_always_star_transformation always favor use of star transformation

_am_container_filesystem_ausize allocation unit size for non-ASM containers

_am_max_containers maximum number of containers

_am_max_groups maximum number of containers

_am_max_seg_bytes maximum number of bytes per array segment

_am_timeouts_enabled enable timeouts

_am_trace_buffer_size size of per-process I/O trace buffer

_and_pruning_enabled allow partition pruning based on multiple mechanisms

_appqos_cdb_setting QoSM CDB Performance Class Setting

_appqos_po_multiplier Multiplier for PC performance objective value

_appqos_qt System Queue time retrieval interval

_aq_disable_x AQ - Disable new cross processes at an instance

_aq_dq_sessions Deq session count

_aq_eq_sessions Enq session count

_aq_init_shards Minimum enqueue shards per queue at an instance

_aq_max_scan_delay Maximum allowable scan delay for AQ indexes and IOTs

_aq_precrt_partitions Precreate Partitions

_aq_pt_processes Partition background processes

_aq_stop_backgrounds Stop all AQ background processes

_aq_subshard_Size Sub Shard Size

_aq_tm_deqcountinterval dequeue count interval for Time Managers to cleanup DEQ IOT BLOCKS

_aq_tm_scanlimit scan limit for Time Managers to clean up IOT

_aq_tm_statistics_duration statistics collection window duration

_aqsharded_cache_limit Limit for cached enqueue/dequeue operations

_arch_comp_dbg_scan archive compression scan debug

_arch_comp_dec_block_check_dump decompress archive compression blocks for checking and dumping

_arch_compress_checksums enable/disable row checksums for archive compressed blocks

_arch_compression archive compression enabled

_arch_io_slaves ARCH I/O slaves

_arch_sim_mode Change behavior of local archiving

_array_update_vector_read_enabled Enable array update vector read

_ash_compression_enable To enable or disable string compression in ASH

_ash_disk_filter_ratio Ratio of the number of in-memory samples to the number of samples actually writt

                                        en to disk


_ash_disk_write_enable To enable or disable Active Session History flushing

_ash_dummy_test_param Oracle internal dummy ASH parameter used ONLY for testing!

_ash_eflush_trigger The percentage above which if the in-memory ASH is full the emergency flusher wi

                                        ll be triggered


_ash_enable To enable or disable Active Session sampling and flushing

_ash_min_mmnl_dump Minimum Time interval passed to consider MMNL Dump

_ash_sample_all To enable or disable sampling every connected session including ones waiting for

                                         idle waits


_ash_sampling_interval Time interval between two successive Active Session samples in millisecs

_ash_size To set the size of the in-memory Active Session History buffers

_asm_access ASM File access mechanism

_asm_acd_chunks initial ACD chunks created

_asm_admin_with_sysdba Does the sysdba role have administrative privileges on ASM?

_asm_allow_appliance_dropdisk_noforce Allow DROP DISK/FAILUREGROUP NOFORCE on ASM Appliances

_asm_allow_lvm_resilvering Enable disk resilvering for external redundancy

_asm_allow_only_raw_disks Discovery only raw devices

_asm_allow_system_alias_rename if system alias renaming is allowed

_asm_allow_unsafe_reconnect attempt unsafe reconnect to ASM

_asm_allowdegeneratemounts Allow force-mounts of DGs w/o proper quorum

_asm_appliance_config_file Appliance configuration file name

_asm_ausize allocation unit size

_asm_automatic_rezone automatically rebalance free space across zones

_asm_avoid_pst_scans Avoid PST Scans

_asm_blksize metadata block size

_asm_check_for_misbehaving_cf_clients check for misbehaving CF-holding clients

_asm_compatibility default ASM compatibility level

_asm_dba_batch ASM Disk Based Allocation Max Batch Size

_asm_dba_spcchk_thld ASM Disk Based Allocation Space Check Threshold

_asm_dba_threshold ASM Disk Based Allocation Threshold

_asm_dbmsdg_nohdrchk dbms_diskgroup.checkfile does not check block headers

_asm_diag_dead_clients diagnostics for dead clients

_asm_direct_con_expire_time Expire time for idle direct connection to ASM instance

_asm_disable_amdu_dump Disable AMDU dump

_asm_disable_async_msgs disable async intra-instance messaging

_asm_disable_multiple_instance_check Disable checking for multiple ASM instances on a given node

_asm_disable_profilediscovery disable profile query for discovery

_asm_disable_smr_creation Do Not create smr

_asm_disable_ufg_dump disable terminated umbilicus diagnostic

_asm_disable_ufgmemberkill disable ufg member kill

_asm_disk_repair_time seconds to wait before dropping a failing disk

_asm_diskerr_traces Number of read/write errors per disk a process can trace

_asm_diskgroups2 disk groups to mount automatically set 2

_asm_diskgroups3 disk groups to mount automatically set 3

_asm_diskgroups4 disk groups to mount automatically set 4

_asm_emulate_nfs_disk Emulate NFS disk test event



_asm_emulmax max number of concurrent disks to emulate I /O errors

_asm_emultimeout timeout before emulation begins (in 3s ticks)

_asm_enable_xrov Enable XROV capability

_asm_evenread ASM Even Read level

_asm_evenread_alpha ASM Even Read Alpha

_asm_evenread_alpha2 ASM Even Read Second Alpha

_asm_evenread_faststart ASM Even Read Fast Start Threshold

_asm_fail_random_rx Randomly fail some RX enqueue gets

_asm_fob_tac_frequency Timeout frequency for FOB cleanup

_asm_force_quiesce Force diskgroup quiescing

_asm_global_dump_level System state dump level for ASM asserts

_asm_hbeatiowait number of secs to wait for PST Async Hbeat IO return

_asm_hbeatwaitquantum quantum used to compute time-to-wait for a PST Hbeat check

_asm_healthcheck_timeout seconds until health check takes action

_asm_imbalance_tolerance hundredths of a percentage of inter-disk imbalance to tolerate

_asm_instlock_quota ASM Instance Lock Quota

_asm_iostat_latch_count ASM I/O statistics latch count

_asm_kfdpevent KFDP event

_asm_kill_unresponsive_clients kill unresponsive ASM clients

_asm_libraries library search order for discovery

_asm_log_scale_rebalance Rebalance power uses logarithmic scale

_asm_lsod_bucket_size ASM lsod bucket size

_asm_max_cod_strides maximum number of COD strides

_asm_max_redo_buffer_size asm maximum redo buffer size

_asm_maxio Maximum size of individual I/O request

_asm_network_timeout Keepalive timeout for ASM network connections

_asm_networks ASM network subnet addresses

_asm_nodekill_escalate_time secs until escalating to nodekill if fence incomplete

_asm_noevenread_diskgroups List of disk groups having even read disabled

_asm_partner_target_disk_part target maximum number of disk partners for repartnering

_asm_partner_target_fg_rel target maximum number of failure group relationships for repartnering

_asm_primary_load Number of cycles/extents to load for non-mirrored files

_asm_primary_load_cycles True if primary load is in cycles, false if extent counts

_asm_procs_trace_diskerr Number of processes allowed to trace a disk failure

_asm_proxy_startwait Maximum time to wait for ASM proxy connection

_asm_random_zone Random zones for new files

_asm_rebalance_plan_size maximum rebalance work unit

_asm_rebalance_space_errors number of out of space errors allowed before aborting rebalance

_asm_remote_client_timeout timeout before killing disconnected remote clients

_asm_repairquantum quantum (in 3s) used to compute elapsed time for disk drop

_asm_reserve_slaves reserve ASM slaves for CF txns

_asm_resyncCkpt number of extents to resync before flushing checkpoint

_asm_root_directory ASM default root directory

_asm_runtime_capability_volume_support runtime capability for volume support returns supported

_asm_scrub_limit ASM disk scrubbing power

_asm_secondary_load Number of cycles/extents to load for mirrored files

_asm_secondary_load_cycles True if secondary load is in cycles, false if extent counts

_asm_serialize_volume_rebalance Serialize volume rebalance

_asm_shadow_cycle Inverse shadow cycle requirement

_asm_skip_diskval_check skip client side discovery for disk revalidate

_asm_skip_rename_check skip the checking of the clients for s/w compatibility for rename

_asm_skip_resize_check skip the checking of the clients for s/w compatibility for resize

_asm_storagemaysplit PST Split Possible

_asm_stripesize ASM file stripe size

_asm_stripewidth ASM file stripe width

_asm_sync_rebalance Rebalance uses sync I/O

_asm_trace_limit_timeout Time-out in milliseconds to reset the number of traces per disk and the number o

                                        f processes allowed to trace


_asm_usd_batch ASM USD Update Max Batch Size

_asm_wait_time Max/imum time to wait before asmb exits

_asmsid ASM instance id

_assm_default ASSM default

_assm_force_fetchmeta enable metadata block fetching in ASSM segment scan

_assm_high_gsp_threshold Number of blocks rejected before growing segment

_assm_low_gsp_threshold Number of blocks rejected before collecting stats

_async_recovery_claims if TRUE, issue recovery claims asynchronously

_async_recovery_reads if TRUE, issue recovery reads asynchronously

_async_ts_threshold check tablespace thresholds asynchronously

_auto_assign_cg_for_sessions auto assign CGs for sessions

_auto_bmr enable/disable Auto BMR

_auto_bmr_bg_time Auto BMR Process Run Time

_auto_bmr_fc_time Auto BMR Flood Control Time

_auto_bmr_pub_timeout Auto BMR Publish Timeout

_auto_bmr_req_timeout Auto BMR Requester Timeout

_auto_bmr_sess_threshold Auto BMR Request Session Threshold

_auto_bmr_sys_threshold Auto BMR Request System Threshold

_auto_manage_enable_offline_check perodically check for OFFLINE disks and attempt to ONLINE

_auto_manage_exadata_disks Automate Exadata disk management

_auto_manage_infreq_tout TEST: Set infrequent timeout action to run at this interval, unit is seconds

_auto_manage_ioctl_bufsz oss_ioctl buffer size, to read and respond to cell notifications

_auto_manage_max_online_tries Max. attempts to auto ONLINE an ASM disk

_auto_manage_num_pipe_msgs Max. number of out-standing msgs in the KXDAM pipe

_auto_manage_num_tries Num. tries before giving up on a automation operation

_auto_manage_online_tries_expire_time Allow Max. attempts to auto ONLINE an ASM disk after lapsing this time (unit in

                                        seconds)


_automatic_maintenance_test Enable AUTOTASK Test Mode

_automemory_broker_interval memory broker statistics gathering interval for auto memory

_autotask_max_window Maximum Logical Maintenance Window Length in minutes

_autotask_min_window Minimum Maintenance Window Length in minutes

_autotask_test_name Name of current Autotask Test (or test step)

_autotune_gtx_idle_time idle time to trigger auto-shutdown a gtx background process

_autotune_gtx_interval interval to autotune global transaction background processes

_autotune_gtx_threshold auto-tune threshold for degree of global transaction concurrency

_aux_dfc_keep_time auxiliary datafile copy keep time in minutes

_available_core_count number of cores for this instance

_avoid_prepare if TRUE, do not prepare a buffer when the master is local

_awr_cdbperf_threshold Setting for AWR CDBPERF Threshold

_awr_corrupt_mode AWR Corrupt Mode

_awr_disabled_flush_tables Disable flushing of specified AWR tables

_awr_flush_threshold_metrics Enable/Disable Flushing AWR Threshold Metrics

_awr_flush_workload_metrics Enable/Disable Flushing AWR Workload Metrics

_awr_mmon_cpuusage Enable/disable AWR MMON CPU Usage Tracking

_awr_mmon_deep_purge_all_expired Allows deep purge to purge AWR data for all expired snapshots

_awr_mmon_deep_purge_extent Set extent of rows to check each deep purge run

_awr_mmon_deep_purge_interval Set interval for deep purge of AWR contents

_awr_mmon_deep_purge_numrows Set max number of rows per table to delete each deep purge run

_awr_pdb_registration_enabled Parameter to enable/disable AWR PDB Registration

_awr_remote_target_dblink AWR Remote Target DBLink for Flushing

_awr_restrict_mode AWR Restrict Mode

_awr_sql_child_limit Setting for AWR SQL Child Limit

_b_tree_bitmap_plans enable the use of bitmap plans for tables w. only B-tree indexes

_backup_align_write_io align backup write I/Os

_backup_automatic_retry automatic retry on backup write errors

_backup_disk_bufcnt number of buffers used for DISK channels

_backup_disk_bufsz size of buffers used for DISK channels

_backup_disk_io_slaves BACKUP Disk I/O slaves

_backup_dynamic_buffers dynamically compute backup/restore buffer sizes

_backup_encrypt_opt_mode specifies encryption block optimization mode

_backup_file_bufcnt number of buffers used for file access

_backup_file_bufsz size of buffers used for file access

_backup_io_pool_size memory to reserve from the large pool

_backup_kgc_blksiz specifies buffer size to be used by HIGH compression

_backup_kgc_bufsz specifies buffer size to be used by BASIC compression

_backup_kgc_memlevel specifies memory level for MEDIUM compression

_backup_kgc_niters specifies number of iterations done by BASIC compression

_backup_kgc_perflevel specifies compression (performance) level for MEDIUM compression

_backup_kgc_scheme specifies compression scheme

_backup_kgc_type specifies compression type used by kgc BASIC compression

_backup_kgc_windowbits specifies window size for MEDIUM compression

_backup_ksfq_bufcnt number of buffers used for backup/restore

_backup_ksfq_bufmem_max maximum amount of memory (in bytes) used for buffers for backup/restore

_backup_ksfq_bufsz size of buffers used for backup/restore

_backup_lzo_size specifies buffer size for LOW compression

_backup_max_gap_size largest gap in an incremental/optimized backup buffer, in bytes

_backup_min_ct_unused_optim mimimun size in bytes of change tracking to apply unused space optimuzation

_backup_seq_bufcnt number of buffers used for non-DISK channels

_backup_seq_bufsz size of buffers used for non-DISK channels

_bct_bitmaps_per_file number of bitmaps to store for each datafile

_bct_buffer_allocation_max maximum size of all change tracking buffer allocations, in bytes

_bct_buffer_allocation_min_extents mininum number of extents to allocate per buffer allocation

_bct_buffer_allocation_size size of one change tracking buffer allocation, in bytes

_bct_chunk_size change tracking datafile chunk size, in bytes

_bct_crash_reserve_size change tracking reserved crash recovery SGA space, in bytes

_bct_file_block_size block size of change tracking file, in bytes

_bct_file_extent_size extent size of change tracking file, in bytes

_bct_fixtab_file change tracking file for fixed tables

_bct_health_check_interval CTWR health check interval (seconds), zero to disable

_bct_initial_private_dba_buffer_size initial number of entries in the private change tracking dba buffers

_bct_mrp_timeout CTWR MRP wait timeout (seconds), zero to wait forever

_bct_public_dba_buffer_dynresize allow dynamic resizing of public dba buffers, zero to disable

_bct_public_dba_buffer_maxsize max buffer size permitted for public dba buffers, in bytes

_bct_public_dba_buffer_size total size of all public change tracking dba buffers, in bytes

_bg_spawn_diag_opts background processes spawn diagnostic options

_bitmap_or_improvement_enabled controls extensions to partition pruning for general predicates

_block_level_offload_high_lat_thresh High Latency Threshold for Block Level Offload operations

_block_sample_readahead_prob_threshold controls readahead value during block sampling

_blocking_sess_graph_cache_size blocking session graph cache size in bytes

_blocks_per_cache_server number of consecutive blocks per global cache server

_bloom_filter_debug debug level for bloom filtering

_bloom_filter_enabled enables or disables bloom filter

_bloom_filter_size bloom filter vector size (in KB)

_bloom_folding_density bloom filter folding density lower bound

_bloom_folding_enabled Enable folding of bloom filter

_bloom_folding_min bloom filter folding size lower bound (in KB)

_bloom_max_size maximum bloom filter size (in KB)

_bloom_minmax_enabled enable or disable bloom min max filtering

_bloom_predicate_enabled enables or disables bloom filter predicate pushdown

_bloom_predicate_offload enables or disables bloom filter predicate offload to cells

_bloom_pruning_enabled Enable partition pruning using bloom filtering

_bloom_pushing_max bloom filter pushing size upper bound (in KB)

_bloom_pushing_total_max bloom filter combined pushing size upper bound (in KB)

_bloom_rm_filter remove bloom predicate in favor of zonemap join pruning predicate

_bloom_sm_enabled enable bloom filter optimization using slave mapping

_branch_tagging enable branch tagging for distributed transaction

_broadcast_scn_mode broadcast-on-commit scn mode

_broadcast_scn_wait_timeout broadcast-on-commit scn wait timeout in centiseconds

_bsln_adaptive_thresholds_enabled Adaptive Thresholds Enabled

_bt_mmv_query_rewrite_enabled allow rewrites with multiple MVs and base tables

_buffer_busy_wait_timeout buffer busy wait time in centiseconds

_buffered_message_spill_age Buffered message spill age

_buffered_publisher_flow_control_thresho Flow control threshold for buffered publishers except capture

ld


_bufq_stop_flow_control Stop enforcing flow control for buffered queues

_build_deferred_mv_skipping_mvlog_update DEFERRED MV creation skipping MV log setup update

_bump_highwater_mark_count how many blocks should we allocate per free list on advancing HWM

_bwr_for_flushed_pi if TRUE, generate a BWR for a flushed PI

_bypass_srl_for_so_eor bypass SRL for S/O EOR logs

_bypass_xplatform_error bypass datafile header cross-platform-compliance errors

_cache_orl_during_open cache online logs

_cache_stats_monitor if TRUE, enable cache stats monitoring

_capture_buffer_size To set the size of the PGA I/O recording buffers

_capture_publisher_flow_control_threshol Flow control threshold for capture publishers

d


_case_sensitive_logon case sensitive logon enabled

_causal_standby_wait_timeout Causal standby wait timeout

_cdb_compatible CDB Compatible

_cdb_rac_affinity rac affinity for parallel cdb operations

_cdc_subscription_owner Change Data Capture subscription_owner

_cdmp_diagnostic_level cdmp directory diagnostic level

_cell_fast_file_create Allow optimized file creation path for Cells

_cell_fast_file_restore Allow optimized rman restore for Cells

_cell_file_format_chunk_size Cell file format chunk size in MB

_cell_index_scan_enabled enable CELL processing of index FFS

_cell_materialize_all_expressions Force materialization of all offloadable expressions on the cells

_cell_materialize_virtual_columns enable offload of expressions underlying virtual columns to cells

_cell_offload_capabilities_enabled specifies capability table to load

_cell_offload_complex_processing enable complex SQL processing offload to cells

_cell_offload_expressions enable offload of expressions to cells

_cell_offload_hybridcolumnar Query offloading of hybrid columnar compressed tables to exadata

_cell_offload_predicate_reordering_enabl enable out-of-order SQL processing offload to cells

ed


_cell_offload_sys_context enable offload of SYS_CONTEXT evaluation to cells

_cell_offload_timezone enable timezone related SQL processing offload to cells

_cell_offload_virtual_columns enable offload of predicates on virtual columns to cells

_cell_range_scan_enabled enable CELL processing of index range scans

_cell_storidx_mode Cell Storage Index mode

_cgs_allgroup_poll_time CGS DBALL group polling interval in milli-seconds

_cgs_comm_readiness_check CGS communication readiness check

_cgs_dball_group_registration CGS DBALL group registration type

_cgs_dbgroup_poll_time CGS DB group polling interval in milli-seconds

_cgs_health_check_in_reconfig CGS health check during reconfiguration

_cgs_memberkill_from_rim_instance allow a RIM instance to issue a CSS member kill

_cgs_msg_batch_size CGS message batch size in bytes

_cgs_msg_batching CGS message batching

_cgs_node_kill_escalation CGS node kill escalation to CSS

_cgs_node_kill_escalation_wait CGS wait time to escalate node kill to CSS in seconds

_cgs_reconfig_extra_wait CGS reconfiguration extra wait time for CSS in seconds

_cgs_reconfig_timeout CGS reconfiguration timeout interval

_cgs_send_timeout CGS send timeout value

_cgs_ticket_sendback CGS ticket active sendback percentage threshold

_cgs_tickets CGS messaging tickets

_cgs_zombie_member_kill_wait CGS zombie member kill wait time in seconds

_change_vector_buffers Number of change vector buffers for media recovery

_check_block_after_checksum perform block check after checksum if both are turned on

_check_block_new_invariant_for_flashback check block new invariant for flashback

_check_column_length check column length

_check_pdbid_in_redo Enable checking of pluggable database ID in redo

_check_ts_threshold check tablespace thresholds

_cleanout_shrcur_buffers if TRUE, cleanout shrcur buffers

_cleanup_rollback_entries no. of undo entries to apply per transaction cleanup

_cleanup_timeout timeout value for PMON cleanup

_cleanup_timeout_flags flags for PMON cleanup timeout

_clear_buffer_before_reuse Always zero-out buffer before reuse for security

_cli_cachebktalloc Percentage of memory to allocate

_client_enable_auto_unregister enable automatic unregister after a send fails with timeout

_client_ntfn_cleanup_interval interval after which dead client registration cleanup task repeats

_client_ntfn_pinginterval time between pings to unreachable notification clients

_client_ntfn_pingretries number of times to ping unreachable notification clients

_client_ntfn_pingtimeout timeout to connect to unreachable notification clients

_client_result_cache_bypass bypass the client result cache

_client_tstz_error_check Should Client give error for suspect Timestamp with Timezone operations

_clone_one_pdb_recovery Recover ROOT and only one PDB in clone database

_close_cached_open_cursors close cursors cached by PL/SQL at each commit

_close_deq_by_cond_curs Close Dequeue By Condition Cursors

_cloud_name gsm cloud name

_cluster_library cluster library selection

_clusterwide_global_transactions enable/disable clusterwide global transactions

_collapse_wait_history collapse wait history

_collect_tempundo_stats Collect Statistics v$tempundostat

_collect_undo_stats Collect Statistics v$undostat

_column_compression_factor Column compression ratio

_column_elimination_off turn off predicate-only column elimination

_column_tracking_level column usage tracking

_common_user_prefix Enforce restriction on a prefix of a Common User/Role/Profile name

_compilation_call_heap_extent_size Size of the compilation call heaps extents

_complex_view_merging enable complex view merging

_compression_above_cache number of recompression above cache for sanity check

_compression_advisor Compression advisor

_compression_chain percentage of chained rows allowed for Compression

_compression_compatibility Compression compatability

_concurrency_chosen what is the chosen value of concurrency

_connect_by_use_union_all use union all for connect by

_connection_broker_host connection broker host for listen address

_controlfile_autobackup_delay time delay (in seconds) for performing controlfile autobackups

_controlfile_backup_copy_check enable check of the copied blocks during controlfile backup copy

_controlfile_block_size control file block size in bytes

_controlfile_cell_flash_caching Flash cache hint for control file accesses

_controlfile_enqueue_dump dump the system states after controlfile enqueue timeout

_controlfile_enqueue_holding_time control file enqueue max holding time in seconds

_controlfile_enqueue_holding_time_tracki control file enqueue holding time tracking size

ng_size


_controlfile_enqueue_timeout control file enqueue timeout in seconds

_controlfile_section_init_size control file initial section size

_controlfile_section_max_expand control file max expansion rate

_controlfile_update_check controlfile update sanity check

_convert_set_to_join enables conversion of set operator to join

_coord_message_buffer parallel recovery coordinator side extra message buffer size

_corrupted_rollback_segments corrupted undo segment list

_cost_equality_semi_join enables costing of equality semi-join

_cp_num_hash_latches connection pool number of hash latches

_cpu_eff_thread_multiplier CPU effective thread multiplier

_cpu_to_io divisor for converting CPU cost to I/O cost

_cr_grant_global_role if TRUE, grant lock for CR requests when block is in global role

_cr_grant_local_role turn 3-way CR grants off, make it automatic, or turn it on

_cr_grant_only if TRUE, grant locks when possible and do not send the block

_cr_server_log_flush if TRUE, flush redo log before serving a CR buffer

_cr_trc_buf_size size of cr trace buffer

_crash_domain_on_exception allow domain to exit for exceptions in any thread

_create_stat_segment create ilm statistics segment

_create_table_in_any_cluster allow creation of table in a cluster not owned by the user

_ctx_doc_policy_stems enable ctx_doc.policy_stems api

_cu_row_locking CU row level locking

_cursor_bind_capture_area_size maximum size of the cursor bind capture area

_cursor_bind_capture_interval interval (in seconds) between two bind capture for a cursor

_cursor_cache_time number of seconds a session cached cursor stay in cache.

_cursor_db_buffers_pinned additional number of buffers a cursor can pin at once

_cursor_features_enabled Shared cursor features enabled bits.

_cursor_obsolete_threshold Number of cursors per parent before obsoletion.

_cursor_plan_enabled enable collection and display of cursor plans

_cursor_plan_hash_version version of cursor plan hash value

_cursor_plan_unparse_enabled enables/disables using unparse to build projection/predicates

_cursor_reload_failure_threshold Number of failed reloads before marking cursor unusable

_cursor_runtimeheap_memlimit Shared cursor runtime heap memory limit

_cursor_stats_enabled Enable cursor stats

_cvmap_buffers Number of change vector buffers for multi instance media recovery

_cvw_enable_weak_checking enable weak view checking

_data_transfer_cache_bc_perc_x100 Percentange * 100 of buffer cache to transfer to data transfer cache

_data_transfer_cache_size Size of data transfer cache

_data_warehousing_scan_buffers if TRUE, enable data warehousing scan buffers

_datafile_cow Use copy on write snapshot for the renamed file

_datafile_write_errors_crash_instance datafile write errors crash instance

_datapump_compressbas_buffer_size specifies buffer size for BASIC compression algorithm

_datapump_metadata_buffer_size specifies buffer size for metadata file I/O

_datapump_tabledata_buffer_size specifies buffer size for table data file I/O

_db_16k_flash_cache_file flash cache file for 16k block size

_db_16k_flash_cache_size flash cache size for _db_16k_flash_cache_file

_db_2k_flash_cache_file flash cache file for 2k block size

_db_2k_flash_cache_size flash cache size for _db_2k_flash_cache_file

_db_32k_flash_cache_file flash cache file for 32k block size

_db_32k_flash_cache_size flash cache size for _db_32k_flash_cache_file

_db_4k_flash_cache_file flash cache file for 4k block size

_db_4k_flash_cache_size flash cache size for _db_4k_flash_cache_file

_db_8k_flash_cache_file flash cache file for 8k block size

_db_8k_flash_cache_size flash cache size for _db_8k_flash_cache_file

_db_aging_cool_count Touch count set when buffer cooled

_db_aging_freeze_cr Make CR buffers always be too cold to keep in cache

_db_aging_hot_criteria Touch count which sends a buffer to head of replacement list

_db_aging_stay_count Touch count set when buffer moved to head of replacement list

_db_aging_touch_time Touch count which sends a buffer to head of replacement list

_db_always_check_system_ts Always perform block check and checksum for System tablespace

_db_block_adjcheck adjacent cache buffer checks - low blkchk overwrite parameter

_db_block_adjchk_level adjacent cache buffer check level

_db_block_align_direct_read Align Direct Reads

_db_block_bad_write_check enable bad write checks

_db_block_buffers Number of database blocks cached in memory: hidden parameter

_db_block_cache_clone Always clone data blocks on get (for debugging)

_db_block_cache_history buffer header tracing (non-zero only when debugging)

_db_block_cache_history_level buffer header tracing level

_db_block_cache_history_lru buffer header tracing for lru operations

_db_block_cache_num_umap number of unmapped buffers (for tracking swap calls on blocks)

_db_block_cache_protect protect database blocks (true only when debugging)

_db_block_cache_protect_internal protect database blocks (for strictly internal use only)

_db_block_check_for_debug Check more and dump block before image for debugging

_db_block_check_objtyp check objd and typ on cache disk read

_db_block_chunkify_ncmbr chunkify noncontig multi block reads

_db_block_corruption_recovery_threshold threshold number of block recovery attempts

_db_block_do_full_mbreads do full block read even if some blocks are in cache

_db_block_hash_buckets Number of database block hash buckets

_db_block_hash_latches Number of database block hash latches

_db_block_header_guard_level number of extra buffer headers to use as guard pages

_db_block_hi_priority_batch_size Fraction of writes for high priority reasons

_db_block_known_clean_pct Initial Percentage of buffers to maintain known clean

_db_block_lru_latches number of lru latches

_db_block_max_cr_dba Maximum Allowed Number of CR buffers per dba

_db_block_max_scan_pct Percentage of buffers to inspect when looking for free

_db_block_med_priority_batch_size Fraction of writes for medium priority reasons

_db_block_numa Number of NUMA nodes

_db_block_prefetch_fast_longjumps_enable Batched IO enable fast longjumps

d


_db_block_prefetch_limit Prefetch limit in blocks

_db_block_prefetch_override Prefetch force override in blocks

_db_block_prefetch_private_cache_enabled Batched IO enable private cache

_db_block_prefetch_quota Prefetch quota as a percent of cache size

_db_block_prefetch_skip_reading_enabled Batched IO enable skip reading buffers

_db_block_prefetch_wasted_threshold_perc Allowed wasted percent threshold of prefetched size

_db_block_table_scan_buffer_size Size of shared table scan read buffer

_db_block_temp_redo generate redo for temp blocks

_db_block_trace_protect trace buffer protect calls

_db_block_vlm_check check of rvlm mapping leaks (for debugging)

_db_block_vlm_leak_threshold Threshold for allowable vlm leaks

_db_blocks_per_hash_latch Number of blocks per hash latch

_db_cache_advice_max_size_factor cache advisory maximum multiple of current size to similate

_db_cache_advice_sample_factor cache advisory sampling factor

_db_cache_advice_sanity_check cache simulation sanity check

_db_cache_block_read_stack_trace dump short call stack for block reads

_db_cache_crx_check check for costly crx examination functions

_db_cache_miss_check_les check LEs after cache miss

_db_cache_mman_latch_check check for wait latch get under MMAN ops in kcb

_db_cache_pre_warm Buffer Cache Pre-Warm Enabled : hidden parameter

_db_cache_process_cr_pin_max maximum number of cr pins a process may have

_db_cache_wait_debug trace new kslwaits

_db_change_notification_enable enable db change notification

_db_check_cell_hints

_db_disable_temp_encryption Disable Temp Encryption for Spills

_db_dump_from_disk_and_efc dump contents from disk and efc

_db_dw_scan_adaptive_cooling if TRUE, enable adaptive DW scan cooling

_db_dw_scan_max_shadow_count DW Scan adaptive cooling max shadow count

_db_dw_scan_obj_cooling_factor DW Scan object cooling factor to cool all temperatures

_db_dw_scan_obj_cooling_interval DW Scan object cooling interval in number of scans, seconds, or pct of cache siz

                                        e


_db_dw_scan_obj_cooling_policy DW scan objtect cooling policy

_db_dw_scan_obj_warming_increment DW Scan object warming increment when an object is scanned

_db_fast_obj_check enable fast object drop sanity check

_db_fast_obj_ckpt enable fast object checkpoint

_db_fast_obj_truncate enable fast object truncate

_db_file_direct_io_count Sequential I/O buf size

_db_file_exec_read_count multiblock read count for regular clients

_db_file_format_io_buffers Block formatting I/O buf count

_db_file_noncontig_mblock_read_count number of noncontiguous db blocks to be prefetched

_db_file_optimizer_read_count multiblock read count for regular clients

_db_flash_cache_force_replenish_limit Flash cache force replenish lower limit in buffers

_db_flash_cache_keep_limit Flash cache keep buffer upper limit in percentage

_db_flash_cache_max_latency Flash cache maximum latency allowed in 10 milliseconds

_db_flash_cache_max_outstanding_writes Flash cache maximum outstanding writes allowed

_db_flash_cache_max_read_retry Flash cache max read retry

_db_flash_cache_max_slow_io Flash cache maximum slow io allowed

_db_flash_cache_write_limit Flash cache write buffer upper limit in percentage

_db_flashback_iobuf_size Flashback IO Buffer Size

_db_flashback_log_min_size Minimum flashback database log size in bytes

_db_flashback_log_min_total_space Minimum flashback database log total space in bytes

_db_flashback_num_iobuf Flashback Number of IO buffers

_db_handles System-wide simultaneous buffer operations

_db_handles_cached Buffer handles cached each process

_db_hot_block_tracking track hot blocks for hash latch contention

_db_index_block_checking index block checking override parameter

_db_initial_cachesize_create_mb size of cache created at startup

_db_l2_tracing flash cache debug tracing

_db_large_dirty_queue Number of buffers which force dirty queue to be written

_db_lost_write_checking Enable scn based lost write detection mechanism

_db_lost_write_tracing Enable _db_lost_write_checking tracing

_db_mttr_advice MTTR advisory

_db_mttr_partitions number of partitions for MTTR advisory

_db_mttr_sample_factor MTTR simulation sampling factor

_db_mttr_sim_target MTTR simulation targets

_db_mttr_sim_trace_size MTTR simulation trace size

_db_mttr_trace_to_alert dump trace entries to alert file

_db_noarch_disble_optim Image redo logging (NOARCHIVEMODE)

_db_num_evict_waitevents number of evict wait events

_db_num_gsm database number in gsm dbpool

_db_obj_enable_ksr enable ksr in object checkpoint/reuse

_db_percent_hot_default Percent of default buffer pool considered hot

_db_percent_hot_keep Percent of keep buffer pool considered hot

_db_percent_hot_recycle Percent of recycle buffer pool considered hot

_db_percpu_create_cachesize size of cache created per cpu in deferred cache create

_db_prefetch_histogram_statistics maintain prefetch histogram statistics in x$kcbprfhs

_db_recovery_temporal_file_dest default database recovery temporal file location

_db_required_percent_fairshare_usage percent of fairshare a processor group should always use

_db_row_overlap_checking row overlap checking override parameter for data/index blocks

_db_todefer_cache_create buffer cache deferred create

_db_writer_chunk_writes Number of writes DBWR should wait for

_db_writer_coalesce_area_size Size of memory allocated to dbwriter for coalescing writes

_db_writer_coalesce_write_limit Limit on size of coalesced write

_db_writer_flush_imu If FALSE, DBWR will not downgrade IMU txns for AGING

_db_writer_histogram_statistics maintain dbwr histogram statistics in x$kcbbhs

_db_writer_max_writes Max number of outstanding DB Writer IOs

_db_writer_nomemcopy_coalesce Enable DBWR no-memcopy coalescing

_db_writer_verify_writes Enable lost write detection mechanism

_dbfs_modify_implicit_fetch DBFS Link allows implicit fetch on modify - only on SecureFiles

_dbg_proc_startup debug process startup

_dbg_scan generic scan debug

_dbms_sql_security_level Security level in DBMS_SQL

_dbop_enabled Any positive number enables automatic DBOP monitoring. 0 is disabled

_dbpool_name gsm database pool name

_dbrm_dynamic_threshold DBRM dynamic threshold setting

_dbrm_num_runnable_list Resource Manager number of runnable list per NUMA node

_dbrm_quantum DBRM quantum

_dbrm_runchk Resource Manager Diagnostic Running Thread Check

_dbrm_short_wait_us Resource Manager short wait length

_dbwr_async_io Enable dbwriter asynchronous writes

_dbwr_scan_interval dbwriter scan interval

_dbwr_tracing Enable dbwriter tracing

_dd_validate_remote_locks GES deadlock detection validate remote locks

_dde_flood_control_init Initialize Flood Control at database open

_dead_process_scan_interval PMON dead process scan interval (in seconds)

_deadlock_diagnostic_level automatic deadlock resolution diagnostics level

_deadlock_record_to_alert_log record resolved deadlocks to the alert log

_deadlock_resolution_incidents_always create incidents when resolving any deadlock?

_deadlock_resolution_incidents_enabled create incidents during deadlock resolution

_deadlock_resolution_level automatic deadlock resolution level

_deadlock_resolution_min_wait_timeout_se the minimum wait timeout required for deadlock resolution

cs


_deadlock_resolution_signal_process_thre the amount of time given to process a deadlock resolution signal

sh_secs


_dedicated_server_poll_count dedicated server poll count

_dedicated_server_post_wait dedicated server post/wait

_dedicated_server_post_wait_call dedicated server post/wait call

_default_encrypt_alg default encryption algorithm

_default_non_equality_sel_check sanity check on default selectivity for like/range predicate

_defer_eor_orl_arch_for_so defer EOR ORL archival for switchover

_defer_log_boundary_ckpt defer media recovery checkpoint at log boundary

_defer_log_count Number of log boundaries media recovery checkpoint lags behind

_defer_rcv_during_sw_to_sby Defer recovery during switchover to standby

_defer_sga_alloc_chunk_size Chunk size for defer sga allocation

_defer_sga_enabled Enable deferred shared memory allocation for SGA

_defer_sga_min_spsz_at_startup Minimum shared pool size at startup with deferred sga enabled

_defer_sga_min_total_defer_segs_sz Minimum total deferred segs size for defer sga allocation

_defer_sga_test_alloc_intv SA** sleeps for N secs before allocating a deferred segment

_deferred_constant_folding_mode Deferred constant folding mode

_deferred_log_dest_is_valid consider deferred log dest as valid for log deletion (TRUE/FALSE)

_deferred_seg_in_seed Enable Deferred Segment Creation in Seed

_delay_index_maintain delays index maintenance until after MV is refreshed

_delta_push_share_blockers enable delta push if greater than the # of share blockers

_deq_execute_reset_time deq execute reset time

_deq_ht_child_latches deq ht child latches

_deq_ht_max_elements deq ht max elements

_deq_large_txn_size deq large txn size

_deq_log_array_size deq log array size

_deq_max_fetch_count deq max fetch count

_deq_maxwait_time Change wait times between dequeue calls

_desired_readmem_rate The desired percentage of redo reading from memory

_dg_broker_trace_level data guard broker trace level

_dg_cf_check_timer Data Guard controlfile check timer

_dg_corrupt_redo_log Corrupt redo log validation during archivals

_diag_adr_auto_purge Enable/disable ADR MMON Auto Purging

_diag_adr_enabled Parameter to enable/disable Diag ADR

_diag_adr_test_param Test parameter for Diagnosability

_diag_arb_before_kill dump diagnostics before killing unresponsive ARBs

_diag_backward_compat Backward Compatibility for Diagnosability

_diag_cc_enabled Parameter to enable/disable Diag Call Context

_diag_conf_cap_enabled Parameter to enable/disable Diag Configuration Capture

_diag_crashdump_level parameter for systemstate dump level, used by DIAG during crash

_diag_daemon start DIAG daemon

_diag_dde_async_age_limit diag dde async actions: message age limit (in seconds)

_diag_dde_async_cputime_limit diag dde async actions: action cputime limit (in seconds)

_diag_dde_async_mode diag dde async actions: dispatch mode

_diag_dde_async_msg_capacity diag dde async actions: message buffer capacity

_diag_dde_async_msgs diag dde async actions: number of preallocated message buffers

_diag_dde_async_process_rate diag dde async actions: message processing rate - per loop

_diag_dde_async_runtime_limit diag dde async actions: action runtime limit (in seconds)

_diag_dde_async_slaves diag dde async actions: max number of concurrent slave processes

_diag_dde_enabled enable DDE handling of critical errors

_diag_dde_fc_enabled Parameter to enable/disable Diag Flood Control

_diag_dde_fc_implicit_time Override Implicit Error Flood Control time parameter

_diag_dde_fc_macro_time Override Macro Error Flood Control time parameter

_diag_dde_inc_proc_delay The minimum delay between two MMON incident sweeps (minutes)

_diag_diagnostics Turn off diag diagnostics

_diag_dump_request_debug_level DIAG dump request debug level (0-2)

_diag_dump_timeout timeout parameter for SYNC dump

_diag_enable_startup_events enable events in instance startup notifiers

_diag_hm_rc_enabled Parameter to enable/disable Diag HM Reactive Checks

_diag_hm_tc_enabled Parameter to enable/disable Diag HM Test(dummy) Checks

_diag_proc_enabled enable hung process diagnostic API

_diag_proc_max_time_ms hung process diagnostic API max wait time in milliseconds

_diag_proc_stack_capture_type hung process diagnostic API stack capture type

_diag_test_seg_reinc_mode Sets trace segmentation to be in reincarnation mode

_diag_uts_control UTS control parameter

_diag_verbose_error_on_init Allow verbose error tracing on diag init

_diag_xm_enabled If TRUE, DIAG allows message exchanges across DB/ASM boundary

_dimension_skip_null control dimension skip when null feature

_direct_io_skip_cur_slot_on_error Skip current slot on error

_direct_io_slots number of slots for direct path I/O

_direct_io_wslots number of write slots for direct path I/O

_direct_path_insert_features disable direct path insert features

_direct_read_decision_statistics_driven enable direct read decision based on optimizer statistics

_disable_12751 disable policy timeout error (ORA-12751)

_disable_12cbigfile DIsable Storing ILM Statistics in 12cBigFiles

_disable_active_influx_move disable active influx move during parallel media recovery

_disable_adaptive_shrunk_aggregation adaptive shrunk aggregation

_disable_appliance_check Disable appliance-specific code

_disable_appliance_partnering Disable appliance partnering algorithms

_disable_autotune_gtx disable autotune global transaction background processes

_disable_block_checking disable block checking at the session level

_disable_cell_optimized_backups disable cell optimized backups

_disable_cpu_check disable cpu_count check

_disable_cursor_sharing disable cursor sharing

_disable_datalayer_sampling disable datalayer sampling

_disable_directory_link_check Disable directory link checking

_disable_duplex_link Turn off connection duplexing

_disable_fast_aggregation fast aggregation

_disable_fast_validate disable PL/SQL fast validation

_disable_fastopen Do Not Use Fastopen

_disable_fba_qrw disable flashback archiver query rewrite

_disable_fba_wpr disable flashback archiver wait for prepared transactions

_disable_file_locks disable file locks for control, data, redo log files

_disable_flashback_archiver disable flashback archiver

_disable_flashback_recyclebin_opt Don't use the Flashback Recyclebin optimization

_disable_flashback_wait_callback Disable flashback wait callback

_disable_function_based_index disable function-based index matching

_disable_gvaq_cache Disable cache

_disable_health_check Disable Health Check

_disable_highres_ticks disable high-res tick counter

_disable_image_check Disable Oracle executable image checking

_disable_implicit_row_movement disable implicit row movement

_disable_incremental_checkpoints Disable incremental checkpoints for thread recovery

_disable_incremental_recovery_ckpt Disable incremental recovery checkpoint mechanism

_disable_index_block_prefetching disable index block prefetching

_disable_initial_block_compression disable initial block compression

_disable_instance_params_check disable instance type check for ksp

_disable_interface_checking disable interface checking at startup

_disable_kcb_flashback_blocknew_opt Disable KCB flashback block new optimization

_disable_kcbhxor_osd disable kcbh(c)xor OSD functionality

_disable_kcbl_flashback_blocknew_opt Disable KCBL flashback block new optimization

_disable_kgghshcrc32_osd disable kgghshcrc32chk OSD functionality

_disable_latch_free_SCN_writes_via_32cas disable latch-free SCN writes using 32-bit compare & swap

_disable_latch_free_SCN_writes_via_64cas disable latch-free SCN writes using 64-bit compare & swap

_disable_logging Disable logging

_disable_metrics_group Disable Metrics Group (or all Metrics Groups)

_disable_multiple_block_sizes disable multiple block size support (for debugging)

_disable_odm disable odm feature

_disable_parallel_conventional_load Disable parallel conventional loads

_disable_primary_bitmap_switch disable primary bitmap switch

_disable_read_only_open_dict_check Disable read-only open dictionary check

_disable_rebalance_space_check disable space usage checks for storage reconfiguration

_disable_recovery_read_skip Disable the read optimization during media recovery

_disable_rolling_patch Disable Rolling Patch Feature

_disable_sample_io_optim disable row sampling IO optimization

_disable_savepoint_reset disable the fix for bug 1402161

_disable_selftune_checkpointing Disable self-tune checkpointing

_disable_storage_type Disable storage type checks

_disable_streams_diagnostics streams diagnostics

_disable_streams_pool_auto_tuning disable streams pool auto tuning

_disable_sun_rsm Disable IPC OSD support for Sun RSMAPI

_disable_system_state disable system state dump

_disable_system_state_wait_samples Disable system state dump - wait samples

_disable_temp_tablespace_alerts disable tablespace alerts for TEMPORARY tablespaces

_disable_thread_internal_disable Disable thread internal disable feature

_disable_thread_snapshot Thread snapshot

_disable_txn_alert disable txn layer alert

_disable_undo_tablespace_alerts disable tablespace alerts for UNDO tablespaces

_disable_wait_state Disable wait state

_discrete_transactions_enabled enable OLTP mode

_disk_sector_size_override if TRUE, OSD sector size could be overridden

_diskmon_pipe_name DiSKMon skgznp pipe name

_dispatcher_rate_scale scale to display rate statistic (100ths of a second)

_dispatcher_rate_ttl time-to-live for rate statistic (100ths of a second)

_distinct_view_unnesting enables unnesting of in subquery into distinct view

_distributed_recovery_connection_hold_ti number of seconds RECO holds outbound connections open

me


_dlmtrace Trace string of global enqueue type(s)

_dm_dmf_details_compatibility set dm dmf details compatibility version

_dm_enable_legacy_dmf_output_types revert dmf output types to pre-12.1.0.1

_dm_max_shared_pool_pct max percentage of the shared pool to use for a mining model

_dml_batch_error_limit number or error handles allocated for DML in batch mode

_dml_frequency_tracking Control DML frequency tracking

_dml_frequency_tracking_advance Control automatic advance and broadcast of DML frequencies

_dml_frequency_tracking_slot_time Time length of each slot for DML frequency tracking

_dml_frequency_tracking_slots Number of slots to use for DML frequency tracking

_dml_monitoring_enabled enable modification monitoring

_dnfs_rdma_enable Enable dNFS RDMA transfers

_dnfs_rdma_max Maximum size of dNFS RDMA transfer

_dnfs_rdma_min Minimum size of dNFS RDMA transfer

_domain_index_batch_size maximum number of rows from one call to domain index fetch routine

_domain_index_dml_batch_size maximum number of rows for one call to domain index dml routines

_dra_bmr_number_threshold Maximum number of BMRs that can be done to a file

_dra_bmr_percent_threshold Maximum percentage of blocks in a file that can be BMR-ed

_dra_enable_offline_dictionary Enable the periodic creation of the offline dictionary for DRA

_drm_parallel_freeze if TRUE enables parallel drm freeze

_drop_flashback_logical_operations_enq Drop logical operations enqueue immediately during flashback marker generation

_drop_stat_segment drop ilm statistics segment

_drop_table_granule drop_table_granule

_drop_table_optimization_enabled reduce SGA memory use during drop of a partitioned table

_ds_enable_auto_txn Dynamic Sampling Service Autonomous Transaction control parameter

_ds_iocount_iosize Dynamic Sampling Service defaults: #IOs and IO Size

_ds_parse_model Dynamic Sampling Service Parse Model control parameter

_dsc_feature_level controls the feature level for deferred segment creation

_dskm_health_check_cnt DiSKMon health check counter

_dss_cache_flush enable full cache flush for parallel execution

_dtree_area_size size of Decision Tree Classification work area

_dtree_binning_enabled Decision Tree Binning Enabled

_dtree_bintest_id Decision Tree Binning Test ID

_dtree_compressbmp_enabled Decision Tree Using Compressed Bitmaps Enabled

_dtree_max_surrogates maximum number of surrogates

_dtree_pruning_enabled Decision Tree Pruning Enabled

_dummy_instance dummy instance started by RMAN

_dump_10261_level Dump level for event 10261, 1=>minimal dump 2=>top pga dump

_dump_common_subexpressions dump common subexpressions

_dump_connect_by_loop_data dump connect by loop error message into trc file

_dump_cursor_heap_sizes dump comp/exec heap sizes to tryace file

_dump_interval_limit trace dump time interval limit (in seconds)

_dump_max_limit max number of dump within dump interval

_dump_qbc_tree dump top level query parse tree to trace

_dump_rcvr_ipc if TRUE enables IPC dump at instance eviction time

_dump_scn_increment_stack Dumps scn increment stack per session

_dump_system_state_scope scope of sysstate dump during instance termination

_dump_trace_scope scope of trace dump during a process crash

_dynamic_rls_policies rls policies are dynamic

_dynamic_stats_threshold delay threshold (in seconds) between sending statistics messages

_eighteenth_spare_parameter eighteenth spare parameter - string

_eighth_spare_parameter eighth spare parameter - integer

_eleventh_spare_parameter eleventh spare parameter - integer

_eliminate_common_subexpr enables elimination of common sub-expressions

_emon_max_active_connections maximum open connections to clients per emon

_emon_outbound_connect_timeout timeout for completing connection set up to clients

_emon_pool_inc increment in EMON slaves per pool type

_emon_pool_max maximum number of EMON slaves per pool type

_emon_pool_min minimum number of EMON slaves per pool type

_emon_regular_ntfn_slaves number of EMON slaves doing regular database notifications

_emon_send_timeout send timeout after which the client is unregistered

_emx_control EM Express control (internal use only)

_emx_max_sessions Maximum number of sessions in the EM Express cache

_emx_session_timeout Session timeout (sec) in the EM Express cache

_enable_12g_bft enable 12g bigfile tablespace

_enable_Front_End_View_Optimization enable front end view optimization

_enable_LGPG_debug Enable LGPG debug mode

_enable_NUMA_interleave Enable NUMA interleave mode

_enable_NUMA_optimization Enable NUMA specific optimizations

_enable_NUMA_support Enable NUMA support and optimizations

_enable_asyncvio enable asynch vectored I/O

_enable_automatic_maintenance if 1, Automated Maintenance Is Enabled

_enable_automatic_sqltune Automatic SQL Tuning Advisory enabled parameter

_enable_block_level_transaction_recovery enable block level recovery

_enable_check_truncate enable checking of corruption caused by canceled truncate

_enable_columnar_cache Enable Columnar Flash Cache Rewrite

_enable_cscn_caching enable commit SCN caching for all transactions

_enable_ddl_wait_lock use this to turn off ddls with wait semantics

_enable_default_affinity enable default implementation of hard affinity osds

_enable_default_temp_threshold Enable Default Tablespace Utilization Threshold for UNDO Tablespaces

_enable_default_undo_threshold Enable Default Tablespace Utilization Threshold for TEMPORARY Tablespaces

_enable_dml_lock_escalation enable dml lock escalation against partitioned tables if TRUE

_enable_editions_for_users enable editions for all users

_enable_exchange_validation_using_check use check constraints on the table for validation

_enable_fast_ref_after_mv_tbs enable fast refresh after move tablespace

_enable_ffw FAL FORWARDING

_enable_flash_logging Enable Exadata Smart Flash Logging

_enable_hash_overflow TRUE - enable hash cluster overflow based on SIZE

_enable_heatmap_internal heatmap related - to be used by oracle dev only

_enable_hwm_sync enable HWM synchronization

_enable_iee_stats enables IEE stats gathering

_enable_ilm_flush_stats Enable ILM Stats Flush

_enable_ilm_testflush_stats Enable Test ILM Stats Flush

_enable_kqf_purge Enable KQF fixed runtime table purge

_enable_list_io Enable List I/O

_enable_midtier_affinity enable midtier affinity metrics processing

_enable_minscn_cr enable/disable minscn optimization for CR

_enable_nativenet_tcpip Enable skgxp driver usage for native net

_enable_obj_queues enable object queues

_enable_offloaded_writes Enable offloaded writes

_enable_online_index_without_s_locking Allow online index creation algorithm without S DML lock

_enable_pluggable_database Enable Pluggable Database

_enable_query_rewrite_on_remote_objs mv rewrite on remote table/view

_enable_redo_global_post LGWR post globally on write

_enable_refresh_schedule enable or disable MV refresh scheduling (revert to 9.2 behavior)

_enable_reliable_latch_waits Enable reliable latch waits

_enable_rename_user enable RENAME-clause using ALTER USER statement

_enable_rlb enable RLB metrics processing

_enable_row_shipping use the row shipping optimization for wide table selects

_enable_sb_detection Split Brain Detection

_enable_schema_synonyms enable DDL operations (e.g. creation) involving schema synonyms

_enable_scn_wait_interface use this to turn off scn wait interface in kta

_enable_securefile_flashback_opt Enable securefile flashback optimization

_enable_separable_transactions enable/disable separable transactions

_enable_shared_pool_durations temporary to disable/enable kgh policy

_enable_shared_server_vector_io Enable shared server vector I/O

_enable_space_preallocation enable space pre-allocation

_enable_spacebg enable space management background task

_enable_tablespace_alerts enable tablespace alerts

_enable_type_dep_selectivity enable type dependent selectivity estimates

_endprot_chunk_comment chunk comment for selective overrun protection

_endprot_heap_comment heap comment for selective overrun protection

_endprot_subheaps selective overrun protection for subeheaps

_enqueue_deadlock_detect_all_global_lock enable deadlock detection on all global enqueues

s


_enqueue_deadlock_scan_secs deadlock scan interval

_enqueue_deadlock_time_sec requests with timeout <= this will not have deadlock detection

_enqueue_debug_multi_instance debug enqueue multi instance

_enqueue_hash enqueue hash table length

_enqueue_hash_chain_latches enqueue hash chain latches

_enqueue_locks locks for managed enqueues

_enqueue_paranoia_mode_enabled enable enqueue layer advanced debugging checks

_enqueue_resources resources for enqueues

_enqueue_sync_retry_attempts max number of times the bg process to retry synchronous enqueue open if it faile

                                        d because master could not allocate memory


_enqueue_sync_sim_mem_error simulate master instance running out of memory when synchronously getting a remo

                                        tely mastered enqueue


_evolve_plan_baseline_report_level Level of detail to show in plan verification/evolution report

_evt_system_event_propagation disable system event propagation

_expand_aggregates expand aggregates

_explain_rewrite_mode allow additional messages to be generated during explain rewrite

_extended_pruning_enabled do runtime pruning in iterator if set to TRUE

_external_scn_logging_threshold_seconds High delta SCN threshold in seconds

_external_scn_rejection_delta_threshold_ external SCN rejection delta threshold in minutes

minutes


_external_scn_rejection_threshold_hours Lag in hours between max allowed SCN and an external SCN

_fair_remote_cvt if TRUE enables fair remote convert

_fairness_threshold number of times to CR serve before downgrading lock

_fast_cursor_reexecute use more memory in order to get faster execution

_fast_dual_enabled enable/disable fast dual

_fast_full_scan_enabled enable/disable index fast full scan

_fast_index_maintenance fast global index maintenance during PMOPs

_fast_psby_conversion Enable fast physical standby conversion

_fastpin_enable enable reference count based fast pins

_fbda_busy_percentage flashback archiver busy percentage

_fbda_debug_assert flashback archiver debug assert for testing

_fbda_debug_mode flashback archiver debug event for testing

_fbda_global_bscn_lag flashback archiver global barrier scn lag

_fbda_inline_percentage flashback archiver inline percentage

_fbda_rac_inactive_limit flashback archiver rac inactive limit

_fg_iorm_slaves ForeGround I/O slaves for IORM

_fg_log_checksum Checksum redo in foreground process

_fg_sync_sleep_usecs Log file sync via usleep

_fic_algorithm_set Set Frequent Itemset Counting Algorithm

_fic_area_size size of Frequent Itemset Counting work area

_fic_max_length Frequent Itemset Counting Maximum Itemset Length

_fic_min_bmsize Frequent Itemset Counting Minimum BITMAP Size

_fic_outofmem_candidates Frequent Itemset Counting Out Of Memory Candidates Generation

_fifteenth_spare_parameter fifteenth spare parameter - integer

_fifth_spare_parameter fifth spare parameter - integer

_file_size_increase_increment Amount of file size increase increment, in bytes

_filemap_dir FILEMAP directory

_first_k_rows_dynamic_proration enable the use of dynamic proration of join cardinalities

_first_spare_parameter first spare parameter - integer

_fix_control bug fix control parameter

_flashback_11.1_block_new_opt use 11.1 flashback block new optimization scheme

_flashback_allow_noarchivelog Allow enabling flashback on noarchivelog database

_flashback_archiver_partition_size flashback archiver table partition size

_flashback_barrier_interval Flashback barrier interval in seconds

_flashback_copy_latches Number of flashback copy latches

_flashback_database_test_only Run Flashback Database in test mode

_flashback_delete_chunk_MB Amount of flashback log (in MB) to delete in one attempt

_flashback_dynamic_enable enable flashback enable code path

_flashback_dynamic_enable_failure Simulate failures during dynamic enable

_flashback_enable_ra Flashback enable read ahead

_flashback_format_chunk_mb Chunk mega-bytes for formatting flashback logs using sync write

_flashback_format_chunk_mb_dwrite Chunk mega-bytes for formatting flashback logs using delayed write

_flashback_fuzzy_barrier Use flashback fuzzy barrier

_flashback_generation_buffer_size flashback generation buffer size

_flashback_hint_barrier_percent Flashback hint barrier percent

_flashback_log_io_error_behavior Specify Flashback log I/O error behavior

_flashback_log_min_size Minimum flashback log size

_flashback_log_rac_balance_factor flashback log rac balance factor

_flashback_log_size Flashback log size

_flashback_logfile_enqueue_timeout flashback logfile enqueue timeout for opens

_flashback_marker_cache_enabled Enable flashback database marker cache

_flashback_marker_cache_size Size of flashback database marker cache

_flashback_max_log_size Maximum flashback log size in bytes (OS limit)

_flashback_max_n_log_per_thread Maximum number of flashback logs per flashback thread

_flashback_max_standby_sync_span Maximum time span between standby recovery sync for flashback

_flashback_n_log_per_thread Desired number of flashback logs per flashback thread

_flashback_prepare_log Prepare Flashback logs in the background

_flashback_size_based_on_redo Size new flashback logs based on average redo log size

_flashback_standby_barrier_interval Flashback standby barrier interval in seconds

_flashback_validate_controlfile validate flashback pointers in controlfile for 11.2.0.2 database

_flashback_verbose_info Print verbose information about flashback database

_flashback_write_max_loop_limit Flashback writer loop limit before it returns

_flush_ilm_stats flush ilm stats

_flush_plan_in_awr_sql Plan is being flushed from an AWR flush SQL

_flush_redo_to_standby Flush redo to standby test event parameter

_flush_undo_after_tx_recovery if TRUE, flush undo buffers after TX recovery

_force_arch_compress Archive Compress all newly created compressed tables

_force_datefold_trunc force use of trunc for datefolding rewrite

_force_hash_join_spill force hash join to spill to disk

_force_hsc_compress compress all newly created tables

_force_logging_in_upgrade force logging during upgrade mode

_force_oltp_compress OLTP Compress all newly created compressed tables

_force_oltp_update_opt OLTP Compressed row optimization on update

_force_rcv_info_ping Force recovery info ping to stdby

_force_rewrite_enable control new query rewrite features

_force_slave_mapping_intra_part_loads Force slave mapping for intra partition loads

_force_sys_compress Sys compress

_force_temptables_for_gsets executes concatenation of rollups using temp tables

_force_tmp_segment_loads Force tmp segment loads

_forwarded_2pc_threshold auto-tune threshold for two-phase commit rate across RAC instances

_fourteenth_spare_parameter fourteenth spare parameter - integer

_fourth_spare_parameter fourth spare parameter - integer

_frame_cache_time number of seconds a cached frame page stay in cache.

_full_diag_on_rim rim nodes have full DIA* function

_full_pwise_join_enabled enable full partition-wise join when TRUE

_fusion_security Fusion Security

_gby_hash_aggregation_enabled enable group-by and aggregation using hash scheme

_gby_onekey_enabled enable use of one comparison of all group by keys

_gc_affinity_acquire_time if TRUE, save the time we acquired an affinity lock

_gc_affinity_locking if TRUE, enable object affinity

_gc_affinity_locks if TRUE, get affinity locks

_gc_affinity_ratio dynamic object affinity ratio

_gc_async_send send blocks asynchronously

_gc_bypass_readers if TRUE, modifications bypass readers

_gc_check_bscn if TRUE, check for stale blocks

_gc_coalesce_recovery_reads if TRUE, coalesce recovery reads

_gc_cpu_time if TRUE, record the gc cpu time

_gc_cr_server_read_wait if TRUE, cr server waits for a read to complete

_gc_defer_ping_index_only if TRUE, restrict deferred ping to index blocks only

_gc_defer_time how long to defer pings for hot buffers in milliseconds

_gc_delta_push_compression if delta >= K bytes, compress before push

_gc_delta_push_max_level max delta level for delta push

_gc_delta_push_objects objects which use delta push

_gc_disable_s_lock_brr_ping_check if TRUE, disable S lock BRR ping check for lost write protect

_gc_down_convert_after_keep if TRUE, down-convert lock after recovery

_gc_element_percent global cache element percent

_gc_escalate_bid if TRUE, escalates create a bid

_gc_fg_merge if TRUE, merge pi buffers in the foreground

_gc_fg_spin_time foreground msgq spin time

_gc_flush_during_affinity if TRUE, flush during affinity

_gc_fusion_compression compress fusion blocks if there is free space

_gc_global_checkpoint_scn if TRUE, enable global checkpoint scn

_gc_global_cpu global cpu checks

_gc_global_lru turn global lru off, make it automatic, or turn it on

_gc_global_lru_touch_count global lru touch count

_gc_global_lru_touch_time global lru touch time in seconds

_gc_integrity_checks set the integrity check level

_gc_keep_recovery_buffers if TRUE, make single instance crash recovery buffers current

_gc_latches number of latches per LMS process

_gc_log_flush if TRUE, flush redo log before a current block transfer

_gc_long_query_threshold threshold for long running query

_gc_max_downcvt maximum downconverts to process at one time

_gc_maximum_bids maximum number of bids which can be prepared

_gc_no_fairness_for_clones if TRUE, no fairness if we serve a clone

_gc_object_queue_max_length maximum length for an object queue

_gc_override_force_cr if TRUE, try to override force-cr requests

_gc_persistent_read_mostly if TRUE, enable persistent read-mostly locking

_gc_policy_minimum dynamic object policy minimum activity per minute

_gc_policy_time how often to make object policy decisions in minutes

_gc_read_mostly_flush_check if TRUE, optimize flushes for read mostly objects

_gc_read_mostly_locking if TRUE, enable read-mostly locking

_gc_sanity_check_cr_buffers if TRUE, sanity check CR buffers

_gc_save_cleanout if TRUE, save cleanout to apply later

_gc_split_flush if TRUE, flush index split redo before rejecting bast

_gc_statistics if TRUE, kcl statistics are maintained

_gc_temp_affinity if TRUE, enable global temporary affinity

_gc_transfer_ratio dynamic object read-mostly transfer ratio

_gc_undo_affinity if TRUE, enable undo affinity

_gc_undo_block_disk_reads if TRUE, enable undo block disk reads

_gc_vector_read if TRUE, vector read current buffers

_gcr_cpu_min_free minimum amount of free CPU to flag an anomaly

_gcr_enable_high_cpu_kill if TRUE, GCR may kill foregrounds under high load

_gcr_enable_high_cpu_rm if TRUE, GCR may enable a RM plan under high load

_gcr_enable_high_cpu_rt if TRUE, GCR may boost bg priority under high load

_gcr_enable_high_memory_kill if TRUE, GCR may kill foregrounds under high memory load

_gcr_enable_new_drm_check if FALSE, revert to old drm load metric

_gcr_enable_statistical_cpu_check if FALSE, revert to old cpu load metric

_gcr_high_cpu_threshold minimum amount of CPU process must consume to be kill target

_gcr_high_memory_threshold minimum amount of Memory process must consume to be kill target

_gcr_max_rt_procs maximum number of RT DLM processes allowed by GCR

_gcr_mem_min_free minimum amount of free memory to flag an anomaly

_gcr_use_css if FALSE, GCR wont register with CSS nor use any CSS feature

_gcs_disable_remote_handles disable remote client/shadow handles

_gcs_disable_skip_close_remastering if TRUE, disable skip close optimization in remastering

_gcs_disable_switch_role_with_writer if TRUE, disable switching to local role with a writer

_gcs_fast_reconfig if TRUE, enable fast reconfiguration for gcs locks

_gcs_latches number of gcs resource hash latches to be allocated per LMS process

_gcs_min_slaves if non zero, it enables the minimum number of gcs slaves

_gcs_pkey_history number of pkey remastering history

_gcs_process_in_recovery if TRUE, process gcs requests during instance recovery

_gcs_res_hash_buckets number of gcs resource hash buckets to be allocated

_gcs_res_per_bucket number of gcs resource per hash bucket

_gcs_reserved_resources allocate the number of reserved resources in reconfiguration

_gcs_reserved_shadows allocate the number of reserved shadows in reconfiguration

_gcs_resources number of gcs resources to be allocated

_gcs_shadow_locks number of pcm shadow locks to be allocated

_gcs_testing GCS testing parameter

_generalized_pruning_enabled controls extensions to partition pruning for general predicates

_ges_dd_debug if 1 or higher enables GES deadlock detection debug diagnostics

_ges_default_lmds default lmds for enqueue hashing

_ges_designated_master designated master for GES and GCS resources

_ges_diagnostics if TRUE enables GES diagnostics

_ges_diagnostics_asm_dump_level systemstate level on global enqueue diagnostics blocked by ASM

_ges_direct_free if TRUE, free each resource directly to the freelist

_ges_direct_free_res_type string of resource types(s) to directly free to the freelist

_ges_dump_open_locks if TRUE, dump open locks for the LCK process during shutdown

_ges_fggl DLM fg grant lock on/off

_ges_freeable_res_chunk_free if TRUE, free dynamic resource chunks which are freeable

_ges_freeable_res_chunk_free_interval time interval for freeing freeable dynamic resource chunks

_ges_gather_res_reuse_stats if TRUE, gather resource reuse statistics

_ges_hash_groups enqueue hash table groups

_ges_health_check if greater than 0 enables GES system health check

_ges_lmd_mapping enqueue to lmd mapping

_ges_nres_divide how to divide number of enqueue resources among hash tables

_ges_num_blockers_to_kill number of blockers to be killed for hang resolution

_ges_resource_memory_opt enable different level of ges res memory optimization

_ges_server_processes number of background global enqueue server processes

_global_hang_analysis_interval_secs the interval at which global hang analysis is run

_globalindex_pnum_filter_enabled enables filter for global index with partition extended syntax

_grant_secure_role Disallow granting of SR to NSR

_groupby_nopushdown_cut_ratio groupby nopushdown cut ratio

_groupby_orderby_combine groupby/orderby don't combine threshold

_gs_anti_semi_join_allowed enable anti/semi join for the GS query

_gsm GSM descriptions

_gsm_config_vers version of gsm config

_gsm_cpu_thresh CPU busy threshold

_gsm_drv_interval metric derived values interval

_gsm_max_instances_per_db maximum number of instances per database in gsm cloud

_gsm_max_num_regions maximum number of regions in gsm cloud

_gsm_region_list List of GSM Regions

_gsm_srlat_thresh Single block read latency threshold

_gsm_thresh_respct threshold resource percentage

_gsm_thresh_zone threshold zone

_gwm_spare1 gsm spare 1

_gwm_spare2 gsm spare 2

_gwm_spare3 gsm spare 3

_hang_analysis_num_call_stacks hang analysis num call stacks

_hang_base_file_count Number of trace files for the normal base trace file

_hang_base_file_space_limit File space limit for current normal base trace file

_hang_bool_spare1 Hang Management 1

_hang_delay_resolution_for_libcache Hang Management delays hang resolution for library cache

_hang_detection_enabled Hang Management detection

_hang_detection_interval Hang Management detection interval in seconds

_hang_hang_analyze_output_hang_chains if TRUE hang manager outputs hang analysis hang chains

_hang_hiload_promoted_ignored_hang_count Hang Management high load or promoted ignored hang count

_hang_hiprior_session_attribute_list Hang Management high priority session attribute list

_hang_ignored_hang_count Hang Management ignored hang count

_hang_ignored_hangs_interval Time in seconds ignored hangs must persist after verification

_hang_int_spare2 Hang Management 2

_hang_log_verified_hangs_to_alert Hang Management log verified hangs to alert log

_hang_long_wait_time_threshold Long session wait time threshold in seconds

_hang_lws_file_count Number of trace files for long waiting sessions

_hang_lws_file_space_limit File space limit for current long waiting session trace file

_hang_monitor_archiving_related_hang_int Time in seconds ignored hangs must persist after verification

erval


_hang_msg_checksum_enabled enable hang graph message checksum

_hang_resolution_allow_archiving_issue_t Hang Management hang resolution allow archiving issue termination

ermination


_hang_resolution_confidence_promotion Hang Management hang resolution confidence promotion

_hang_resolution_global_hang_confidence_ Hang Management hang resolution global hang confidence promotion

promotion


_hang_resolution_policy Hang Management hang resolution policy

_hang_resolution_promote_process_termina Hang Management hang resolution promote process termination

tion


_hang_resolution_scope Hang Management hang resolution scope

_hang_signature_list_match_output_freque Hang Signature List matched output frequency

ncy


_hang_statistics_collection_interval Hang Management statistics collection interval in seconds

_hang_statistics_collection_ma_alpha Hang Management statistics collection moving average alpha

_hang_statistics_high_io_percentage_thre Hang Management statistics high IO percentage threshold

shold


_hang_terminate_session_replay_enabled Hang Management terminates sessions allowing replay

_hang_verification_interval Hang Management verification interval in seconds

_hard_protection if TRUE enable H.A.R.D specific format changes

_hash_join_enabled enable/disable hash join

_hash_multiblock_io_count number of blocks hash join will read/write at once

_hashops_prefetch_size maximum no of rows whose relevant memory locations are prefetched

_hb_redo_msg_interval BOC HB redo message interval in ms

_heatmap_format_1block heatmap related - to be used by oracle dev only

_heatmap_min_maxsize Internal testing only

_heur_deadlock_resolution_secs the heuristic wait time per node for deadlock resolution

_high_priority_processes High Priority Process Name Mask

_high_server_threshold high server thresholds

_highres_drift_allowed_sec allowed highres timer drift for VKTM

_highthreshold_undoretention high threshold undo_retention in seconds

_hj_bit_filter_threshold hash-join bit filtering threshold (0 always enabled)

_hm_analysis_oradebug_sys_dump_level the oradebug system state level for hang manager hang analysis

_hm_xm_enabled If TRUE, DIA0 allows message exchanges across DB/ASM boundary

_hwm_sync_threshold HWM synchronization threshold in percentage

_idl_conventional_index_maintenance enable conventional index maintenance for insert direct load

_idle_session_kill_enabled enables or disables resource manager session idle limit checks

_idxrb_rowincr proportionality constant for dop vs. rows in index rebuild

_ignore_desc_in_index ignore DESC in indexes, sort those columns ascending anyhow

_ignore_edition_enabled_for_EV_creation ignore schema's edition-enabled status during EV creation

_ignore_fg_deps ignore fine-grain dependencies during invalidation

_ilm_mem_limit percentage of the max shared pool heat-map can use - internal

_ilmflush_stat_limit ILM flush statistics limit - Internal testing only

_ilmset_stat_limit ILM set statistics limit - Internal testing only

_ilmstat_memlimit Percentage of shared pool for use by ILM Statistics

_image_redo_gen_delay Image redo generation delay in centi-seconds (direct write mode)

_immediate_commit_propagation if TRUE, propagate commit SCN immediately

_improved_outerjoin_card improved outer-join cardinality calculation

_improved_row_length_enabled enable the improvements for computing the average row length

_imr_active Activate Instance Membership Recovery feature

_imr_avoid_double_voting Avoid device voting for CSS reconfig during IMR

_imr_controlfile_access_wait_time IMR controlfile access wait time in seconds

_imr_device_type Type of device to be used by IMR

_imr_disk_voting_interval Maximum wait for IMR disk voting (seconds)

_imr_diskvote_implementation IMR disk voting implementation method

_imr_evicted_member_kill IMR issue evicted member kill after a wait

_imr_evicted_member_kill_wait IMR evicted member kill wait time in seconds

_imr_extra_reconfig_wait Extra reconfiguration wait in seconds

_imr_highload_threshold IMR system highload threshold

_imr_max_reconfig_delay Maximum Reconfiguration delay (seconds)

_imr_rr_holder_kill_time IMR max time instance is allowed to hold RR lock in seconds

_imr_splitbrain_res_wait Maximum wait for split-brain resolution (seconds)

_imr_systemload_check Perform the system load check during IMR

_imu_pools in memory undo pools

_in_memory_tbs_search FALSE - disable fast path for alter tablespace read only

_in_memory_undo Make in memory undo for top level transactions

_incremental_recovery_ckpt_min_batch minimum number of writes for incremental recovery ckpt every second

_index_join_enabled enable the use of index joins

_index_max_inc_trans_pct max itl expand percentage soft limit during index insert

_index_partition_large_extents Enables large extent allocation for partitioned indices

_index_prefetch_factor index prefetching factor

_index_scan_check_skip_corrupt check and skip corrupt blocks during index scans

_index_scan_check_stopkey check stopkey during index range scans

_init_granule_interval number of granules to process for deferred cache

_init_sql_file File containing SQL statements to execute upon database creation

_inject_startup_fault inject fault in the startup code

_inline_sql_in_plsql inline SQL in PL/SQL

_inplace_update_retry inplace update retry for ora1551

_inquiry_retry_interval if greater than 0 enables inquiry retry after specified interval

_insert_enable_hwm_brokered during parallel inserts high water marks are brokered

_inst_locking_period period an instance can retain a newly acquired level1 bitmap

_interconnect_checksum if TRUE, checksum interconnect blocks

_intrapart_pdml_enabled Enable intra-partition updates/deletes

_intrapart_pdml_randomlocal_enabled Enable intra-partition updates/deletes with random local dist

_io_internal_test I/O internal testing parameter

_io_osd_param OSD specific parameter

_io_outlier_threshold Latency threshold for io_outlier table

_io_resource_manager_always_on io resource manager always on

_io_shared_pool_size Size of I/O buffer pool from SGA

_io_slaves_disabled Do not use I/O slaves

_io_statistics if TRUE, ksfd I/O statistics are collected

_iocalibrate_init_ios iocalibrate init I/Os per process

_iocalibrate_max_ios iocalibrate max I/Os per process

_ioq_fanin_multiplier IOQ miss count before a miss exception

_ior_serialize_fault inject fault in the ior serialize code

_iorm_tout IORM scheduler timeout value in msec

_ioslave_batch_count Per attempt IOs picked

_ioslave_issue_count IOs issued before completion check

_ipc_fail_network Simulate cluster network failer

_ipc_test_failover Test transparent cluster network failover

_ipc_test_mult_nets simulate multiple cluster networks

_ipddb_enable Enable IPD/DB data collection

_job_queue_interval Wakeup interval in seconds for job queue co-ordinator

_k2q_latches number of k2q latches

_ka_allow_reenable reenability of kernel accelerator service after disable

_ka_compatibility_requirement kernel accelerator compatibility operation requirement

_ka_doorbell kernel accelerator doorbell mode

_ka_locks_per_sector locks per sector in kernel accelerator

_ka_mode kernel accelerator mode

_ka_msg_reap_count maximum number of KA messages to receive and process per wait

_ka_pbatch_messages kernel accelerator perform pbatch messages

_kcfis_automem_level Set auto memory management control for kcfis memory allocation

_kcfis_block_dump_level Smart IO block dump level

_kcfis_caching_enabled enable kcfis intra-scan session caching

_kcfis_cell_passthru_dataonly Allow dataonly passthru for smart scan

_kcfis_cell_passthru_enabled Do not perform smart IO filtering on the cell

_kcfis_cell_passthru_fromcpu_enabled Enable automatic passthru mode when cell CPU util is too high

_kcfis_celloflsrv_passthru_enabled Enable offload server usage for passthru operations

_kcfis_celloflsrv_usage_enabled Enable offload server usage for offload operations

_kcfis_control1 Kcfis control1

_kcfis_control2 Kcfis control2

_kcfis_control3 Kcfis control3

_kcfis_control4 Kcfis control4

_kcfis_control5 Kcfis control5

_kcfis_control6 Kcfis control6

_kcfis_disable_platform_decryption Don't use platform-specific decryption on the storage cell

_kcfis_dump_corrupt_block Dump any corrupt blocks found during smart IO

_kcfis_fast_response_enabled Enable smart scan optimization for fast response (first rows)

_kcfis_fast_response_initiosize Fast response - The size of the first IO in logical blocks

_kcfis_fast_response_iosizemult Fast response - (next IO size = current IO size * this parameter)

_kcfis_fast_response_threshold Fast response - the number of IOs after which smartIO is used

_kcfis_fault_control Fault Injection Control

_kcfis_io_prefetch_size Smart IO prefetch size for a cell

_kcfis_ioreqs_throttle_enabled Enable Smart IO requests throttling

_kcfis_kept_in_cellfc_enabled Enable usage of cellsrv flash cache for kept objects

_kcfis_large_payload_enabled enable large payload to be passed to cellsrv

_kcfis_max_cached_sessions Sets the maximum number of kcfis sessions cached

_kcfis_max_out_translations Sets the maximum number of outstanding translations in kcfis

_kcfis_nonkept_in_cellfc_enabled Enable use of cellsrv flash cache for non-kept objects

_kcfis_oss_io_size KCFIS OSS I/O size

_kcfis_qm_prioritize_sys_plan Prioritize Quaranitine Manager system plan

_kcfis_qm_user_plan_name Quaranitine Manager user plan name

_kcfis_rdbms_blockio_enabled Use block IO instead of smart IO in the smart IO module on RDBMS

_kcfis_read_buffer_limit KCFIS Read Buffer (per session) memory limit in bytes

_kcfis_spawn_debugger Decides whether to spawn the debugger at kcfis initialize

_kcfis_stats_level sets kcfis stats level

_kcfis_storageidx_diag_mode Debug mode for storage index on the cell

_kcfis_storageidx_disabled Don't use storage index optimization on the storage cell

_kcfis_test_control1 kcfis tst control1

_kcfis_trace_bucket_size KCFIS tracing bucket size in bytes

_kcl_commit if TRUE, call kjbcommit

_kcl_conservative_log_flush if TRUE, conservatively log flush before CR serving

_kcl_debug if TRUE, record le history

_kcl_index_split if TRUE, reject pings on blocks in middle of a split

_kd_symtab_chk enable or disable symbol table integrity block check

_kdbl_enable_post_allocation allocate dbas after populating data buffers

_kdi_avoid_block_checking avoid index block checking on sensitive opcodes

_kdic_segarr_sz size threshold for segmented arrays for seg_info_kdicctx

_kdis_reject_level b+tree level to enable rejection limit

_kdis_reject_limit #block rejections in space reclamation before segment extension

_kdis_reject_ops enable rejection heuristic for branch splits

_kdlf_read_flag kdlf read flag

_kdli_STOP_bsz undocumented parameter for internal use only

_kdli_STOP_dba undocumented parameter for internal use only

_kdli_STOP_fsz undocumented parameter for internal use only

_kdli_STOP_nio undocumented parameter for internal use only

_kdli_STOP_tsn undocumented parameter for internal use only

_kdli_allow_corrupt allow corrupt filesystem_logging data blocks during read/write

_kdli_buffer_inject use buffer injection for CACHE [NO]LOGGING lobs

_kdli_cache_inode cache inode state across calls

_kdli_cache_read_threshold minimum lob size for cache->nocache read (0 disables heuristic)

_kdli_cache_size maximum #entries in inode cache

_kdli_cache_verify verify cached inode via deserialization

_kdli_cache_write_threshold minimum lob size for cache->nocache write (0 disables heuristic)

_kdli_cacheable_length minimum lob length for inode cacheability

_kdli_checkpoint_flush do not invalidate cache buffers after write

_kdli_dbc override db_block_checking setting for securefiles

_kdli_delay_flushes delay flushing cache writes to direct-write lobs

_kdli_descn_adj coalesce extents with deallocation scn adjustment

_kdli_flush_cache_reads flush cache-reads data blocks after load

_kdli_flush_injections flush injected buffers of CACHE NOLOGGING lobs before commit

_kdli_force_cr force CR when reading data blocks of direct-write lobs

_kdli_force_cr_meta force CR when reading metadata blocks of direct-write lobs

_kdli_force_storage force storage settings for all lobs

_kdli_full_readahead_threshold maximum lob size for full readahead

_kdli_inject_assert inject asserts into the inode

_kdli_inject_batch buffer injection batch size [1, KCBNEWMAX]

_kdli_inject_crash inject crashes into the inode

_kdli_inline_xfm allow inline transformed lobs

_kdli_inode_preference inline inode evolution preference (data, headless, lhb)

_kdli_inplace_overwrite maximum inplace overwrite size (> chunksize)

_kdli_itree_entries #entries in lhb/itree blocks (for testing only)

_kdli_memory_protect trace accesses to inode memory outside kdli API functions

_kdli_mts_so use state objects in shared server for asyncIO pipelines

_kdli_oneblk allocate chunks as single blocks

_kdli_preallocation_mode preallocation mode for lob growth

_kdli_preallocation_pct percentage preallocation [0 .. inf) for lob growth

_kdli_ralc_length lob length threshold to trigger rounded allocations

_kdli_ralc_rounding rounding granularity for rounded allocations

_kdli_rci_lobmap_entries #entries in RCI lobmap before migration to lhb

_kdli_readahead_limit shared/cached IO readahead limit

_kdli_readahead_strategy shared/cached IO readahead strategy

_kdli_recent_scn use recent (not dependent) scns for block format/allocation

_kdli_reshape reshape an inode to inline or headless on length truncation

_kdli_safe_callbacks invoke inode read/write callbacks safely

_kdli_sio_async asynchronous shared IO

_kdli_sio_backoff use exponential backoff when attempting SIOP allocations

_kdli_sio_bps maximum blocks per IO slot

_kdli_sio_dop degree-of-parallelism in the SIO keep pool

_kdli_sio_fbwrite_pct percentage of buffer used for direct writes in flashback-db

_kdli_sio_fgio reap asynchronous IO in the foreground

_kdli_sio_fileopen shared IO fileopen mode: datasync vs nodatasync vs async

_kdli_sio_flush enable shared IO pool operations

_kdli_sio_free free IO buffers when not in active use

_kdli_sio_min_read shared IO pool read threshold

_kdli_sio_min_write shared IO pool write threshold

_kdli_sio_nbufs maximum #IO buffers to allocate per session

_kdli_sio_niods maximum #IO descriptors to allocate per session

_kdli_sio_on enable shared IO pool operations

_kdli_sio_pga use PGA allocations for direct IO

_kdli_sio_pga_top PGA allocations come from toplevel PGA heap

_kdli_sio_strategy shared IO strategy: block vs. extent

_kdli_sio_write_pct percentage of buffer used for direct writes

_kdli_small_cache_limit size limit of small inode cache

_kdli_sort_dbas sort dbas during chunkification

_kdli_space_cache_limit maximum size of the space cache in #blocks

_kdli_squeeze compact lobmap extents with contiguous dbas

_kdli_timer_dmp dump inode timers on session termination

_kdli_timer_trc trace inode timers to uts/tracefile

_kdli_trace inode trace level

_kdli_vll_direct use skip-navigation and direct-positioning in vll-domain

_kdlu_max_bucket_size UTS kdlu bucket size

_kdlu_max_bucket_size_mts UTS kdlu bucket size for mts

_kdlu_trace_layer UTS kdlu per-layer trace level

_kdlu_trace_system UTS system dump

_kdlw_enable_ksi_locking enable ksi locking for lobs

_kdlw_enable_write_gathering enable lob write gathering for sql txns

_kdlwp_flush_threshold WGC flush threshold in bytes

_kdlxp_cmp_subunit_size size of compression sub-unit in bytes

_kdlxp_dedup_flush_threshold deduplication flush threshold in bytes

_kdlxp_dedup_hash_algo secure hash algorithm for deduplication - only on SecureFiles

_kdlxp_dedup_inl_pctfree deduplication pct size increase by which inlining avoided

_kdlxp_dedup_prefix_threshold deduplication prefix hash threshold in bytes

_kdlxp_dedup_wapp_len deduplication length to allow write-append

_kdlxp_lobcmpadp enable adaptive compression - only on SecureFiles

_kdlxp_lobcmplevel Default securefile compression

_kdlxp_lobcmprciver Default securefile compression map version

_kdlxp_lobcompress enable lob compression - only on SecureFiles

_kdlxp_lobdeduplicate enable lob deduplication - only on SecureFiles

_kdlxp_lobdedupvalidate enable deduplicate validate - only on SecureFiles

_kdlxp_lobencrypt enable lob encryption - only on SecureFiles

_kdlxp_mincmp minimum comp ratio in pct - only on SecureFiles

_kdlxp_mincmplen minimum loblen to compress - only on SecureFiles

_kdlxp_minxfm_size minimum transformation size in bytes

_kdlxp_spare1 deduplication spare 1

_kdlxp_uncmp lob data uncompressed - only on SecureFiles

_kdlxp_xfmcache enable xfm cache - only on SecureFiles

_kdt_buffering control kdt buffering for conventional inserts

_kdtgsp_retries max number of retries in kdtgsp if space returns same block

_kdu_array_depth array update retry recursion depth limits

_kdz_hcc_flags Miscellaneous HCC flags

_kdz_hcc_track_upd_rids Enable rowid tracking during updates

_kdz_pred_nrows Number of rows to predicate at a time in kdzt

_kdz_proj_nrows Number of rows to project at a time in kdzt

_kebm_nstrikes kebm # strikes to auto suspend an action

_kebm_suspension_time kebm auto suspension time in seconds

_kecap_cache_size Workload Replay INTERNAL parameter used to set memory usage in Application Repl

                                        ay


_keep_remote_column_size remote column size does not get modified

_kernel_message_network_driver kernel message network driver

_kes_parse_model SQL Tune/SPA KES Layer Parse Model control parameter

_kffmap_hash_size size of kffmap_hash table

_kffmlk_hash_size size of kffmlk_hash table

_kffmop_chunks number of chunks of kffmop's

_kffmop_hash_size size of kffmop_hash table

_kfm_disable_set_fence disable set fence calls and revert to default (process fence)

_kghdsidx_count max kghdsidx count

_kgl_bucket_count Library cache hash table bucket count (2^_kgl_bucket_count * 256)

_kgl_cap_hd_alo_stacks capture stacks for library cache handle allocation

_kgl_cluster_lock Library cache support for cluster lock

_kgl_cluster_lock_read_mostly Library cache support for cluster lock read mostly optimization

_kgl_cluster_pin Library cache support for cluster pins

_kgl_debug Library cache debugging

_kgl_fixed_extents fixed extent size for library cache memory allocations

_kgl_hash_collision Library cache name hash collision possible

_kgl_heap_size extent size for library cache heap 0

_kgl_hot_object_copies Number of copies for the hot object

_kgl_kqr_cap_so_stacks capture stacks for library and row cache state objects

_kgl_large_heap_warning_threshold maximum heap size before KGL writes warnings to the alert log

_kgl_latch_count number of library cache latches

_kgl_message_locks RAC message lock count

_kgl_min_cached_so_count Minimum cached SO count. If > 1 can help find SO corruptions

_kgl_time_to_wait_for_locks time to wait for locks and pins before timing out

_kglsim_maxmem_percent max percentage of shared pool size to be used for KGL advice

_kgsb_threshold_size threshold size for base allocator

_kgx_latches # of mutex latches if CAS is not supported.

_kill_controlfile_enqueue_blocker enable killing controlfile enqueue blocker on timeout

_kill_diagnostics_timeout timeout delay in seconds before killing enqueue blocker

_kill_enqueue_blocker if greater than 0 enables killing enqueue blocker

_kill_java_threads_on_eoc Kill Java threads and do sessionspace migration at end of call

_kill_session_dump Process dump on kill session immediate

_kjac_force_outcome_current_session if TRUE, enable to run force outcome on the current session

_kjdd_call_stack_dump_enabled Enables printing of short call stack with the WFG

_kjdd_wfg_dump_cntrl To control the way Wait-For_Graph is dumped

_kjltmaxgt record latch requests that takes longer than this many us

_kjltmaxht record latch reqeust that are held longer than this many us

_kjlton track DLM latch usage on/off

_kkfi_trace trace expression substitution

_kks_free_cursor_stat_pct percentage of cursor stats buckets to scan on each load, in 1/10th of a percent

_kokli_cache_size Size limit of ADT Table Lookup Cache

_kokln_current_read Make all LOB reads for this session 'current' reads

_kolfuseslf allow kolf to use slffopen

_kqdsn_max_instance_bits maximum bits used for instance value in sequence partition

_kqdsn_min_instance_bits minimum bits used for instance value in sequence partition

_kqdsn_partition_ratio ratio of instance to session bits in sequence partition

_kql_subheap_trace tracing level for library cache subheap level pins

_kqr_optimistic_reads optimistic reading of row cache objects

_ksb_restart_clean_time process uptime for restarts

_ksb_restart_policy_times process restart policy times in seconds

_ksd_test_param KSD test parmeter

_ksdx_charset_ratio ratio between the system and oradebug character set

_ksdxdocmd_default_timeout_ms default timeout for internal oradebug commands

_ksdxdocmd_enabled if TRUE ksdxdocmd* invocations are enabled

_ksdxw_cini_flg ksdxw context initialization flag

_ksdxw_nbufs ksdxw number of buffers in buffered mode

_ksdxw_num_pgw number of watchpoints on a per-process basis

_ksdxw_num_sgw number of watchpoints to be shared by all processes

_ksdxw_stack_depth number of PCs to collect in the stack when watchpoint is hit

_kse_die_timeout amount of time a dying process is spared by PMON (in centi-secs)

_kse_pc_table_size kse pc table cache size

_kse_signature_entries number of entries in the kse stack signature cache

_kse_signature_limit number of stack frames to cache per kse signature

_kse_snap_ring_record_stack should error snap ring entries show a short stack trace

_kse_snap_ring_size ring buffer to debug internal error 17090

_kse_trace_int_msg_clear enables soft assert of KGECLEAERERROR is cleares an interrupt message

_ksfd_verify_write verify asynchronous writes issued through ksfd

_ksi_clientlocks_enabled if TRUE, DLM-clients can provide the lock memory

_ksi_trace KSI trace string of lock type(s)

_ksi_trace_bucket memory tracing: use ksi-private or rdbms-shared bucket

_ksi_trace_bucket_size size of the KSI trace bucket

_ksipc_libipc_path over-ride default location of libipc

_ksipc_mode ksipc mode

_ksipc_spare_param1 ksipc spare param 1

_ksipc_spare_param2 ksipc spare param 2

_ksipc_wait_flags tune ksipcwait

_ksm_post_sga_init_notif_delay_secs seconds to delay instance startup at sga initialization (post)

_ksm_pre_sga_init_notif_delay_secs seconds to delay instance startup at sga initialization (pre)

_ksmb_debug ksmb debug flags

_ksmd_protect_mode KSMD protect mode for catching stale access

_ksmg_granule_locking_status granule locking status

_ksmg_granule_size granule size in bytes

_ksmg_lock_check_interval timeout action interval in minutes

_ksmg_lock_reacquire_count repeat count for acquisition of locks

_ksmlsaf KSM log alloc and free

_kspol_tac_timeout timeouts for TAC registerd by kspol

_ksr_unit_test_processes number of ksr unit test processes

_kss_callstack_type state object callstack trace type

_kss_quiet if TRUE access violations during kss dumps are not recorded

_ksu_diag_kill_time number of seconds ksuitm waits before killing diag

_ksuitm_addon_trccmd command to execute when dead processes don't go away

_ksuitm_dont_kill_dumper delay inst. termination to allow processes to dump

_ksv_dynamic_flags1 ksv dynamic flags 1 - override default behavior

_ksv_max_spawn_fail_limit bg slave spawn failure limit

_ksv_pool_hang_kill_to bg slave pool terminate timeout

_ksv_pool_wait_timeout bg slave pool wait limit

_ksv_slave_exit_timeout slave exit timeout

_ksv_spawn_control_all control all spawning of background slaves

_ksv_static_flags1 ksv static flags 1 - override default behavior

_ksvppktmode ksv internal pkt test

_ksxp_compat_flags ksxp compat flags

_ksxp_control_flags modify ksxp behavior

_ksxp_diagmode set to OFF to disable automatic slowsend diagnostics

_ksxp_disable_clss disable CLSS interconnects

_ksxp_disable_dynamic_loading disable dynamic loadin of lib skgxp

_ksxp_disable_ipc_stats disable ipc statistics

_ksxp_disable_rolling_migration disable possibility of starting rolling migration

_ksxp_dump_timeout set timeout for kjzddmp request

_ksxp_dynamic_skgxp_param dynamic skgxp parameters

_ksxp_if_config ksxp if config flags

_ksxp_init_stats_bkts initial number arrays for ipc statistics

_ksxp_lwipc_enabled enable lwipc for KSXP

_ksxp_max_stats_bkts max. arrays for ipc statistics

_ksxp_ping_enable disable dynamic loadin of lib skgxp

_ksxp_ping_polling_time max. arrays for ipc statistics

_ksxp_reaping tune ksxp layer reaping limit

_ksxp_reporting_process reporting process for KSXP

_ksxp_send_timeout set timeout for sends queued with the inter-instance IPC

_ksxp_skgxp_ant_options SKGXP ANT options

_ksxp_skgxp_compat_library_path over-ride default location of lib skgxp compat

_ksxp_skgxp_ctx_flags1 IPC debug options flags (RAC)

_ksxp_skgxp_ctx_flags1mask IPC debug options flags mask (RAC)

_ksxp_skgxp_dynamic_protocol IPC protocol override (RAC) (0/-1=*,2=UDP,3=RDS,!0x1000=ipc_X)

_ksxp_skgxp_inets limit SKGXP networks

_ksxp_skgxp_library_path over-ride default location of lib skgxp

_ksxp_skgxp_rgn_ports region socket limits (0xFFFFNNXX): F=flags, N=min, X=max

_ksxp_skgxp_spare_param1 ipc ksxp spare parameter 1

_ksxp_skgxp_spare_param2 ipc ksxp spare parameter 2

_ksxp_skgxp_spare_param3 ipc ksxp spare parameter 3

_ksxp_skgxp_spare_param4 ipc ksxp spare parameter 4

_ksxp_skgxp_spare_param5 ipc ksxp spare parameter 5

_ksxp_skgxpg_last_parameter last defined skgxpg parameter - ksxp

_ksxp_stats_mem_lmt limit ipc statistics memory. this parameter is a percentage value

_ksxp_testing KSXP test parameter

_ksxp_unit_test_byte_transformation enable byte transformation unit test

_ksxp_wait_flags tune ksxpwait

_ktb_debug_flags ktb-layer debug flags

_ktc_debug for ktc debug

_ktc_latches number of ktc latches

_ktilmsc_exp expiration time of ktilm segment cache (in second)

_ktslj_segext_max_mb segment pre-extension max size in MB (0: unlimited)

_ktslj_segext_retry segment pre-extension retry

_ktslj_segext_warning segment pre-extension warning threshold in percentage

_ktslj_segext_warning_mb segment pre-extension warning threshold in MB

_ktspsrch_maxsc maximum segments supported by space search cache

_ktspsrch_maxskip space search cache rejection skip upper limit

_ktspsrch_scchk cleanout check time of space search cache

_ktspsrch_scexp expiration time of space search cache

_ktst_rss_max maximum temp extents to be released across instance

_ktst_rss_min minimum temp extents to be released across instance

_ktst_rss_retry maximum retries of sort segment release

_kttext_warning tablespace pre-extension warning threshold in percentage

_ktu_latches number of KTU latches

_ku_trace datapump trace parameter

_kxdbio_ctx_init_count initial count of KXDBIO state object

_kxdbio_disable_offload_opcode KXDBIO Disable offload for the set opcodes. Value is a Bitmap of 0x00000001

                                        - disable cell to cell data copy offload    0x00000002 - disable disk scrubbing
                                        offload to cell


_kxdbio_enable_ds_opcode KXDBIO Enable Dumb storage simulation for the set opcodes.

_kxdbio_ut_ctl kxdbio unit test controls

_large_pool_min_alloc minimum allocation size in bytes for the large allocation pool

_last_allocation_period period over which an instance can retain an active level1 bitmap

_latch_class_0 latch class 0

_latch_class_1 latch class 1

_latch_class_2 latch class 2

_latch_class_3 latch class 3

_latch_class_4 latch class 4

_latch_class_5 latch class 5

_latch_class_6 latch class 6

_latch_class_7 latch class 7

_latch_classes latch classes override

_latch_miss_stat_sid Sid of process for which to collect latch stats

_latch_wait_list_pri_sleep_secs Time to sleep on latch wait list until getting priority

_ldr_io_size size of write IOs used during a load operation

_ldr_io_size2 size of write IOs used during a load operation of EHCC with HWMB

_ldr_pga_lim pga limit, beyond which new partition loads are delayed

_ldr_tempseg_threshold amount to buffer prior to allocating temp segment (extent sizing)

_left_nested_loops_random enable random distribution method for left of nestedloops

_lgwr_delay_write LGWR write delay for debugging

_lgwr_io_outlier LGWR I/O outlier frequency

_lgwr_io_slaves LGWR I/O slaves

_lgwr_max_ns_wt Maximum wait time for lgwr to allow NetServer to progress

_lgwr_ns_nl_max Variable to simulate network latency or buffer threshold

_lgwr_ns_nl_min Variable to simulate network latency or buffer threshold

_lgwr_ns_sim_err Variable to simulate errors lgwrns

_lgwr_posts_for_pending_bcasts LGWR posts commit waiters for pending broadcasts

_lgwr_ta_sim_err Variable to simulate errors lgwr true async

_library_cache_advice whether KGL advice should be turned on

_lightweight_hdrs Lightweight headers for redo

_like_with_bind_as_equality treat LIKE predicate with bind as an equality predicate

_limit_itls limit the number of ITLs in OLTP Compressed Tables

_linux_prepage_large_pages prepage large pages during allocation on Linux

_lm_activate_lms_threshold threshold value to activate an additional lms

_lm_asm_enq_hashing if TRUE makes ASM use enqueue master hashing for fusion locks

_lm_batch_compression_threshold GES threshold to start compression on batch messages

_lm_better_ddvictim GES better deadlock victim

_lm_big_cluster_optimizations enable certain big cluster optimizations in drm

_lm_broadcast_res Enable broadcast of highest held mode of resource.

_lm_broadcast_resname Trace string of resource type(s)

_lm_cache_allocated_res_ratio ratio of cached over allocated resources

_lm_cache_lvl0_cleanup how often to cleanup level 0 cache res (in sec)

_lm_cache_res_cleanup percentage of cached resources should be cleanup

_lm_cache_res_cleanup_tries max number of batches of cached resources to free per cleanup

_lm_cache_res_options ges resource cache options

_lm_cache_res_skip_cleanup multiple of iniital res cache below which cleanup is skipped

_lm_cache_res_type cache resource: string of lock types(s)

_lm_checksum_batch_msg GES checksum batch messages

_lm_comm_channel GES communication channel type

_lm_comm_msgq_busywait busy wait time in microsecond for msgq

_lm_comm_reap_count message reap count for receive

_lm_comm_tkts_add_factor Ticket allocation addition factor

_lm_comm_tkts_calc_period_length Weighted average calculation interval length (second)

_lm_comm_tkts_max_periods Max number of periods used in weighted avearage calculation

_lm_comm_tkts_min_decrease_wait Time to wait before allowing an allocation decrease

_lm_comm_tkts_min_increase_wait Time to wait before allowing an allocation increase

_lm_comm_tkts_mult_factor Ticket allocation multiplication factor

_lm_comm_tkts_nullreq_threshold Null request frequency threshold (percentage)

_lm_compression_scheme GES compression scheme

_lm_contiguous_res_count number of contiguous blocks that will hash to the same HV bucket

_lm_dd_ignore_nodd if TRUE nodeadlockwait/nodeadlockblock options are ignored

_lm_dd_interval dd time interval in seconds

_lm_dd_max_search_time max dd search time per token

_lm_dd_maxdump max number of locks to be dumped during dd validation

_lm_dd_scan_interval dd scan interval in seconds

_lm_dd_search_cnt number of dd search per token get

_lm_deferred_msg_timeout deferred message timeout

_lm_drm_batch_time time in seconds to wait to batch drm requests

_lm_drm_disable disable drm in different level

_lm_drm_hiload_percentage drm high load threshold percentage

_lm_drm_lowload_percentage drm low load threshold percentage

_lm_drm_max_requests dynamic remastering maximum affinity requests processed together

_lm_drm_min_interval minimum interval in secs between two consecutive drms

_lm_drm_object_scan enable/disable object scan to force full table scan always

_lm_drm_window dynamic remastering bucket window size

_lm_drm_xlatch dynamic remastering forced exclusive latches

_lm_drmopt12 enable drm scan optimizations in 12

_lm_drmopt12_nolatch enable drm latching optimizations in 12

_lm_dump_null_lock dump null lock in state dump

_lm_dynamic_lms dynamic lms invocation

_lm_dynamic_load dynamic load adjustment

_lm_enable_aff_benefit_stats enables affinity benefit computations if TRUE

_lm_enq_lock_freelist Number of ges enqueue element freelist

_lm_enq_rcfg if TRUE enables enqueue reconfiguration

_lm_enqueue_blocker_dump_timeout enqueue blocker dump timeout

_lm_enqueue_blocker_dump_timeout_cnt enqueue blocker dump timeout count

_lm_enqueue_blocker_kill_timeout enqueue blocker kill timeout

_lm_enqueue_freelist Number of enqueue freelist

_lm_enqueue_timeout enqueue suggested min timeout in seconds

_lm_fdrm_stats gather full drm statistics

_lm_file_affinity mapping between file id and master instance number

_lm_file_read_mostly mapping between read-mostly file id and master instance number

_lm_free_queue_threshold GES free queue threshold

_lm_freeze_kill_time timeout for killing unfrozen processes in rcfg/drm freeze step

_lm_global_posts if TRUE deliver global posts to remote nodes

_lm_hashtable_bkt_high High element threshold in hash table bucket

_lm_hashtable_bkt_low Low element threshold in hash table bucket

_lm_hashtable_bkt_thr Threshold for hash table resizing

_lm_hb_acceptable_hang_condition list of acceptable hang conditions in heartbeat check

_lm_hb_callstack_collect_time hb diagnostic call stack collection time in seconds

_lm_hb_disable_check_list list of process names to be disabled in heartbeat check

_lm_hb_enable_acl_check to enable the wait analysis with acceptable condition lists

_lm_hb_exponential_hang_time_factor heartbeat exponential hang time multiplier

_lm_hb_maximum_hang_report_count maximum heartbeat hang report count

_lm_high_load_sysload_percentage high watermark system load percentage

_lm_high_load_threshold high load threshold parameter

_lm_idle_connection_check GES idle connection check

_lm_idle_connection_check_interval GES idle connection check interval time

_lm_idle_connection_instance_check_callo GES idle connection instance check callout

ut


_lm_idle_connection_kill GES idle connection kill

_lm_idle_connection_kill_max_skips GES idle connection max skip kill request

_lm_idle_connection_max_ignore_kill_coun GES maximum idle connection kill request ignore count

t


_lm_idle_connection_quorum_threshold GES idle connection health quorum threshold

_lm_kill_fg_on_timeout GES kill fg on IPC timeout

_lm_lhupd_interval load and health update interval

_lm_lmd_waittime default wait time for lmd in centiseconds

_lm_lmon_nowait_latch if TRUE makes lmon get nowait latches with timeout loop

_lm_lms number of background gcs server processes to start

_lm_lms_opt_priority enable freeslot lms priority optimization

_lm_lms_priority_check_frequency frequency of LMS priority decisions in milliseconds

_lm_lms_priority_dynamic enable lms priority modification

_lm_lms_rt_threshold maximum number of real time lms processes on machine

_lm_lms_spin make lms not sleep

_lm_lms_waittime default wait time for lms in centiseconds

_lm_local_hp_enq use static file affinity for HP enqueue mastership

_lm_locks number of enqueues configured for cluster database

_lm_low_load_percentage low watermark percentage for load threshold

_lm_master_weight master resource weight for this instance

_lm_max_lms max. number of background global cache server processes

_lm_msg_batch_size GES batch message size

_lm_msg_cleanup_interval GES message buffer cleanup interval time

_lm_no_lh_check skip load and health check at decision points

_lm_no_sync skip reconfiguration/drm syncr/synca messaging

_lm_node_join_opt cluster database node join optimization in reconfig

_lm_non_fault_tolerant disable cluster database fault-tolerance mode

_lm_num_bnft_stats_buckets number of buckets in the benefit stats hash table

_lm_num_pt_buckets number of buckets in the object affinity hash table

_lm_num_pt_latches number of latches in the object affinity hash table

_lm_postevent_buffer_size postevent buffer size

_lm_preregister_css_restype enqueue type that requires pre-registration to css

_lm_proc_freeze_timeout reconfiguration: process freeze timeout

_lm_process_batching GES implicit process batching for IPC messages

_lm_process_lock_q_scan_limit limit on scanning process lock queue instead of resource convert lock queue

_lm_procs number of client processes configured for cluster database

_lm_psrcfg enable pseudo reconfiguration

_lm_rac_spare_dp1 rac parameter dp1

_lm_rac_spare_dp10 rac parameter dp10

_lm_rac_spare_dp2 rac parameter dp2

_lm_rac_spare_dp3 rac parameter dp3

_lm_rac_spare_dp4 rac parameter dp4

_lm_rac_spare_dp5 rac parameter dp5

_lm_rac_spare_dp6 rac parameter dp6

_lm_rac_spare_dp7 rac parameter dp7

_lm_rac_spare_dp8 rac parameter dp8

_lm_rac_spare_dp9 rac parameter dp9

_lm_rac_spare_p1 rac parameter p1

_lm_rac_spare_p10 rac parameter p10

_lm_rac_spare_p2 rac parameter p2

_lm_rac_spare_p3 rac parameter p3

_lm_rac_spare_p4 rac parameter p4

_lm_rac_spare_p5 rac parameter p5

_lm_rac_spare_p6 rac parameter p6

_lm_rac_spare_p7 rac parameter p7

_lm_rac_spare_p8 rac parameter p8

_lm_rac_spare_p9 rac parameter p9

_lm_rcfg_timeout dlm reconfiguration timeout

_lm_rcvinst designated instance to do instance recovery

_lm_rcvr_hang_allow_time receiver hang allow time in seconds

_lm_rcvr_hang_cfio_kill to kill receiver hang at control file IO

_lm_rcvr_hang_check_frequency receiver hang check frequency in seconds

_lm_rcvr_hang_check_system_load examine system load when check receiver health

_lm_rcvr_hang_kill to kill receiver hang

_lm_rcvr_hang_systemstate_dump_level systemstate dump level upon receiver hang

_lm_res_hash_bucket number of resource hash buckets

_lm_res_part number of resource partition configured for gcs

_lm_res_tm_hash_bucket number of extra TM resource hash buckets

_lm_resend_open_convert_timeout timeout in secs before resubmitting the open-convert

_lm_ress number of resources configured for cluster database

_lm_rm_slaves if non zero, it enables remastering slaves

_lm_send_mode GES send mode

_lm_send_queue_batching GES send queue message batching

_lm_send_queue_length GES send queue maximum length

_lm_sendproxy_reserve GES percentage of send proxy reserve of send tickets

_lm_share_lock_opt if TRUE enables share lock optimization

_lm_single_inst_affinity_lock enable single instance affinity lock optimization

_lm_spare_threads number of spare threads to be created by the GPnP master

_lm_spare_undo number of spare undo tablespaces to be created by GPnP master

_lm_sq_batch_factor GES send queue minimum batching factor

_lm_sq_batch_type GES send queue batching mechanism

_lm_sq_batch_waittick GES send queue batching waittime in tick

_lm_sync_timeout Synchronization timeout for DLM reconfiguration steps

_lm_ticket_active_sendback Flow control ticket active sendback threshold

_lm_tickets GES messaging tickets

_lm_tx_delta TX lock localization delta

_lm_use_gcr use GCR module if TRUE

_lm_use_new_defmsgtmo_action use new defered msg queue timeout action

_lm_use_tx_tsn use undo tsn affinity master as TX enqueue master

_lm_validate_pbatch GES process batch validation

_lm_wait_pending_send_queue GES wait on pending send queue

_lm_watchpoint_maximum GES number of watchpoints

_lm_watchpoint_timeout GES maximum time in seconds to keep watchpoint

_lm_xids number of transaction IDs configured for cluster database

_lmn_compression suppl logging for compression enabled

_load_without_compile Load PL/SQL or Database objects without compilation

_local_arc_assert_on_wait Assert whenever local ORL arch waits for space

_local_communication_costing_enabled enable local communication costing when TRUE

_local_communication_ratio set the ratio between global and local communication (0..100)

_local_hang_analysis_interval_secs the interval at which local hang analysis is run

_lock_ref_constraint_count number of nowait attempts to lock referential constraint

_lock_sga_areas Lock specified areas of the SGA in physical memory

_log_archive_avoid_memcpy log archive avoid memcpy

_log_archive_buffers Number of buffers to allocate for archiving

_log_archive_callout archival callout

_log_archive_network_redo_size Log archive network redo buffer size used by ARCH

_log_archive_prot_auto_demote log archive protection auto demotion

_log_archive_strong_auth log archive security strong auth

_log_archive_trace_pids log archive trace pids parameter

_log_blocks_during_backup log block images when changed during backup

_log_buffer_coalesce Coalescing log buffers for log writes

_log_buffers_corrupt corrupt redo buffers before write

_log_buffers_debug debug redo buffers (slows things down)

_log_checkpoint_recovery_check # redo blocks to verify after checkpoint

_log_committime_block_cleanout Log commit-time block cleanout

_log_deletion_policy archivelog deletion policy for mandatory/all destination

_log_event_queues number of the log writer event queues

_log_file_sync_timeout Log file sync timeout (centiseconds)

_log_max_optimize_threads maximum number of threads to which log scan optimization is applied

_log_parallelism_dynamic Enable dynamic strands

_log_parallelism_max Maximum number of log buffer strands

_log_private_mul Private strand multiplier for log space preallocation

_log_private_parallelism_mul Active sessions multiplier to deduce number of private strands

_log_read_buffer_size buffer size for reading log files

_log_read_buffers Number of log read buffers for media recovery

_log_simultaneous_copies number of simultaneous copies into redo buffer(# of copy latches)

_log_space_errors should we report space errors to alert log

_log_switch_timeout Maximum number of seconds redos in the current log could span

_log_undo_df_info generate marker to log file# that belong to undo tablespace

_log_write_info_size Size of log write info array

_log_writer_worker_dlm_hearbeat_update_f LGWR worker DLM health-monitoring heartbeat update frequency (ms)

req


_logout_storm_rate number of processes that can logout in a second

_logout_storm_retrycnt maximum retry count for logouts

_logout_storm_timeout timeout in centi-seconds for time to wait between retries

_long_bcast_ack_warning_threshold threshold for long bcast ack warning messages in ms

_long_log_write_warning_threshold threshold for long log write warning messages in ms

_longops_enabled longops stats enabled

_low_server_threshold low server thresholds

_lowres_drift_allowed_sec allowed lowres timer drift for VKTM

_ltc_trace tracing level for load table conventional

_lthread_cleanup_intv_secs interval for cleaning lightweight threads in secs

_lthread_clnup_hk_wait_secs timeout after hard killing operation for lthread to exit

_lthread_clnup_pmon_softkill_wait_secs wait timeout for PMON between soft kill and hard kill of lthreads

_lthread_clnup_spawner_sk_wait_secs timeout for spawner between soft kill and hard kill of lthreads

_lthread_debug Enable Debugging mode for lightweight threads

_lthread_enabled Enable lightweight threads

_lthread_max_spawn_time_csecs maximum time interval a spawner will wait for a lthread to get ready

_lthread_spawn_check_intv_ms time interval for a spawner to check for spawnee to get ready

_lthread_step_debugging Enable Step wise Debugging mode for lightweight threads

_main_dead_process_scan_interval PMON main dead process scan interval (in seconds)

_master_direct_sends direct sends for messages from master (DFS)

_mav_refresh_consistent_read refresh materialized views using consistent read snapshot

_mav_refresh_double_count_prevented materialized view MAV refreshes avoid double counting

_mav_refresh_opt optimizations during refresh of materialized views

_mav_refresh_unionall_tables # tables for union all expansion during materialized view refresh

_max_aq_persistent_queue_memory max aq persistent queue memory

_max_async_wait_for_catch_up Switchover wait time for async LNS to catch up in seconds

_max_clients_per_emon maximum number of clients per emon

_max_cr_rollbacks Maximum number of CR rollbacks per block (LMS)

_max_data_transfer_cache_size Maximum size of data transfer cache

_max_defer_gran_xfer_atonce Maximum deferred granules transferred by MMAN atonce

_max_exponential_sleep max sleep during exponential backoff

_max_filestat_tries maximum number of file stat tries

_max_fsu_segments Maximum segments to track for fast space usage

_max_fsu_stale_time Allowed space usage staleness in seconds

_max_incident_file_size Maximum size (in KB, MB, GB, Blocks) of incident dump file

_max_io_size Maximum I/O size in bytes for sequential file accesses

_max_kcnibr_ranges Max number of nonlogged data block ranges

_max_large_io IORM:max number of large I/O's to issue

_max_largepage_alloc_time_secs Maximum number of seconds to spend on largepage allocation

_max_lns_shutdown_archival_time Maximum time spent by LNS to archive last log during shutdown

_max_log_write_io_parallelism Maximum I/O parallelism within a log write (auto=0)

_max_log_write_parallelism Maximum parallelism within a log write (auto=0)

_max_outstanding_log_writes Maximum number of outstanding redo log writes

_max_pending_scn_bcasts maximum number of pending SCN broadcasts

_max_protocol_support Max occurrence protocols supported in a process

_max_queued_report_requests Maximum number of report requests that can be queued in a list

_max_reasonable_scn_rate Max reasonable SCN rate

_max_report_flushes_percycle Max no of report requests that can be flushed per cycle

_max_rwgs_groupings maximum no of groupings on materialized views

_max_services maximum number of database services

_max_shrink_obj_stats number of segments for which shrink stats will be maintained

_max_sleep_holding_latch max time to sleep while holding a latch

_max_small_io IORM:max number of small I/O's to issue

_max_spacebg_msgs_percentage maximum space management interrupt message throttling

_max_spacebg_slaves maximum space management background slaves

_max_spacebg_tasks maximum space management background tasks

_max_string_size_bypass controls error checking for the max_string_size parameter

_max_sys_next_extent Dictionary managed SYSTEM tablespace maximum next extent size in MB (allowed ran

                                        ge [16-4095], 0 if unlimited)


_media_recovery_read_batch media recovery block read batch

_mem_annotation_pr_lev private memory annotation collection level

_mem_annotation_scale memory annotation pre-allocation scaling

_mem_annotation_sh_lev shared memory annotation collection level

_mem_annotation_store memory annotation in-memory store

_mem_std_extent_size standard extent size for fixed-size-extent heaps

_memory_broker_log_stat_entries memory broker num stat entries

_memory_broker_marginal_utility_bc Marginal Utility threshold pct for bc

_memory_broker_marginal_utility_sp Marginal Utility threshold pct for sp

_memory_broker_shrink_heaps memory broker allow policy to shrink shared pool

_memory_broker_shrink_java_heaps memory broker allow policy to shrink java pool

_memory_broker_shrink_streams_pool memory broker allow policy to shrink streams pool

_memory_broker_shrink_timeout memory broker policy to timeout shrink shared/java pool

_memory_broker_stat_interval memory broker statistics gathering interval for auto sga

_memory_checkinuse_timeintv check inuse time interval

_memory_imm_mode_without_autosga Allow immediate mode without sga/memory target

_memory_initial_sga_split_perc Initial default sga target percentage with memory target

_memory_management_tracing trace memory management activity

_memory_max_tgt_inc_cnt counts the times checker increments memory target

_memory_mgmt_fail_immreq always fail immediate mode request

_memory_mgmt_immreq_timeout time in seconds to time out immediate mode request

_memory_nocancel_defsgareq do not cancel deferred sga reqs with auto-memory

_memory_sanity_check partial granule sanity check

_messages message queue resources - dependent on # processes & # buffers

_mgd_rcv_handle_orphan_datafiles Managed recovery handle orphan datafile situation

_midtier_affinity_cluswait_prc_threshold cluster wait precentage threshold to enter affinity

_midtier_affinity_goodness_threshold goodness gradient threshold to dissolve affinity

_min_time_between_psp0_diag_secs minimum time between PSP0 diagnostic used for flow control

_minfree_plus max percentage of block space + minfree before we mark block full

_minimal_stats_aggregation prohibit stats aggregation at compile/partition maintenance time

_minimum_blocks_to_shrink minimum number freeable blocks for shrink to be present

_minimum_db_flashback_retention Minimum flashback retention

_minimum_extents_to_shrink minimum number freeable extents for shrink to be present

_mirror_redo_buffers Save buffers for debugging redo corruptions

_mmv_query_rewrite_enabled allow rewrites with multiple MVs and/or base tables

_modify_column_index_unusable allow ALTER TABLE MODIFY(column) to violate index key length limit

_module_action_old_length Use module and action old length parameter

_mpmt_enabled MPMT mode enabled

_mpmt_enabled_backgrounds mpmt enabled backgrounds

_mpmt_fg_enabled MPMT mode foreground enabled

_mpmt_procs_per_osp max procs per osp

_multi_instance_pmr force multi instance parallel recovery

_multi_join_key_table_lookup TRUE iff multi-join-key table lookup prefetch is enabled

_multi_transaction_optimization_enabled reduce SGA memory use during create of a partitioned table

_multiple_instance_recovery use multiple instances for media recovery

_mutex_spin_count Mutex spin count

_mutex_wait_scheme Mutex wait scheme

_mutex_wait_time Mutex wait time

_mv_add_log_placeholder add log placeholder

_mv_cleanup_orphaned_metadata cleanup orphaned materialized view metadata

_mv_complete_refresh_conventional use conventional INSERTs for MV complete refresh

_mv_deferred_no_log_age_val avoid build deferred MV log age validate

_mv_expression_extend_size MV expression extend size

_mv_generalized_oj_refresh_opt enable/disable new algorithm for MJV with generalized outer joins

_mv_refresh_ana what percent to analyze after complete/PCT refresh

_mv_refresh_costing refresh decision based on cost or on rules

_mv_refresh_delta_fraction delta mv as fractional percentage of size of mv

_mv_refresh_enhanced_dml_detection enable enhanced detection of DML types from MV log

_mv_refresh_eut refresh materialized views using EUT(partition)-based algorithm

_mv_refresh_force_parallel_query force materialized view refreshes to use parallel query

_mv_refresh_insert_no_append materialized view refresh using insert no append

_mv_refresh_new_setup_disabled materialized view MV refresh new setup disabling

_mv_refresh_no_idx_rebuild avoid index rebuild as part of the MV refresh

_mv_refresh_pkfk_data_units_opt control MV refresh based on the assumption of PK-FK data units

_mv_refresh_pkfk_relationship_opt control MV refresh based on the use of PK-FK relationships

_mv_refresh_rebuild_percentage minimum percentage change required in MV to force an indexrebuild

_mv_refresh_selections create materialized views with selections and fast refresh

_mv_refresh_update_analysis materialized view refresh using update analysis

_mv_refresh_use_hash_sj use hash_sj hint in queries

_mv_refresh_use_no_merge use no_merge hint in queries

_mv_refresh_use_stats pass cardinality hints to refresh queries

_mv_refsched_timeincr proportionality constant for dop vs. time in MV refresh

_mv_rolling_inv create/alter mv uses rolling cursor invalidation instead of immediate

_mwin_schedule Enable/disable Maintenance Window Schedules

_nameservice_consistency_check NameService Consistency check switch

_nchar_imp_cnv NLS allow Implicit Conversion between CHAR and NCHAR

_nchar_imp_conv should implicit conversion bewteen clob and nclob be allowed

_ncmb_readahead_enabled enable multi-block readahead for an index scan

_ncmb_readahead_tracing turn on multi-block readahead tracing

_ncomp_shared_objects_dir native compilation shared objects dir

_nested_loop_fudge nested loop fudge

_nested_mv_fast_oncommit_enabled nested MV refresh fast on commit allowed

_net_timeout_latency NET_TIMEOUT latency

_new_initial_join_orders enable initial join orders based on new ordering heuristics

_new_sort_cost_estimate enables the use of new cost estimate for sort

_newsort_enabled controls whether new sorts can be used as system sort

_newsort_ordered_pct controls when new sort avoids sorting ordered input

_newsort_type specifies options for the new sort algorithm

_nineteenth_spare_parameter nineteenth spare parameter - string

_ninth_spare_parameter ninth spare parameter - integer

_nlj_batching_ae_flag FAE flag type set after restoring to IO batching buffer

_nlj_batching_enabled enable batching of the RHS IO in NLJ

_nlj_batching_misses_enabled enable exceptions for buffer cache misses

_nls_parameter_sync_enabled enables or disables updates to v$parameter whenever an alter session statement m

                                        odifies various nls parameters


_no_objects no object features are used

_no_or_expansion OR expansion during optimization disabled

_no_recovery_through_resetlogs no recovery through this resetlogs operation

_no_small_file Not to apply new extent scheme for small file temp spaces

_no_stale_joinback_rewrite No joinbacks if mv is stale

_nologging_kcnbuf_hash_buckets Number of nologging buffer hash buckets

_nologging_kcnbuf_hash_latches Number of nologging buffer hash latches

_nologging_load_slotsz Nologging standby: direct load buffer size

_nologging_sdcl_append_wait Nologging standby append sdcl wait time

_nologging_sendbuf_ratio Nologging standby: outstanding send buffer ratio

_nologging_txn_cmt_wait Nologging standby transaction commit wait time

_noncdb_to_pdb converting a non-cdb to a pdb

_noseg_for_unusable_index_enabled no segments for unusable indexes if set to TRUE

_notify_crs notify cluster ready services of startup and shutdown

_ns_max_flush_wt Flush wait time for NetServer to flush oustanding writes

_ns_max_send_delay Data Loss Time Bound for NetServer

_num_longop_child_latches number of child latches for long op array

_numa_buffer_cache_stats Configure NUMA buffer cache stats

_numa_shift_enabled Enable NUMA shift

_numa_shift_value user defined value for numa nodes shift

_numa_trace_level numa trace event

_number_cached_attributes maximum number of cached attributes per instance

_number_cached_group_memberships maximum number of cached group memberships

_obj_ckpt_tracing Enable object checkpoint tracing

_object_number_cache_size Object number cache size

_object_reuse_bast if 1 or higher, handle object reuse

_object_statistics enable the object level statistics collection

_object_stats_max_entries Maximum number of entries to be tracked per stat

_odci_aggregate_save_space trade speed for space in user-defined aggregation

_offline_rollback_segments offline undo segment list

_ogms_home GMS home directory

_olap_adv_comp_stats_cc_precomp do additional predicate stats analysis for AW rowsource

_olap_adv_comp_stats_max_rows do additional predicate stats analysis for AW rowsource

_olap_aggregate_buffer_size OLAP Aggregate max buffer size

_olap_aggregate_flags OLAP Aggregate debug flags

_olap_aggregate_function_cache_enabled OLAP Aggregate function cache enabler

_olap_aggregate_max_thread_tuples OLAP Aggregate max thread tuples creation

_olap_aggregate_min_buffer_size OLAP Aggregate min buffer size

_olap_aggregate_min_thread_status OLAP Aggregate minimum cardinality of dimensions for thread

_olap_aggregate_multipath_hier OLAP Aggregate Multi-path Hierarhies enabled

_olap_aggregate_statlen_thresh OLAP Aggregate status array usage threshold

_olap_aggregate_work_per_thread OLAP Aggregate max work parents

_olap_aggregate_worklist_max OLAP Aggregate max worklists generated at once

_olap_allocate_errorlog_format OLAP Allocate Errorlog Format

_olap_allocate_errorlog_header OLAP Allocate Errorlog Header format

_olap_analyze_max OLAP DML ANALYZE command max cells to analyze

_olap_continuous_trace_file OLAP logging definition

_olap_dbgoutfile_echo_to_eventlog OLAP DbgOutfile copy output to event log (tracefile)

_olap_dimension_corehash_force OLAP Dimension In-Core Hash Table Force

_olap_dimension_corehash_large OLAP Dimension In-Core Hash Table Large Threshold

_olap_dimension_corehash_pressure OLAP Dimension In-Core Hash Table Pressure Threshold

_olap_dimension_corehash_size OLAP Dimension In-Core Hash Table Maximum Memory Use

_olap_eif_export_lob_size OLAP EIF Export BLOB size

_olap_lmgen_dim_size Limitmap generator dimension column size

_olap_lmgen_meas_size Limitmap generator measure column size

_olap_object_hash_class OLAP Object Hash Table Class

_olap_page_pool_expand_rate OLAP Page Pool Expand Rate

_olap_page_pool_hi OLAP Page Pool High Watermark

_olap_page_pool_hit_target OLAP Page Pool Hit Target

_olap_page_pool_low OLAP Page Pool Low Watermark

_olap_page_pool_pressure OLAP Page Pool Pressure Threshold

_olap_page_pool_shrink_rate OLAP Page Pool Shrink Rate

_olap_parallel_update_server_num OLAP parallel update server count

_olap_parallel_update_small_threshold OLAP parallel update threshold for number of small pagespaces

_olap_parallel_update_threshold OLAP parallel update threshold in pages

_olap_row_load_time_precision OLAP Row Load Time Precision

_olap_sesscache_enabled OLAP Session Cache knob

_olap_sort_buffer_pct OLAP Sort Buffer Size Percentage

_olap_sort_buffer_size OLAP Sort Buffer Size

_olap_statbool_corebits OLAP Status Boolean max incore bits

_olap_statbool_threshold OLAP Status Boolean CBM threshold

_olap_table_function_statistics Specify TRUE to output OLAP table function timed statistics trace

_olap_wrap_errors Wrap error messages to OLAP outfile

_olapi_history_retention enable olapi history retention

_olapi_iface_object_history enable olapi interface object history collection

_olapi_iface_object_history_retention enable olapi interface object history retention

_olapi_iface_operation_history_retention enable olapi interface operation history retention

_olapi_interface_operation_history enable olapi interface operation history collection

_olapi_memory_operation_history enable olapi memory alloc/free history collection

_olapi_memory_operation_history_pause_at enable olapi memory alloc/free history collection pausing

_seqno


_olapi_memory_operation_history_retentio enable olapi memory operation history retention

n


_olapi_session_history enable olapi session history collection

_olapi_session_history_retention enable olapi session history retention

_old_connect_by_enabled enable/disable old connect by

_old_extent_scheme Revert to old extent allocation

_ols_cleanup_task Clean up unnecessary entries in OLS sessinfo table

_oltp_comp_dbg_scan oltp compression scan debug

_oltp_compression oltp compression enabled

_oltp_compression_gain oltp compression gain

_oltp_spill spill rows for oltp compression if loader pga limit is exceeded

_omf enable/disable OMF

_omni_enqueue_enable Enable Omni Enqueue feature (0 = disable, 1 = enable on ASM (default), 2 = enabl

                                        e)


_oneside_colstat_for_equijoins sanity check on default selectivity for like/range predicate

_online_ctas_diag controls dumping diagnostic information for online ctas

_online_patch_disable_stack_check disable check for function on stack for online patches

_ops_per_semop the exact number of operations per semop system call

_optim_adjust_for_part_skews adjust stats for skews across partitions

_optim_dict_stats_at_db_cr_upg enable/disable dictionary stats gathering at db create/upgrade

_optim_enhance_nnull_detection TRUE to enable index [fast] full scan more often

_optim_new_default_join_sel improves the way default equijoin selectivity are computed

_optim_peek_user_binds enable peeking of user binds

_optimizer_adaptive_cursor_sharing optimizer adaptive cursor sharing

_optimizer_adaptive_plan_control internal controls for adaptive plans

_optimizer_adaptive_plans enable adaptive plans

_optimizer_adjust_for_nulls adjust selectivity for null values

_optimizer_ads_max_table_count maximum number of tables in a join under ADS

_optimizer_ads_time_limit maximum time limit (seconds) under ADS

_optimizer_ads_use_result_cache use result cache for ADS queries

_optimizer_ansi_join_lateral_enhance optimization of left/full ansi-joins and lateral views

_optimizer_ansi_rearchitecture re-architecture of ANSI left, right, and full outer joins

_optimizer_autostats_job enable/disable auto stats collection job

_optimizer_aw_join_push_enabled Enables AW Join Push optimization

_optimizer_aw_stats_enabled Enables statistcs on AW olap_table table function

_optimizer_batch_table_access_by_rowid enable table access by ROWID IO batching

_optimizer_better_inlist_costing enable improved costing of index access using in-list(s)

_optimizer_block_size standard block size used by optimizer

_optimizer_cache_stats cost with cache statistics

_optimizer_cartesian_enabled optimizer cartesian join enabled

_optimizer_cbqt_factor cost factor for cost-based query transformation

_optimizer_cbqt_no_size_restriction disable cost based transformation query size restriction

_optimizer_ceil_cost CEIL cost in CBO

_optimizer_coalesce_subqueries consider coalescing of subqueries optimization

_optimizer_complex_pred_selectivity enable selectivity estimation for builtin functions

_optimizer_compute_index_stats force index stats collection on index creation/rebuild

_optimizer_connect_by_cb_whr_only use cost-based transformation for whr clause in connect by

_optimizer_connect_by_combine_sw combine no filtering connect by and start with

_optimizer_connect_by_cost_based use cost-based transformation for connect by

_optimizer_connect_by_elim_dups allow connect by to eliminate duplicates from input

_optimizer_correct_sq_selectivity force correct computation of subquery selectivity

_optimizer_cost_based_transformation enables cost-based query transformation

_optimizer_cost_filter_pred enables costing of filter predicates in IO cost model

_optimizer_cost_hjsmj_multimatch add cost of generating result set when #rows per key > 1

_optimizer_cost_model optimizer cost model

_optimizer_cube_join_enabled enable cube join

_optimizer_degree force the optimizer to use the same degree of parallelism

_optimizer_dim_subq_join_sel use join selectivity in choosing star transformation dimensions

_optimizer_disable_strans_sanity_checks disable star transformation sanity checks

_optimizer_distinct_agg_transform Transforms Distinct Aggregates to non-distinct aggregates

_optimizer_distinct_elimination Eliminates redundant SELECT DISTNCT's

_optimizer_distinct_placement consider distinct placement optimization

_optimizer_dsdir_usage_control controls optimizer usage of dynamic sampling directives

_optimizer_dyn_smp_blks number of blocks for optimizer dynamic sampling

_optimizer_eliminate_filtering_join optimizer filtering join elimination enabled

_optimizer_enable_density_improvements use improved density computation for selectivity estimation

_optimizer_enable_extended_stats use extended statistics for selectivity estimation

_optimizer_enable_table_lookup_by_nl consider table lookup by nl transformation

_optimizer_enhanced_filter_push push filters before trying cost-based query transformation

_optimizer_extend_jppd_view_types join pred pushdown on group-by, distinct, semi-/anti-joined view

_optimizer_extended_cursor_sharing optimizer extended cursor sharing

_optimizer_extended_cursor_sharing_rel optimizer extended cursor sharing for relational operators

_optimizer_extended_stats_usage_control controls the optimizer usage of extended stats

_optimizer_false_filter_pred_pullup optimizer false predicate pull up transformation

_optimizer_fast_access_pred_analysis use fast algorithm to traverse predicates for physical optimizer

_optimizer_fast_pred_transitivity use fast algorithm to generate transitive predicates

_optimizer_feedback_control controls the optimizer feedback framework

_optimizer_filter_pred_pullup use cost-based flter predicate pull up transformation

_optimizer_filter_pushdown enable/disable filter predicate pushdown

_optimizer_fkr_index_cost_bias Optimizer index bias over FTS/IFFS under first K rows mode

_optimizer_force_CBQT force CBQT transformation regardless of cost

_optimizer_free_transformation_heap free transformation subheap after each transformation

_optimizer_full_outer_join_to_outer enable/disable full outer to left outer join conversion

_optimizer_gather_feedback optimizer gather feedback

_optimizer_gather_stats_on_load enable/disable online statistics gathering

_optimizer_generate_transitive_pred optimizer generate transitive predicates

_optimizer_group_by_placement consider group-by placement optimization

_optimizer_hybrid_fpwj_enabled enable hybrid full partition-wise join when TRUE

_optimizer_ignore_hints enables the embedded hints to be ignored

_optimizer_improve_selectivity improve table and partial overlap join selectivity computation

_optimizer_instance_count force the optimizer to use the specified number of instances

_optimizer_interleave_jppd interleave join predicate pushdown during CBQT

_optimizer_invalidation_period time window for invalidation of cursors of analyzed objects

_optimizer_join_elimination_enabled optimizer join elimination enabled

_optimizer_join_factorization use join factorization transformation

_optimizer_join_order_control controls the optimizer join order search algorithm

_optimizer_join_sel_sanity_check enable/disable sanity check for multi-column join selectivity

_optimizer_max_permutations optimizer maximum join permutations per query block

_optimizer_min_cache_blocks set minimum cached blocks

_optimizer_mjc_enabled enable merge join cartesian

_optimizer_mode_force force setting of optimizer mode for user recursive SQL also

_optimizer_multi_level_push_pred consider join-predicate pushdown that requires multi-level pushdown to base tabl

                                        e


_optimizer_multi_table_outerjoin allows multiple tables on the left of outerjoin

_optimizer_multiple_cenv generate and run plans using several compilation environments

_optimizer_multiple_cenv_report control what to report in trace file when run in multi-plan mode

_optimizer_multiple_cenv_stmt control the types of statements that are run in multi-plan mode

_optimizer_native_full_outer_join execute full outer join using native implementaion

_optimizer_nested_rollup_for_gset number of groups above which we use nested rollup exec for gset

_optimizer_new_join_card_computation compute join cardinality using non-rounded input values

_optimizer_null_accepting_semijoin enables null-accepting semijoin

_optimizer_null_aware_antijoin null-aware antijoin parameter

_optimizer_or_expansion control or expansion approach used

_optimizer_or_expansion_subheap Use subheap for optimizer or-expansion

_optimizer_order_by_elimination_enabled Eliminates order bys from views before query transformation

_optimizer_outer_join_to_inner enable/disable outer to inner join conversion

_optimizer_outer_to_anti_enabled Enable transformation of outer-join to anti-join if possible

_optimizer_partial_join_eval partial join evaluation parameter

_optimizer_percent_parallel optimizer percent parallel

_optimizer_performance_feedback controls the performance feedback

_optimizer_proc_rate_level control the level of processing rates

_optimizer_proc_rate_source control the source of processing rates

_optimizer_purge_stats_iteration_row_cou number of rows to be deleted at each iteration of the stats pu

nt rging process


_optimizer_push_down_distinct push down distinct from query block to table

_optimizer_push_pred_cost_based use cost-based query transformation for push pred optimization

_optimizer_random_plan optimizer seed value for random plans

_optimizer_reuse_cost_annotations reuse cost annotations during cost-based query transformation

_optimizer_rownum_bind_default Default value to use for rownum bind

_optimizer_rownum_pred_based_fkr enable the use of first K rows due to rownum predicate

_optimizer_save_stats enable/disable saving old versions of optimizer stats

_optimizer_search_limit optimizer search limit

_optimizer_self_induced_cache_cost account for self-induced caching

_optimizer_skip_scan_enabled enable/disable index skip scan

_optimizer_skip_scan_guess consider index skip scan for predicates with guessed selectivity

_optimizer_sortmerge_join_enabled enable/disable sort-merge join method

_optimizer_sortmerge_join_inequality enable/disable sort-merge join using inequality predicates

_optimizer_squ_bottomup enables unnesting of subquery in a bottom-up manner

_optimizer_star_tran_in_with_clause enable/disable star transformation in with clause queries

_optimizer_star_trans_min_cost optimizer star transformation minimum cost

_optimizer_star_trans_min_ratio optimizer star transformation minimum ratio

_optimizer_starplan_enabled optimizer star plan enabled

_optimizer_strans_adaptive_pruning allow adaptive pruning of star transformation bitmap trees

_optimizer_system_stats_usage system statistics usage

_optimizer_table_expansion consider table expansion transformation

_optimizer_trace optimizer trace parameter

_optimizer_transitivity_retain retain equi-join pred upon transitive equality pred generation

_optimizer_try_st_before_jppd try Star Transformation before Join Predicate Push Down

_optimizer_undo_changes undo changes to query optimizer

_optimizer_undo_cost_change optimizer undo cost change

_optimizer_unnest_all_subqueries enables unnesting of every type of subquery

_optimizer_unnest_corr_set_subq Unnesting of correlated set subqueries (TRUE/FALSE)

_optimizer_unnest_disjunctive_subq Unnesting of disjunctive subqueries (TRUE/FALSE)

_optimizer_unnest_scalar_sq enables unnesting of of scalar subquery

_optimizer_use_cbqt_star_transformation use rewritten star transformation using cbqt framework

_optimizer_use_feedback optimizer use feedback

_optimizer_use_gtt_session_stats use GTT session private statistics

_optimizer_use_histograms enable/disable the usage of histograms by the optimizer

_optimizer_use_subheap Enables physical optimizer subheap

_or_expand_nvl_predicate enable OR expanded plan for NVL/DECODE predicate

_oracle_script Running an Oracle-supplied script

_oradbg_pathname path of oradbg script

_oradebug_cmds_at_startup oradebug commands to execute at instance startup

_oradebug_force force target processes to execute oradebug commands?

_ordered_nested_loop enable ordered nested loop costing

_ordered_semijoin enable ordered semi-join subquery

_orph_cln_interval qmon periodic interval for removed subscriber messages cleanup

_os_sched_high_priority OS high priority level

_oss_skgxp_udp_dynamic_credit_mgmt OSSLIB enable[!0]/disable[0] dynamic credit mgmt for SKGXP-UDP

_other_wait_event_exclusion exclude event names from _other_wait_threshold calculations

_other_wait_threshold threshold wait percentage for event wait class Other

_outline_bitmap_tree BITMAP_TREE hint enabled in outline

_parallel_adaptive_max_users maximum number of users running with default DOP

_parallel_blackbox_enabled parallel execution blackbox enabled

_parallel_blackbox_sga true if blackbox will be allocated in SGA, false if PGA

_parallel_blackbox_size parallel execution blackbox bucket size

_parallel_broadcast_enabled enable broadcasting of small inputs to hash and sort merge joins

_parallel_cluster_cache_pct max percentage of the global buffer cache to use for affinity

_parallel_cluster_cache_policy policy used for parallel execution on cluster(ADAPTIVE/CACHED)

_parallel_conservative_queuing conservative parallel statement queuing

_parallel_ctas_enabled enable/disable parallel CTAS operation

_parallel_default_max_instances default maximum number of instances for parallel query

_parallel_execution_message_align Alignment of PX buffers to OS page boundary

_parallel_fake_class_pct fake db-scheduler percent used for testing

_parallel_fault_tolerance_threshold total number of faults fault-tolerance will handle

_parallel_fixwrite_bucket Number of buckets for each round of fix write

_parallel_heartbeat_snapshot_interval interval of snapshot to track px msging between instances

_parallel_heartbeat_snapshot_max maximum number of historical snapshots archived

_parallel_load_bal_unit number of threads to allocate per instance

_parallel_load_balancing parallel execution load balanced slave allocation

_parallel_load_publish_threshold diffrence in percentage controlling px load propagation

_parallel_min_message_pool minimum size of shared pool memory to reserve for pq servers

_parallel_optimization_phase_for_local parallel optimization phase when all slaves are local

_parallel_queuing_max_waitingtime parallel statement queuing: max waiting time in queue

_parallel_recovery_stopat stop at -position- to step through SMON

_parallel_replay_msg_limit Number of messages for each round of parallel replay

_parallel_scalability Parallel scalability criterion for parallel execution

_parallel_server_idle_time idle time before parallel query server dies (in 1/100 sec)

_parallel_server_sleep_time sleep time between dequeue timeouts (in 1/100ths)

_parallel_slave_acquisition_wait time(in seconds) to wait before retrying slave acquisition

_parallel_statement_queuing parallel statement queuing enabled

_parallel_syspls_obey_force TRUE to obey force parallel query/dml/ddl under System PL/SQL

_parallel_time_unit unit of work used to derive the degree of parallelism (in seconds)

_parallel_txn_global enable parallel_txn hint with updates and deletes

_parallelism_cost_fudge_factor set the parallelism cost fudge factor

_parameter_table_block_size parameter table block size

_part_access_version_by_number use version numbers to access versioned objects for partitioning

_part_redef_global_index_update online partition redefinition update global indexes

_partial_pwise_join_enabled enable partial partition-wise join when TRUE

_partition_advisor_srs_active enables sampling based partitioning validation

_partition_large_extents Enables large extent allocation for partitioned tables

_partition_view_enabled enable/disable partitioned views

_passwordfile_enqueue_timeout password file enqueue timeout in seconds

_pct_refresh_double_count_prevented materialized view PCT refreshes avoid double counting

_pdb_use_sequence_cache Use sequence cache in PDB mode

_pdml_gim_sampling control separation of global index maintenance for PDML

_pdml_gim_staggered slaves start on different index when doing index maint

_pdml_slaves_diff_part slaves start on different partition when doing index maint

_percent_flashback_buf_partial_full Percent of flashback buffer filled to be considered partial full

_pga_large_extent_size PGA large extent size

_pga_limit_check_wait_time microseconds to wait for over limit confirmation

_pga_limit_dump_summary dump PGA summary when signalling ORA-4036

_pga_limit_interrupt_smaller whether to interrupt smaller eligible processes

_pga_limit_min_req_size bytes of PGA usage below which process will not get ORA-4036

_pga_limit_simulated_physmem_size bytes of physical memory to determine pga_aggregate_limit with

_pga_limit_target_perc default percent of pga_aggregate_target for pga_aggregate_limit

_pga_limit_time_to_interrupt seconds to wait until direct interrupt

_pga_limit_time_until_idle seconds to wait before treating process as idle

_pga_limit_time_until_killed seconds to wait before killing session over limit

_pga_limit_tracing trace pga_aggregate_limit activity

_pga_limit_use_immediate_kill use immediate kill for sessions over limit

_pga_limit_watch_perc percentage of limit to have processes watch

_pga_limit_watch_size bytes of PGA usage at which process will begin watching limit

_pga_max_size Maximum size of the PGA memory for one process

_pgactx_cap_stacks capture stacks for setting pgactx

_pin_time_statistics if TRUE collect statistics for how long a current pin is held

_ping_wait_for_log_force Wait for log force before block ping

_pivot_implementation_method pivot implementation method

_pkt_enable enable progressive kill test

_pkt_pmon_interval PMON process clean-up interval (cs)

_pkt_start start progressive kill test instrumention

_plan_outline_data explain plan outline data enabled

_plan_verify_improvement_margin Performance improvement criterion for evolving plan baselines

_plan_verify_local_time_limit Local time limit to use for an individual plan verification

_plsql_anon_block_code_type PL/SQL anonymous block code-type

_plsql_cache_enable PL/SQL Function Cache Enabled

_plsql_dump_buffer_events conditions upon which the PL/SQL circular buffer is dumped

_plsql_max_stack_size PL/SQL maximum stack size

_plsql_minimum_cache_hit_percent plsql minimum cache hit percentage required to keep caching active

_plsql_native_frame_threshold Allocate PL/SQL native frames on the heap if size exceeds this value

_plsql_nvl_optimize PL/SQL NVL optimize

_pluggable_database_debug Debug flag for pluggable database related operations

_pmon_dead_blkrs_alive_chk_rate_secs rate to check blockers are alive during cleanup (in seconds)

_pmon_dead_blkrs_max_blkrs max blockers to check during cleanup

_pmon_dead_blkrs_max_cleanup_attempts max attempts per blocker while checking dead blockers

_pmon_dead_blkrs_scan_rate_secs rate to scan for dead blockers during cleanup (in seconds)

_pmon_enable_dead_blkrs look for dead blockers during PMON cleanup

_pmon_load_constants server load balancing constants (S,P,D,I,L,C,M)

_pmon_max_consec_posts PMON max consecutive posts in main loop

_post_wait_queues_dynamic_queues Post Wait Queues - Num Dynamic Queues

_post_wait_queues_num_per_class Post Wait Queues - Num Per Class

_pqq_debug_txn_act pq queuing transaction active

_pqq_enabled Enable Resource Manager based Parallel Statement Queuing

_pre_rewrite_push_pred push predicates into views before rewrite

_precompute_gid_values precompute gid values and copy them before returning a row

_pred_move_around enables predicate move-around

_predicate_elimination_enabled allow predicate elimination if set to TRUE

_prefered_standby standby db_unique_name prefered for krb operations

_prescomm presume commit of IMU transactions

_print_inmem_heatmap print inmem ilm heatmap

_print_refresh_schedule enable dbms_output of materialized view refresh schedule

_print_stat_segment print ilm statistics segment

_private_memory_address Start address of large extent memory segment

_project_view_columns enable projecting out unreferenced columns of a view

_projection_pushdown projection pushdown

_projection_pushdown_debug level for projection pushdown debugging

_prop_old_enabled Shift to pre 11g propagation behaviour

_protect_frame_heaps Protect cursor frame heaps

_ptn_cache_threshold flags and threshold to control partition metadata caching

_push_join_predicate enable pushing join predicate inside a view

_push_join_union_view enable pushing join predicate inside a union all view

_push_join_union_view2 enable pushing join predicate inside a union view

_px_adaptive_dist_method determines the behavior of adaptive distribution methods

_px_adaptive_dist_method_threshold Buffering / decision threshold for adaptive distribution methods

_px_adaptive_offload_percentage percentage for PQ adaptive offloading of granules

_px_adaptive_offload_threshold threshold (GB/s) for PQ adaptive offloading of granules

_px_async_getgranule asynchronous get granule in the slave

_px_back_to_parallel allow going back to parallel after a serial operation

_px_bind_peek_sharing enables sharing of px cursors that were built using bind peeking

_px_broadcast_fudge_factor set the tq broadcasting fudge factor percentage

_px_buffer_ttl ttl for px mesg buffers in seconds

_px_cdb_view_enabled parallel cdb view evaluation enabled

_px_chunklist_count_ratio ratio of the number of chunk lists to the default DOP per instance

_px_compilation_debug debug level for parallel compilation

_px_compilation_trace tracing level for parallel compilation

_px_concurrent enables pq with concurrent execution of serial inputs

_px_cpu_autodop_enabled enables or disables auto dop cpu computation

_px_cpu_operator_bandwidth CPU operator bandwidth in MB/sec for DOP computation

_px_cpu_process_bandwidth CPU process bandwidth in MB/sec for DOP computation

_px_dp_array_size Max number of pq processes supported

_px_dump_12805_source enables or disables tracing of 12805 signal source

_px_dynamic_opt turn off/on restartable qerpx dynamic optimization

_px_dynamic_sample_size num of samples for restartable qerpx dynamic optimization

_px_execution_services_enabled enable service-based constraint of px slave allocation

_px_filter_parallelized enables or disables correlated filter parallelization

_px_filter_skew_handling enable correlated filter parallelization to handle skew

_px_freelist_latch_divisor Divide the computed number of freelists by this power of 2

_px_gim_factor weighted autodop global index maintenance factor

_px_granule_batch_size maximum size of a batch of granules

_px_granule_randomize enables or disables randomization of parallel scans rowid granules

_px_granule_size default size of a rowid range granule (in KB)

_px_groupby_pushdown perform group-by pushdown for parallel query

_px_hold_time hold px at execution time (unit: second)

_px_hybrid_TSM_HWMB_load Enable Hybrid Temp Segment Merge/High Water Mark Brokered load method

_px_index_sampling_objsize parallel query sampling for index create based on object size

_px_io_process_bandwidth IO process bandwidth in MB/sec for computing DOP

_px_io_system_bandwidth total IO system bandwidth in MB/sec for computing DOP

_px_join_skew_handling enables skew handling for parallel joins

_px_join_skew_minfreq sets minimum frequency(%) for skewed value for parallel joins

_px_join_skew_ratio sets skew ratio for parallel joins

_px_kxib_tracing turn on kxib tracing

_px_load_balancing_policy parallel load balancing policy

_px_load_factor weighted autodop load factor

_px_load_monitor_threshold threshold for pushing information to load slave workload monitor

_px_load_publish_interval interval at which LMON will check whether to publish PX load

_px_loc_msg_cost CPU cost to send a PX message via shared memory

_px_max_granules_per_slave maximum number of rowid range granules to generate per slave

_px_max_map_val Maximum value of rehash mapping for PX

_px_max_message_pool_pct percentage of shared pool for px msg buffers range [5,90]

_px_message_compression enable compression of control messages for parallel query

_px_min_granules_per_slave minimum number of rowid range granules to generate per slave

_px_minus_intersect enables pq for minus/interect operators

_px_monitor_load enable consumer load slave workload monitoring

_px_net_msg_cost CPU cost to send a PX message over the internconnect

_px_no_granule_sort prevent parallel partition granules to be sorted on size

_px_no_stealing prevent parallel granule stealing in shared nothing environment

_px_nss_planb enables or disables NSS Plan B reparse with outline

_px_numa_stealing_enabled enable/disable PQ granule stealing across NUMA nodes

_px_numa_support_enabled enable/disable PQ NUMA support

_px_object_sampling parallel query sampling for base objects (100000 = 100%)

_px_object_sampling_enabled use base object sampling when possible for range distribution

_px_onepass_slave_acquisition enable/disable one pass slave acquisition for parallel execution

_px_parallelize_expression enables or disables expression evaluation parallelization

_px_partial_rollup_pushdown perform partial rollup pushdown for parallel execution

_px_partition_scan_enabled enables or disables parallel partition-based scan

_px_partition_scan_threshold least number of partitions per slave to start partition-based scan

_px_proactive_slave_alloc_threshold parallel proactive slave allocation threshold/unit

_px_proc_constrain reduce parallel_max_servers if greater than (processes - fudge)

_px_pwg_enabled parallel partition wise group by enabled

_px_pwmr_enabled parallel partition wise match recognize enabled

_px_replication_enabled enables or disables replication of small table scans

_px_round_robin_rowcnt round robin row count to enq to next slave

_px_rownum_pd turn off/on parallel rownum pushdown optimization

_px_send_timeout IPC message send timeout value in seconds

_px_single_server_enabled allow single-slave dfo in parallel query

_px_slaves_share_cursors slaves share cursors with QC

_px_tq_rowhvs turn on intra-row hash valueing sharing in TQ

_px_trace px trace parameter

_px_ual_serial_input enables new pq for UNION operators

_px_wif_dfo_declumping NDV-aware DFO clumping of multiple window sorts

_px_wif_extend_distribution_keys extend TQ data redistribution keys for window functions

_px_wif_min_ndv_per_slave mininum NDV of TQ keys needed per slave for scalable WiF PX

_px_xtgranule_size default size of a external table granule (in KB)

_qa_control Oracle internal parameter to control QA

_qa_lrg_type Oracle internal parameter to specify QA lrg type

_query_cost_rewrite perform the cost based rewrite with materialized views

_query_execution_cache_max_size max size of query execution cache

_query_mmvrewrite_maxcmaps query mmv rewrite maximum number of cmaps per dmap in query disjunct

_query_mmvrewrite_maxdmaps query mmv rewrite maximum number of dmaps per query disjunct

_query_mmvrewrite_maxinlists query mmv rewrite maximum number of in-lists per disjunct

_query_mmvrewrite_maxintervals query mmv rewrite maximum number of intervals per disjunct

_query_mmvrewrite_maxpreds query mmv rewrite maximum number of predicates per disjunct

_query_mmvrewrite_maxqryinlistvals query mmv rewrite maximum number of query in-list values

_query_mmvrewrite_maxregperm query mmv rewrite maximum number of region permutations

_query_on_physical query on physical

_query_rewrite_1 perform query rewrite before&after or only before view merging

_query_rewrite_2 perform query rewrite before&after or only after view merging

_query_rewrite_drj mv rewrite and drop redundant joins

_query_rewrite_expression rewrite with cannonical form for expressions

_query_rewrite_fpc mv rewrite fresh partition containment

_query_rewrite_fudge cost based query rewrite with MVs fudge factor

_query_rewrite_jgmigrate mv rewrite with jg migration

_query_rewrite_maxdisjunct query rewrite max disjuncts

_query_rewrite_or_error allow query rewrite, if referenced tables are not dataless

_query_rewrite_setopgrw_enable perform general rewrite using set operator summaries

_query_rewrite_vop_cleanup prune frocol chain before rewrite after view-merging

_queue_buffer_max_dump_len max number of bytes to dump to trace file for queue buffer dump

_radm_enabled Data Redaction

_rbr_ckpt_tracing Enable reuse block range checkpoint tracing

_rcfg_disable_verify if TRUE disables verify at reconfiguration

_rcfg_parallel_fixwrite if TRUE enables parallel fixwrite at reconfiguration

_rcfg_parallel_replay if TRUE enables parallel replay and cleanup at reconfiguration

_rcfg_parallel_verify if TRUE enables parallel verify at reconfiguration

_rdbms_compatibility default RDBMS compatibility level

_rdbms_internal_fplib_enabled enable CELL FPLIB filtering within rdbms

_rdbms_internal_fplib_raise_errors enable reraising of any exceptions in CELL FPLIB

_re_fast_sql_operator enables fast boxable sql operator

_re_independent_expression_cache_size defines max number of compiled cached expressions for iee

_re_num_complex_operator defines max number of compiled complex operator per ruleset-iee

_re_num_rowcache_load defines max number of complex operators loaded with row cache

_re_result_cache_keysiz defines max number key for result cache hash table

_re_result_cache_size defines max number of cached elements for result cache

_read_mostly_enable_logon Read mostly instances enable non-privileged logons

_read_mostly_instance indicates this is a read_mostly instance

_read_mostly_instance_qa_control internal parameter to control read mostly instance QA

_read_mostly_slave_timeout Time to wait on read mostly node when hub not available

_read_only_violation_dump_to_trace read-only violation dump to trace files

_read_only_violation_max_count read-only violation array max count

_read_only_violation_max_count_per_modul read-only violation array per module max count

e


_readable_standby_sync_timeout readable standby query scn sync timeout

_real_time_apply_sim Simulation value with real time apply

_realfree_heap_max_size minimum max total heap size, in Kbytes

_realfree_heap_mode mode flags for real-free heap

_realfree_heap_pagesize hint for real-free page size in bytes

_realfree_pq_heap_pagesize hint for pq real-free page size in bytes

_recoverable_recovery_batch_percent Recoverable recovery batch size (percentage of buffer cache)

_recovery_asserts if TRUE, enable expensive integrity checks

_recovery_percentage recovery buffer cache percentage

_recovery_read_limit number of recovery reads which can be outstanding

_recovery_skip_cfseq_check allow media recovery even if controlfile seq check fails

_recovery_verify_writes enable thread recovery write verify

_recursive_imu_transactions recursive transactions may be IMU

_recursive_with_max_recursion_level check for maximum level of recursion instead of checking for cycles

_redef_on_statement Use on-statement refresh in online redefinition

_redo_compatibility_check general and redo/undo compatibility sanity check

_redo_log_debug_config Various configuration flags for debugging redo logs

_redo_log_record_life Life time in hours for redo log table records

_redo_read_from_memory Enable reading redo from in-memory log buffer

_redo_transport_compress_all Is ASYNC LNS compression allowed?

_redo_transport_sanity_check redo transport sanity check bit mask

_redo_transport_stall_time I/O stall time before terminating redo transport process

_redo_transport_stall_time_long long I/O stall time before terminating redo transport process

_redo_transport_stream_test test stream connection?

_redo_transport_stream_writes Stream network writes?

_redo_transport_vio_size_req VIO size requirement

_reduce_sby_log_scan enable standby log scan optimization

_region_name gsm region name

_release_insert_threshold maximum number of unusable blocks to unlink from freelist

_reliable_block_sends if TRUE, no side channel on reliable interconnect

_relocate_pdb Relocate PDB to another RAC instance after it is closed in the current instance

_relocation_commit_batch_size ASM relocation commit batch size

_remote_asm remote ASM configuration

_remote_awr_enabled Enable/disable Remote AWR Mode

_remove_aggr_subquery enables removal of subsumed aggregated subquery

_remove_exf_component enable/disable removing of components EXF and RUL during upgrade

_rep_base_path base path for EM reports in database

_replace_virtual_columns replace expressions with virtual columns

_report_capture_cycle_time Time (in sec) between two cycles of report capture daemon

_report_capture_dbtime_percent_cutoff 100X Percent of system db time daemon is allowed over 10 cycles

_report_capture_recharge_window No of report capture cycles after which db time is recharged

_report_capture_timeband_length Length of time band (in hours) in the reports time bands table

_report_request_ageout_minutes Time (in min) after which a report request is deleted from queue

_reset_maxcap_history reset maxcap history time

_resource_includes_unlimited_tablespace Whether RESOURCE role includes UNLIMITED TABLESPACE privilege

_resource_manager_always_off disable the resource manager always

_resource_manager_plan resource mgr top plan for internal use

_restore_maxopenfiles restore assumption for maxopenfiles

_restore_spfile restore spfile to this location

_result_cache_auto_dml_monitoring_durati result cache auto dml monitoring duration

on


_result_cache_auto_dml_monitoring_slots result cache auto dml monitoring slot

_result_cache_auto_dml_threshold result cache auto dml threshold

_result_cache_auto_dml_trend_threshold result cache auto dml trend threshold

_result_cache_auto_execution_threshold result cache auto execution threshold

_result_cache_auto_size_threshold result cache auto max size allowed

_result_cache_auto_time_distance result cache auto time distance

_result_cache_auto_time_threshold result cache auto time threshold

_result_cache_block_size result cache block size

_result_cache_copy_block_count blocks to copy instead of pinning the result

_result_cache_deterministic_plsql result cache deterministic PLSQL functions

_result_cache_global Are results available globally across RAC?

_result_cache_timeout maximum time (sec) a session waits for a result

_resumable_critical_alert raise critical alert for resumable failure

_reuse_index_loop number of blocks being examine for index block reuse

_right_outer_hash_enable Right Outer/Semi/Anti Hash Enabled

_rm_cluster_interconnects interconnects for RAC use (RM)

_rm_numa_sched_enable Is Resource Manager (RM) related NUMA scheduled policy enabled

_rm_numa_simulation_cpus number of cpus for each pg for numa simulation in resource manager

_rm_numa_simulation_pgs number of PGs for numa simulation in resource manager

_rman_io_priority priority at which rman backup i/o's are done

_rman_roundrobin_placement Numa round robin placement for RMAN procs

_rollback_segment_count number of undo segments

_rollback_segment_initial starting undo segment number

_rollback_stopat stop at -position to step rollback

_rond_test_mode rac one node test mode

_row_cache_cursors number of cached cursors for row cache management

_row_cr enable row cr for all sql

_row_locking row-locking

_row_shipping_explain enable row shipping explain plan support

_row_shipping_threshold row shipping column selection threshold

_rowlen_for_chaining_threshold maximum rowlen above which rows may be chained across blocks

_rowsets_enabled enable/disable rowsets

_rowsets_max_rows maximum number of rows in a rowset

_rowsets_target_maxsize target size in bytes for space reserved in the frame for a rowset

_rowsource_execution_statistics if TRUE, Oracle will collect rowsource statistics

_rowsource_profiling_statistics if TRUE, Oracle will capture active row sources in v$active_session_history

_rowsource_statistics_sampfreq frequency of rowsource statistic sampling (must be a power of 2)

_rowsrc_trace_level Row source tree tracing level

_rta_sync_wait_timeout RTA sync wait timeout

_rtaddm_trigger_args comma-separated list of numeric arguments for RT addm trigger

_rtaddm_trigger_enabled To enable or disable Real-Time ADDM automatic trigger

_rtc_infeasible_threshold Redo Transport Compression infeasible threshold

_sample_rows_per_block number of rows per block used for sampling IO optimization

_scalar_type_lob_storage_threshold threshold for VARCHAR2, NVARCHAR2, and RAW storage as BLOB

_scatter_gcs_resources if TRUE, gcs resources are scattered uniformly across sub pools

_scatter_gcs_shadows if TRUE, gcs shadows are scattered uniformly across sub pools

_sched_delay_max_samples scheduling delay maximum number of samples

_sched_delay_measurement_sleep_us scheduling delay mesurement sleep us

_sched_delay_os_tick_granularity_us os tick granularity used by scheduling delay calculations

_sched_delay_sample_collection_thresh_ms scheduling delay sample collection duration threshold ms

_sched_delay_sample_interval_ms scheduling delay sampling interval in ms

_scn_wait_interface_max_backoff_time_sec max exponential backoff time for scn wait interface in kta

s


_scn_wait_interface_max_timeout_secs max timeout for scn wait interface in kta

_sdiag_crash sql diag crash

_sec_enable_test_rpcs Whether to enable the test RPCs

_second_spare_parameter second spare parameter - integer

_securefile_log_num_latches Maximum number of open descriptors for securefile log

_securefile_log_shared_pool_size Size of securefile log buffer pool from SGA

_securefile_timers collect kdlu timers and accumulate per layers

_securefiles_breakreten_retry segment retry before dishonoring retention

_securefiles_bulkinsert securefiles segment insert only optization

_securefiles_concurrency_estimate securefiles concurrency estimate

_securefiles_fg_retry segment retry before foreground waits

_securefiles_forceflush securefiles force flush before allocation

_securefiles_memory_percentofSGA securefiles memory as percent of SGA

_securefiles_spcutl securefiles segment utl optimization

_select_any_dictionary_security_enabled Exclude USER$, XS$VERIFIERS, ENC$ and DEFAULT_PWD$ from SELECT ANY D

                                        ICTIONARY system privilege


_selectivity_for_srf_enabled enable/disable selectivity for storage reduction factor

_selfjoin_mv_duplicates control rewrite self-join algorithm

_selftune_checkpoint_write_pct Percentage of total physical i/os for self-tune ckpt

_selftune_checkpointing_lag Self-tune checkpointing lag the tail of the redo log

_sem_per_semid the exact number of semaphores per semaphore set to allocate

_send_ast_to_foreground if TRUE, send ast message to foreground

_send_close_with_block if TRUE, send close with block even with direct sends

_send_requests_to_pi if TRUE, try to send CR requests to PI buffers

_serial_direct_read enable direct read in serial

_serial_log_write_worker_io Serialize log write slave I/O

_serial_recovery force serial recovery or parallel recovery

_serializable serializable

_serialize_lgwr_sync_io Serialize LGWR SYNC local and remote io

_service_cleanup_timeout timeout to peform service cleanup

_session_allocation_latches one latch per group of sessions

_session_cached_instantiations Number of pl/sql instantiations to cache in a session.

_session_context_size session app context size

_session_idle_bit_latches one latch per session or a latch per group of sessions

_session_page_extent Session Page Extent Size

_session_wait_history enable session wait history collection

_set_mgd_recovery_state set mgd recovery state to new value

_seventeenth_spare_parameter seventeenth spare parameter - string

_seventh_spare_parameter seventh spare parameter - integer

_sf_default_enabled enable 12g securefile default

_sga_alloc_slaves_term_timeout_secs Termination timeout in secs for SA** slaves

_sga_clear_dump Allow dumping encrypted blocks in clear for debugging

_sga_early_trace sga early trace event

_sga_locking sga granule locking state

_shared_io_pool_buf_size Shared IO pool buffer size

_shared_io_pool_debug_trc trace kcbi debug info to tracefile

_shared_io_pool_size Size of shared IO pool

_shared_io_set_value shared io pool size set internal value - overwrite zero user size

_shared_iop_max_size maximum shared io pool size

_shared_pool_max_size shared pool maximum size when auto SGA enabled

_shared_pool_minsize_on shared pool minimum size when auto SGA enabled

_shared_pool_reserved_min_alloc minimum allocation size in bytes for reserved area of shared pool

_shared_pool_reserved_pct percentage memory of the shared pool allocated for the reserved area

_shared_server_load_balance shared server load balance

_shared_server_num_queues number of shared server common queues

_shmprotect allow mprotect use for shared memory

_short_stack_timeout_ms short stack timeout in ms

_show_mgd_recovery_state Show internal managed recovery state

_shrd_que_tm_processes number of sharded queue Time Managers to start

_shrd_que_tm_statistics_duration Shaded queue statistics collection window duration

_shrunk_aggs_disable_threshold percentage of exceptions at which to switch to full length aggs

_shrunk_aggs_enabled enable use of variable sized buffers for non-distinct aggregates

_shutdown_completion_timeout_mins minutes for shutdown operation to wait for sessions to complete

_side_channel_batch_size number of messages to batch in a side channel message (DFS)

_side_channel_batch_timeout timeout before shipping out the batched side channelmessages in seconds

_side_channel_batch_timeout_ms timeout before shipping out the batched side channelmessages in milliseconds

_simple_view_merging control simple view merging performed by the optimizer

_simulate_disk_sectorsize Enables skgfr to report simulated disk sector size

_simulate_io_wait Simulate I/O wait to test segment advisor

_simulate_mem_transfer simulate auto memory sga/pga transfers

_simulated_log_write_usecs Simulated latency of log writes (usecs)

_simulator_bucket_mindelta LRU bucket minimum delta

_simulator_internal_bound simulator internal bound percent

_simulator_lru_rebalance_sizthr LRU list rebalance threshold (size)

_simulator_lru_rebalance_thresh LRU list rebalance threshold (count)

_simulator_lru_scan_count LRU scan count

_simulator_pin_inval_maxcnt maximum count of invalid chunks on pin list

_simulator_reserved_heap_count simulator reserved heap count

_simulator_reserved_obj_count simulator reserved object count

_simulator_sampling_factor sampling factor for the simulator

_simulator_upper_bound_multiple upper bound multiple of pool size

_single_process run without detached processes

_siop_flashback_scandepth Shared IO pool flashback io completion scan depth

_siop_perc_of_bc_x100 percentange * 100 of cache to transfer to shared io pool

_sixteenth_spare_parameter sixteenth spare parameter - string

_sixth_spare_parameter sixth spare parameter - integer

_skgxp_ant_options SKGXP ANT options (oss)

_skgxp_ctx_flags1 IPC debug options flags (oss)

_skgxp_ctx_flags1mask IPC debug options flags mask (oss)

_skgxp_dynamic_protocol IPC protocol override (!0/-1=*,2=UDP,3=RDS,0x1000=ipc_X)

_skgxp_gen_ant_off_rpc_timeout_in_sec VRPC request timeout when ANT disabled

_skgxp_gen_ant_ping_misscount ANT protocol ping miss count

_skgxp_gen_rpc_no_path_check_in_sec ANT ping protocol miss count

_skgxp_gen_rpc_timeout_in_sec VRPC request timeout when ANT enabled

_skgxp_inets limit SKGXP networks (oss)

_skgxp_min_rpc_rcv_zcpy_len IPC threshold for rpc rcv zcpy operation (default = 0 - disabled)

_skgxp_min_zcpy_len IPC threshold for zcpy operation (default = 0 - disabled)

_skgxp_reaping tune skgxp OSD reaping limit

_skgxp_rgn_ports region socket limits (0xFFFFNNXX): F=flags, N=min, X=max

_skgxp_spare_param1 ipc oss spare parameter 1

_skgxp_spare_param2 ipc oss spare parameter 2

_skgxp_spare_param3 ipc oss spare parameter 3

_skgxp_spare_param4 ipc oss spare parameter 4

_skgxp_spare_param5 ipc oss spare parameter 5

_skgxp_udp_ach_reaping_time time in minutes before idle ach's are reaped

_skgxp_udp_ack_delay Enables delayed acks

_skgxp_udp_enable_dynamic_credit_mgmt Enables dynamic credit management

_skgxp_udp_hiwat_warn ach hiwat mark warning interval

_skgxp_udp_interface_detection_time_secs time in seconds between interface detection checks

_skgxp_udp_keep_alive_ping_timer_secs connection idle time in seconds before keep alive is initiated. min: 30 sec max:

                                         1800 sec default: 300 sec


_skgxp_udp_lmp_mtusize MTU size for UDP LMP testing

_skgxp_udp_lmp_on enable UDP long message protection

_skgxp_udp_timed_wait_buffering diagnostic log buffering space (in bytes) for timed wait (0 means unbufferd

_skgxp_udp_timed_wait_seconds time in seconds before timed wait is invoked

_skgxp_udp_use_tcb disable use of high speek timer

_skgxp_zcpy_flags IPC zcpy options flags

_skgxpg_last_parameter last defined skgxpg parameter - oss

_skip_acfs_checks Override checking if on an ACFS file system

_skip_assume_msg if TRUE, skip assume message for consigns at the master

_skip_trstamp_check Skip terminal recovery stamp check

_slave_mapping_enabled enable slave mapping when TRUE

_slave_mapping_group_size force the number of slave group in a slave mapper

_slave_mapping_skew_ratio maximum skew before slave mapping is disabled

_small_table_threshold lower threshold level of table size for direct reads

_smm_advice_enabled if TRUE, enable v$pga_advice

_smm_advice_log_size overwrites default size of the PGA advice workarea history log

_smm_auto_cost_enabled if TRUE, use the AUTO size policy cost functions

_smm_auto_max_io_size Maximum IO size (in KB) used by sort/hash-join in auto mode

_smm_auto_min_io_size Minimum IO size (in KB) used by sort/hash-join in auto mode

_smm_bound overwrites memory manager automatically computed bound

_smm_control provides controls on the memory manager

_smm_freeable_retain value in KB of the instance freeable PGA memory to retain

_smm_isort_cap maximum work area for insertion sort(v1)

_smm_max_size maximum work area size in auto mode (serial)

_smm_max_size_static static maximum work area size in auto mode (serial)

_smm_min_size minimum work area size in auto mode

_smm_px_max_size maximum work area size in auto mode (global)

_smm_px_max_size_static static maximum work area size in auto mode (global)

_smm_retain_size work area retain size in SGA for shared server sessions (0 for AUTO)

_smm_trace Turn on/off tracing for SQL memory manager

_smon_internal_errlimit limit of SMON internal errors

_smon_undo_seg_rescan_limit limit of SMON continous undo segments re-scan

_smu_debug_mode <debug-flag> - set debug event for testing SMU operations

_smu_error_simulation_site site ID of error simulation in KTU code

_smu_error_simulation_type error type for error simulation in KTU code

_smu_timeouts comma-separated *AND double-quoted* list of AUM timeouts: mql, tur, sess_exprn,

                                        qry_exprn, slot_intvl


_snapshot_recovery_enabled enable/disable snapshot recovery

_sort_elimination_cost_ratio cost ratio for sort eimination under first_rows mode

_sort_multiblock_read_count multi-block read count for sort

_sort_spill_threshold force sort to spill to disk each time this many rows are received

_sort_sync_min_spill_threshold controls the mininum spill size for synchronized spill (in percent)

_sort_sync_min_spillsize controls the size of mininum run size for synchronized spill (in kb)

_space_align_size space align size

_spare_test_parameter Spare test parameter

_spawn_diag_opts thread spawn diagnostic options

_spawn_diag_thresh_secs thread spawn diagnostic minimal threshold in seconds

_spin_count Amount to spin waiting for a latch

_spr_max_rules maximum number of rules in sql spreadsheet

_spr_push_pred_refspr push predicates through reference spreadsheet

_spr_use_AW_AS enable AW for hash table in spreadsheet

_spr_use_hash_table use hash table for spreadsheet

_sql_analyze_enable_auto_txn SQL Analyze Autonomous Transaction control parameter

_sql_analyze_parse_model SQL Analyze Parse Model control parameter

_sql_compatibility sql compatability bit vector

_sql_connect_capability_override SQL Connect Capability Table Override

_sql_connect_capability_table SQL Connect Capability Table (testing only)

_sql_diag_repo_origin duarations where sql diag repository are retained

_sql_diag_repo_retain retain sql diag repository to cursor or not

_sql_hash_debug Hash value of the SQL statement to debug

_sql_hvshare_debug control hash value sharing debug level

_sql_hvshare_threshold threshold to control hash value sharing across operators

_sql_model_unfold_forloops specifies compile-time unfolding of sql model forloops

_sql_ncg_mode Optimization mode for SQL NCG

_sql_plan_directive_mgmt_control controls internal SQL Plan Directive management activities

_sql_plan_management_control controls various internal SQL Plan Management algorithms

_sql_show_expreval show expression evalution as shared hash producer in plan

_sqlexec_progression_cost sql execution progression monitoring cost threshold

_sqlmon_binds_xml_format format of column binds_xml in [G]V$SQL_MONITOR

_sqlmon_max_plan Maximum number of plans entry that can be monitored. Defaults to 20 per CPU

_sqlmon_max_planlines Number of plan lines beyond which a plan cannot be monitored

_sqlmon_recycle_time Minimum time (in s) to wait before a plan entry can be recycled

_sqlmon_threshold CPU/IO time threshold before a statement is monitored. 0 is disabled

_sqltune_category_parsed Parsed category qualifier for applying hintsets

_srvntfn_job_deq_timeout srvntfn job deq timeout

_srvntfn_jobsubmit_interval srvntfn job submit interval

_srvntfn_max_concurrent_jobs srvntfn max concurrent jobs

_srvntfn_q_msgcount srvntfn q msg count for job exit

_srvntfn_q_msgcount_inc srvntfn q msg count increase for job submit

_sscr_dir Session State Capture and Restore DIRectory object

_sscr_osdir Session State Capture and Restore OS DIRectory

_sta_control SQL Tuning Advisory control parameter

_stack_guard_level stack guard level

_standby_causal_heartbeat_timeout readable standby causal heartbeat timeout

_standby_flush_mode standby flush mode

_standby_implicit_rcv_timeout minutes to wait for redo during standby implicit recovery

_standby_switchover_timeout Number of secords for standby switchover enqueue timeout

_stat_aggs_one_pass_algorithm enable one pass algorithm for variance-related functions

_static_backgrounds static backgrounds

_statistics_based_srf_enabled enable/disable the use of statistics for storage reduction factor

_step_down_limit_in_pct step down limit in percentage

_streams_pool_max_size streams pool maximum size when auto SGA enabled

_subquery_pruning_cost_factor subquery pruning cost factor

_subquery_pruning_enabled enable the use of subquery predicates to perform pruning

_subquery_pruning_mv_enabled enable the use of subquery predicates with MVs to perform pruning

_subquery_pruning_reduction subquery pruning reduction factor

_suppress_identifiers_on_dupkey supress owner index name err msg

_switch_current_scan_scn switch current uses scan scn

_switchover_timeout Switchover timeout in minutes

_switchover_to_standby_option option for graceful switchover to standby

_switchover_to_standby_switch_log Switchover to standby switches log for open redo threads

_swrf_metric_frequent_mode Enable/disable SWRF Metric Frequent Mode Collection

_swrf_mmon_dbfus Enable/disable SWRF MMON DB Feature Usage

_swrf_mmon_flush Enable/disable SWRF MMON FLushing

_swrf_mmon_metrics Enable/disable SWRF MMON Metrics Collection

_swrf_on_disk_enabled Parameter to enable/disable SWRF

_swrf_test_action test action parameter for SWRF

_swrf_test_dbfus Enable/disable DB Feature Usage Testing

_sync_primary_wait_time wait time for alter session sync with primary

_synonym_repoint_tracing whether to trace metadata comparisons for synonym repointing

_sys_logon_delay failed logon delay for sys

_sysaux_test_param test parameter for SYSAUX

_system_api_interception_debug enable debug tracing for system api interception

_system_index_caching optimizer percent system index caching

_system_trig_enabled are system triggers enabled

_ta_lns_wait_for_arch_log LNS Wait time for arhcived version of online log

_table_lookup_prefetch_size table lookup prefetch vector size

_table_lookup_prefetch_thresh table lookup prefetch threshold

_table_scan_cost_plus_one bump estimated full table scan and index ffs cost by one

_tablespaces_per_transaction estimated number of tablespaces manipulated by each transaction

_target_log_write_size Do log write if this many redo blocks in buffer (auto=0)

_target_log_write_size_timeout How long LGWR will wait for redo to accumulate (csecs)

_target_rba_max_lag_percentage target rba max log lag percentage

_tdb_debug_mode set debug mode for testing transportable database

_temp_tran_block_threshold number of blocks for a dimension before we temp transform

_temp_tran_cache determines if temp table is created with cache option

_temp_undo_disable_adg is temp undo disabled on ADG

_tenth_spare_parameter tenth spare parameter - integer

_test_hm_extent_map heatmap related - to be used by oracle dev only

_test_ksusigskip test the function ksusigskip

_test_param_1 test parmeter 1 - integer

_test_param_2 test parameter 2 - string

_test_param_3 test parameter 3 - string

_test_param_4 test parameter 4 - string list

_test_param_5 test parmeter 5 - deprecated integer

_test_param_6 test parmeter 6 - size (ub8)

_test_param_7 test parameter 7 - big integer list

_test_param_8 test parameter 8 - cdb tests

_third_spare_parameter third spare parameter - integer

_thirteenth_spare_parameter thirteenth spare parameter - integer

_thread_state_change_timeout_pnp Thread state change timeout for PnP instance (in sec)

_threshold_alerts_enable if 1, issue threshold-based alerts

_time_based_rcv_ckpt_target time-based incremental recovery checkpoint target in sec

_time_based_rcv_hdr_update_interval time-based incremental recovery file header update interval in sec

_timemodel_collection enable timemodel collection

_timeout_actions_enabled enables or disables KSU timeout actions

_timer_precision VKTM timer precision in milli-sec

_total_large_extent_memory Total memory for allocating large extents

_tq_dump_period time period for duping of TQ statistics (s)

_trace_buffer_wait_timeouts trace buffer busy wait timeouts

_trace_buffers trace buffer sizes per process

_trace_dump_all_procs if TRUE on error buckets of all processes will be dumped to the current trace fi

                                        le


_trace_dump_client_buckets if TRUE dump client (ie. non-kst) buckets

_trace_dump_cur_proc_only if TRUE on error just dump our process bucket

_trace_dump_static_only if TRUE filter trace dumps to always loaded dlls

_trace_events trace events enabled at startup

_trace_files_public Create publicly accessible trace files

_trace_kqlidp trace kqlidp0 operation

_trace_ktfs Trace ILM Stats Tracking

_trace_ktfs_mem Debug memleak

_trace_navigation_scope enabling trace navigation linking

_trace_pin_time trace how long a current pin is held

_trace_pool_size trace pool size in bytes

_trace_processes enable KST tracing in process

_trace_temp Trace Tempspace Management

_trace_virtual_columns trace virtual columns exprs

_track_metrics_memory Enable/disable Metrics Memory Tracking

_transaction_auditing transaction auditing records generated in the redo log

_transaction_recovery_servers max number of parallel recovery slaves that may be used

_transient_logical_clear_hold_mrp_bit clear KCCDI2HMRP flag during standby recovery

_truncate_optimization_enabled do truncate optimization if set to TRUE

_tsenc_obfuscate_key Encryption key obfuscation in memory

_tsenc_tracing Enable TS encryption tracing

_tsm_connect_string TSM test connect string

_tsm_disable_auto_cleanup Disable TSM auto cleanup actions

_tstz_localtime_bypass Should TTC not convert to LocalTime to preserve Timestamp with Timezone values

_tts_allow_charset_mismatch allow plugging in a tablespace with an incompatible character set

_twelfth_spare_parameter twelfth spare parameter - integer

_twentieth_spare_parameter twentieth spare parameter - string

_twenty-eighth_spare_parameter twenty-eighth spare parameter - boolean

_twenty-fifth_spare_parameter twenty-fifth spare parameter - string list

_twenty-first_spare_parameter twenty-first spare parameter - string list

_twenty-fourth_spare_parameter twenty-fourth spare parameter - string list

_twenty-second_spare_parameter twenty-second spare parameter - string list

_twenty-seventh_spare_parameter twenty-seventh spare parameter - boolean

_twenty-sixth_spare_parameter twenty-sixth spare parameter - boolean

_twenty-third_spare_parameter twenty-third spare parameter - string list

_two_pass enable two-pass thread recovery

_two_pass_reverse_polish_enabled uses two-pass reverse polish alg. to generate canonical forms

_txn_control_trace_buf_size size the in-memory buffer size of txn control

_uga_cga_large_extent_size UGA/CGA large extent size

_ultrafast_latch_statistics maintain fast-path statistics for ultrafast latches

_undo_autotune enable auto tuning of undo_retention

_undo_block_compression enable undo block compression

_undo_debug_mode debug flag for undo related operations

_undo_debug_usage invoke undo usage functions for testing

_unified_audit_flush_interval Unified Audit SGA Queue Flush Interval

_unified_audit_flush_threshold Unified Audit SGA Queue Flush Threshold

_unified_audit_policy_disabled Disable Default Unified Audit Policies on DB Create

_union_rewrite_for_gs expand queries with GSets into UNIONs for rewrite

_unnest_subquery enables unnesting of complex subqueries

_unused_block_compression enable unused block compression

_update_datafile_headers_with_space_info user requested update of datafile headers of locally managed datafiles with spac

rmation e information


_upddel_dba_hash_mask_bits controls masking of lower order bits in DBA

_use_adaptive_log_file_sync Adaptively switch between post/wait and polling

_use_best_fit use best fit to allocate space

_use_column_stats_for_function enable the use of column statistics for DDP functions

_use_hidden_partitions use hidden partitions

_use_hybrid_encryption_mode Enable platform optimized encryption in hybrid mode

_use_ism Enable Shared Page Tables - ISM

_use_ism_for_pga Use ISM for allocating large extents

_use_nosegment_indexes use nosegment indexes in explain plan

_use_platform_compression_lib Enable platform optimized compression implementation

_use_platform_encryption_lib Enable platform optimized encryption implementation

_use_realfree_heap use real-free based allocator for PGA memory

_use_seq_process_cache whether to use process local seq cache

_use_single_log_writer Use a single process for redo log writing

_use_vector_post use vector post

_use_zero_copy_io Should network vector IO interface be used for data transfer

_utlmmig_table_stats_gathering enable/disable utlmmig table stats gathering at upgrade

_uts_first_segment_retain Should we retain the first trace segment

_uts_first_segment_size Maximum size (in bytes) of first segments

_uts_trace_disk_threshold Trace disk threshold parameter

_uts_trace_segment_size Maximum size (in bytes) of a trace segment

_uts_trace_segments Maximum number of trace segments

_validate_flashback_database Scan database to validate result of flashback database

_validate_metric_groups Enable/disable SGA Metric Structure validation

_validate_readmem_redo validate redo blocks read from in-memory log buffer

_vendor_lib_loc Vendor library search root directory

_verify_fg_log_checksum LGWR verifies redo checksums generated by foreground processes

_verify_flashback_redo Verify that the redo logs needed for flashback are available

_verify_undo_quota TRUE - verify consistency of undo quota statistics

_very_large_object_threshold upper threshold level of object size for direct reads

_very_large_partitioned_table very_large_partitioned_table

_virtual_column_overload_allowed overload virtual columns expression

_vkrm_schedule_interval VKRM scheduling interval

_vktm_assert_thresh soft assert threshold VKTM timer drift

_wait_breakup_threshold_csecs Wait breakup threshold (in centiseconds)

_wait_breakup_time_csecs Wait breakup time (in centiseconds)

_wait_for_sync wait for sync on commit MUST BE ALWAYS TRUE

_wait_samples_max_sections Wait Samples maximum sections

_wait_samples_max_time_secs Wait Samples maximum time in seconds

_wait_tracker_interval_secs Wait Tracker number of seconds per interval

_wait_tracker_num_intervals Wait Tracker number of intervals

_wait_yield_hp_mode Wait Yield - High Priority Mode

_wait_yield_mode Wait Yield - Mode

_wait_yield_sleep_freq Wait Yield - Sleep Frequency

_wait_yield_sleep_time_msecs Wait Yield - Sleep Time (in milliseconds)

_wait_yield_yield_freq Wait Yield - Yield Frequency

_walk_insert_threshold maximum number of unusable blocks to walk across freelist

_watchpoint_on is the watchpointing feature turned on?

_wcr_control Oracle internal test WCR parameter used ONLY for testing!

_wcr_grv_cache_size Oracle internal: Set the replay cache size for WRR$_REPLAY_DATA.

_wcr_seq_cache_size Oracle internal: Set the replay cache size for WRR$_REPLAY_SEQ_DATA.

_widetab_comp_enabled wide table compression enabled

_windowfunc_optimization_settings settings for window function optimizations

_with_subquery WITH subquery transformation

_write_clones write clones flag

_xa_internal_retries number of internal retries for xa transactions

_xds_max_child_cursors Maximum number of XDS user-specific child cursors

_xengem_devname override default VM GEM device name used by skgvm

_xengem_diagmode set to OFF to disable VM GEM support and functionalities

_xengem_enabled Enable OVM GEM support

_xpl_peeked_binds_log_size maximum bytes for logging peeked bind values for V$SQL_PLAN (0 = OFF)

_xpl_trace Explain Plan tracing parameter

_xs_cleanup_task Triton Session Cleanup

_xs_dispatcher_only XS dispatcher only mode

_xsolapi_auto_materialization_bound OLAP API lower bound for auto materialization.

_xsolapi_auto_materialization_type OLAP API behavior for auto materialization

_xsolapi_build_trace OLAP API output build info to trace file

_xsolapi_debug_output OLAP API debug output disposition

_xsolapi_densify_cubes OLAP API cube densification

_xsolapi_dimension_group_creation OLAP API symmetric overfetch

_xsolapi_dml_trace OLAP API output dml commands and expressions to trace file

_xsolapi_fetch_type OLAP API fetch type

_xsolapi_fix_vptrs OLAP API Enable vptr fixing logic in shared server mode

_xsolapi_generate_with_clause OLAP API generates WITH clause?

_xsolapi_hierarchy_value_type OLAP API hierarchy value type

_xsolapi_load_at_process_start When to load OLAP API library at server process start

_xsolapi_materialization_rowcache_min_ro OLAP API min number of rows required to use rowcache in query materialization

ws_for_use


_xsolapi_materialize_sources OLAP API Enable source materialization

_xsolapi_metadata_reader_mode OLAP API metadata reader mode

_xsolapi_odbo_mode OLAP API uses ODBO mode?

_xsolapi_opt_aw_position OLAP API enables AW position and count optimization?

_xsolapi_optimize_suppression OLAP API optimizes suppressions?

_xsolapi_precompute_subquery OLAP API precomputes subqueries?

_xsolapi_remove_columns_for_materializat OLAP API removes columns for materialization?

ion


_xsolapi_set_nls OLAP API sets NLS?

_xsolapi_share_executors OLAP API share executors?

_xsolapi_source_trace OLAP API output Source definitions to trace file

_xsolapi_sql_all_multi_join_non_base_hin OLAP API multi-join non-base hints

ts


_xsolapi_sql_all_non_base_hints OLAP API non-base hints

_xsolapi_sql_auto_dimension_hints OLAP API enable automatic dimension hints

_xsolapi_sql_auto_measure_hints OLAP API enable automatic measure hints

_xsolapi_sql_dimension_hints OLAP API dimension hints

_xsolapi_sql_enable_aw_join OLAP API enables AW join?

_xsolapi_sql_enable_aw_qdr_merge OLAP API enables AW QDR merge?

_xsolapi_sql_hints OLAP API generic hints

_xsolapi_sql_measure_hints OLAP API measure hints

_xsolapi_sql_minus_threshold OLAP API SQL MINUS threshold

_xsolapi_sql_optimize OLAP API enable optimization

_xsolapi_sql_prepare_stmt_cache_size OLAP API prepare statement cache size

_xsolapi_sql_remove_columns OLAP API enable remove unused columns optimizations

_xsolapi_sql_result_set_cache_size OLAP API result set cache size

_xsolapi_sql_symmetric_predicate OLAP API enable symmetric predicate for dimension groups

_xsolapi_sql_top_dimension_hints OLAP API top dimension hints

_xsolapi_sql_top_measure_hints OLAP API top measure hints

_xsolapi_sql_use_bind_variables OLAP API enable bind variables optimization

_xsolapi_stringify_order_levels OLAP API stringifies order levels?

_xsolapi_support_mtm OLAP API MTM mapping classes supported?

_xsolapi_suppression_aw_mask_threshold OLAP API suppression AW mask threshold

_xsolapi_suppression_chunk_size OLAP API suppression chunk size

_xsolapi_use_models OLAP API uses models?

_xsolapi_use_olap_dml OLAP API uses OLAP DML?

_xsolapi_use_olap_dml_for_rank OLAP API uses OLAP DML for rank?

_xt_coverage external tables code coverage parameter

_xt_trace external tables trace parameter

_xtbuffer_size buffer size in KB needed for populate/query operation

_xtts_allow_pre10 allow cross platform for pre10 compatible tablespace

_xtts_set_platform_info set cross platform info during file header read

_zonemap_control control different uses/algorithms related to zonemaps

_zonemap_staleness_tracking control the staleness tracking of zonemaps via trigger

_zonemap_use_enabled enable the use of zonemaps for IO pruning