select
ksppinm,
ksppdesc
from
x$ksppi
where
substr(ksppinm,1,1) = '_'
order by
1,2;
-----------------------------------------------------------------------------
| Parameter | Description |
| _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 |
| _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 |
| __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_recovery_on_join | if TRUE, abort recovery on join reconfigurations |
| _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 | Threshold for frequent log file sync mode switches (per minute) |
| _adaptive_log_file_sync_poll_aggressiveness | Polling interval selection bias (conservative=0, aggressive=100) |
| _adaptive_log_file_sync_sched_delay_window | Window (in seconds) for measuring average scheduling delay |
| _adaptive_log_file_sync_use_polling_threshold | Ratio of redo synch time to expected poll time as a percentage |
| _adaptive_log_file_sync_use_postwait_threshold | Percentage of foreground load from when post/wait was last used |
| _add_col_optim_enabled | Allows new add column 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 |
| _adjust_literal_replacement | If TRUE, we will adjust the SQL/PLUS output |
| _adr_migrate_runonce | Enable/disable ADR Migrate Runonce action |
| _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_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 |
| _and_pruning_enabled | allow partition pruning based on multiple mechanisms |
| _app_ctx_vers | enable app ctx versioning |
| _appqos_qt | System Queue time retrieval interval |
| _aq_max_scan_delay | Maximum allowable scan delay for AQ indexes and IOTs |
| _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 |
| _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 written 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 will 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_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_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_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_disk_repair_time | seconds to wait before dropping a failing disk |
| _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_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_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_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_kfioevent | KFIO 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_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_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_repairquantum | quantum (in 3s) used to compute elapsed time for disk drop |
| _asm_reserve_slaves | reserve ASM slaves for CF txns |
| _asm_root_directory | ASM default root directory |
| _asm_runtime_capability_volume_support | runtime capability for volume support returns supported |
| _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_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_usd_batch | ASM USD Update Max Batch Size |
| _asm_wait_time | Max/imum time to wait before asmb exits |
| _asmlib_test | Osmlib test event |
| _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 |
| _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 |
| _available_core_count | number of cores for this instance |
| _avoid_prepare | if TRUE, do not prepare a buffer when the master is local |
| _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_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_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_bufcnt_max | maximum number of buffers used 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_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_public_dba_buffer_size | total size of all public change tracking dba buffers, in bytes |
| _bitmap_or_improvement_enabled | controls extensions to partition pruning for general predicates |
| _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_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 |
| _bloom_max_size | bloom filter maximum size in bytes |
| _bloom_minmax_enabled | enable or disable bloom min max filtering |
| _bloom_predicate_enabled | enables or disables bloom filter predicate pushdown |
| _bloom_predicate_pushdown_to_storage | enables or disables bloom filter predicate pushdown to storage |
| _bloom_pruning_enabled | Enable partition pruning using bloom filtering |
| _bloom_pushing_max | bloom filter pushing size upper bound |
| _bloom_pushing_total_max | bloom filter combined pushing size (DOP x filter size) upper bound |
| _bloom_vector_elements | number of elements in a bloom filter vector |
| _bmr_prefered_standby | standby db_unique_name prefered for standby BMR |
| _branch_tagging | enable branch tagging for distributed transaction |
| _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_threshold | Flow control threshold for buffered publishers except capture |
| _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_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_threshold | Flow control threshold for capture publishers |
| _case_sensitive_logon | case sensitive logon enabled |
| _causal_standby_wait_timeout | Causal standby wait timeout |
| _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_offload_capabilities_enabled | specifies capability table to load |
| _cell_offload_hybridcolumnar | Query offloading of hybrid columnar compressed tables to exadata |
| _cell_offload_predicate_reordering_enabled | enable out-of-order SQL processing offload 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_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_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_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_ts_threshold | check tablespace thresholds |
| _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 |
| _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 |
| _close_cached_open_cursors | close cursors cached by PL/SQL at each commit |
| _close_deq_by_cond_curs | Close Dequeue By Condition Cursors |
| _cluster_library | cluster library selection |
| _clusterwide_global_transactions | enable/disable clusterwide global transactions |
| _collapse_wait_history | collapse wait history |
| _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 |
| _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 |
| _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_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_tracking_size | control file enqueue holding time tracking 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_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 |
| _create_table_in_any_cluster | allow creation of table in a cluster not owned by the user |
| _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_runtimeheap_memlimit | Shared cursor runtime heap memory limit |
| _cursor_stats_enabled | Enable cursor stats |
| _cvw_enable_weak_checking | enable weak view checking |
| _datafile_cow | Use copy on write snapshot for the renamed file |
| _datafile_write_errors_crash_instance | datafile write errors crash instance |
| _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_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_enabled | Batched IO enable fast longjumps |
| _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_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_noefc | dump reading buffer contents |
| _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_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_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 |
| _dbg_proc_startup | debug process startup |
| _dbms_sql_security_level | Security level in DBMS_SQL |
| _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 |
| _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_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_secs | the minimum wait timeout required for deadlock resolution |
| _deadlock_resolution_signal_process_thresh_secs | the amount of time given to process a deadlock resolution signal |
| _debug_enable | wait for debug |
| _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 |
| _deferred_constant_folding_mode | Deferred constant folding mode |
| _deferred_log_dest_is_valid | consider deferred log dest as valid for log deletion (TRUE/FALSE) |
| _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_uts_control | UTS control parameter |
| _diag_verbose_error_on_init | Allow verbose error tracing on diag init |
| _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_active_influx_move | disable active influx move during parallel media recovery |
| _disable_adaptive_shrunk_aggregation | adaptive shrunk aggregation |
| _disable_appliance_check | Disable checking for appliance bread crumbs |
| _disable_appliance_partnering | Disable partnering mode for appliance |
| _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_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_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_ntlog_events | Disable logging to NT event log |
| _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_compact | disable space usage checks for storage reconfiguration |
| _disable_rebalance_space_check | disable space usage checks for storage reconfiguration |
| _disable_recovery_read_skip | Disable the read optimization during media recovery |
| _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_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_time | number of seconds RECO holds outbound connections open |
| _dlmtrace | Trace string of global enqueue type(s) |
| _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 |
| _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_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_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_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 list |
| _eighth_spare_parameter | eighth spare parameter - integer |
| _eleventh_spare_parameter | eleventh spare parameter - string |
| _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_regular_ntfn_slaves | number of EMON slaves doing regular database notifications |
| _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_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_hwm_sync | enable HWM synchronization |
| _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_online_index_without_s_locking | Allow online index creation algorithm without S DML lock |
| _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_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_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 |
| _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 |
| _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 |
| _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 - string |
| _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_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_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_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 - string |
| _fourth_spare_parameter | fourth spare parameter - integer |
| _frame_cache_time | number of seconds a cached frame page stay in cache. |
| _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_locking | if TRUE, enable object affinity |
| _gc_affinity_locks | if TRUE, get affinity locks |
| _gc_affinity_ratio | dynamic object affinity ratio |
| _gc_async_memcpy | if TRUE, use async memcpy |
| _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_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_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_serve_high_pi_as_current | if TRUE, use a higher clone scn when serving a pi |
| _gc_statistics | if TRUE, kcl statistics are maintained |
| _gc_transfer_ratio | dynamic object read-mostly transfer ratio |
| _gc_tsn_undo_affinity | if TRUE, use TSN undo affinity |
| _gc_undo_affinity | if TRUE, enable dynamic undo affinity |
| _gc_undo_block_disk_reads | if TRUE, enable undo block disk reads |
| _gc_use_cr | if TRUE, allow CR pins on PI and WRITING buffers |
| _gc_vector_read | if TRUE, vector read current buffers |
| _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_high_cpu_threshold | minimum amount of CPU process must consume to be kill target |
| _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_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_pkey_history | number of pkey remastering history |
| _gcs_process_in_recovery | if TRUE, process gcs requests during instance recovery |
| _gcs_res_per_bucket | number of gcs resource per hash bucket |
| _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_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_health_check | if greater than 0 enables GES system health check |
| _ges_num_blockers_to_kill | number of blockers to be killed for hang resolution |
| _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 |
| _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 |
| _hang_analysis_num_call_stacks | hang analysis num call stacks |
| _hang_detection_enabled | Hang Management detection |
| _hang_detection_interval | Hang Management detection interval in seconds |
| _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_log_incidents | Hang Manager incident logging |
| _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_time_limit | Timespan in seconds for current long waiting session trace file |
| _hang_msg_checksum_enabled | enable hang graph message checksum |
| _hang_output_suspected_hangs | Hang Management enabled output of suspected hangs |
| _hang_resolution_confidence_promotion | Hang Management hang resolution confidence promotion |
| _hang_resolution_global_hang_confidence_promotion | Hang Management hang resolution global hang confidence promotion |
| _hang_resolution_policy | Hang Management hang resolution policy |
| _hang_resolution_promote_process_termination | Hang Management hang resolution promote process termination |
| _hang_resolution_scope | Hang Management hang resolution scope |
| _hang_signature_list_match_output_frequency | Hang Signature List matched output frequency |
| _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_threshold | Hang Management statistics high IO percentage threshold |
| _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 |
| _hb_redo_msg_interval | BOC HB redo message interval in ms |
| _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_node_dump_level | the oradebug node dump level for hang manager hang analysis |
| _hm_analysis_oradebug_sys_dump_level | the oradebug system state level for hang manager hang analysis |
| _hm_analysis_output_disk | if TRUE the hang manager outputs hang analysis results to disk |
| _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 |
| _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_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_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_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 |
| _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 |
| _kcfis_block_dump_level | Smart IO block dump level |
| _kcfis_caching_enabled | enable kcfis intra-scan session caching |
| _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_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_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 |
| _kcfis_trace_level | sets kcfis tracing level |
| _kcfis_work_set_appliances | Working Set of appliances in a KCFIS session |
| _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 |
| _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_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_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_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_session | UTS session dump |
| _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 |
| _kebm_nstrikes | kebm # strikes to auto suspend an action |
| _kebm_suspension_time | kebm auto suspension time in seconds |
| _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 |
| _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_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 |
| _kkfi_trace | trace expression substitution |
| _kks_cached_parse_errors | KKS cached parse errors |
| _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 |
| _kql_subheap_trace | tracing level for library cache subheap level pins |
| _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 |
| _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 |
| _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_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_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_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 |
| _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 |
| _kttext_warning | tablespace pre-extension warning threshold in percentage |
| _ktu_latches | number of KTU latches |
| _ku_trace | datapump trace parameter |
| _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_recovery_alignment | align latch recovery structures |
| _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 |
| _left_nested_loops_random | enable random distribution method for left of nestedloops |
| _lgwr_delay_write | LGWR write delay for debugging |
| _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 |
| _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_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_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_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_kill_timeout | enqueue blocker kill timeout |
| _lm_enqueue_freelist | Number of enqueue freelist |
| _lm_enqueue_timeout | enqueue suggested min timeout in seconds |
| _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_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_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_callout | GES idle connection instance check callout |
| _lm_idle_connection_kill | GES idle connection kill |
| _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_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_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_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_ress | number of resources configured for cluster database |
| _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_validate_resource_type | if TRUE enables resource name validation |
| _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_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_security_enabled | log archive security enabled |
| _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_io_size | automatically initiate log write if this many redo blocks in buffer |
| _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 |
| _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 |
| _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_cr_rollbacks | Maximum number of CR rollbacks per block (LMS) |
| _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_io_size | Maximum I/O size in bytes for sequential file accesses |
| _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_pending_scn_bcasts | maximum number of pending SCN broadcasts |
| _max_protocol_support | Max occurrence protocols supported in a process |
| _max_reasonable_scn_rate | Max reasonable SCN rate |
| _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 |
| _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_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_clusterwait_threshold | cluster wait threshold to enter affinity |
| _midtier_affinity_goodness_threshold | goodness gradient threshold to dissolve affinity |
| _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 |
| _minimum_giga_scn | Minimum SCN to start with in 2^30 units |
| _mirror_redo_buffers | Save buffers for debugging redo corruptions |
| _mmv_query_rewrite_enabled | allow rewrites with multiple MVs and/or base tables |
| _module_action_old_length | Use module and action old length parameter |
| _mpmt_enabled | MPMT mode enabled |
| _multi_instance_pmr | force multi instance or single instance parallel recovery |
| _multi_join_key_table_lookup | TRUE iff multi-join-key table lookup prefetch is enabled |
| _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_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_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 |
| _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 |
| _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 list |
| _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 modifies 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 |
| _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_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 |
| _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_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_seqno | enable olapi memory alloc/free history collection pausing |
| _olapi_memory_operation_history_retention | enable olapi memory operation history retention |
| _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 |
| _ols_cleanup_task | Clean up unnecessary entries in OLS sessinfo table |
| _oltp_compression | oltp compression enabled |
| _oltp_compression_gain | oltp compression gain |
| _omf | enable/disable OMF |
| _oneside_colstat_for_equijoins | sanity check on default selectivity for like/range predicate |
| _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_adjust_for_nulls | adjust selectivity for null values |
| _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_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_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_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_group_by_placement | consider group-by placement optimization |
| _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 table |
| _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_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_percent_parallel | optimizer percent parallel |
| _optimizer_purge_stats_iteration_row_count | number of rows to be deleted at each iteration of the stats purging 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_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_use_cbqt_star_transformation | use rewritten star transformation using cbqt framework |
| _optimizer_use_feedback | optimizer use feedback |
| _optimizer_use_subheap | Enables physical optimizer subheap |
| _or_expand_nvl_predicate | enable OR expanded plan for NVL/DECODE predicate |
| _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_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_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_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 |
| _partial_pwise_join_enabled | enable partial partition-wise join when TRUE |
| _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 |
| _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_max_size | Maximum size of the PGA memory for one process |
| _pgactx_cap_stacks | capture stacks for setting pgactx |
| _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 |
| _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 |
| _prescomm | presume commit of IMU transactions |
| _print_refresh_schedule | enable dbms_output of materialized view refresh schedule |
| _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_offload_pecentage | 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_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_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_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_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 | default 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_hold_time | hold px at execution time (unit: second) |
| _px_index_sampling | parallel query sampling for index create (100000 = 100%) |
| _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_kxib_tracing | turn on kxib tracing |
| _px_load_factor | weighted autodop load factor |
| _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,60] |
| _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_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_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_proc_constrain | reduce parallel_max_servers if greater than (processes - fudge) |
| _px_pwg_enabled | parallel partition wise group by enabled |
| _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_slaves_share_cursors | slaves share cursors with QC |
| _px_trace | px trace parameter |
| _px_ual_serial_input | enables new pq for UNION operators |
| _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 |
| _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 |
| _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_module | read-only violation array per module max count |
| _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 | hint for real-free page size in bytes |
| _reasonable_scn_offset_seconds | Reasonable SCN offset seconds |
| _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 |
| _redo_compatibility_check | general and redo/undo compatibility sanity check |
| _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 |
| _release_insert_threshold | maximum number of unusable blocks to unlink from freelist |
| _reliable_block_sends | if TRUE, no side channel on reliable interconnect |
| _relocation_commit_batch_size | ASM relocation commit batch size |
| _remove_aggr_subquery | enables removal of subsumed aggregated subquery |
| _rep_base_path | base path for EM reports in database |
| _replace_virtual_columns | replace expressions with virtual columns |
| _reset_maxcap_history | reset maxcap history time |
| _resource_manager_always_off | disable the resource manager always |
| _resource_manager_always_on | enable 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_duration | result cache auto dml monitoring duration |
| _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_global | Are results available globally across RAC? |
| _result_cache_timeout | maximum time (sec) a session waits for a result |
| _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_restore_through_link | RMAN restore through link |
| _rollback_segment_count | number of undo segments |
| _rollback_segment_initial | starting undo segment number |
| _rollback_stopat | stop at -position to step rollback |
| _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 |
| _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 |
| _rtc_infeasible_threshold | Redo Transport Compression infeasible threshold |
| _sample_rows_per_block | number of rows per block used for sampling IO optimization |
| _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_secs | max exponential backoff time for scn wait interface in kta |
| _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_timers | collect kdlu timers and accumulate per layers |
| _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 |
| _select_any_dictionary_security_enabled | Exclude user$ from SELECT ANY DICTIONARY 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 |
| _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_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 list |
| _seventh_spare_parameter | seventh spare parameter - integer |
| _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 |
| _short_stack_timeout_ms | short stack timeout in ms |
| _show_mgd_recovery_state | Show internal managed recovery state |
| _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 |
| _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 list |
| _sixth_spare_parameter | sixth spare parameter - integer |
| _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 |
| _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_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_min_size | minimum work area size in auto mode |
| _smm_px_max_size | 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 | |
| _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 |
| _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 |
| _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_hash_debug | Hash value of the SQL statement to debug |
| _sql_model_unfold_forloops | specifies compile-time unfolding of sql model forloops |
| _sql_ncg_mode | Optimization mode for SQL NCG |
| _sql_plan_management_control | controls various internal SQL Plan Management algorithms |
| _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 |
| _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 |
| _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 |
| _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_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 |
| _tenth_spare_parameter | tenth spare parameter - integer |
| _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) |
| _third_spare_parameter | third spare parameter - integer |
| _thirteenth_spare_parameter | thirteenth spare parameter - string |
| _threshold_alerts_enable | if 1, issue threshold-based alerts |
| _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 file |
| _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_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_virtual_columns | trace virtual columns exprs |
| _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_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 - string |
| _twentieth_spare_parameter | twentieth 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 |
| _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 |
| _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_information | user requested update of datafile headers of locally managed datafiles with space information |
| _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_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_vector_post | use vector post |
| _use_zero_copy_io | Should network vector IO interface be used for data transfer |
| _validate_flashback_database | Scan database to validate result of flashback database |
| _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! |
| _windowfunc_optimization_settings | settings for window function optimizations |
| _with_subquery | WITH subquery transformation |
| _write_clones | write clones flag |
| _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 |
| _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_rows_for_use | OLAP API min number of rows required to use rowcache in query materialization |
| _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_materialization | OLAP API removes columns for materialization? |
| _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_hints | OLAP API multi-join non-base hints |
| _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 |
No comments:
Post a Comment