前端之家收集整理的这篇文章主要介绍了
Oracle11g版本中未归档隐藏参数,
前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
In this post,I will give a list of all undocumented parameters in Oracle 11g. Here is a query to see all the parameters (documented and undocumented) which contain the string you enter when prompted:
– Enter name of the parameter when prompted
SET linesize 235
col Parameter FOR a50
col SESSION FOR a28
col Instance FOR a55
col S FOR a1
col I FOR a1
col D FOR a1
col Description FOR a90
SELECT
a.ksppinm "Parameter",
decode(p.isses_modifiable,'FALSE',NULL,b.ksppstvl) "Session",
c.ksppstvl "Instance",'F','TRUE','T') "S",
decode(p.issys_modifiable,'T','IMMEDIATE','I','DEFERRED','D') "I",
decode(p.isdefault,'T') "D",
a.ksppdesc "Description"
FROM x$ksppi a,x$ksppcv b,x$ksppsv c,v$parameter p
WHERE a.indx = b.indx AND a.indx = c.indx
AND p.name(+) = a.ksppinm
AND UPPER(a.ksppinm) LIKE UPPER('%&1%')
ORDER BY a.ksppinm;
Enter value for 1:
Here is the list of all undocumented parameters in Oracle 11g :
PARAMETER NAME |
PARAMETER VALUE |
DESCRIPTION |
@H_403_68@_4031_dump_bitvec
@H_403_68@67194879
@H_403_68@bitvec to specify dumps prior to 4031 error
@H_403_68@_4031_dump_interval
@H_403_68@300
@H_403_68@Dump 4031 error once for each n-second interval
@H_403_68@_4031_max_dumps
@H_403_68@100
@H_403_68@Maximum number of 4031 dumps for this process
@H_403_68@_4031_sga_dump_interval
@H_403_68@3600
@H_403_68@Dump 4031 SGA heapdump error once for each n-second interval
@H_403_68@_4031_sga_max_dumps
@H_403_68@10
@H_403_68@Maximum number of SGA heapdumps
@H_403_68@_NUMA_instance_mapping
@H_403_68@Not specified
@H_403_68@Set of nodes that this instance should run on
@H_403_68@_NUMA_pool_size
@H_403_68@aggregate size in bytes of NUMA pool
@H_403_68@_PX_use_large_pool
@H_403_68@FALSE
@H_403_68@Use Large Pool as source of PX buffers
@H_403_68@_UTL_FILE_FOLLOW_SYMLINKS
@H_403_68@UTL_FILE backout event which allows UTL_FILE to open symlinks
@H_403_68@__db_cache_size
@H_403_68@314572800
@H_403_68@Actual size of DEFAULT buffer pool for standard block size buffers
@H_403_68@__dg_broker_service_names
@H_403_68@pdb11_XPT
@H_403_68@service names for broker use
@H_403_68@__java_pool_size
@H_403_68@20971520
@H_403_68@Actual size in bytes of java pool
@H_403_68@__large_pool_size
@H_403_68@4194304
@H_403_68@Actual size in bytes of large pool
@H_403_68@__oracle_base
@H_403_68@/u01/app/oracle
@H_403_68@ORACLE_BASE
@H_403_68@__pga_aggregate_target
@H_403_68@209715200
@H_403_68@Current target size for the aggregate PGA memory consumed
@H_403_68@__sga_target
@H_403_68@629145600
@H_403_68@Actual size of SGA
@H_403_68@__shared_io_pool_size
@H_403_68@0
@H_403_68@Actual size of shared IO pool
@H_403_68@__shared_pool_size
@H_403_68@281018368
@H_403_68@Actual size in bytes of shared pool
@H_403_68@__streams_pool_size
@H_403_68@Actual size in bytes of streams pool
@H_403_68@_abort_recovery_on_join
@H_403_68@if TRUE,abort recovery on join reconfigurations
@H_403_68@_accept_versions
@H_403_68@
@H_403_68@List of parameters for rolling operation
@H_403_68@_active_standby_fast_reconfiguration
@H_403_68@TRUE
@H_403_68@if TRUE optimize dlm reconfiguration for active/standby OPS
@H_403_68@_adaptive_direct_read
@H_403_68@Adaptive Direct Read
@H_403_68@_adaptive_fetch_enabled
@H_403_68@enable/disable adaptive fetch in parallel group by
@H_403_68@_add_col_optim_enabled
@H_403_68@Allows new add column optimization
@H_403_68@_add_stale_mv_to_dependency_list
@H_403_68@add stale mv to dependency list
@H_403_68@_addm_auto_enable
@H_403_68@governs whether ADDM gets run automatically after every AWR snapshot
@H_403_68@_addm_skiprules
@H_403_68@comma-separated list of ADDM nodes to skip
@H_403_68@_addm_version_check
@H_403_68@governs whether ADDM checks the input AWR snapshot version
@H_403_68@_adjust_literal_replacement
@H_403_68@If TRUE,we will adjust the sql/PLUS output
@H_403_68@_affinity_on
@H_403_68@enable/disable affinity at run time
@H_403_68@_aiowait_timeouts
@H_403_68@Number of aiowait timeouts before error is reported
@H_403_68@_alert_expiration
@H_403_68@604800
@H_403_68@seconds before an alert message is moved to exception queue
@H_403_68@_alert_message_cleanup
@H_403_68@1
@H_403_68@Enable Alert Message Cleanup
@H_403_68@_alert_message_purge
@H_403_68@Enable Alert Message Purge
@H_403_68@_alert_post_background
@H_403_68@Enable Background Alert Posting
@H_403_68@_all_shared_dblinks
@H_403_68@treat all dblinks as shared
@H_403_68@_allocate_creation_order
@H_403_68@should files be examined in creation order during allocation
@H_403_68@_allocation_update_interval
@H_403_68@3
@H_403_68@interval at which successful search in L1 should be updated
@H_403_68@_allow_commutativity
@H_403_68@allow for commutativity of +,* when comparing expressions
@H_403_68@_allow_drop_snapshot_standby_grsp
@H_403_68@Allow dropping snapshot standby guaranteed restore point
@H_403_68@_allow_error_simulation
@H_403_68@Allow error simulation for testing
@H_403_68@_allow_level_without_connect_by
@H_403_68@allow level without connect by
@H_403_68@_allow_read_only_corruption
@H_403_68@allow read-only open even if database is corrupt
@H_403_68@_allow_resetlogs_corruption
@H_403_68@allow resetlogs even if it will cause corruption
@H_403_68@_allow_sage_attr
@H_403_68@Allow checking Disk Group SAGE Attr
@H_403_68@_allow_terminal_recovery_corruption
@H_403_68@Finish terminal recovery even if it may cause corruption
@H_403_68@_alternate_iot_leaf_block_split_points
@H_403_68@enable alternate index-organized table leaf-block split-points
@H_403_68@_always_anti_join
@H_403_68@CHOOSE
@H_403_68@always use this method for anti-join when possible
@H_403_68@_always_semi_join
@H_403_68@always use this method for semi-join when possible
@H_403_68@_always_star_transformation
@H_403_68@always favor use of star transformation
@H_403_68@_app_ctx_vers
@H_403_68@enable app ctx versioning
@H_403_68@_aq_tm_scanlimit
@H_403_68@scan limit for Time Managers to clean up IOT
@H_403_68@_arch_corrupted_redo_log
@H_403_68@Variable to simulate corruption errors during archivals
@H_403_68@_arch_io_slaves
@H_403_68@ARCH I/O slaves
@H_403_68@_array_update_vector_read_enabled
@H_403_68@Enable array update vector read
@H_403_68@_ash_disk_filter_ratio
@H_403_68@Ratio of the number of in-memory samples to the number of samples actually written to disk
@H_403_68@_ash_disk_write_enable
@H_403_68@To enable or disable Active Session History flushing
@H_403_68@_ash_dummy_test_param
@H_403_68@Oracle internal dummy ASH parameter used ONLY for testing!
@H_403_68@_ash_eflush_trigger
@H_403_68@66
@H_403_68@The percentage above which if the in-memory ASH is full the emergency flusher will be triggered
@H_403_68@_ash_enable
@H_403_68@To enable or disable Active Session sampling and flushing
@H_403_68@_ash_min_mmnl_dump
@H_403_68@90
@H_403_68@Minimum Time interval passed to consider MMNL Dump
@H_403_68@_ash_sample_all
@H_403_68@To enable or disable sampling every connected session including ones waiting for idle waits
@H_403_68@_ash_sampling_interval
@H_403_68@1000
@H_403_68@Time interval between two successive Active Session samples in millisecs
@H_403_68@_ash_size
@H_403_68@1048618
@H_403_68@To set the size of the in-memory Active Session History buffers
@H_403_68@_asm_acd_chunks
@H_403_68@initial ACD chunks created
@H_403_68@_asm_allow_only_raw_disks
@H_403_68@Discovery only raw devices
@H_403_68@_asm_allow_resilver_corruption
@H_403_68@Enable disk resilvering for external redundancy
@H_403_68@_asm_ausize
@H_403_68@1048576
@H_403_68@allocation unit size
@H_403_68@_asm_blksize
@H_403_68@4096
@H_403_68@Metadata block size
@H_403_68@_asm_compatibility
@H_403_68@10.1
@H_403_68@default ASM compatibility level
@H_403_68@_asm_dbmsdg_nohdrchk
@H_403_68@dbms_diskgroup.checkfile does not check block headers
@H_403_68@_asm_disk_repair_time
@H_403_68@14400
@H_403_68@seconds to wait before dropping a failing disk
@H_403_68@_asm_emulmax
@H_403_68@10000
@H_403_68@max number of concurrent disks to emulate I/O errors
@H_403_68@_asm_emultimeout
@H_403_68@timeout before emulation begins (in 3s ticks)
@H_403_68@_asm_kfdpevent
@H_403_68@KFDP event
@H_403_68@_asm_kfioevent
@H_403_68@KFIO event
@H_403_68@_asm_libraries
@H_403_68@ufs
@H_403_68@library search order for discovery
@H_403_68@_asm_maxio
@H_403_68@Maximum size of individual I/O request
@H_403_68@_asm_repairquantum
@H_403_68@60
@H_403_68@quantum (in 3s) used to compute elapsed time for disk drop
@H_403_68@_asm_runtime_capability_volume_support
@H_403_68@runtime capability for volume support returns supported
@H_403_68@_asm_skip_resize_check
@H_403_68@skip the checking of the clients for s/w compatibility for resize
@H_403_68@_asm_stripesize
@H_403_68@131072
@H_403_68@ASM file stripe size
@H_403_68@_asm_stripewidth
@H_403_68@8
@H_403_68@ASM file stripe width
@H_403_68@_asm_wait_time
@H_403_68@18
@H_403_68@Max/imum time to wait before asmb exits
@H_403_68@_asmlib_test
@H_403_68@Osmlib test event
@H_403_68@_asmsid
@H_403_68@asm
@H_403_68@ASM instance id
@H_403_68@_assm_default
@H_403_68@ASSM default
@H_403_68@_async_recovery_claims
@H_403_68@_async_recovery_reads |
@H_403_68@_async_ts_threshold |
@H_403_68@check tablespace thresholds asynchronously
@H_403_68@_auto_assign_cg_for_sessions
@H_403_68@auto assign CGs for sessions
@H_403_68@_automatic_maintenance_test
@H_403_68@Enable AUTOTASK Test Mode
@H_403_68@_automemory_broker_interval
@H_403_68@memory broker statistics gathering interval for auto memory
@H_403_68@_autotask_max_window
@H_403_68@480
@H_403_68@Maximum Logical Maintenance Window Length in minutes
@H_403_68@_autotask_min_window
@H_403_68@15
@H_403_68@Minimum Maintenance Window Length in minutes
@H_403_68@_autotune_gtx_idle_time
@H_403_68@600
@H_403_68@idle time to trigger auto-shutdown a gtx background process
@H_403_68@_autotune_gtx_interval
@H_403_68@5
@H_403_68@interval to autotune global transaction background processes
@H_403_68@_autotune_gtx_threshold
@H_403_68@auto-tune threshold for degree of global transaction concurrency
@H_403_68@_avoid_prepare
@H_403_68@_aw_row_source_enabled |
@H_403_68@Enables AW Row Source instead of collection iterator
@H_403_68@_awr_corrupt_mode
@H_403_68@AWR Corrupt Mode
@H_403_68@_awr_disabled_flush_tables
@H_403_68@Disable flushing of specified AWR tables
@H_403_68@_awr_flush_threshold_metrics
@H_403_68@Enable/Disable Flushing AWR Threshold Metrics
@H_403_68@_awr_flush_workload_metrics
@H_403_68@Enable/Disable Flushing AWR Workload Metrics
@H_403_68@_awr_mmon_cpuusage
@H_403_68@Enable/disable AWR MMON cpu Usage Tracking
@H_403_68@_awr_restrict_mode
@H_403_68@AWR Restrict Mode
@H_403_68@_awr_sql_child_limit
@H_403_68@200
@H_403_68@Setting for AWR sql Child Limit
@H_403_68@_b_tree_bitmap_plans
@H_403_68@enable the use of bitmap plans for tables even when the tables only have B-tree indexes
@H_403_68@_backup_disk_io_slaves
@H_403_68@BACKUP Disk I/O slaves
@H_403_68@_backup_encrypt_opt_mode
@H_403_68@4294967294
@H_403_68@specifies encryption block optimization mode
@H_403_68@_backup_io_pool_size
@H_403_68@memory to reserve from the large pool
@H_403_68@_backup_kgc_bufsz
@H_403_68@specifies buffer size to be used by BZIP2 compression
@H_403_68@_backup_kgc_memlevel
@H_403_68@specifies memory level for ZLIB compression
@H_403_68@_backup_kgc_niters
@H_403_68@specifies number of iterations done by BZIP2 compression
@H_403_68@_backup_kgc_perflevel
@H_403_68@specifies compression (performance) level for ZLIB compression
@H_403_68@_backup_kgc_scheme
@H_403_68@ZLIB
@H_403_68@specifies compression scheme
@H_403_68@_backup_kgc_type
@H_403_68@specifies compression type used by kgc BZIP2 compression
@H_403_68@_backup_kgc_windowbits
@H_403_68@specifies window size for ZLIB compression
@H_403_68@_backup_ksfq_bufcnt
@H_403_68@number of the ksfq buffers used for backup/restore
@H_403_68@_backup_ksfq_bufcnt_max
@H_403_68@maximum number of the ksfq buffer used for backup/restore
@H_403_68@_backup_ksfq_bufsz
@H_403_68@size of the ksfq buffer used for backup/restore
@H_403_68@_backup_max_gap_size
@H_403_68@largest gap in an incremental/optimized backup buffer,in bytes
@H_403_68@_bct_bitmaps_per_file
@H_403_68@number of bitmaps to store for each datafile
@H_403_68@_bct_buffer_allocation_max
@H_403_68@104857600
@H_403_68@maximum size of all change tracking buffer allocations,237); padding:6px 10px 6px 0px">_bct_buffer_allocation_min_extents
@H_403_68@mininum number of extents to allocate per buffer allocation
@H_403_68@_bct_buffer_allocation_size
@H_403_68@2097152
@H_403_68@size of one change tracking buffer allocation,237); padding:6px 10px 6px 0px">_bct_chunk_size
@H_403_68@change tracking datafile chunk size,237); padding:6px 10px 6px 0px">_bct_crash_reserve_size
@H_403_68@262144
@H_403_68@change tracking reserved crash recovery SGA space,237); padding:6px 10px 6px 0px">_bct_file_block_size
@H_403_68@block size of change tracking file,237); padding:6px 10px 6px 0px">_bct_file_extent_size
@H_403_68@extent size of change tracking file,237); padding:6px 10px 6px 0px">_bct_fixtab_file
@H_403_68@change tracking file for fixed tables
@H_403_68@_bct_initial_private_dba_buffer_size
@H_403_68@initial number of entries in the private change tracking dba buffers
@H_403_68@_bct_public_dba_buffer_size
@H_403_68@total size of all public change tracking dba buffers,237); padding:6px 10px 6px 0px">_bitmap_or_improvement_enabled
@H_403_68@controls extensions to partition pruning for general predicates
@H_403_68@_block_change_tracking
@H_403_68@change tracking possible
@H_403_68@_blocking_sess_graph_cache_size
@H_403_68@blocking session graph cache size in bytes
@H_403_68@_blocks_per_cache_server
@H_403_68@64
@H_403_68@number of consecutive blocks per global cache server
@H_403_68@_bloom_filter_debug
@H_403_68@debug level for bloom filtering
@H_403_68@_bloom_filter_enabled
@H_403_68@enables or disables bloom filter
@H_403_68@_bloom_predicate_enabled
@H_403_68@enables or disables bloom filter predicate pushdown
@H_403_68@_bloom_pruning_enabled
@H_403_68@Enable partition pruning using bloom filtering
@H_403_68@_bloom_vector_elements
@H_403_68@number of elements in a bloom filter vector
@H_403_68@_bsln_adaptive_thresholds_enabled
@H_403_68@Adaptive Thresholds Enabled
@H_403_68@_bt_mmv_query_rewrite_enabled
@H_403_68@allow rewrites with multiple MVs and base tables
@H_403_68@_buffer_busy_wait_timeout
@H_403_68@buffer busy wait time in centiseconds
@H_403_68@_buffered_publisher_flow_control_threshold
@H_403_68@Flow control threshold for buffered publishers except capture
@H_403_68@_bufq_stop_flow_control
@H_403_68@Stop enforcing flow control for buffered queues
@H_403_68@_build_deferred_mv_skipping_mvlog_update
@H_403_68@DEFERRED MV creation skipping MV log setup update
@H_403_68@_bump_highwater_mark_count
@H_403_68@how many blocks should we allocate per free list on advancing HWM
@H_403_68@_bwr_for_flushed_pi
@H_403_68@_cache_stats_monitor |
@H_403_68@_capture_buffer_size |
@H_403_68@65536
@H_403_68@To set the size of the PGA I/O recording buffers
@H_403_68@_capture_publisher_flow_control_threshold
@H_403_68@Flow control threshold for capture publishers
@H_403_68@_case_sensitive_logon
@H_403_68@case sensitive logon enabled
@H_403_68@_cgs_reconfig_timeout
@H_403_68@CGS reconfiguration timeout interval
@H_403_68@_cgs_send_timeout
@H_403_68@CGS send timeout value
@H_403_68@_cgs_tickets
@H_403_68@CGS messaging tickets
@H_403_68@_check_block_after_checksum
@H_403_68@perform block check after checksum if both are turned on
@H_403_68@_check_block_new_invariant_for_flashback
@H_403_68@check block new invariant for flashback
@H_403_68@_check_ts_threshold
@H_403_68@check tablespace thresholds
@H_403_68@_cleanup_rollback_entries
@H_403_68@no. of undo entries to apply per transaction cleanup
@H_403_68@_client_result_cache_bypass
@H_403_68@bypass the client result cache
@H_403_68@_close_cached_open_cursors
@H_403_68@close cursors cached by PL/sql at each commit
@H_403_68@_cluster_library
@H_403_68@clss
@H_403_68@cluster library selection
@H_403_68@_clusterwide_global_transactions
@H_403_68@enable/disable clusterwide global transactions
@H_403_68@_collapse_wait_history
@H_403_68@collapse wait history
@H_403_68@_collect_undo_stats
@H_403_68@Collect Statistics v$undostat
@H_403_68@_column_compression_factor
@H_403_68@Column compression ratio
@H_403_68@_column_elimination_off
@H_403_68@turn off predicate-only column elimination
@H_403_68@_column_tracking_level
@H_403_68@column usage tracking
@H_403_68@_compilation_call_heap_extent_size
@H_403_68@16384
@H_403_68@Size of the compilation call heaps extents
@H_403_68@_complex_view_merging
@H_403_68@enable complex view merging
@H_403_68@_compression_above_cache
@H_403_68@number of recompression above cache for sanity check
@H_403_68@_compression_advisor
@H_403_68@Compression advisor
@H_403_68@_compression_chain
@H_403_68@50
@H_403_68@percentage of chained rows allowed for Compression
@H_403_68@_controlfile_block_size
@H_403_68@control file block size in bytes
@H_403_68@_controlfile_enqueue_dump
@H_403_68@dump the system states after controlfile enqueue timeout
@H_403_68@_controlfile_enqueue_holding_time
@H_403_68@780
@H_403_68@control file enqueue max holding time in seconds
@H_403_68@_controlfile_enqueue_timeout
@H_403_68@900
@H_403_68@control file enqueue timeout in seconds
@H_403_68@_controlfile_section_init_size
@H_403_68@control file initial section size
@H_403_68@_controlfile_section_max_expand
@H_403_68@control file max expansion rate
@H_403_68@_controlfile_update_check
@H_403_68@OFF
@H_403_68@controlfile update sanity check
@H_403_68@_convert_set_to_join
@H_403_68@enables conversion of set operator to join
@H_403_68@_coord_message_buffer
@H_403_68@parallel recovery coordinator side extra message buffer size
@H_403_68@_corrupted_rollback_segments
@H_403_68@corrupted undo segment list
@H_403_68@_cost_equality_semi_join
@H_403_68@enables costing of equality semi-join
@H_403_68@_cp_num_hash_latches
@H_403_68@connection pool number of hash latches
@H_403_68@_cpu_to_io
@H_403_68@divisor for converting cpu cost to I/O cost
@H_403_68@_cr_grant_global_role
@H_403_68@_cr_grant_local_role |
@H_403_68@AUTO
@H_403_68@turn 3-way CR grants off,make it automatic,or turn it on
@H_403_68@_cr_server_log_flush
@H_403_68@_cursor_bind_capture_area_size |
@H_403_68@400
@H_403_68@maximum size of the cursor bind capture area
@H_403_68@_cursor_bind_capture_interval
@H_403_68@interval (in seconds) between two bind capture for a cursor
@H_403_68@_cursor_db_buffers_pinned
@H_403_68@178
@H_403_68@additional number of buffers a cursor can pin at once
@H_403_68@_cursor_features_enabled
@H_403_68@2
@H_403_68@Shared cursor features enabled bits.
@H_403_68@_cursor_plan_enabled
@H_403_68@enable collection and display of cursor plans
@H_403_68@_cursor_plan_hash_version
@H_403_68@version of cursor plan hash value
@H_403_68@_cursor_plan_unparse_enabled
@H_403_68@enables/disables using unparse to build projection/predicates
@H_403_68@_cursor_stats_bucket
@H_403_68@Hash table buckets for cursor stats (2^).
@H_403_68@_cursor_stats_heap
@H_403_68@4
@H_403_68@Heaps/latches for cursor stats.
@H_403_68@_cvw_enable_weak_checking
@H_403_68@enable weak view checking
@H_403_68@_db_aging_cool_count
@H_403_68@Touch count set when buffer cooled
@H_403_68@_db_aging_freeze_cr
@H_403_68@Make CR buffers always be too cold to keep in cache
@H_403_68@_db_aging_hot_criteria
@H_403_68@Touch count which sends a buffer to head of replacement list
@H_403_68@_db_aging_stay_count
@H_403_68@Touch count set when buffer moved to head of replacement list
@H_403_68@_db_aging_touch_time
@H_403_68@_db_always_check_system_ts
@H_403_68@Always perform block check and checksum for System tablespace
@H_403_68@_db_block_adjcheck
@H_403_68@adjacent cache buffer checks – low blkchk overwrite parameter
@H_403_68@_db_block_adjchk_level
@H_403_68@adjacent cache buffer check level
@H_403_68@_db_block_align_direct_read
@H_403_68@Align Direct Reads
@H_403_68@_db_block_bad_write_check
@H_403_68@enable bad write checks
@H_403_68@_db_block_buffers
@H_403_68@27060
@H_403_68@Number of database blocks cached in memory: hidden parameter
@H_403_68@_db_block_cache_clone
@H_403_68@Always clone data blocks on get (for debugging)
@H_403_68@_db_block_cache_history
@H_403_68@buffer header tracing (non-zero only when debugging)
@H_403_68@_db_block_cache_history_level
@H_403_68@buffer header tracing level
@H_403_68@_db_block_cache_num_umap
@H_403_68@number of unmapped buffers (for tracking swap calls on blocks)
@H_403_68@_db_block_cache_protect
@H_403_68@protect database blocks (true only when debugging)
@H_403_68@_db_block_cache_protect_internal
@H_403_68@protect database blocks (for strictly internal use only)
@H_403_68@_db_block_check_for_debug
@H_403_68@Check more and dump block before image for debugging
@H_403_68@_db_block_check_objtyp
@H_403_68@check objd and typ on cache disk read
@H_403_68@_db_block_corruption_recovery_threshold
@H_403_68@threshold number of block recovery attempts
@H_403_68@_db_block_do_full_mbreads
@H_403_68@do full block read even if some blocks are in cache
@H_403_68@_db_block_hash_buckets
@H_403_68@Number of database block hash buckets
@H_403_68@_db_block_hash_latches
@H_403_68@2048
@H_403_68@Number of database block hash latches
@H_403_68@_db_block_header_guard_level
@H_403_68@number of extra buffer headers to use as guard pages
@H_403_68@_db_block_hi_priority_batch_size
@H_403_68@Fraction of writes for high priority reasons
@H_403_68@_db_block_known_clean_pct
@H_403_68@Initial Percentage of buffers to maintain known clean
@H_403_68@_db_block_lru_latches
@H_403_68@number of lru latches
@H_403_68@_db_block_max_cr_dba
@H_403_68@6
@H_403_68@Maximum Allowed Number of CR buffers per dba
@H_403_68@_db_block_max_scan_pct
@H_403_68@40
@H_403_68@Percentage of buffers to inspect when looking for free
@H_403_68@_db_block_med_priority_batch_size
@H_403_68@Fraction of writes for medium priority reasons
@H_403_68@_db_block_numa
@H_403_68@Number of NUMA nodes
@H_403_68@_db_block_prefetch_fast_longjumps_enabled
@H_403_68@Batched IO enable fast longjumps
@H_403_68@_db_block_prefetch_limit
@H_403_68@Prefetch limit in blocks
@H_403_68@_db_block_prefetch_override
@H_403_68@Prefetch force override in blocks
@H_403_68@_db_block_prefetch_private_cache_enabled
@H_403_68@Batched IO enable private cache
@H_403_68@_db_block_prefetch_quota
@H_403_68@Prefetch quota as a percent of cache size
@H_403_68@_db_block_prefetch_skip_reading_enabled
@H_403_68@Batched IO enable skip reading buffers
@H_403_68@_db_block_table_scan_buffer_size
@H_403_68@Size of shared table scan read buffer
@H_403_68@_db_block_temp_redo
@H_403_68@generate redo for temp blocks
@H_403_68@_db_block_trace_protect
@H_403_68@trace buffer protect calls
@H_403_68@_db_block_vlm_check
@H_403_68@check of rvlm mapping leaks (for debugging)
@H_403_68@_db_block_vlm_leak_threshold
@H_403_68@Threshold for allowable vlm leaks
@H_403_68@_db_blocks_per_hash_latch
@H_403_68@Number of blocks per hash latch
@H_403_68@_db_cache_advice_batch_size
@H_403_68@128
@H_403_68@cache advisory simulation batch size
@H_403_68@_db_cache_advice_sample_factor
@H_403_68@cache advisory sampling factor
@H_403_68@_db_cache_crx_check
@H_403_68@check for costly crx examination functions
@H_403_68@_db_cache_pre_warm
@H_403_68@Buffer Cache Pre-Warm Enabled : hidden parameter
@H_403_68@_db_cache_process_cr_pin_max
@H_403_68@maximum number of cr pins a process may have
@H_403_68@_db_change_notification_enable
@H_403_68@enable db change notification
@H_403_68@_db_disable_temp_encryption
@H_403_68@Diable Temp Encryption for Spills
@H_403_68@_db_fast_obj_check
@H_403_68@enable fast object drop sanity check
@H_403_68@_db_fast_obj_ckpt
@H_403_68@enable fast object checkpoint
@H_403_68@_db_fast_obj_truncate
@H_403_68@enable fast object truncate
@H_403_68@_db_file_direct_io_count
@H_403_68@Sequential I/O buf size
@H_403_68@_db_file_exec_read_count
@H_403_68@multiblock read count for regular clients
@H_403_68@_db_file_format_io_buffers
@H_403_68@Block formatting I/O buf count
@H_403_68@_db_file_noncontig_mblock_read_count
@H_403_68@11
@H_403_68@number of noncontiguous db blocks to be prefetched
@H_403_68@_db_file_optimizer_read_count
@H_403_68@_db_handles
@H_403_68@750
@H_403_68@System-wide simultaneous buffer operations
@H_403_68@_db_handles_cached
@H_403_68@Buffer handles cached each process
@H_403_68@_db_hot_block_tracking
@H_403_68@track hot blocks for hash latch contention
@H_403_68@_db_index_block_checking
@H_403_68@index block checking override parameter
@H_403_68@_db_large_dirty_queue
@H_403_68@25
@H_403_68@Number of buffers which force dirty queue to be written
@H_403_68@_db_lost_write_checking
@H_403_68@Enable scn based lost write detection mechanism
@H_403_68@_db_mttr_advice
@H_403_68@ON
@H_403_68@MTTR advisory
@H_403_68@_db_mttr_partitions
@H_403_68@number of partitions for MTTR advisory
@H_403_68@_db_mttr_sample_factor
@H_403_68@MTTR simulation sampling factor
@H_403_68@_db_mttr_sim_target
@H_403_68@MTTR simulation targets
@H_403_68@_db_mttr_sim_trace_size
@H_403_68@256
@H_403_68@MTTR simulation trace size
@H_403_68@_db_mttr_trace_to_alert
@H_403_68@dump trace entries to alert file
@H_403_68@_db_noarch_disble_optim
@H_403_68@Image redo logging (NOARCHIVEMODE)
@H_403_68@_db_num_evict_waitevents
@H_403_68@number of evict wait events
@H_403_68@_db_obj_enable_ksr
@H_403_68@enable ksr in object checkpoint/reuse
@H_403_68@_db_percent_hot_default
@H_403_68@Percent of default buffer pool considered hot
@H_403_68@_db_percent_hot_keep
@H_403_68@Percent of keep buffer pool considered hot
@H_403_68@_db_percent_hot_recycle
@H_403_68@Percent of recycle buffer pool considered hot
@H_403_68@_db_percpu_create_cachesize
@H_403_68@size of cache created per cpu in deferred cache create
@H_403_68@_db_recovery_temporal_file_dest
@H_403_68@default database recovery temporal file location
@H_403_68@_db_required_percent_fairshare_usage
@H_403_68@percent of fairshare a processor group should always use
@H_403_68@_db_row_overlap_checking
@H_403_68@row overlap checking override parameter for data/index blocks
@H_403_68@_db_todefer_cache_create
@H_403_68@buffer cache deferred create
@H_403_68@_db_writer_chunk_writes
@H_403_68@Number of writes DBWR should wait for
@H_403_68@_db_writer_coalesce_area_size
@H_403_68@2293760
@H_403_68@Size of memory allocated to dbwriter for coalescing writes
@H_403_68@_db_writer_coalesce_write_limit
@H_403_68@Limit on size of coalesced write
@H_403_68@_db_writer_flush_imu
@H_403_68@If FALSE,DBWR will not downgrade IMU txns for AGING
@H_403_68@_db_writer_histogram_statistics
@H_403_68@maintain dbwr histogram statistics in x$kcbbhs
@H_403_68@_db_writer_max_writes
@H_403_68@Max number of outstanding DB Writer IOs
@H_403_68@_db_writer_nomemcopy_coalesce
@H_403_68@Enable DBWR no-memcopy coalescing
@H_403_68@_db_writer_verify_writes
@H_403_68@Enable lost write detection mechanism
@H_403_68@_dbg_proc_startup
@H_403_68@debug process startup
@H_403_68@_dbms_sql_security_level
@H_403_68@Security level in DBMS_sql
@H_403_68@_dbwr_async_io
@H_403_68@Enable dbwriter asynchronous writes
@H_403_68@_dbwr_scan_interval
@H_403_68@dbwriter scan interval
@H_403_68@_dbwr_tracing
@H_403_68@Enable dbwriter tracing
@H_403_68@_dde_flood_control_init
@H_403_68@Initialize Flood Control at database open
@H_403_68@_dead_process_scan_interval
@H_403_68@PMON dead process scan interval
@H_403_68@_deadlock_diagnostic_level
@H_403_68@automatic deadlock resolution diagnostics level
@H_403_68@_deadlock_resolution_incidents_enabled
@H_403_68@create incidents during deadlock resolution
@H_403_68@_deadlock_resolution_level
@H_403_68@automatic deadlock resolution level
@H_403_68@_deadlock_resolution_min_wait_timeout_secs
@H_403_68@the minimum wait timeout required for deadlock resolution
@H_403_68@_deadlock_resolution_signal_process_thresh_secs
@H_403_68@the amount of time given to process a deadlock resolution signal
@H_403_68@_dedicated_server_poll_count
@H_403_68@dedicated server poll count
@H_403_68@_dedicated_server_post_wait
@H_403_68@dedicated server post/wait
@H_403_68@_dedicated_server_post_wait_call
@H_403_68@dedicated server post/wait call
@H_403_68@_default_encrypt_alg
@H_403_68@default encryption algorithm
@H_403_68@_default_non_equality_sel_check
@H_403_68@sanity check on default selectivity for like/range predicate
@H_403_68@_defer_log_boundary_ckpt
@H_403_68@defer media recovery checkpoint at log boundary
@H_403_68@_defer_log_count
@H_403_68@Number of log boundaries media recovery checkpoint lags behind
@H_403_68@_delay_index_maintain
@H_403_68@delays index maintenance until after MV is refreshed
@H_403_68@_desired_readmem_rate
@H_403_68@70
@H_403_68@The desired percentage of redo reading from memory
@H_403_68@_diag_adr_auto_purge
@H_403_68@Enable/disable ADR MMON Auto Purging
@H_403_68@_diag_adr_enabled
@H_403_68@Parameter to enable/disable Diag ADR
@H_403_68@_diag_adr_test_param
@H_403_68@Test parameter for Diagnosability
@H_403_68@_diag_backward_compat
@H_403_68@Backward Compatibility for Diagnosability
@H_403_68@_diag_cc_enabled
@H_403_68@Parameter to enable/disable Diag Call Context
@H_403_68@_diag_conf_cap_enabled
@H_403_68@Parameter to enable/disable Diag Configuration Capture
@H_403_68@_diag_daemon
@H_403_68@start DIAG daemon
@H_403_68@_diag_dde_async_age_limit
@H_403_68@diag dde async actions: message age limit (in seconds)
@H_403_68@_diag_dde_async_cputime_limit
@H_403_68@diag dde async actions: action cputime limit (in seconds)
@H_403_68@_diag_dde_async_mode
@H_403_68@diag dde async actions: dispatch mode
@H_403_68@_diag_dde_async_msg_capacity
@H_403_68@1024
@H_403_68@diag dde async actions: message buffer capacity
@H_403_68@_diag_dde_async_msgs
@H_403_68@diag dde async actions: number of preallocated message buffers
@H_403_68@_diag_dde_async_process_rate
@H_403_68@diag dde async actions: message processing rate – per loop
@H_403_68@_diag_dde_async_runtime_limit
@H_403_68@diag dde async actions: action runtime limit (in seconds)
@H_403_68@_diag_dde_async_slaves
@H_403_68@diag dde async actions: max number of concurrent slave processes
@H_403_68@_diag_dde_enabled
@H_403_68@enable DDE handling of critical errors
@H_403_68@_diag_dde_fc_enabled
@H_403_68@Parameter to enable/disable Diag Flood Control
@H_403_68@_diag_dde_fc_implicit_time
@H_403_68@Override Implicit Error Flood Control time parameter
@H_403_68@_diag_dde_fc_macro_time
@H_403_68@Override Macro Error Flood Control time parameter
@H_403_68@_diag_dde_inc_proc_delay
@H_403_68@The minimum delay between two MMON incident sweeps (minutes)
@H_403_68@_diag_diagnostics
@H_403_68@Turn off diag diagnostics
@H_403_68@_diag_dump_timeout
@H_403_68@30
@H_403_68@timeout parameter for SYNC dump
@H_403_68@_diag_hm_rc_enabled
@H_403_68@Parameter to enable/disable Diag HM Reactive Checks
@H_403_68@_diag_hm_tc_enabled
@H_403_68@Parameter to enable/disable Diag HM Test(dummy) Checks
@H_403_68@_diag_uts_control
@H_403_68@UTS control parameter
@H_403_68@_dimension_skip_null
@H_403_68@control dimension skip when null feature
@H_403_68@_direct_path_insert_features
@H_403_68@disable direct path insert features
@H_403_68@_disable_12751
@H_403_68@disable policy timeout error (ORA-12751)
@H_403_68@_disable_adaptive_shrunk_aggregation
@H_403_68@adaptive shrunk aggregation
@H_403_68@_disable_autotune_gtx
@H_403_68@disable autotune global transaction background processes
@H_403_68@_disable_datalayer_sampling
@H_403_68@disable datalayer sampling
@H_403_68@_disable_duplex_link
@H_403_68@Turn off connection duplexing
@H_403_68@_disable_fast_aggregation
@H_403_68@fast aggregation
@H_403_68@_disable_fast_validate
@H_403_68@disable PL/sql fast validation
@H_403_68@_disable_fastopen
@H_403_68@Do Not Use Fastopen
@H_403_68@_disable_fba_qrw
@H_403_68@disable flashback archiver query rewrite
@H_403_68@_disable_fba_wpr
@H_403_68@disable flashback archiver wait for prepared transactions
@H_403_68@_disable_file_locks
@H_403_68@disable file locks for control,data,redo log files
@H_403_68@_disable_flashback_archiver
@H_403_68@disable flashback archiver
@H_403_68@_disable_flashback_wait_callback
@H_403_68@Disable flashback wait callback
@H_403_68@_disable_function_based_index
@H_403_68@disable function-based index matching
@H_403_68@_disable_health_check
@H_403_68@Disable Health Check
@H_403_68@_disable_highres_ticks
@H_403_68@disable high-res tick counter
@H_403_68@_disable_image_check
@H_403_68@Disable Oracle executable image checking
@H_403_68@_disable_incremental_checkpoints
@H_403_68@Disable incremental checkpoints for thread recovery
@H_403_68@_disable_incremental_recovery_ckpt
@H_403_68@Disable incremental recovery checkpoint mechanism
@H_403_68@_disable_index_block_prefetching
@H_403_68@disable index block prefetching
@H_403_68@_disable_instance_params_check
@H_403_68@disable instance type check for ksp
@H_403_68@_disable_interface_checking
@H_403_68@disable interface checking at startup
@H_403_68@_disable_kcb_flashback_blocknew_opt
@H_403_68@Disable KCB flashback block new optimization
@H_403_68@_disable_kcbhxor_osd
@H_403_68@disable kcbh(c)xor OSD functionality
@H_403_68@_disable_kcbl_flashback_blocknew_opt
@H_403_68@Disable KCBL flashback block new optimization
@H_403_68@_disable_latch_free_SCN_writes_via_32cas
@H_403_68@disable latch-free SCN writes using 32-bit compare & swap
@H_403_68@_disable_latch_free_SCN_writes_via_64cas
@H_403_68@disable latch-free SCN writes using 64-bit compare & swap
@H_403_68@_disable_logging
@H_403_68@Disable logging
@H_403_68@_disable_metrics_group
@H_403_68@Disable Metrics Group (or all Metrics Groups)
@H_403_68@_disable_multiple_block_sizes
@H_403_68@disable multiple block size support (for debugging)
@H_403_68@_disable_odm
@H_403_68@disable odm feature
@H_403_68@_disable_parallel_conventional_load
@H_403_68@Disable parallel conventional loads
@H_403_68@_disable_read_only_open_dict_check
@H_403_68@Disable read-only open dictionary check
@H_403_68@_disable_rebalance_space_check
@H_403_68@disable space usage checks for storage reconfiguration
@H_403_68@_disable_recoverable_recovery
@H_403_68@Disable the new recoverable recovery mechanism
@H_403_68@_disable_recovery_read_skip
@H_403_68@Disable the read optimization during media recovery
@H_403_68@_disable_sample_io_optim
@H_403_68@disable row sampling IO optimization
@H_403_68@_disable_savepoint_reset
@H_403_68@disable the fix for bug 1402161
@H_403_68@_disable_sec_ticks
@H_403_68@disable low-res (sec) counter
@H_403_68@_disable_selftune_checkpointing
@H_403_68@Disable self-tune checkpointing
@H_403_68@_disable_streams_pool_auto_tuning
@H_403_68@disable streams pool auto tuning
@H_403_68@_disable_sun_rsm
@H_403_68@Disable IPC OSD support for Sun RSMAPI
@H_403_68@_disable_system_state
@H_403_68@disable system state dump
@H_403_68@_disable_thread_internal_disable
@H_403_68@Disable thread internal disable feature
@H_403_68@_disable_txn_alert
@H_403_68@disable txn layer alert
@H_403_68@_disable_vktm
@H_403_68@disable vktm process
@H_403_68@_disable_wait_stack
@H_403_68@Disable wait stack
@H_403_68@_discrete_transactions_enabled
@H_403_68@enable OLTP mode
@H_403_68@_diskmon_pipe_name
@H_403_68@DiSKMon skgznp pipe name
@H_403_68@_dispatcher_rate_scale
@H_403_68@scale to display rate statistic (100ths of a second)
@H_403_68@_dispatcher_rate_ttl
@H_403_68@time-to-live for rate statistic (100ths of a second)
@H_403_68@_distinct_view_unnesting
@H_403_68@enables unnesting of in subquery into distinct view
@H_403_68@_distributed_recovery_connection_hold_time
@H_403_68@number of seconds RECO holds outbound connections open
@H_403_68@_dlmtrace
@H_403_68@Trace string of global enqueue type(s)
@H_403_68@_dm_max_shared_pool_pct
@H_403_68@max percentage of the shared pool to use for a mining model
@H_403_68@_dml_monitoring_enabled
@H_403_68@enable modification monitoring
@H_403_68@_domain_index_batch_size
@H_403_68@2000
@H_403_68@maximum number of rows from one call to domain index fetch routine
@H_403_68@_domain_index_dml_batch_size
@H_403_68@maximum number of rows for one call to domain index dml routines
@H_403_68@_dra_bmr_number_threshold
@H_403_68@Maximum number of BMRs that can be done to a file
@H_403_68@_dra_bmr_percent_threshold
@H_403_68@Maximum percentage of blocks in a file that can be BMR-ed
@H_403_68@_dra_enable_offline_dictionary
@H_403_68@Enable the periodic creation of the offline dictionary for DRA
@H_403_68@_drop_table_granule
@H_403_68@drop_table_granule
@H_403_68@_drop_table_optimization_enabled
@H_403_68@reduce SGA memory use during drop of a partitioned table
@H_403_68@_ds_iocount_iosize
@H_403_68@6553664
@H_403_68@Dynamic Sampling Service defaults: #IOs and IO Size
@H_403_68@_dss_cache_flush
@H_403_68@enable full cache flush for parallel execution
@H_403_68@_dtree_area_size
@H_403_68@size of Decision Tree Classification work area
@H_403_68@_dtree_binning_enabled
@H_403_68@Decision Tree Binning Enabled
@H_403_68@_dtree_bintest_id
@H_403_68@Decision Tree Binning Test ID
@H_403_68@_dtree_compressbmp_enabled
@H_403_68@Decision Tree Using Compressed Bitmaps Enabled
@H_403_68@_dtree_max_surrogates
@H_403_68@maximum number of surrogates
@H_403_68@_dtree_pruning_enabled
@H_403_68@Decision Tree Pruning Enabled
@H_403_68@_dummy_instance
@H_403_68@dummy instance started by RMAN
@H_403_68@_dump_common_subexpressions
@H_403_68@dump common subexpressions
@H_403_68@_dump_connect_by_loop_data
@H_403_68@dump connect by loop error message into trc file
@H_403_68@_dump_cursor_heap_sizes
@H_403_68@dump comp/exec heap sizes to tryace file
@H_403_68@_dump_interval_limit
@H_403_68@120
@H_403_68@trace dump time interval limit (in seconds)
@H_403_68@_dump_max_limit
@H_403_68@max number of dump within dump interval
@H_403_68@_dump_qbc_tree
@H_403_68@dump top level query parse tree to trace
@H_403_68@_dump_rcvr_ipc
@H_403_68@if TRUE enables IPC dump at instance eviction time
@H_403_68@_dump_system_state_scope
@H_403_68@local
@H_403_68@scope of sysstate dump during instance termination
@H_403_68@_dump_trace_scope
@H_403_68@global
@H_403_68@scope of trace dump during a process crash
@H_403_68@_dynamic_rls_policies
@H_403_68@rls policies are dynamic
@H_403_68@_dynamic_stats_threshold
@H_403_68@delay threshold (in seconds) between sending statistics messages
@H_403_68@_edition_based_redefinition
@H_403_68@enable edition based redefinition
@H_403_68@_eliminate_common_subexpr
@H_403_68@enables elimination of common sub-expressions
@H_403_68@_emon_regular_ntfn_slaves
@H_403_68@number of EMON slaves doing regular database notifications
@H_403_68@_enable_NUMA_optimization
@H_403_68@Enable NUMA specific optimizations
@H_403_68@_enable_automatic_maintenance
@H_403_68@if 1,Automated Maintenance Is Enabled
@H_403_68@_enable_automatic_sqltune
@H_403_68@Automatic sql Tuning Advisory enabled parameter
@H_403_68@_enable_block_level_transaction_recovery
@H_403_68@enable block level recovery
@H_403_68@_enable_cscn_caching
@H_403_68@enable commit SCN caching for all transactions
@H_403_68@_enable_ddl_wait_lock
@H_403_68@use this to turn off ddls with wait semantics
@H_403_68@_enable_default_affinity
@H_403_68@to enable default implementation of affinity osds
@H_403_68@_enable_dml_lock_escalation
@H_403_68@enable dml lock escalation against partitioned tables if TRUE
@H_403_68@_enable_exchange_validation_using_check
@H_403_68@use check constraints on the table for validation
@H_403_68@_enable_fast_ref_after_mv_tbs
@H_403_68@enable fast refresh after move tablespace
@H_403_68@_enable_hash_overflow
@H_403_68@TRUE – enable hash cluster overflow based on SIZE
@H_403_68@_enable_hwm_sync
@H_403_68@enable HWM synchronization
@H_403_68@_enable_list_io
@H_403_68@Enable List I/O
@H_403_68@_enable_midtier_affinity
@H_403_68@enable midtier affinity metrics processing
@H_403_68@_enable_nativenet_tcpip
@H_403_68@Enable skgxp driver usage for native net
@H_403_68@_enable_obj_queues
@H_403_68@enable object queues
@H_403_68@_enable_online_index_without_s_locking
@H_403_68@Allow online index creation algorithm without S DML lock
@H_403_68@_enable_query_rewrite_on_remote_objs
@H_403_68@mv rewrite on remote table/view
@H_403_68@_enable_refresh_schedule
@H_403_68@enable or disable MV refresh scheduling (revert to 9.2 behavior)
@H_403_68@_enable_reliable_latch_waits
@H_403_68@Enable reliable latch waits
@H_403_68@_enable_rlb
@H_403_68@enable RLB metrics processing
@H_403_68@_enable_row_shipping
@H_403_68@use the row shipping optimization for wide table selects
@H_403_68@_enable_scn_wait_interface
@H_403_68@use this to turn off scn wait interface in kta
@H_403_68@_enable_separable_transactions
@H_403_68@enable/disable separable transactions
@H_403_68@_enable_shared_pool_durations
@H_403_68@temporary to disable/enable kgh policy
@H_403_68@_enable_shared_server_vector_io
@H_403_68@Enable shared server vector I/O
@H_403_68@_enable_space_preallocation
@H_403_68@enable space pre-allocation
@H_403_68@_enable_spacebg
@H_403_68@enable space management background task
@H_403_68@_enable_tablespace_alerts
@H_403_68@enable tablespace alerts
@H_403_68@_enable_type_dep_selectivity
@H_403_68@enable type dependent selectivity estimates
@H_403_68@_endprot_chunk_comment
@H_403_68@chk 10235 dflt
@H_403_68@chunk comment for selective overrun protection
@H_403_68@_endprot_heap_comment
@H_403_68@hp 10235 dflt
@H_403_68@heap comment for selective overrun protection
@H_403_68@_endprot_subheaps
@H_403_68@selective overrun protection for subeheaps
@H_403_68@_enqueue_deadlock_time_sec
@H_403_68@requests with timeout <= this will not have deadlock detection
@H_403_68@_enqueue_debug_multi_instance
@H_403_68@debug enqueue multi instance
@H_403_68@_enqueue_hash
@H_403_68@375
@H_403_68@enqueue hash table length
@H_403_68@_enqueue_hash_chain_latches
@H_403_68@enqueue hash chain latches
@H_403_68@_enqueue_locks
@H_403_68@2260
@H_403_68@locks for managed enqueues
@H_403_68@_enqueue_resources
@H_403_68@968
@H_403_68@resources for enqueues
@H_403_68@_evolve_plan_baseline_report_level
@H_403_68@TYPICAL
@H_403_68@Level of detail to show in plan verification/evolution report
@H_403_68@_evt_system_event_propagation
@H_403_68@disable system event propagation
@H_403_68@_expand_aggregates
@H_403_68@expand aggregates
@H_403_68@_explain_rewrite_mode
@H_403_68@allow additional messages to be generated during explain rewrite
@H_403_68@_extended_pruning_enabled
@H_403_68@do runtime pruning in iterator if set to TRUE
@H_403_68@_fair_remote_cvt
@H_403_68@if TRUE enables fair remote convert
@H_403_68@_fairness_threshold
@H_403_68@number of times to CR serve before downgrading lock
@H_403_68@_fast_dual_enabled
@H_403_68@enable/disable fast dual
@H_403_68@_fast_full_scan_enabled
@H_403_68@enable/disable index fast full scan
@H_403_68@_fastpin_enable
@H_403_68@enable reference count based fast pins
@H_403_68@_fbda_busy_percentage
@H_403_68@flashback archiver busy percentage
@H_403_68@_fbda_inline2_percentage
@H_403_68@flashback archiver full inline percentage
@H_403_68@_fbda_inline_percentage
@H_403_68@flashback archiver inline percentage
@H_403_68@_fg_iorm_slaves
@H_403_68@ForeGround I/O slaves for IORM
@H_403_68@_fg_log_checksum
@H_403_68@Checksum redo in foreground process
@H_403_68@_fic_algorithm_set
@H_403_68@automatic
@H_403_68@Set Frequent Itemset Counting Algorithm
@H_403_68@_fic_area_size
@H_403_68@size of Frequent Itemset Counting work area
@H_403_68@_fic_max_length
@H_403_68@20
@H_403_68@Frequent Itemset Counting Maximum Itemset Length
@H_403_68@_fic_min_bmsize
@H_403_68@Frequent Itemset Counting Minimum BITMAP Size
@H_403_68@_fic_outofmem_candidates
@H_403_68@Frequent Itemset Counting Out Of Memory Candidates Generation
@H_403_68@_fifth_spare_parameter
@H_403_68@fifth spare parameter – string
@H_403_68@_filemap_dir
@H_403_68@FILEMAP directory
@H_403_68@_first_k_rows_dynamic_proration
@H_403_68@enable the use of dynamic proration of join cardinalities
@H_403_68@_first_spare_parameter
@H_403_68@first spare parameter – integer
@H_403_68@_fix_control
@H_403_68@bug fix control parameter
@H_403_68@_flashback_allow_noarchivelog
@H_403_68@Allow enabling flashback on noarchivelog database
@H_403_68@_flashback_archiver_partition_size
@H_403_68@flashback archiver table partition size
@H_403_68@_flashback_barrier_interval
@H_403_68@1800
@H_403_68@Flashback barrier interval in seconds
@H_403_68@_flashback_copy_latches
@H_403_68@Number of flashback copy latches
@H_403_68@_flashback_format_chunk_mb
@H_403_68@Chunk mega-bytes for formatting flashback logs using sync write
@H_403_68@_flashback_format_chunk_mb_dwrite
@H_403_68@16
@H_403_68@Chunk mega-bytes for formatting flashback logs using delayed write
@H_403_68@_flashback_fuzzy_barrier
@H_403_68@Use flashback fuzzy barrier
@H_403_68@_flashback_generation_buffer_size
@H_403_68@flashback generation buffer size
@H_403_68@_flashback_hint_barrier_percent
@H_403_68@Flashback hint barrier percent
@H_403_68@_flashback_log_io_error_behavior
@H_403_68@Specify Flashback log I/O error behavior
@H_403_68@_flashback_log_min_size
@H_403_68@Minimum flashback log size
@H_403_68@_flashback_log_size
@H_403_68@Flashback log size
@H_403_68@_flashback_logfile_enqueue_timeout
@H_403_68@flashback logfile enqueue timeout for opens
@H_403_68@_flashback_marker_cache_enabled
@H_403_68@Enable flashback database marker cache
@H_403_68@_flashback_marker_cache_size
@H_403_68@328
@H_403_68@Size of flashback database marker cache
@H_403_68@_flashback_max_log_size
@H_403_68@Maximum flashback log size in bytes (OS limit)
@H_403_68@_flashback_max_n_log_per_thread
@H_403_68@Maximum number of flashback logs per flashback thread
@H_403_68@_flashback_max_standby_sync_span
@H_403_68@Maximum time span between standby recovery sync for flashback
@H_403_68@_flashback_n_log_per_thread
@H_403_68@Desired number of flashback logs per flashback thread
@H_403_68@_flashback_standby_barrier_interval
@H_403_68@Flashback standby barrier interval in seconds
@H_403_68@_flashback_verbose_info
@H_403_68@Print verbose information about flashback database
@H_403_68@_flashback_write_max_loop_limit
@H_403_68@Flashback writer loop limit before it returns
@H_403_68@_force_datefold_trunc
@H_403_68@force use of trunc for datefolding rewrite
@H_403_68@_force_hsc_compress
@H_403_68@compress all new created tables
@H_403_68@_force_oltp_compress
@H_403_68@OLTP Compress all new created tables
@H_403_68@_force_rewrite_enable
@H_403_68@control new query rewrite features
@H_403_68@_force_slave_mapping_intra_part_loads
@H_403_68@Force slave mapping for intra partition loads
@H_403_68@_force_temptables_for_gsets
@H_403_68@executes concatenation of rollups using temp tables
@H_403_68@_force_tmp_segment_loads
@H_403_68@Force tmp segment loads
@H_403_68@_forwarded_2pc_threshold
@H_403_68@auto-tune threshold for two-phase commit rate across RAC instances
@H_403_68@_fourth_spare_parameter
@H_403_68@fourth spare parameter – string
@H_403_68@_full_pwise_join_enabled
@H_403_68@enable full partition-wise join when TRUE
@H_403_68@_gby_hash_aggregation_enabled
@H_403_68@enable group-by and aggregation using hash scheme
@H_403_68@_gby_onekey_enabled
@H_403_68@enable use of one comparison of all group by keys
@H_403_68@_gc_affinity_locking
@H_403_68@_gc_affinity_locks |
@H_403_68@_gc_affinity_ratio |
@H_403_68@dynamic object affinity ratio
@H_403_68@_gc_async_memcpy
@H_403_68@_gc_bypass_readers |
@H_403_68@_gc_check_bscn |
@H_403_68@_gc_coalesce_recovery_reads |
@H_403_68@_gc_defer_time |
@H_403_68@how long to defer down converts for hot buffers
@H_403_68@_gc_dissolve_undo_affinity
@H_403_68@_gc_element_percent |
@H_403_68@110
@H_403_68@global cache element percent
@H_403_68@_gc_global_checkpoint_scn
@H_403_68@_gc_global_lru |
@H_403_68@turn global lru off,237); padding:6px 10px 6px 0px">_gc_initiate_undo_affinity
@H_403_68@_gc_integrity_checks |
@H_403_68@set the integrity check level
@H_403_68@_gc_keep_recovery_buffers
@H_403_68@_gc_latches |
@H_403_68@number of latches per LMS process
@H_403_68@_gc_long_query_threshold
@H_403_68@threshold for long running query
@H_403_68@_gc_maximum_bids
@H_403_68@maximum number of bids which can be prepared
@H_403_68@_gc_policy_minimum
@H_403_68@1500
@H_403_68@dynamic object policy minimum activity per minute
@H_403_68@_gc_policy_time
@H_403_68@how often to make object policy decisions in minutes
@H_403_68@_gc_read_mostly_locking
@H_403_68@_gc_statistics |
@H_403_68@_gc_transfer_ratio |
@H_403_68@dynamic object read-mostly transfer ratio
@H_403_68@_gc_undo_affinity
@H_403_68@_gc_undo_block_disk_reads |
@H_403_68@_gc_use_cr |
@H_403_68@_gc_vector_read |
@H_403_68@_gc_voluntary_down_convert_obj |
@H_403_68@object number for voluntary down-convert
@H_403_68@_gcs_fast_reconfig
@H_403_68@_gcs_latches |
@H_403_68@number of gcs resource hash latches to be allocated per LMS process
@H_403_68@_gcs_process_in_recovery
@H_403_68@_gcs_res_per_bucket |
@H_403_68@number of gcs resource per hash bucket
@H_403_68@_gcs_resources
@H_403_68@number of gcs resources to be allocated
@H_403_68@_gcs_shadow_locks
@H_403_68@number of pcm shadow locks to be allocated
@H_403_68@_gcs_testing
@H_403_68@GCS testing parameter
@H_403_68@_generalized_pruning_enabled
@H_403_68@_ges_dd_debug
@H_403_68@if 1 or higher enables GES deadlock detection debug diagnostics
@H_403_68@_ges_diagnostics
@H_403_68@if TRUE enables GES diagnostics
@H_403_68@_ges_health_check
@H_403_68@if greater than 0 enables GES system health check
@H_403_68@_global_hang_analysis_interval_secs
@H_403_68@the interval at which global hang analysis is run
@H_403_68@_globalindex_pnum_filter_enabled
@H_403_68@enables filter for global index with partition extended Syntax
@H_403_68@_groupby_nopushdown_cut_ratio
@H_403_68@groupby nopushdown cut ratio
@H_403_68@_groupby_orderby_combine
@H_403_68@5000
@H_403_68@groupby/orderby don’t combine threshold
@H_403_68@_gs_anti_semi_join_allowed
@H_403_68@enable anti/semi join for the GS query
@H_403_68@_hang_analysis_num_call_stacks
@H_403_68@hang analysis num call stacks
@H_403_68@_hang_detection
@H_403_68@Hang Management detection interval
@H_403_68@_hang_resolution
@H_403_68@Hang Management hang resolution
@H_403_68@_hard_protection
@H_403_68@if TRUE enable H.A.R.D specific format changes
@H_403_68@_hash_join_enabled
@H_403_68@enable/disable hash join
@H_403_68@_hash_multiblock_io_count
@H_403_68@number of blocks hash join will read/write at once
@H_403_68@_heur_deadlock_resolution_secs
@H_403_68@the heuristic wait time per node for deadlock resolution
@H_403_68@_high_priority_processes
@H_403_68@LMS*|VKTM
@H_403_68@High Priority Process Name Mask
@H_403_68@_high_server_threshold
@H_403_68@high server thresholds
@H_403_68@_hj_bit_filter_threshold
@H_403_68@hash-join bit filtering threshold (0 always enabled)
@H_403_68@_hm_analysis_oradebug_node_dump_level
@H_403_68@the oradebug node dump level for hang manager hang analysis
@H_403_68@_hm_analysis_oradebug_sys_dump_level
@H_403_68@the oradebug system state level for hang manager hang analysis
@H_403_68@_hm_analysis_output_disk
@H_403_68@if TRUE the hang manager outputs hang analysis results to disk
@H_403_68@_hm_log_incidents
@H_403_68@Hang Manager incident logging
@H_403_68@_hm_verification_interval
@H_403_68@the hang manager verification interval
@H_403_68@_hwm_sync_threshold
@H_403_68@HWM synchronization threshold in percentage
@H_403_68@_idl_conventional_index_maintenance
@H_403_68@enable conventional index maintenance for insert direct load
@H_403_68@_idle_session_kill_enabled
@H_403_68@enables or disables resource manager session idle limit checks
@H_403_68@_idxrb_rowincr
@H_403_68@100000000
@H_403_68@proportionality constant for dop vs. rows in index rebuild
@H_403_68@_ignore_desc_in_index
@H_403_68@ignore DESC in indexes,sort those columns ascending anyhow
@H_403_68@_ignore_fg_deps
@H_403_68@ignore fine-grain dependencies during invalidation
@H_403_68@_immediate_commit_propagation
@H_403_68@_improved_outerjoin_card |
@H_403_68@improved outer-join cardinality calculation
@H_403_68@_improved_row_length_enabled
@H_403_68@enable the improvements for computing the average row length
@H_403_68@_imr_active
@H_403_68@Activate Instance Membership Recovery feature
@H_403_68@_imr_avoid_double_voting
@H_403_68@Avoid device voting for CSS reconfig during IMR
@H_403_68@_imr_device_type
@H_403_68@controlfile
@H_403_68@Type of device to be used by IMR
@H_403_68@_imr_disk_voting_interval
@H_403_68@Maximum wait for IMR disk voting (seconds)
@H_403_68@_imr_evicted_member_kill
@H_403_68@IMR issue evicted member kill after a wait
@H_403_68@_imr_evicted_member_kill_wait
@H_403_68@IMR evicted member kill wait time in seconds
@H_403_68@_imr_highload_threshold
@H_403_68@IMR system highload threshold
@H_403_68@_imr_max_reconfig_delay
@H_403_68@Maximum Reconfiguration delay (seconds)
@H_403_68@_imr_splitbrain_res_wait
@H_403_68@Maximum wait for split-brain resolution (seconds)
@H_403_68@_imr_systemload_check
@H_403_68@Perform the system load check during IMR
@H_403_68@_imu_pools
@H_403_68@in memory undo pools
@H_403_68@_in_memory_undo
@H_403_68@Make in memory undo for top level transactions
@H_403_68@_incremental_recovery_ckpt_min_batch
@H_403_68@Minimum number of writes for incremental recovery ckpt every 3 sec
@H_403_68@_index_join_enabled
@H_403_68@enable the use of index joins
@H_403_68@_index_prefetch_factor
@H_403_68@index prefetching factor
@H_403_68@_init_granule_interval
@H_403_68@number of granules to process for deferred cache
@H_403_68@_init_sql_file
@H_403_68@?/rdbms/admin/sql.bsq
@H_403_68@File containing sql statements to execute upon database creation
@H_403_68@_inject_startup_fault
@H_403_68@inject fault in the startup code
@H_403_68@_inline_sql_in_plsql
@H_403_68@inline sql in PL/sql
@H_403_68@_insert_enable_hwm_brokered
@H_403_68@during parallel inserts high water marks are brokered
@H_403_68@_inst_locking_period
@H_403_68@period an instance can retain a newly acquired level1 bitmap
@H_403_68@_interconnect_checksum
@H_403_68@_intrapart_pdml_enabled |
@H_403_68@Enable intra-partition updates/deletes
@H_403_68@_intrapart_pdml_randomlocal_enabled
@H_403_68@Enable intra-partition updates/deletes with random local dist
@H_403_68@_io_resource_manager_always_on
@H_403_68@io resource manager always on
@H_403_68@_io_shared_pool_size
@H_403_68@Size of I/O buffer pool from SGA
@H_403_68@_io_slaves_disabled
@H_403_68@Do not use I/O slaves
@H_403_68@_io_statistics
@H_403_68@_ioq_fanin_multiplier |
@H_403_68@IOQ miss count before a miss exception
@H_403_68@_ior_serialize_fault
@H_403_68@inject fault in the ior serialize code
@H_403_68@_iorm_tout
@H_403_68@IORM scheduler timeout value in msec
@H_403_68@_ioslave_batch_count
@H_403_68@Per attempt IOs picked
@H_403_68@_ioslave_issue_count
@H_403_68@500
@H_403_68@IOs issued before completion check
@H_403_68@_ipc_fail_network
@H_403_68@Simulate cluster network failer
@H_403_68@_ipc_test_failover
@H_403_68@Test transparent cluster network failover
@H_403_68@_ipc_test_mult_nets
@H_403_68@simulate multiple cluster networks
@H_403_68@_job_queue_interval
@H_403_68@Wakeup interval in seconds for job queue co-ordinator
@H_403_68@_k2q_latches
@H_403_68@number of k2q latches
@H_403_68@_kcfis_fault_control
@H_403_68@trace level setting for kcfIS module
@H_403_68@_kcfis_max_appliances
@H_403_68@Max. appliances in a kcfIS session
@H_403_68@_kcfis_oss_io_size
@H_403_68@kcfIS OSS I/O size
@H_403_68@_kcfis_read_buffer_limit
@H_403_68@kcfIS Read Buffer (per session) memory limit in bytes
@H_403_68@_kcfis_trace_level
@H_403_68@_kcfis_work_set_appliances
@H_403_68@Working Set of appliances in a kcfIS session
@H_403_68@_kcl_commit
@H_403_68@_kcl_conservative_log_flush |
@H_403_68@_kcl_debug |
@H_403_68@_kcl_index_split |
@H_403_68@_kdbl_enable_post_allocation |
@H_403_68@allocate dbas after populating data buffers
@H_403_68@_kdi_avoid_block_checking
@H_403_68@avoid index block checking on sensitive opcodes
@H_403_68@_kdli_STOP_bsz
@H_403_68@undocumented parameter for internal use only
@H_403_68@_kdli_STOP_dba
@H_403_68@_kdli_STOP_fsz
@H_403_68@_kdli_STOP_nio
@H_403_68@_kdli_STOP_tsn
@H_403_68@_kdli_allow_corrupt
@H_403_68@allow corrupt filesystem_logging data blocks during read/write
@H_403_68@_kdli_cache_inode
@H_403_68@cache inode state across calls
@H_403_68@_kdli_cache_read_threshold
@H_403_68@minimum lob size for cache->nocache read (0 disables heuristic)
@H_403_68@_kdli_cache_size
@H_403_68@maximum #entries in inode cache
@H_403_68@_kdli_cache_verify
@H_403_68@verify cached inode via deserialization
@H_403_68@_kdli_cache_write_threshold
@H_403_68@minimum lob size for cache->nocache write (0 disables heuristic)
@H_403_68@_kdli_cacheable_length
@H_403_68@minimum lob length for inode cacheability
@H_403_68@_kdli_force_cr
@H_403_68@force CR when reading data blocks of direct-write lobs
@H_403_68@_kdli_force_cr_Meta
@H_403_68@force CR when reading Metadata blocks of direct-write lobs
@H_403_68@_kdli_force_storage
@H_403_68@none
@H_403_68@force storage settings for all lobs
@H_403_68@_kdli_full_readahead_threshold
@H_403_68@maximum lob size for full readahead
@H_403_68@_kdli_inject_assert
@H_403_68@inject asserts into the inode
@H_403_68@_kdli_inject_crash
@H_403_68@inject crashes into the inode
@H_403_68@_kdli_inline_xfm
@H_403_68@allow inline transformed lobs
@H_403_68@_kdli_inode_preference
@H_403_68@data
@H_403_68@inline inode evolution preference (data,headless,lhb)
@H_403_68@_kdli_itree_entries
@H_403_68@#entries in lhb/itree blocks (for testing only)
@H_403_68@_kdli_memory_protect
@H_403_68@trace accesses to inode memory outside kdli API functions
@H_403_68@_kdli_rci_lobmap_entries
@H_403_68@255
@H_403_68@#entries in RCI lobmap before migration to lhb
@H_403_68@_kdli_readahead_limit
@H_403_68@shared/cached IO readahead limit
@H_403_68@_kdli_readahead_strategy
@H_403_68@contig
@H_403_68@shared/cached IO readahead strategy
@H_403_68@_kdli_recent_scn
@H_403_68@use recent (not dependent) scns for block format/allocation
@H_403_68@_kdli_reshape
@H_403_68@reshape an inode to inline or headless on length truncation
@H_403_68@_kdli_safe_callbacks
@H_403_68@invoke inode read/write callbacks safely
@H_403_68@_kdli_sio_async
@H_403_68@asynchronous shared IO
@H_403_68@_kdli_sio_backoff
@H_403_68@use exponential backoff when attempting SIOP allocations
@H_403_68@_kdli_sio_bps
@H_403_68@maximum blocks per IO slot
@H_403_68@_kdli_sio_dop
@H_403_68@degree-of-parallelism in the SIO keep pool
@H_403_68@_kdli_sio_fgio
@H_403_68@reap asynchronous IO in the foreground
@H_403_68@_kdli_sio_fileopen
@H_403_68@nodsync
@H_403_68@shared IO fileopen mode: datasync vs nodatasync vs async
@H_403_68@_kdli_sio_flush
@H_403_68@enable shared IO pool operations
@H_403_68@_kdli_sio_free
@H_403_68@free IO buffers when not in active use
@H_403_68@_kdli_sio_min_read
@H_403_68@shared IO pool read threshold
@H_403_68@_kdli_sio_min_write
@H_403_68@shared IO pool write threshold
@H_403_68@_kdli_sio_nbufs
@H_403_68@maximum #IO buffers to allocate per session
@H_403_68@_kdli_sio_niods
@H_403_68@maximum #IO descriptors to allocate per session
@H_403_68@_kdli_sio_on
@H_403_68@_kdli_sio_pga
@H_403_68@use PGA allocations for direct IO
@H_403_68@_kdli_sio_pga_top
@H_403_68@PGA allocations come from toplevel PGA heap
@H_403_68@_kdli_sio_strategy
@H_403_68@auto
@H_403_68@shared IO strategy: block vs. extent
@H_403_68@_kdli_small_cache_limit
@H_403_68@32
@H_403_68@size limit of small inode cache
@H_403_68@_kdli_sort_dbas
@H_403_68@sort dbas during chunkification
@H_403_68@_kdli_space_cache_limit
@H_403_68@maximum size of the space cache in #blocks
@H_403_68@_kdli_squeeze
@H_403_68@compact lobmap extents with contiguous dbas
@H_403_68@_kdli_timer_dmp
@H_403_68@dump inode timers on session termination
@H_403_68@_kdli_timer_trc
@H_403_68@trace inode timers to uts/tracefile
@H_403_68@_kdli_trace
@H_403_68@inode trace level
@H_403_68@_kdlu_max_bucket_size
@H_403_68@UTS kdlu bucket size
@H_403_68@_kdlu_max_bucket_size_mts
@H_403_68@UTS kdlu bucket size for mts
@H_403_68@_kdlu_trace_layer
@H_403_68@UTS kdlu per-layer trace level
@H_403_68@_kdlu_trace_session
@H_403_68@UTS session dump
@H_403_68@_kdlu_trace_system
@H_403_68@UTS system dump
@H_403_68@_kdlw_enable_ksi_locking
@H_403_68@enable ksi locking for lobs
@H_403_68@_kdlw_enable_write_gathering
@H_403_68@enable lob write gathering for sql txns
@H_403_68@_kdlwp_flush_threshold
@H_403_68@WGC flush threshold in bytes
@H_403_68@_kdlxp_cmp_subunit_size
@H_403_68@size of compression sub-unit in bytes
@H_403_68@_kdlxp_dedup_flush_threshold
@H_403_68@8388608
@H_403_68@deduplication flush threshold in bytes
@H_403_68@_kdlxp_dedup_hash_algo
@H_403_68@SHA1
@H_403_68@secure hash algorithm for deduplication – only on SecureFiles
@H_403_68@_kdlxp_dedup_prefix_threshold
@H_403_68@deduplication prefix hash threshold in bytes
@H_403_68@_kdlxp_lobcompress
@H_403_68@enable lob compression – only on SecureFiles
@H_403_68@_kdlxp_lobdeduplicate
@H_403_68@enable lob deduplication – only on SecureFiles
@H_403_68@_kdlxp_lobdedupvalidate
@H_403_68@enable deduplicate validate – only on SecureFiles
@H_403_68@_kdlxp_lobencrypt
@H_403_68@enable lob encryption – only on SecureFiles
@H_403_68@_kdlxp_min_xfm_size
@H_403_68@32768
@H_403_68@minimum transformation size in bytes
@H_403_68@_kdlxp_mincmp
@H_403_68@minimum comp ratio in pct – only on SecureFiles
@H_403_68@_kdlxp_spare1
@H_403_68@deduplication spare 1
@H_403_68@_kdlxp_xfmcache
@H_403_68@enable xfm cache – only on SecureFiles
@H_403_68@_kdt_buffering
@H_403_68@control kdt buffering for conventional inserts
@H_403_68@_kebm_nstrikes
@H_403_68@kebm # strikes to auto suspend an action
@H_403_68@_kebm_suspension_time
@H_403_68@82800
@H_403_68@kebm auto suspension time in seconds
@H_403_68@_keep_remote_column_size
@H_403_68@remote column size does not get modified
@H_403_68@_kernel_message_network_driver
@H_403_68@kernel message network driver
@H_403_68@_kffmap_hash_size
@H_403_68@size of kffmap_hash table
@H_403_68@_kffmop_hash_size
@H_403_68@size of kffmop_hash table
@H_403_68@_kfm_disable_set_fence
@H_403_68@disable set fence calls and revert to default (process fence)
@H_403_68@_kghdsidx_count
@H_403_68@max kghdsidx count
@H_403_68@_kgl_bucket_count
@H_403_68@9
@H_403_68@index to the bucket count array
@H_403_68@_kgl_debug
@H_403_68@Library cache debugging
@H_403_68@_kgl_features_enabled
@H_403_68@Library cache features enabled bits
@H_403_68@_kgl_fixed_extents
@H_403_68@fixed extent size for library cache memory allocations
@H_403_68@_kgl_hash_collision
@H_403_68@whether KGL hash collision is possible
@H_403_68@_kgl_heap_size
@H_403_68@extent size for library cache heap 0
@H_403_68@_kgl_kqr_cap_so_stacks
@H_403_68@capture stacks for library and row cache state objects
@H_403_68@_kgl_large_heap_warning_threshold
@H_403_68@52428800
@H_403_68@maximum heap size before KGL writes warnings to the alert log
@H_403_68@_kgl_latch_count
@H_403_68@number of library cache latches
@H_403_68@_kgl_message_locks
@H_403_68@RAC message lock count
@H_403_68@_kgl_min_cached_so_count
@H_403_68@Minimum cached SO count. If > 1 can help find SO corruptions
@H_403_68@_kgl_multi_instance_invalidation
@H_403_68@whether KGL to support multi-instance invalidations
@H_403_68@_kgl_multi_instance_lock
@H_403_68@whether KGL to support multi-instance locks
@H_403_68@_kgl_multi_instance_pin
@H_403_68@whether KGL to support multi-instance pins
@H_403_68@_kgl_so_stack_depth
@H_403_68@The depth of the stack capture for SO get or free
@H_403_68@_kgl_time_to_wait_for_locks
@H_403_68@time to wait for locks and pins before timing out
@H_403_68@_kglsim_maxmem_percent
@H_403_68@max percentage of shared pool size to be used for KGL advice
@H_403_68@_kgsb_threshold_size
@H_403_68@16777216
@H_403_68@threshold size for base allocator
@H_403_68@_kgx_latches
@H_403_68@# of mutex latches if CAS is not supported.
@H_403_68@_kgx_spin_count
@H_403_68@third spare parameter – integer
@H_403_68@_kill_controlfile_enqueue_blocker
@H_403_68@enable killing controlfile enqueue blocker on timeout
@H_403_68@_kill_diagnostics_timeout
@H_403_68@timeout delay in seconds before killing enqueue blocker
@H_403_68@_kill_enqueue_blocker
@H_403_68@if greater than 0 enables killing enqueue blocker
@H_403_68@_kill_java_threads_on_eoc
@H_403_68@Kill Java threads and do sessionspace migration at end of call
@H_403_68@_kill_session_dump
@H_403_68@Process dump on kill session immediate
@H_403_68@_kkdlgon_max_iter
@H_403_68@20000
@H_403_68@kkdlgon maximum number of iterations
@H_403_68@_kkfi_trace
@H_403_68@trace expression substitution
@H_403_68@_kks_free_cursor_stat_pct
@H_403_68@percentage of cursor stats buckets to scan on each load,in 1/10th of a percent
@H_403_68@_kks_use_mutex_pin
@H_403_68@Turning on this will make KKS use mutex for cursor pins.
@H_403_68@_kokli_cache_size
@H_403_68@Size limit of Materialized View and Object Table Lookup Cache
@H_403_68@_kolfuseslf
@H_403_68@allow kolf to use slffopen
@H_403_68@_kql_subheap_trace
@H_403_68@tracing level for library cache subheap level pins
@H_403_68@_ksb_disable_diagpid
@H_403_68@disable the call to ksb_diagpid
@H_403_68@_ksb_restart_clean_time
@H_403_68@30000
@H_403_68@process uptime for restarts
@H_403_68@_ksb_restart_policy_times
@H_403_68@0,60,120,240
@H_403_68@process restart policy times in seconds
@H_403_68@_ksd_test_param
@H_403_68@999
@H_403_68@KSD test parmeter
@H_403_68@_ksdxdocmd_default_timeout_ms
@H_403_68@default timeout for internal oradebug commands
@H_403_68@_ksdxdocmd_enabled
@H_403_68@if TRUE ksdxdocmd* invocations are enabled
@H_403_68@_ksdxw_cini_flg
@H_403_68@ksdxw context initialization flag
@H_403_68@_ksdxw_nbufs
@H_403_68@ksdxw number of buffers in buffered mode
@H_403_68@_ksdxw_num_pgw
@H_403_68@number of watchpoints on a per-process basis
@H_403_68@_ksdxw_num_sgw
@H_403_68@number of watchpoints to be shared by all processes
@H_403_68@_ksdxw_stack_depth
@H_403_68@number of PCs to collect in the stack when watchpoint is hit
@H_403_68@_kse_die_timeout
@H_403_68@60000
@H_403_68@amount of time a dying process is spared by PMON (in centi-secs)
@H_403_68@_kse_pc_table_size
@H_403_68@kse pc table cache size
@H_403_68@_kse_signature_entries
@H_403_68@number of entries in the kse stack signature cache
@H_403_68@_kse_signature_limit
@H_403_68@7
@H_403_68@number of stack frames to cache per kse signature
@H_403_68@_kse_snap_ring_size
@H_403_68@ring buffer to debug internal error 17090
@H_403_68@_ksfd_verify_write
@H_403_68@verify asynchronous writes issued through ksfd
@H_403_68@_ksi_trace
@H_403_68@KSI trace string of lock type(s)
@H_403_68@_ksi_trace_bucket
@H_403_68@PRIVATE
@H_403_68@memory tracing: use ksi-private or rdbms-shared bucket
@H_403_68@_ksi_trace_bucket_size
@H_403_68@8192
@H_403_68@size of the KSI trace bucket
@H_403_68@_ksmb_debug
@H_403_68@ksmb debug flags
@H_403_68@_ksmd_protect_mode
@H_403_68@off
@H_403_68@KSMD protect mode for catching stale access
@H_403_68@_ksmg_granule_locking_status
@H_403_68@granule locking status
@H_403_68@_ksmg_granule_size
@H_403_68@granule size in bytes
@H_403_68@_ksmg_lock_check_interval
@H_403_68@timeout action interval in minutes
@H_403_68@_ksmg_lock_reacquire_count
@H_403_68@repeat count for acquisition of locks
@H_403_68@_kspol_tac_timeout
@H_403_68@timeouts for TAC registerd by kspol
@H_403_68@_ksr_unit_test_processes
@H_403_68@number of ksr unit test processes
@H_403_68@_kss_quiet
@H_403_68@if TRUE access violations during kss dumps are not recorded
@H_403_68@_ksu_diag_kill_time
@H_403_68@number of seconds ksuitm waits before killing diag
@H_403_68@_ksuitm_addon_trccmd
@H_403_68@command to execute when dead processes don’t go away
@H_403_68@_ksuitm_dont_kill_dumper
@H_403_68@delay inst. termination to allow processes to dump
@H_403_68@_ksv_max_spawn_fail_limit
@H_403_68@bg slave spawn failure limit
@H_403_68@_ksv_pool_hang_kill_to
@H_403_68@bg slave pool terminate timeout
@H_403_68@_ksv_pool_wait_timeout
@H_403_68@bg slave pool wait limit
@H_403_68@_ksv_spawn_control_all
@H_403_68@control all spawning of background slaves
@H_403_68@_ksvppktmode
@H_403_68@ksv internal pkt test
@H_403_68@_ksxp_diagmode
@H_403_68@set to OFF to disable automatic slowsend diagnostics
@H_403_68@_ksxp_disable_dynamic_loading
@H_403_68@disable dynamic loadin of lib skgxp
@H_403_68@_ksxp_disable_ipc_stats
@H_403_68@disable ipc statistics
@H_403_68@_ksxp_init_stats_bkts
@H_403_68@initial number arrays for ipc statistics
@H_403_68@_ksxp_max_stats_bkts
@H_403_68@max. arrays for ipc statistics
@H_403_68@_ksxp_ping_enable
@H_403_68@_ksxp_ping_polling_time
@H_403_68@_ksxp_reaping
@H_403_68@tune ksxp layer reaping limit
@H_403_68@_ksxp_reporting_process
@H_403_68@LMD0
@H_403_68@reporting process for KSXP
@H_403_68@_ksxp_send_timeout
@H_403_68@set timeout for sends queued with the inter-instance IPC
@H_403_68@_ksxp_skgxp_compat_library_path
@H_403_68@over-ride default location of lib skgxp compat
@H_403_68@_ksxp_skgxp_library_path
@H_403_68@over-ride default location of lib skgxp
@H_403_68@_ksxp_stats_mem_lmt
@H_403_68@limit ipc statistics memory. this parameter is a percentage value
@H_403_68@_ksxp_testing
@H_403_68@KSXP test parameter
@H_403_68@_ksxp_unit_test_byte_transformation
@H_403_68@enable byte transformation unit test
@H_403_68@_ktc_debug
@H_403_68@for ktc debug
@H_403_68@_ktc_latches
@H_403_68@number of ktc latches
@H_403_68@_ktslj_segext_warning
@H_403_68@segment pre-extension warning threshold in percentage
@H_403_68@_ktspsrch_maxsc
@H_403_68@maximum segments supported by space search cache
@H_403_68@_kttext_warning
@H_403_68@tablespace pre-extension warning threshold in percentage
@H_403_68@_ktu_latches
@H_403_68@number of KTU latches
@H_403_68@_ku_trace
@H_403_68@datapump trace parameter
@H_403_68@_large_pool_min_alloc
@H_403_68@16000
@H_403_68@minimum allocation size in bytes for the large allocation pool
@H_403_68@_last_allocation_period
@H_403_68@period over which an instance can retain an active level1 bitmap
@H_403_68@_latch_class_0
@H_403_68@latch class 0
@H_403_68@_latch_class_1
@H_403_68@latch class 1
@H_403_68@_latch_class_2
@H_403_68@latch class 2
@H_403_68@_latch_class_3
@H_403_68@latch class 3
@H_403_68@_latch_class_4
@H_403_68@latch class 4
@H_403_68@_latch_class_5
@H_403_68@latch class 5
@H_403_68@_latch_class_6
@H_403_68@latch class 6
@H_403_68@_latch_class_7
@H_403_68@latch class 7
@H_403_68@_latch_classes
@H_403_68@latch classes override
@H_403_68@_latch_miss_stat_sid
@H_403_68@Sid of process for which to collect latch stats
@H_403_68@_latch_recovery_alignment
@H_403_68@65534
@H_403_68@align latch recovery structures
@H_403_68@_ldr_io_size
@H_403_68@size of write IOs used during a load operation
@H_403_68@_left_nested_loops_random
@H_403_68@enable random distribution method for left of nestedloops
@H_403_68@_lgwr_async_broadcasts
@H_403_68@LGWR Asynchronous Broadcasts enabling boolean flag
@H_403_68@_lgwr_delay_write
@H_403_68@LGWR write delay for debugging
@H_403_68@_lgwr_io_slaves
@H_403_68@LGWR I/O slaves
@H_403_68@_lgwr_max_ns_wt
@H_403_68@Maximum wait time for lgwr to allow NetServer to progress
@H_403_68@_lgwr_ns_nl_max
@H_403_68@Variable to simulate network latency or buffer threshold
@H_403_68@_lgwr_ns_nl_min
@H_403_68@_lgwr_ns_sim_err
@H_403_68@Variable to simulate errors lgwrns
@H_403_68@_lgwr_ta_sim_err
@H_403_68@Variable to simulate errors lgwr true async
@H_403_68@_library_cache_advice
@H_403_68@whether KGL advice should be turned on
@H_403_68@_lightweight_hdrs
@H_403_68@Lightweight headers for redo
@H_403_68@_like_with_bind_as_equality
@H_403_68@treat LIKE predicate with bind as an equality predicate
@H_403_68@_lm_activate_lms_threshold
@H_403_68@threshold value to activate an additional lms
@H_403_68@_lm_asm_enq_hashing
@H_403_68@if TRUE makes ASM use enqueue master hashing for fusion locks
@H_403_68@_lm_better_ddvictim
@H_403_68@GES better deadlock victim
@H_403_68@_lm_cache_lvl0_cleanup
@H_403_68@how often to cleanup level 0 cache res (in sec)
@H_403_68@_lm_cache_res_cleanup
@H_403_68@percentage of cached resources should be cleanup
@H_403_68@_lm_cache_res_type
@H_403_68@TMHWDI
@H_403_68@cache resource: string of lock types(s)
@H_403_68@_lm_checksum_batch_msg
@H_403_68@GES checksum batch messages
@H_403_68@_lm_contiguous_res_count
@H_403_68@number of contiguous blocks that will hash to the same HV bucket
@H_403_68@_lm_dd_interval
@H_403_68@dd time interval in seconds
@H_403_68@_lm_dd_max_search_time
@H_403_68@180
@H_403_68@max dd search time per token
@H_403_68@_lm_dd_scan_interval
@H_403_68@dd scan interval in seconds
@H_403_68@_lm_dd_search_cnt
@H_403_68@number of dd search per token get
@H_403_68@_lm_drm_max_requests
@H_403_68@dynamic remastering maximum affinity requests processed together
@H_403_68@_lm_drm_window
@H_403_68@dynamic remastering bucket window size
@H_403_68@_lm_drm_xlatch
@H_403_68@dynamic remastering forced exclusive latches
@H_403_68@_lm_dynamic_lms
@H_403_68@dynamic lms invocation
@H_403_68@_lm_dynamic_load
@H_403_68@dynamic load adjustment
@H_403_68@_lm_enq_lock_freelist
@H_403_68@Number of ges enqueue element freelist
@H_403_68@_lm_enq_rcfg
@H_403_68@if TRUE enables enqueue reconfiguration
@H_403_68@_lm_enqueue_freelist
@H_403_68@Number of enqueue freelist
@H_403_68@_lm_file_affinity
@H_403_68@mapping between file id and master instance number
@H_403_68@_lm_global_posts
@H_403_68@if TRUE deliver global posts to remote nodes
@H_403_68@_lm_idle_connection_check
@H_403_68@GES idle connection check
@H_403_68@_lm_idle_connection_check_interval
@H_403_68@GES idle connection check interval time
@H_403_68@_lm_idle_connection_kill
@H_403_68@GES idle connection kill
@H_403_68@_lm_lmd_waittime
@H_403_68@default wait time for lmd in centiseconds
@H_403_68@_lm_lmon_nowait_latch
@H_403_68@if TRUE makes lmon get nowait latches with timeout loop
@H_403_68@_lm_lms
@H_403_68@number of background gcs server processes to start
@H_403_68@_lm_lms_waittime
@H_403_68@default wait time for lms in centiseconds
@H_403_68@_lm_locks
@H_403_68@12000
@H_403_68@number of enqueues configured for cluster database
@H_403_68@_lm_master_weight
@H_403_68@master resource weight for this instance
@H_403_68@_lm_max_lms
@H_403_68@max. number of background global cache server processes
@H_403_68@_lm_msg_batch_size
@H_403_68@GES batch message size
@H_403_68@_lm_msg_cleanup_interval
@H_403_68@3000
@H_403_68@GES message buffer cleanup interval time
@H_403_68@_lm_node_join_opt
@H_403_68@cluster database node join optimization in reconfig
@H_403_68@_lm_non_fault_tolerant
@H_403_68@disable cluster database fault-tolerance mode
@H_403_68@_lm_num_pt_buckets
@H_403_68@number of buckets in the object affinity hash table
@H_403_68@_lm_num_pt_latches
@H_403_68@number of latches in the object affinity hash table
@H_403_68@_lm_postevent_buffer_size
@H_403_68@postevent buffer size
@H_403_68@_lm_proc_freeze_timeout
@H_403_68@reconfiguration: process freeze timeout
@H_403_68@_lm_process_batching
@H_403_68@GES implicit process batching for IPC messages
@H_403_68@_lm_procs
@H_403_68@320
@H_403_68@number of client processes configured for cluster database
@H_403_68@_lm_psrcfg
@H_403_68@enable pseudo reconfiguration
@H_403_68@_lm_rcfg_timeout
@H_403_68@1260
@H_403_68@Reconfiguration timeout
@H_403_68@_lm_rcvr_hang_allow_time
@H_403_68@receiver hang allow time in seconds
@H_403_68@_lm_rcvr_hang_check_frequency
@H_403_68@receiver hang check frequency in seconds
@H_403_68@_lm_rcvr_hang_kill
@H_403_68@to kill receiver hang
@H_403_68@_lm_res_hash_bucket
@H_403_68@number of resource hash buckets
@H_403_68@_lm_res_part
@H_403_68@number of resource partition configured for gcs
@H_403_68@_lm_ress
@H_403_68@6000
@H_403_68@number of resources configured for cluster database
@H_403_68@_lm_send_mode
@H_403_68@GES send mode
@H_403_68@_lm_send_queue_batching
@H_403_68@GES send queue message batching
@H_403_68@_lm_send_queue_length
@H_403_68@GES send queue maximum length
@H_403_68@_lm_sendproxy_reserve
@H_403_68@GES percentage of send proxy reserve of send tickets
@H_403_68@_lm_share_lock_opt
@H_403_68@if TRUE enables share lock optimization
@H_403_68@_lm_sq_batch_factor
@H_403_68@GES send queue minimum batching factor
@H_403_68@_lm_sq_batch_type
@H_403_68@GES send queue batching mechanism
@H_403_68@_lm_sq_batch_waittick
@H_403_68@GES send queue batching waittime in tick
@H_403_68@_lm_sync_timeout
@H_403_68@420
@H_403_68@Synchronization timeout for DLM reconfiguration steps
@H_403_68@_lm_ticket_active_sendback
@H_403_68@Flow control ticket active sendback threshold
@H_403_68@_lm_tickets
@H_403_68@GES messaging tickets
@H_403_68@_lm_tx_delta
@H_403_68@TX lock localization delta
@H_403_68@_lm_validate_resource_type
@H_403_68@if TRUE enables resource name validation
@H_403_68@_lm_xids
@H_403_68@352
@H_403_68@number of transaction IDs configured for cluster database
@H_403_68@_lmn_compression
@H_403_68@suppl logging for compression enabled
@H_403_68@_load_without_compile
@H_403_68@NONE
@H_403_68@Load PL/sql or Database objects without compilation
@H_403_68@_local_communication_costing_enabled
@H_403_68@enable local communication costing when TRUE
@H_403_68@_local_communication_ratio
@H_403_68@set the ratio between global and local communication (0..100)
@H_403_68@_local_hang_analysis_interval_secs
@H_403_68@the interval at which local hang analysis is run
@H_403_68@_lock_sga_areas
@H_403_68@Lock specified areas of the SGA in physical memory
@H_403_68@_log_archive_avoid_memcpy
@H_403_68@log archive avoid memcpy
@H_403_68@_log_archive_buffers
@H_403_68@Number of buffers to allocate for archiving
@H_403_68@_log_archive_callout
@H_403_68@archival callout
@H_403_68@_log_archive_compress_enable
@H_403_68@Bypass database rules for enabling archivelog compression
@H_403_68@_log_archive_network_redo_size
@H_403_68@Log archive network redo buffer size used by ARCH
@H_403_68@_log_archive_prot_auto_demote
@H_403_68@log archive protection auto demotion
@H_403_68@_log_archive_security_enabled
@H_403_68@log archive security enabled
@H_403_68@_log_archive_strong_auth
@H_403_68@log archive security strong auth
@H_403_68@_log_blocks_during_backup
@H_403_68@log block images when changed during backup
@H_403_68@_log_buffers_corrupt
@H_403_68@corrupt redo buffers before write
@H_403_68@_log_buffers_debug
@H_403_68@debug redo buffers (slows things down)
@H_403_68@_log_checkpoint_recovery_check
@H_403_68@# redo blocks to verify after checkpoint
@H_403_68@_log_committime_block_cleanout
@H_403_68@Log commit-time block cleanout
@H_403_68@_log_deletion_policy
@H_403_68@mandatory
@H_403_68@archivelog deletion policy for mandatory/all destination
@H_403_68@_log_event_queues
@H_403_68@number of the log writer event queues
@H_403_68@_log_io_size
@H_403_68@automatically initiate log write if this many redo blocks in buffer
@H_403_68@_log_parallelism_dynamic
@H_403_68@Enable dynamic strands
@H_403_68@_log_parallelism_max
@H_403_68@Maximum number of log buffer strands
@H_403_68@_log_private_mul
@H_403_68@Private strand multiplier for log space preallocation
@H_403_68@_log_private_parallelism
@H_403_68@Number of private log buffer strands for zero-copy redo
@H_403_68@_log_private_parallelism_mul
@H_403_68@Active sessions multiplier to deduce number of private strands
@H_403_68@_log_read_buffers
@H_403_68@Number of log read buffers for media recovery
@H_403_68@_log_simultaneous_copies
@H_403_68@number of simultaneous copies into redo buffer(# of copy latches)
@H_403_68@_log_space_errors
@H_403_68@should we report space errors to alert log
@H_403_68@_log_switch_timeout
@H_403_68@Maximum number of seconds redos in the current log could span
@H_403_68@_logout_storm_rate
@H_403_68@number of processes that can logout in a second
@H_403_68@_logout_storm_retrycnt
@H_403_68@maximum retry count for logouts
@H_403_68@_logout_storm_timeout
@H_403_68@timeout in centi-seconds for time to wait between retries
@H_403_68@_longops_enabled
@H_403_68@longops stats enabled
@H_403_68@_low_server_threshold
@H_403_68@low server thresholds
@H_403_68@_ltc_trace
@H_403_68@tracing level for load table conventional
@H_403_68@_master_direct_sends
@H_403_68@31
@H_403_68@direct sends for messages from master (DFS)
@H_403_68@_mav_refresh_consistent_read
@H_403_68@refresh materialized views using consistent read snapshot
@H_403_68@_mav_refresh_double_count_prevented
@H_403_68@materialized view MAV refreshes avoid double counting
@H_403_68@_mav_refresh_opt
@H_403_68@optimizations during refresh of materialized views
@H_403_68@_mav_refresh_unionall_tables
@H_403_68@# tables for union all expansion during materialized view refresh
@H_403_68@_max_arch_lns_wait
@H_403_68@Maximum wait by ARCH to allow NetServer to complete archival
@H_403_68@_max_exponential_sleep
@H_403_68@max sleep during exponential backoff
@H_403_68@_max_io_size
@H_403_68@Maximum I/O size in bytes for sequential file accesses
@H_403_68@_max_large_io
@H_403_68@IORM:max number of large I/O’s to issue
@H_403_68@_max_lns_shutdown_archival_time
@H_403_68@Maximum time spent by LNS to archive last log during shutdown
@H_403_68@_max_protocol_support
@H_403_68@Max occurrence protocols supported in a process
@H_403_68@_max_shrink_obj_stats
@H_403_68@number of segments for which shrink stats will be maintained
@H_403_68@_max_sleep_holding_latch
@H_403_68@max time to sleep while holding a latch
@H_403_68@_max_small_io
@H_403_68@IORM:max number of small I/O’s to issue
@H_403_68@_max_spacebg_slaves
@H_403_68@maximum space management background slaves
@H_403_68@_max_spacebg_tasks
@H_403_68@maximum space management background tasks
@H_403_68@_max_temp_overhead
@H_403_68@max tempspc overhead
@H_403_68@_media_recovery_read_batch
@H_403_68@media recovery block read batch
@H_403_68@_mem_annotation_pr_lev
@H_403_68@private memory annotation collection level
@H_403_68@_mem_annotation_scale
@H_403_68@memory annotation pre-allocation scaling
@H_403_68@_mem_annotation_sh_lev
@H_403_68@shared memory annotation collection level
@H_403_68@_mem_annotation_store
@H_403_68@memory annotation in-memory store
@H_403_68@_mem_std_extent_size
@H_403_68@standard extent size for fixed-size-extent heaps
@H_403_68@_memory_broker_log_stat_entries
@H_403_68@memory broker num stat entries
@H_403_68@_memory_broker_marginal_utility_bc
@H_403_68@12
@H_403_68@Marginal Utility threshold pct for bc
@H_403_68@_memory_broker_marginal_utility_sp
@H_403_68@Marginal Utility threshold pct for sp
@H_403_68@_memory_broker_shrink_heaps
@H_403_68@memory broker allow policy to shrink shared pool
@H_403_68@_memory_broker_shrink_java_heaps
@H_403_68@memory broker allow policy to shrink java pool
@H_403_68@_memory_broker_shrink_streams_pool
@H_403_68@memory broker allow policy to shrink streams pool
@H_403_68@_memory_broker_shrink_timeout
@H_403_68@60000000
@H_403_68@memory broker policy to timeout shrink shared/java pool
@H_403_68@_memory_broker_stat_interval
@H_403_68@memory broker statistics gathering interval for auto sga
@H_403_68@_memory_management_tracing
@H_403_68@trace memory management activity
@H_403_68@_memory_nocancel_defsgareq
@H_403_68@do not cancel deferred sga reqs with auto-memory
@H_403_68@_memory_sanity_check
@H_403_68@partial granule sanity check
@H_403_68@_messages
@H_403_68@message queue resources – dependent on # processes & # buffers
@H_403_68@_midtier_affinity_clusterwait_threshold
@H_403_68@cluster wait threshold to enter affinity
@H_403_68@_midtier_affinity_goodness_threshold
@H_403_68@goodness gradient threshold to dissolve affinity
@H_403_68@_midtier_affinity_timeout
@H_403_68@default timeout for midtier affinity processing
@H_403_68@_minfree_plus
@H_403_68@max percentage of block space + minfree before we mark block full
@H_403_68@_minimal_stats_aggregation
@H_403_68@prohibit stats aggregation at compile/partition maintenance time
@H_403_68@_minimum_blocks_to_shrink
@H_403_68@minimum number freeable blocks for shrink to be present
@H_403_68@_minimum_db_flashback_retention
@H_403_68@Minimum flashback retention
@H_403_68@_minimum_extents_to_shrink
@H_403_68@minimum number freeable extents for shrink to be present
@H_403_68@_minimum_giga_scn
@H_403_68@Minimum SCN to start with in 2^30 units
@H_403_68@_mirror_redo_buffers
@H_403_68@Save buffers for debugging redo corruptions
@H_403_68@_mmv_query_rewrite_enabled
@H_403_68@allow rewrites with multiple MVs and/or base tables
@H_403_68@_multi_instance_pmr
@H_403_68@force multi instance or single instance parallel recovery
@H_403_68@_multi_join_key_table_lookup
@H_403_68@TRUE iff multi-join-key table lookup prefetch is enabled
@H_403_68@_multiple_instance_recovery
@H_403_68@use multiple instances for media recovery
@H_403_68@_mv_refresh_ana
@H_403_68@what percent to analyze after complete/PCT refresh
@H_403_68@_mv_refresh_costing
@H_403_68@rule
@H_403_68@refresh decision based on cost or on rules
@H_403_68@_mv_refresh_delta_fraction
@H_403_68@delta mv as fractional percentage of size of mv
@H_403_68@_mv_refresh_eut
@H_403_68@refresh materialized views using EUT(partition)-based algorithm
@H_403_68@_mv_refresh_force_parallel_query
@H_403_68@force materialized view refreshes to use parallel query
@H_403_68@_mv_refresh_new_setup_disabled
@H_403_68@materialized view MV refresh new setup disabling
@H_403_68@_mv_refresh_rebuild_percentage
@H_403_68@minimum percentage change required in MV to force an indexrebuild
@H_403_68@_mv_refresh_selections
@H_403_68@create materialized views with selections and fast refresh
@H_403_68@_mv_refresh_use_stats
@H_403_68@pass cardinality hints to refresh queries
@H_403_68@_mv_refsched_timeincr
@H_403_68@300000
@H_403_68@proportionality constant for dop vs. time in MV refresh
@H_403_68@_mv_rolling_inv
@H_403_68@create/alter mv uses rolling cursor invalidation instead of immediate
@H_403_68@_mwin_schedule
@H_403_68@Enable/disable Maintenance Window Schedules
@H_403_68@_nchar_imp_cnv
@H_403_68@NLS allow Implicit Conversion between CHAR and NCHAR
@H_403_68@_nchar_imp_conv
@H_403_68@should implicit conversion bewteen clob and nclob be allowed
@H_403_68@_ncmb_readahead_enabled
@H_403_68@enable multi-block readahead for an index scan
@H_403_68@_ncmb_readahead_tracing
@H_403_68@turn on multi-block readahead tracing
@H_403_68@_ncomp_shared_objects_dir
@H_403_68@native compilation shared objects dir
@H_403_68@_nested_loop_fudge
@H_403_68@nested loop fudge
@H_403_68@_nested_mav_fast_oncommit_enabled
@H_403_68@nested MAV refresh fast on commit allowed
@H_403_68@_new_initial_join_orders
@H_403_68@enable initial join orders based on new ordering heuristics
@H_403_68@_new_sort_cost_estimate
@H_403_68@enables the use of new cost estimate for sort
@H_403_68@_newsort_enabled
@H_403_68@controls whether new sorts can be used as system sort
@H_403_68@_newsort_ordered_pct
@H_403_68@63
@H_403_68@controls when new sort avoids sorting ordered input
@H_403_68@_newsort_type
@H_403_68@specifies options for the new sort algorithm
@H_403_68@_nlj_batching_enabled
@H_403_68@enable batching of the RHS IO in NLJ
@H_403_68@_nlj_batching_misses_enabled
@H_403_68@enable exceptions for buffer cache misses
@H_403_68@_no_objects
@H_403_68@no object features are used
@H_403_68@_no_or_expansion
@H_403_68@OR expansion during optimization disabled
@H_403_68@_no_recovery_through_resetlogs
@H_403_68@no recovery through this resetlogs operation
@H_403_68@_notify_crs
@H_403_68@notify cluster ready services of startup and shutdown
@H_403_68@_ns_max_flush_wt
@H_403_68@Flush wait time for NetServer to flush oustanding writes
@H_403_68@_ns_max_send_delay
@H_403_68@Data Loss Time Bound for NetServer
@H_403_68@_num_longop_child_latches
@H_403_68@number of child latches for long op array
@H_403_68@_number_cached_attributes
@H_403_68@maximum number of cached attributes per instance
@H_403_68@_object_reuse_bast
@H_403_68@if 1 or higher,handle object reuse
@H_403_68@_object_statistics
@H_403_68@enable the object level statistics collection
@H_403_68@_object_stats_max_entries
@H_403_68@3072
@H_403_68@Maximum number of entries to be tracked per stat
@H_403_68@_offline_rollback_segments
@H_403_68@offline undo segment list
@H_403_68@_ogms_home
@H_403_68@GMS home directory
@H_403_68@_olap_aggregate_buffer_size
@H_403_68@OLAP Aggregate max buffer size
@H_403_68@_olap_aggregate_flags
@H_403_68@OLAP Aggregate debug flags
@H_403_68@_olap_aggregate_function_cache_enabled
@H_403_68@OLAP Aggregate function cache enabler
@H_403_68@_olap_aggregate_function_merge_threshold
@H_403_68@529
@H_403_68@OLAP Aggregate function merge threshold
@H_403_68@_olap_aggregate_max_thread_tuples
@H_403_68@OLAP Aggregate max thread tuples creation
@H_403_68@_olap_aggregate_min_buffer_size
@H_403_68@OLAP Aggregate min buffer size
@H_403_68@_olap_aggregate_min_thread_status
@H_403_68@OLAP Aggregate minimum cardinality of dimensions for thread
@H_403_68@_olap_aggregate_multipath_hier
@H_403_68@OLAP Aggregate Multi-path Hierarhies enabled
@H_403_68@_olap_aggregate_statlen_thresh
@H_403_68@OLAP Aggregate status array usage threshold
@H_403_68@_olap_aggregate_store_probability
@H_403_68@OLAP Aggregate function storeback probability
@H_403_68@_olap_aggregate_work_per_thread
@H_403_68@OLAP Aggregate max work parents
@H_403_68@_olap_aggregate_worklist_max
@H_403_68@OLAP Aggregate max worklists generated at once
@H_403_68@_olap_allocate_errorlog_format
@H_403_68@%8p %8y %8z %e (%n)
@H_403_68@OLAP Allocate Errorlog Format
@H_403_68@_olap_allocate_errorlog_header
@H_403_68@Dim Source Basis %-8d %-8s %-8b Description ——– ——– ——– ———–
@H_403_68@OLAP Allocate Errorlog Header format
@H_403_68@_olap_analyze_max
@H_403_68@OLAP DML ANALYZE command max cells to analyze
@H_403_68@_olap_continuous_trace_file
@H_403_68@Specify TRUE to enable continuous OLAP tracing – otherwise only exceptional events will be logged
@H_403_68@_olap_dbgoutfile_echo_to_eventlog
@H_403_68@OLAP DbgOutfile copy output to event log (tracefile)
@H_403_68@_olap_dimension_corehash_class
@H_403_68@OLAP Dimension In-Core Hash Table Class
@H_403_68@_olap_dimension_corehash_large
@H_403_68@50000
@H_403_68@OLAP Dimension In-Core Hash Table Large Threshold
@H_403_68@_olap_dimension_corehash_pressure
@H_403_68@OLAP Dimension In-Core Hash Table Pressure Threshold
@H_403_68@_olap_dimension_corehash_size
@H_403_68@OLAP Dimension In-Core Hash Table Maximum Memory Use
@H_403_68@_olap_dimension_corehash_small
@H_403_68@OLAP Dimension In-Core Hash Table Small Threshold
@H_403_68@_olap_eif_export_lob_size
@H_403_68@2147483647
@H_403_68@OLAP EIF Export BLOB size
@H_403_68@_olap_lmgen_dim_size
@H_403_68@Limitmap generator dimension column size
@H_403_68@_olap_lmgen_meas_size
@H_403_68@Limitmap generator measure column size
@H_403_68@_olap_object_hash_class
@H_403_68@OLAP Object Hash Table Class
@H_403_68@_olap_page_pool_expand_rate
@H_403_68@OLAP Page Pool Expand Rate
@H_403_68@_olap_page_pool_hi
@H_403_68@OLAP Page Pool High Watermark
@H_403_68@_olap_page_pool_hit_target
@H_403_68@OLAP Page Pool Hit Target
@H_403_68@_olap_page_pool_low
@H_403_68@OLAP Page Pool Low Watermark
@H_403_68@_olap_page_pool_pressure
@H_403_68@OLAP Page Pool Pressure Threshold
@H_403_68@_olap_page_pool_shrink_rate
@H_403_68@OLAP Page Pool Shrink Rate
@H_403_68@_olap_parallel_update_small_group
@H_403_68@OLAP parallel update pagespace by group
@H_403_68@_olap_parallel_update_small_threshold
@H_403_68@OLAP parallel update threshold for number of small pagespaces
@H_403_68@_olap_parallel_update_threshold
@H_403_68@OLAP parallel update threshold in pages
@H_403_68@_olap_poutlog_echo_to_eventlog
@H_403_68@OLAP POutLog copy output to event log (tracefile)
@H_403_68@_olap_sesscache_enabled
@H_403_68@OLAP Session Cache knob
@H_403_68@_olap_sort_buffer_size
@H_403_68@OLAP Sort Buffer Size
@H_403_68@_olap_statbool_corebits
@H_403_68@20000000
@H_403_68@OLAP Status Boolean max incore bits
@H_403_68@_olap_statbool_threshold
@H_403_68@8100
@H_403_68@OLAP Status Boolean CBM threshold
@H_403_68@_olap_table_function_statistics
@H_403_68@Specify TRUE to output OLAP table function timed statistics trace
@H_403_68@_olap_wrap_errors
@H_403_68@Wrap error messages to OLAP outfile
@H_403_68@_olapi_history_retention
@H_403_68@enable olapi history retention
@H_403_68@_olapi_iface_object_history
@H_403_68@enable olapi interface object history collection
@H_403_68@_olapi_iface_object_history_retention
@H_403_68@enable olapi interface object history retention
@H_403_68@_olapi_iface_operation_history_retention
@H_403_68@enable olapi interface operation history retention
@H_403_68@_olapi_interface_operation_history
@H_403_68@enable olapi interface operation history collection
@H_403_68@_olapi_memory_operation_history
@H_403_68@enable olapi memory alloc/free history collection
@H_403_68@_olapi_memory_operation_history_pause_at_seqno
@H_403_68@enable olapi memory alloc/free history collection pausing
@H_403_68@_olapi_memory_operation_history_retention
@H_403_68@enable olapi memory operation history retention
@H_403_68@_olapi_session_history
@H_403_68@enable olapi session history collection
@H_403_68@_olapi_session_history_retention
@H_403_68@enable olapi session history retention
@H_403_68@_old_connect_by_enabled
@H_403_68@enable/disable old connect by
@H_403_68@_ols_cleanup_task
@H_403_68@Clean up unnecessary entries in OLS sessinfo table
@H_403_68@_oltp_compression
@H_403_68@oltp compression enabled
@H_403_68@_oltp_compression_gain
@H_403_68@oltp compression gain
@H_403_68@_omf
@H_403_68@enabled
@H_403_68@enable/disable OMF
@H_403_68@_oneside_colstat_for_equijoins
@H_403_68@_online_patch_disable_stack_check
@H_403_68@disable check for function on stack for online patches
@H_403_68@_optim_adjust_for_part_skews
@H_403_68@adjust stats for skews across partitions
@H_403_68@_optim_dict_stats_at_db_cr_upg
@H_403_68@enable/disable dictionary stats gathering at db create/upgrade
@H_403_68@_optim_enhance_nnull_detection
@H_403_68@TRUE to enable index [fast] full scan more often
@H_403_68@_optim_new_default_join_sel
@H_403_68@improves the way default equijoin selectivity are computed
@H_403_68@_optim_peek_user_binds
@H_403_68@enable peeking of user binds
@H_403_68@_optimizer_adaptive_cursor_sharing
@H_403_68@optimizer adaptive cursor sharing
@H_403_68@_optimizer_adjust_for_nulls
@H_403_68@adjust selectivity for null values
@H_403_68@_optimizer_autostats_job
@H_403_68@enable/disable auto stats collection job
@H_403_68@_optimizer_aw_join_push_enabled
@H_403_68@Enables AW Join Push optimization
@H_403_68@_optimizer_aw_stats_enabled
@H_403_68@Enables statistcs on AW olap_table table function
@H_403_68@_optimizer_better_inlist_costing
@H_403_68@ALL
@H_403_68@enable improved costing of index access using in-list(s)
@H_403_68@_optimizer_block_size
@H_403_68@standard block size used by optimizer
@H_403_68@_optimizer_cache_stats
@H_403_68@cost with cache statistics
@H_403_68@_optimizer_cartesian_enabled
@H_403_68@optimizer cartesian join enabled
@H_403_68@_optimizer_cbqt_factor
@H_403_68@cost factor for cost-based query transformation
@H_403_68@_optimizer_cbqt_no_size_restriction
@H_403_68@disable cost based transformation query size restriction
@H_403_68@_optimizer_ceil_cost
@H_403_68@CEIL cost in CBO
@H_403_68@_optimizer_choose_permutation
@H_403_68@force the optimizer to use the specified permutation
@H_403_68@_optimizer_complex_pred_selectivity
@H_403_68@enable selectivity estimation for builtin functions
@H_403_68@_optimizer_compute_index_stats
@H_403_68@force index stats collection on index creation/rebuild
@H_403_68@_optimizer_connect_by_combine_sw
@H_403_68@combine no filtering connect by and start with
@H_403_68@_optimizer_connect_by_cost_based
@H_403_68@use cost-based transformation for connect by
@H_403_68@_optimizer_correct_sq_selectivity
@H_403_68@force correct computation of subquery selectivity
@H_403_68@_optimizer_cost_based_transformation
@H_403_68@LINEAR
@H_403_68@enables cost-based query transformation
@H_403_68@_optimizer_cost_filter_pred
@H_403_68@enables costing of filter predicates in IO cost model
@H_403_68@_optimizer_cost_hjsmj_multimatch
@H_403_68@add cost of generating result set when #rows per key > 1
@H_403_68@_optimizer_cost_model
@H_403_68@optimizer cost model
@H_403_68@_optimizer_degree
@H_403_68@force the optimizer to use the same degree of parallelism
@H_403_68@_optimizer_dim_subq_join_sel
@H_403_68@use join selectivity in choosing star transformation dimensions
@H_403_68@_optimizer_disable_strans_sanity_checks
@H_403_68@disable star transformation sanity checks
@H_403_68@_optimizer_distinct_elimination
@H_403_68@Eliminates redundant SELECT DISTNCT’s
@H_403_68@_optimizer_dyn_smp_blks
@H_403_68@number of blocks for optimizer dynamic sampling
@H_403_68@_optimizer_enable_density_improvements
@H_403_68@use improved density computation for selectivity estimation
@H_403_68@_optimizer_enable_extended_stats
@H_403_68@use extended statistics for selectivity estimation
@H_403_68@_optimizer_enhanced_filter_push
@H_403_68@push filters before trying cost-based query transformation
@H_403_68@_optimizer_extend_jppd_view_types
@H_403_68@join pred pushdown on group-by,distinct,semi-/anti-joined view
@H_403_68@_optimizer_extended_cursor_sharing
@H_403_68@UDO
@H_403_68@optimizer extended cursor sharing
@H_403_68@_optimizer_extended_cursor_sharing_rel
@H_403_68@SIMPLE
@H_403_68@optimizer extended cursor sharing for relational operators
@H_403_68@_optimizer_extended_stats_usage_control
@H_403_68@240
@H_403_68@controls the optimizer usage of extended stats
@H_403_68@_optimizer_filter_pred_pullup
@H_403_68@use cost-based flter predicate pull up transformation
@H_403_68@_optimizer_fkr_index_cost_bias
@H_403_68@Optimizer index bias over FTS/IFFS under first K rows mode
@H_403_68@_optimizer_free_transformation_heap
@H_403_68@free transformation subheap after each transformation
@H_403_68@_optimizer_group_by_placement
@H_403_68@consider group-by placement optimization
@H_403_68@_optimizer_ignore_hints
@H_403_68@enables the embedded hints to be ignored
@H_403_68@_optimizer_improve_selectivity
@H_403_68@improve table and partial overlap join selectivity computation
@H_403_68@_optimizer_invalidation_period
@H_403_68@18000
@H_403_68@time window for invalidation of cursors of analyzed objects
@H_403_68@_optimizer_join_elimination_enabled
@H_403_68@optimizer join elimination enabled
@H_403_68@_optimizer_join_order_control
@H_403_68@controls the optimizer join order search algorithm
@H_403_68@_optimizer_join_sel_sanity_check
@H_403_68@enable/disable sanity check for multi-column join selectivity
@H_403_68@_optimizer_max_permutations
@H_403_68@optimizer maximum join permutations per query block
@H_403_68@_optimizer_min_cache_blocks
@H_403_68@set minimum cached blocks
@H_403_68@_optimizer_mjc_enabled
@H_403_68@enable merge join cartesian
@H_403_68@_optimizer_mode_force
@H_403_68@force setting of optimizer mode for user recursive sql also
@H_403_68@_optimizer_multi_level_push_pred
@H_403_68@consider join-predicate pushdown that requires multi-level pushdown to base table
@H_403_68@_optimizer_multiple_cenv
@H_403_68@generate and run plans using several compilation environments
@H_403_68@_optimizer_native_full_outer_join
@H_403_68@FORCE
@H_403_68@execute full outer join using native implementaion
@H_403_68@_optimizer_nested_rollup_for_gset
@H_403_68@number of groups above which we use nested rollup exec for gset
@H_403_68@_optimizer_new_join_card_computation
@H_403_68@compute join cardinality using non-rounded input values
@H_403_68@_optimizer_null_aware_antijoin
@H_403_68@null-aware antijoin parameter
@H_403_68@_optimizer_or_expansion
@H_403_68@DEPTH
@H_403_68@control or expansion approach used
@H_403_68@_optimizer_or_expansion_subheap
@H_403_68@Use subheap for optimizer or-expansion
@H_403_68@_optimizer_order_by_elimination_enabled
@H_403_68@Eliminates order bys from views before query transformation
@H_403_68@_optimizer_outer_to_anti_enabled
@H_403_68@Enable transformation of outer-join to anti-join if possible
@H_403_68@_optimizer_percent_parallel
@H_403_68@101
@H_403_68@optimizer percent parallel
@H_403_68@_optimizer_push_down_distinct
@H_403_68@push down distinct from query block to table
@H_403_68@_optimizer_push_pred_cost_based
@H_403_68@use cost-based query transformation for push pred optimization
@H_403_68@_optimizer_random_plan
@H_403_68@optimizer seed value for random plans
@H_403_68@_optimizer_reuse_cost_annotations
@H_403_68@reuse cost annotations during cost-based query transformation
@H_403_68@_optimizer_rownum_bind_default
@H_403_68@Default value to use for rownum bind
@H_403_68@_optimizer_rownum_pred_based_fkr
@H_403_68@enable the use of first K rows due to rownum predicate
@H_403_68@_optimizer_save_stats
@H_403_68@enable/disable saving old versions of optimizer stats
@H_403_68@_optimizer_search_limit
@H_403_68@optimizer search limit
@H_403_68@_optimizer_self_induced_cache_cost
@H_403_68@account for self-induced caching
@H_403_68@_optimizer_skip_scan_enabled
@H_403_68@enable/disable index skip scan
@H_403_68@_optimizer_skip_scan_guess
@H_403_68@consider index skip scan for predicates with guessed selectivity
@H_403_68@_optimizer_sortmerge_join_enabled
@H_403_68@enable/disable sort-merge join method
@H_403_68@_optimizer_sortmerge_join_inequality
@H_403_68@enable/disable sort-merge join using inequality predicates
@H_403_68@_optimizer_squ_bottomup
@H_403_68@enables unnesting of subquery in a bottom-up manner
@H_403_68@_optimizer_star_tran_in_with_clause
@H_403_68@enable/disable star transformation in with clause queries
@H_403_68@_optimizer_star_trans_min_cost
@H_403_68@optimizer star transformation minimum cost
@H_403_68@_optimizer_star_trans_min_ratio
@H_403_68@optimizer star transformation minimum ratio
@H_403_68@_optimizer_starplan_enabled
@H_403_68@optimizer star plan enabled
@H_403_68@_optimizer_system_stats_usage
@H_403_68@system statistics usage
@H_403_68@_optimizer_trace
@H_403_68@optimizer trace parameter
@H_403_68@_optimizer_transitivity_retain
@H_403_68@retain equi-join pred upon transitive equality pred generation
@H_403_68@_optimizer_undo_changes
@H_403_68@undo changes to query optimizer
@H_403_68@_optimizer_undo_cost_change
@H_403_68@11.1.0.6
@H_403_68@optimizer undo cost change
@H_403_68@_optimizer_use_subheap
@H_403_68@Enables physical optimizer subheap
@H_403_68@_or_expand_nvl_predicate
@H_403_68@enable OR expanded plan for NVL/DECODE predicate
@H_403_68@_oradbg_pathname
@H_403_68@path of oradbg script
@H_403_68@_oradebug_force
@H_403_68@force target processes to execute oradebug commands?
@H_403_68@_ordered_nested_loop
@H_403_68@enable ordered nested loop costing
@H_403_68@_ordered_semijoin
@H_403_68@enable ordered semi-join subquery
@H_403_68@_orph_cln_interval
@H_403_68@1200
@H_403_68@qmon periodic interval for removed subscriber messages cleanup
@H_403_68@_os_sched_high_priority
@H_403_68@OS high priority level
@H_403_68@_other_wait_event_exclusion
@H_403_68@exclude event names from _other_wait_threshold calculations
@H_403_68@_other_wait_threshold
@H_403_68@threshold wait percentage for event wait class Other
@H_403_68@_outline_bitmap_tree
@H_403_68@BITMAP_TREE hint enabled in outline
@H_403_68@_parallel_adaptive_max_users
@H_403_68@maximum number of users running with default DOP
@H_403_68@_parallel_broadcast_enabled
@H_403_68@enable broadcasting of small inputs to hash and sort merge joins
@H_403_68@_parallel_default_max_instances
@H_403_68@default maximum number of instances for parallel query
@H_403_68@_parallel_execution_message_align
@H_403_68@Alignment of PX buffers to OS page boundary
@H_403_68@_parallel_fake_class_pct
@H_403_68@fake db-scheduler percent used for testing
@H_403_68@_parallel_fixwrite_bucket
@H_403_68@Number of buckets for each round of fix write
@H_403_68@_parallel_load_bal_unit
@H_403_68@number of threads to allocate per instance
@H_403_68@_parallel_load_balancing
@H_403_68@parallel execution load balanced slave allocation
@H_403_68@_parallel_min_message_pool
@H_403_68@206592
@H_403_68@minimum size of shared pool memory to reserve for pq servers
@H_403_68@_parallel_policy
@H_403_68@MANUAL
@H_403_68@policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)
@H_403_68@_parallel_recovery_stopat
@H_403_68@32767
@H_403_68@stop at -position- to step through SMON
@H_403_68@_parallel_replay_msg_limit
@H_403_68@4000
@H_403_68@Number of messages for each round of parallel replay
@H_403_68@_parallel_server_idle_time
@H_403_68@idle time before parallel query server dies (in 1/100 sec)
@H_403_68@_parallel_server_sleep_time
@H_403_68@sleep time between dequeue timeouts (in 1/100ths)
@H_403_68@_parallel_slave_acquisition_wait
@H_403_68@time(in seconds) to wait before retrying slave acquisition
@H_403_68@_parallel_time_threshold
@H_403_68@threshold above which a plan is a candidate for parallelization (in seconds)
@H_403_68@_parallel_time_unit
@H_403_68@unit of work used to derive the degree of parallelism (in seconds)
@H_403_68@_parallel_txn_global
@H_403_68@enable parallel_txn hint with updates and deletes
@H_403_68@_parallelism_cost_fudge_factor
@H_403_68@350
@H_403_68@set the parallelism cost fudge factor
@H_403_68@_parameter_table_block_size
@H_403_68@parameter table block size
@H_403_68@_partial_pwise_join_enabled
@H_403_68@enable partial partition-wise join when TRUE
@H_403_68@_partition_view_enabled
@H_403_68@enable/disable partitioned views
@H_403_68@_passwordfile_enqueue_timeout
@H_403_68@password file enqueue timeout in seconds
@H_403_68@_pct_refresh_double_count_prevented
@H_403_68@materialized view PCT refreshes avoid double counting
@H_403_68@_pdml_gim_sampling
@H_403_68@control separation of global index maintenance for PDML
@H_403_68@_pdml_gim_staggered
@H_403_68@slaves start on different index when doing index maint
@H_403_68@_pdml_slaves_diff_part
@H_403_68@slaves start on different partition when doing index maint
@H_403_68@_percent_flashback_buf_partial_full
@H_403_68@Percent of flashback buffer filled to be considered partial full
@H_403_68@_pga_large_extent_size
@H_403_68@PGA large extent size
@H_403_68@_pga_max_size
@H_403_68@Maximum size of the PGA memory for one process
@H_403_68@_ping_level
@H_403_68@fusion ping level
@H_403_68@_pivot_implementation_method
@H_403_68@pivot implementation method
@H_403_68@_pkt_enable
@H_403_68@enable progressive kill test
@H_403_68@_pkt_pmon_interval
@H_403_68@PMON process clean-up interval (cs)
@H_403_68@_pkt_start
@H_403_68@start progressive kill test instrumention
@H_403_68@_plan_outline_data
@H_403_68@explain plan outline data enabled
@H_403_68@_plan_verify_improvement_margin
@H_403_68@150
@H_403_68@Performance improvement criterion for evolving plan baselines
@H_403_68@_plan_verify_local_time_limit
@H_403_68@Local time limit to use for an individual plan verification
@H_403_68@_plsql_anon_block_code_type
@H_403_68@INTERPRETED
@H_403_68@PL/sql anonymous block code-type
@H_403_68@_plsql_cache_enable
@H_403_68@PL/sql Function Cache Enabled
@H_403_68@_plsql_dump_buffer_events
@H_403_68@conditions upon which the PL/sql circular buffer is dumped
@H_403_68@_plsql_minimum_cache_hit_percent
@H_403_68@plsql minimum cache hit percentage required to keep caching active
@H_403_68@_plsql_nvl_optimize
@H_403_68@PL/sql NVL optimize
@H_403_68@_pmon_load_constants
@H_403_68@300,192,64,3,10,0
@H_403_68@server load balancing constants (S,P,D,I,L,C,M)
@H_403_68@_pre_rewrite_push_pred
@H_403_68@push predicates into views before rewrite
@H_403_68@_precompute_gid_values
@H_403_68@precompute gid values and copy them before returning a row
@H_403_68@_pred_move_around
@H_403_68@enables predicate move-around
@H_403_68@_predicate_elimination_enabled
@H_403_68@allow predicate elimination if set to TRUE
@H_403_68@_prescomm
@H_403_68@presume commit of IMU transactions
@H_403_68@_print_refresh_schedule
@H_403_68@false
@H_403_68@enable dbms_output of materialized view refresh schedule
@H_403_68@_private_memory_address
@H_403_68@Start address of large extent memory segment
@H_403_68@_project_view_columns
@H_403_68@enable projecting out unreferenced columns of a view
@H_403_68@_projection_pushdown
@H_403_68@projection pushdown
@H_403_68@_projection_pushdown_debug
@H_403_68@level for projection pushdown debugging
@H_403_68@_prop_old_enabled
@H_403_68@Shift to pre 11g propagation behavIoUr
@H_403_68@_protect_frame_heaps
@H_403_68@Protect cursor frame heaps
@H_403_68@_push_join_predicate
@H_403_68@enable pushing join predicate inside a view
@H_403_68@_push_join_union_view
@H_403_68@enable pushing join predicate inside a union all view
@H_403_68@_push_join_union_view2
@H_403_68@enable pushing join predicate inside a union view
@H_403_68@_px_async_getgranule
@H_403_68@asynchronous get granule in the slave
@H_403_68@_px_bind_peek_sharing
@H_403_68@enables sharing of px cursors that were built using bind peeking
@H_403_68@_px_broadcast_fudge_factor
@H_403_68@set the tq broadcasting fudge factor percentage
@H_403_68@_px_buffer_ttl
@H_403_68@ttl for px mesg buffers in seconds
@H_403_68@_px_compilation_debug
@H_403_68@debug level for parallel compilation
@H_403_68@_px_compilation_trace
@H_403_68@tracing level for parallel compilation
@H_403_68@_px_dump_12805_source
@H_403_68@enables or disables tracing of 12805 signal source
@H_403_68@_px_dynamic_opt
@H_403_68@turn off/on restartable qerpx dynamic optimization
@H_403_68@_px_dynamic_sample_size
@H_403_68@num of samples for restartable qerpx dynamic optimization
@H_403_68@_px_execution_services_enabled
@H_403_68@enable service-based constraint of px slave allocation
@H_403_68@_px_granule_size
@H_403_68@100000
@H_403_68@default size of a rowid range granule (in KB)
@H_403_68@_px_index_sampling
@H_403_68@parallel query sampling for index create (100000 = 100%)
@H_403_68@_px_io_process_bandwidth
@H_403_68@IO process bandwidth in MB/sec for computing DOP
@H_403_68@_px_io_system_bandwidth
@H_403_68@total IO system bandwidth in MB/sec for computing DOP
@H_403_68@_px_kxib_tracing
@H_403_68@turn on kxib tracing
@H_403_68@_px_load_publish_interval
@H_403_68@interval at which LMON will check whether to publish PX load
@H_403_68@_px_loc_msg_cost
@H_403_68@cpu cost to send a PX message via shared memory
@H_403_68@_px_max_granules_per_slave
@H_403_68@maximum number of rowid range granules to generate per slave
@H_403_68@_px_min_granules_per_slave
@H_403_68@13
@H_403_68@minimum number of rowid range granules to generate per slave
@H_403_68@_px_minus_intersect
@H_403_68@enables pq for minus/interect operators
@H_403_68@_px_net_msg_cost
@H_403_68@cpu cost to send a PX message over the internconnect
@H_403_68@_px_no_granule_sort
@H_403_68@prevent parallel partition granules to be sorted on size
@H_403_68@_px_no_stealing
@H_403_68@prevent parallel granule stealing in shared nothing environment
@H_403_68@_px_nss_planb
@H_403_68@enables or disables NSS Plan B reparse with outline
@H_403_68@_px_proc_constrain
@H_403_68@reduce parallel_max_servers if greater than (processes – fudge)
@H_403_68@_px_pwg_enabled
@H_403_68@parallel partition wise group by enabled
@H_403_68@_px_rownum_pd
@H_403_68@turn off/on parallel rownum pushdown optimization
@H_403_68@_px_send_timeout
@H_403_68@IPC message send timeout value in seconds
@H_403_68@_px_slaves_share_cursors
@H_403_68@slaves share cursors with QC
@H_403_68@_px_trace
@H_403_68@px trace parameter
@H_403_68@_px_ual_serial_input
@H_403_68@enables new pq for UNION operators
@H_403_68@_px_xtgranule_size
@H_403_68@default size of a external table granule (in KB)
@H_403_68@_qa_control
@H_403_68@Oracle internal parameter to control QA
@H_403_68@_qa_lrg_type
@H_403_68@Oracle internal parameter to specify QA lrg type
@H_403_68@_query_cost_rewrite
@H_403_68@perform the cost based rewrite with materialized views
@H_403_68@_query_execution_cache_max_size
@H_403_68@max size of query execution cache
@H_403_68@_query_mmvrewrite_maxcmaps
@H_403_68@query mmv rewrite maximum number of cmaps per dmap in query disjunct
@H_403_68@_query_mmvrewrite_maxdmaps
@H_403_68@query mmv rewrite maximum number of dmaps per query disjunct
@H_403_68@_query_mmvrewrite_maxinlists
@H_403_68@query mmv rewrite maximum number of in-lists per disjunct
@H_403_68@_query_mmvrewrite_maxintervals
@H_403_68@query mmv rewrite maximum number of intervals per disjunct
@H_403_68@_query_mmvrewrite_maxmergedcmaps
@H_403_68@query mmv rewrite maximum number of merged cmaps
@H_403_68@_query_mmvrewrite_maxpreds
@H_403_68@query mmv rewrite maximum number of predicates per disjunct
@H_403_68@_query_mmvrewrite_maxqryinlistvals
@H_403_68@query mmv rewrite maximum number of query in-list values
@H_403_68@_query_mmvrewrite_maxregperm
@H_403_68@512
@H_403_68@query mmv rewrite maximum number of region permutations
@H_403_68@_query_rewrite_1
@H_403_68@perform query rewrite before&after or only before view merging
@H_403_68@_query_rewrite_2
@H_403_68@perform query rewrite before&after or only after view merging
@H_403_68@_query_rewrite_drj
@H_403_68@mv rewrite and drop redundant joins
@H_403_68@_query_rewrite_expression
@H_403_68@rewrite with cannonical form for expressions
@H_403_68@_query_rewrite_fpc
@H_403_68@mv rewrite fresh partition containment
@H_403_68@_query_rewrite_fudge
@H_403_68@cost based query rewrite with MVs fudge factor
@H_403_68@_query_rewrite_jgmigrate
@H_403_68@mv rewrite with jg migration
@H_403_68@_query_rewrite_maxdisjunct
@H_403_68@257
@H_403_68@query rewrite max disjuncts
@H_403_68@_query_rewrite_or_error
@H_403_68@allow query rewrite,if referenced tables are not dataless
@H_403_68@_query_rewrite_setopgrw_enable
@H_403_68@perform general rewrite using set operator summaries
@H_403_68@_query_rewrite_vop_cleanup
@H_403_68@prune frocol chain before rewrite after view-merging
@H_403_68@_rcfg_parallel_fixwrite
@H_403_68@if TRUE enables parallel fixwrite at reconfiguration
@H_403_68@_rcfg_parallel_replay
@H_403_68@if TRUE enables parallel replay and cleanup at reconfiguration
@H_403_68@_rcfg_parallel_verify
@H_403_68@if TRUE enables parallel verify at reconfiguration
@H_403_68@_rdbms_compatibility
@H_403_68@default RDBMS compatibility level
@H_403_68@_rdbms_internal_fplib_enabled
@H_403_68@enable SAGE FPLIB filtering within rdbms
@H_403_68@_rdbms_internal_fplib_raise_errors
@H_403_68@enable reraising of any exceptions in SAGE FPLIB
@H_403_68@_readable_standby_mode
@H_403_68@SLFLUSH
@H_403_68@readable standby mode
@H_403_68@_readable_standby_sync_timeout
@H_403_68@readable standby query scn sync timeout
@H_403_68@_real_time_apply_sim
@H_403_68@Simulation value with real time apply
@H_403_68@_realfree_heap_max_size
@H_403_68@minimum max total heap size,in Kbytes
@H_403_68@_realfree_heap_mode
@H_403_68@mode flags for real-free heap
@H_403_68@_realfree_heap_pagesize_hint
@H_403_68@hint for real-free page size in bytes
@H_403_68@_recoverable_recovery_batch_percent
@H_403_68@Recoverable recovery batch size (percentage of buffer cache)
@H_403_68@_recovery_asserts
@H_403_68@_recovery_percentage |
@H_403_68@recovery buffer cache percentage
@H_403_68@_recovery_verify_writes
@H_403_68@enable thread recovery write verify
@H_403_68@_recursive_imu_transactions
@H_403_68@recursive transactions may be IMU
@H_403_68@_redo_compatibility_check
@H_403_68@general and redo/undo compatibility sanity check
@H_403_68@_redo_read_from_memory
@H_403_68@Enable reading redo from memory
@H_403_68@_redo_transport_compress_all
@H_403_68@Is ASYNC LNS compression allowed?
@H_403_68@_release_insert_threshold
@H_403_68@maximum number of unusable blocks to unlink from freelist
@H_403_68@_reliable_block_sends
@H_403_68@_remove_aggr_subquery |
@H_403_68@enables removal of subsumed aggregated subquery
@H_403_68@_replace_virtual_columns
@H_403_68@replace expressions with virtual columns
@H_403_68@_resource_manager_always_off
@H_403_68@disable the resource manager always
@H_403_68@_resource_manager_always_on
@H_403_68@enable the resource manager always
@H_403_68@_restore_spfile
@H_403_68@restore spfile to this location
@H_403_68@_result_cache_auto_execution_threshold
@H_403_68@result cache auto execution threshold
@H_403_68@_result_cache_auto_size_threshold
@H_403_68@result cache auto max size allowed
@H_403_68@_result_cache_auto_time_distance
@H_403_68@result cache auto time distance
@H_403_68@_result_cache_auto_time_threshold
@H_403_68@result cache auto time threshold
@H_403_68@_result_cache_block_size
@H_403_68@result cache block size
@H_403_68@_result_cache_timeout
@H_403_68@maximum time (sec) a session waits for a result
@H_403_68@_reuse_index_loop
@H_403_68@number of blocks being examine for index block reuse
@H_403_68@_right_outer_hash_enable
@H_403_68@Right Outer/Semi/Anti Hash Enabled
@H_403_68@_rman_io_priority
@H_403_68@priority at which rman backup i/o’s are done
@H_403_68@_rman_restore_through_link
@H_403_68@RMAN restore through link
@H_403_68@_rollback_segment_count
@H_403_68@number of undo segments
@H_403_68@_rollback_segment_initial
@H_403_68@starting undo segment number
@H_403_68@_rollback_stopat
@H_403_68@stop at -position to step rollback
@H_403_68@_row_cache_cursors
@H_403_68@number of cached cursors for row cache management
@H_403_68@_row_cr
@H_403_68@enable row cr for all sql
@H_403_68@_row_locking
@H_403_68@always
@H_403_68@row-locking
@H_403_68@_row_shipping_explain
@H_403_68@enable row shipping explain plan support
@H_403_68@_row_shipping_threshold
@H_403_68@80
@H_403_68@row shipping column selection threshold
@H_403_68@_rowsource_execution_statistics
@H_403_68@_rowsource_profiling_statistics |
@H_403_68@_rowsource_statistics_sampfreq |
@H_403_68@frequency of rowsource statistic sampling (must be a power of 2)
@H_403_68@_rowsrc_trace_level
@H_403_68@Row source tree tracing level
@H_403_68@_rtc_infeasible_threshold
@H_403_68@Redo Transport Compression infeasible threshold
@H_403_68@_sage_enabled
@H_403_68@enable real SAGE functionality
@H_403_68@_sage_fcre
@H_403_68@Allow optimized file creation path for SAGE
@H_403_68@_sample_rows_per_block
@H_403_68@number of rows per block used for sampling IO optimization
@H_403_68@_scatter_gcs_resources
@H_403_68@_scatter_gcs_shadows |
@H_403_68@_scn_wait_interface_max_backoff_time_secs |
@H_403_68@max exponential backoff time for scn wait interface in kta
@H_403_68@_scn_wait_interface_max_timeout_secs
@H_403_68@max timeout for scn wait interface in kta
@H_403_68@_sdiag_crash
@H_403_68@sql diag crash
@H_403_68@_sec_enable_test_rpcs
@H_403_68@Whether to enable the test RPCs
@H_403_68@_second_spare_parameter
@H_403_68@second spare parameter – integer
@H_403_68@_securefile_timers
@H_403_68@collect kdlu timers and accumulate per layers
@H_403_68@_selectivity_for_srf_enabled
@H_403_68@enable/disable selectivity for storage reduction factor
@H_403_68@_selfjoin_mv_duplicates
@H_403_68@control rewrite self-join algorithm
@H_403_68@_selftune_checkpoint_write_pct
@H_403_68@Percentage of total physical i/os for self-tune ckpt
@H_403_68@_selftune_checkpointing_lag
@H_403_68@Self-tune checkpointing lag the tail of the redo log
@H_403_68@_send_ast_to_foreground
@H_403_68@_send_close_with_block |
@H_403_68@_send_requests_to_pi |
@H_403_68@_serial_direct_read |
@H_403_68@enable direct read in serial
@H_403_68@_serial_recovery
@H_403_68@force serial recovery or parallel recovery
@H_403_68@_serializable
@H_403_68@serializable
@H_403_68@_session_cached_instantiations
@H_403_68@Number of pl/sql instantiations to cache in a session.
@H_403_68@_session_context_size
@H_403_68@session app context size
@H_403_68@_session_idle_bit_latches
@H_403_68@one latch per session or a latch per group of sessions
@H_403_68@_session_idle_check_interval
@H_403_68@Resource Manager session idle limit check interval in seconds
@H_403_68@_session_kept_cursor_pins
@H_403_68@Number of cursors pins to keep in a session
@H_403_68@_session_wait_history
@H_403_68@enable session wait history collection
@H_403_68@_seventh_spare_parameter
@H_403_68@seventh spare parameter – string list
@H_403_68@_sga_clear_dump
@H_403_68@Allow dumping encrypted blocks in clear for debugging
@H_403_68@_sga_early_trace
@H_403_68@sga early trace event
@H_403_68@_sga_locking
@H_403_68@sga granule locking state
@H_403_68@_shared_io_pool_buf_size
@H_403_68@Shared IO pool buffer size
@H_403_68@_shared_io_pool_debug_trc
@H_403_68@trace kcbi debug info to tracefile
@H_403_68@_shared_io_pool_size
@H_403_68@Size of shared IO pool
@H_403_68@_shared_io_set_value
@H_403_68@shared io pool size set internal value – overwrite zero user size
@H_403_68@_shared_iop_max_size
@H_403_68@536870912
@H_403_68@maximum shared io pool size
@H_403_68@_shared_pool_max_size
@H_403_68@shared pool maximum size when auto SGA enabled
@H_403_68@_shared_pool_minsize_on
@H_403_68@shared pool minimum size when auto SGA enabled
@H_403_68@_shared_pool_reserved_min_alloc
@H_403_68@4400
@H_403_68@minimum allocation size in bytes for reserved area of shared pool
@H_403_68@_shared_pool_reserved_pct
@H_403_68@percentage memory of the shared pool allocated for the reserved area
@H_403_68@_shared_server_load_balance
@H_403_68@shared server load balance
@H_403_68@_shared_server_num_queues
@H_403_68@number of shared server common queues
@H_403_68@_short_stack_timeout_ms
@H_403_68@short stack timeout in ms
@H_403_68@_shrunk_aggs_disable_threshold
@H_403_68@percentage of exceptions at which to switch to full length aggs
@H_403_68@_shrunk_aggs_enabled
@H_403_68@enable use of variable sized buffers for non-distinct aggregates
@H_403_68@_side_channel_batch_size
@H_403_68@number of messages to batch in a side channel message (DFS)
@H_403_68@_side_channel_batch_timeout
@H_403_68@timeout before shipping out the batched side channelmessages in seconds
@H_403_68@_side_channel_batch_timeout_ms
@H_403_68@timeout before shipping out the batched side channelmessages in milliseconds
@H_403_68@_simple_view_merging
@H_403_68@control simple view merging performed by the optimizer
@H_403_68@_simulate_mem_transfer
@H_403_68@simulate auto memory sga/pga transfers
@H_403_68@_simulator_bucket_mindelta
@H_403_68@LRU bucket minimum delta
@H_403_68@_simulator_internal_bound
@H_403_68@simulator internal bound percent
@H_403_68@_simulator_lru_rebalance_sizthr
@H_403_68@LRU list rebalance threshold (size)
@H_403_68@_simulator_lru_rebalance_thresh
@H_403_68@10240
@H_403_68@LRU list rebalance threshold (count)
@H_403_68@_simulator_lru_scan_count
@H_403_68@LRU scan count
@H_403_68@_simulator_pin_inval_maxcnt
@H_403_68@maximum count of invalid chunks on pin list
@H_403_68@_simulator_reserved_heap_count
@H_403_68@simulator reserved heap count
@H_403_68@_simulator_reserved_obj_count
@H_403_68@simulator reserved object count
@H_403_68@_simulator_sampling_factor
@H_403_68@sampling factor for the simulator
@H_403_68@_simulator_upper_bound_multiple
@H_403_68@upper bound multiple of pool size
@H_403_68@_single_process
@H_403_68@run without detached processes
@H_403_68@_siop_flashback_scandepth
@H_403_68@Shared IO pool flashback io completion scan depth
@H_403_68@_sixth_spare_parameter
@H_403_68@sixth spare parameter – string list
@H_403_68@_skgxp_reaping
@H_403_68@tune skgxp OSD reaping limit
@H_403_68@_skgxp_udp_ach_reaping_time
@H_403_68@time in minutes before idle ach’s are reaped
@H_403_68@_skgxp_udp_ack_delay
@H_403_68@Enables delayed acks
@H_403_68@_skgxp_udp_enable_dynamic_credit_mgmt
@H_403_68@Enables dynamic credit management
@H_403_68@_skgxp_udp_hiwat_warn
@H_403_68@ach hiwat mark warning interval
@H_403_68@_skgxp_udp_interface_detection_time_secs
@H_403_68@time in seconds between interface detection checks
@H_403_68@_skgxp_udp_keep_alive_ping_timer_secs
@H_403_68@connection idle time in seconds before keep alive is initiated. min: 30 sec max: 1800 sec default: 300 sec
@H_403_68@_skgxp_udp_lmp_mtusize
@H_403_68@MTU size for UDP LMP testing
@H_403_68@_skgxp_udp_lmp_on
@H_403_68@enable UDP long message protection
@H_403_68@_skgxp_udp_timed_wait_buffering
@H_403_68@diagnostic log buffering space (in bytes) for timed wait (0 means unbufferd
@H_403_68@_skgxp_udp_timed_wait_seconds
@H_403_68@time in seconds before timed wait is invoked
@H_403_68@_skgxp_udp_use_tcb
@H_403_68@disable use of high speek timer
@H_403_68@_skip_assume_msg
@H_403_68@_slave_mapping_enabled |
@H_403_68@enable slave mapping when TRUE
@H_403_68@_slave_mapping_group_size
@H_403_68@force the number of slave group in a slave mapper
@H_403_68@_small_table_threshold
@H_403_68@541
@H_403_68@threshold level of table size for direct reads
@H_403_68@_smm_advice_enabled
@H_403_68@_smm_advice_log_size |
@H_403_68@overwrites default size of the PGA advice workarea history log
@H_403_68@_smm_auto_cost_enabled
@H_403_68@_smm_auto_max_io_size |
@H_403_68@248
@H_403_68@Maximum IO size (in KB) used by sort/hash-join in auto mode
@H_403_68@_smm_auto_min_io_size
@H_403_68@56
@H_403_68@Minimum IO size (in KB) used by sort/hash-join in auto mode
@H_403_68@_smm_bound
@H_403_68@overwrites memory manager automatically computed bound
@H_403_68@_smm_control
@H_403_68@provides controls on the memory manager
@H_403_68@_smm_freeable_retain
@H_403_68@5120
@H_403_68@value in KB of the instance freeable PGA memory to retain
@H_403_68@_smm_isort_cap
@H_403_68@102400
@H_403_68@maximum work area for insertion sort(v1)
@H_403_68@_smm_max_size
@H_403_68@40960
@H_403_68@maximum work area size in auto mode (serial)
@H_403_68@_smm_min_size
@H_403_68@204
@H_403_68@minimum work area size in auto mode
@H_403_68@_smm_px_max_size
@H_403_68@maximum work area size in auto mode (global)
@H_403_68@_smm_retain_size
@H_403_68@work area retain size in SGA for shared server sessions (0 for AUTO)
@H_403_68@_smm_trace
@H_403_68@Turn on/off tracing for sql memory manager
@H_403_68@_smon_internal_errlimit
@H_403_68@limit of SMON internal errors
@H_403_68@_smon_undo_seg_rescan_limit
@H_403_68@limit of SMON continous undo segments re-scan
@H_403_68@_smu_debug_mode
@H_403_68@- set debug event for testing SMU operations
@H_403_68@_smu_error_simulation_site
@H_403_68@site ID of error simulation in KTU code
@H_403_68@_smu_error_simulation_type
@H_403_68@error type for error simulation in KTU code
@H_403_68@_smu_timeouts
@H_403_68@comma-separated *AND double-quoted* list of AUM timeouts: mql,tur,sess_exprn,qry_exprn,slot_intvl
@H_403_68@_sort_elimination_cost_ratio
@H_403_68@cost ratio for sort eimination under first_rows mode
@H_403_68@_sort_multiblock_read_count
@H_403_68@multi-block read count for sort
@H_403_68@_space_align_size
@H_403_68@space align size
@H_403_68@_spin_count
@H_403_68@Amount to spin waiting for a latch
@H_403_68@_spr_max_rules
@H_403_68@maximum number of rules in sql spreadsheet
@H_403_68@_spr_push_pred_refspr
@H_403_68@push predicates through reference spreadsheet
@H_403_68@_spr_use_AW_AS
@H_403_68@enable AW for hash table in spreadsheet
@H_403_68@_spr_use_hash_table
@H_403_68@use hash table for spreadsheet
@H_403_68@_sql_analyze_parse_model
@H_403_68@sql Analyze Parse Model control parameter
@H_403_68@_sql_connect_capability_override
@H_403_68@sql Connect Capability Table Override
@H_403_68@_sql_connect_capability_table
@H_403_68@sql Connect Capability Table (testing only)
@H_403_68@_sql_hash_debug
@H_403_68@Hash value of the sql statement to debug
@H_403_68@_sql_model_unfold_forloops
@H_403_68@RUN_TIME
@H_403_68@specifies compile-time unfolding of sql model forloops
@H_403_68@_sql_plan_baseline_capture_on_1_exec
@H_403_68@With auto-capture on,create new sql plan baseline on first exec
@H_403_68@_sqlexec_progression_cost
@H_403_68@sql execution progression monitoring cost threshold
@H_403_68@_sqlmon_max_plan
@H_403_68@Maximum number of plans entry that can be monitored. Defaults to 20 per cpu
@H_403_68@_sqlmon_max_planlines
@H_403_68@Number of plan lines beyond which a plan cannot be monitored
@H_403_68@_sqlmon_threshold
@H_403_68@cpu/IO time threshold before a statement is monitored. 0 is disabled
@H_403_68@_sqltune_category_parsed
@H_403_68@DEFAULT
@H_403_68@Parsed category qualifier for applying hintsets
@H_403_68@_srvntfn_job_deq_timeout
@H_403_68@srvntfn job deq timeout
@H_403_68@_srvntfn_jobsubmit_interval
@H_403_68@srvntfn job submit interval
@H_403_68@_srvntfn_max_concurrent_jobs
@H_403_68@srvntfn max concurrent jobs
@H_403_68@_srvntfn_q_msgcount
@H_403_68@srvntfn q msg count for job exit
@H_403_68@_srvntfn_q_msgcount_inc
@H_403_68@srvntfn q msg count increase for job submit
@H_403_68@_sscr_dir
@H_403_68@Session State Capture and Restore DIRectory object
@H_403_68@_sscr_osdir
@H_403_68@Session State Capture and Restore OS DIRectory
@H_403_68@_sta_control
@H_403_68@sql Tuning Advisory control parameter
@H_403_68@_stack_guard_level
@H_403_68@stack guard level
@H_403_68@_static_backgrounds
@H_403_68@static backgrounds
@H_403_68@_statistics_based_srf_enabled
@H_403_68@enable/disable the use of statistics for storage reduction factor
@H_403_68@_step_down_limit_in_pct
@H_403_68@step down limit in percentage
@H_403_68@_stn_trace
@H_403_68@sql tracing parameter
@H_403_68@_storage_predicate_access_predicate
@H_403_68@put storage predicate into access predicate in explain plan
@H_403_68@_streams_pool_max_size
@H_403_68@streams pool maximum size when auto SGA enabled
@H_403_68@_subquery_pruning_cost_factor
@H_403_68@subquery pruning cost factor
@H_403_68@_subquery_pruning_enabled
@H_403_68@enable the use of subquery predicates to perform pruning
@H_403_68@_subquery_pruning_mv_enabled
@H_403_68@enable the use of subquery predicates with MVs to perform pruning
@H_403_68@_subquery_pruning_reduction
@H_403_68@subquery pruning reduction factor
@H_403_68@_swrf_metric_frequent_mode
@H_403_68@Enable/disable SWRF Metric Frequent Mode Collection
@H_403_68@_swrf_mmon_dbfus
@H_403_68@Enable/disable SWRF MMON DB Feature Usage
@H_403_68@_swrf_mmon_flush
@H_403_68@Enable/disable SWRF MMON FLushing
@H_403_68@_swrf_mmon_metrics
@H_403_68@Enable/disable SWRF MMON Metrics Collection
@H_403_68@_swrf_on_disk_enabled
@H_403_68@Parameter to enable/disable SWRF
@H_403_68@_swrf_test_action
@H_403_68@test action parameter for SWRF
@H_403_68@_swrf_test_dbfus
@H_403_68@Enable/disable DB Feature Usage Testing
@H_403_68@_synonym_repoint_tracing
@H_403_68@whether to trace Metadata comparisons for synonym repointing
@H_403_68@_sysaux_test_param
@H_403_68@test parameter for SYSAUX
@H_403_68@_system_index_caching
@H_403_68@optimizer percent system index caching
@H_403_68@_system_trig_enabled
@H_403_68@are system triggers enabled
@H_403_68@_ta_lns_wait_for_arch_log
@H_403_68@LNS Wait time for arhcived version of online log
@H_403_68@_table_lookup_prefetch_size
@H_403_68@table lookup prefetch vector size
@H_403_68@_table_lookup_prefetch_thresh
@H_403_68@table lookup prefetch threshold
@H_403_68@_table_scan_cost_plus_one
@H_403_68@bump estimated full table scan and index ffs cost by one
@H_403_68@_target_rba_max_lag_percentage
@H_403_68@target rba max log lag percentage
@H_403_68@_tdb_debug_mode
@H_403_68@set debug mode for testing transportable database
@H_403_68@_temp_tran_block_threshold
@H_403_68@number of blocks for a dimension before we temp transform
@H_403_68@_temp_tran_cache
@H_403_68@determines if temp table is created with cache option
@H_403_68@_test_ksusigskip
@H_403_68@test the function ksusigskip
@H_403_68@_test_param_1
@H_403_68@test parmeter 1 – integer
@H_403_68@_test_param_2
@H_403_68@test parameter 2 – string
@H_403_68@_test_param_3
@H_403_68@test parameter 3 – string
@H_403_68@_test_param_4
@H_403_68@test parameter 4 – string list
@H_403_68@_test_param_5
@H_403_68@test parmeter 5 – deprecated integer
@H_403_68@_test_param_6
@H_403_68@test parmeter 6 – size (ub8)
@H_403_68@_test_spacebg
@H_403_68@test space management background task
@H_403_68@_third_spare_parameter
@H_403_68@_threshold_alerts_enable
@H_403_68@_timemodel_collection |
@H_403_68@enable timemodel collection
@H_403_68@_timeout_actions_enabled
@H_403_68@enables or disables KSU timeout actions
@H_403_68@_timer_precision
@H_403_68@VKTM sleep time in milli-sec
@H_403_68@_total_large_extent_memory
@H_403_68@Total memory for allocating large extents
@H_403_68@_tq_dump_period
@H_403_68@time period for duping of TQ statistics (s)
@H_403_68@_trace_buffer_wait_timeouts
@H_403_68@trace buffer busy wait timeouts
@H_403_68@_trace_buffers
@H_403_68@ALL:256
@H_403_68@trace buffer sizes per process
@H_403_68@_trace_dump_all_procs
@H_403_68@if TRUE on error buckets of all processes will be dumped to the current trace file
@H_403_68@_trace_dump_client_buckets
@H_403_68@if TRUE dump client (ie. non-kst) buckets
@H_403_68@_trace_dump_cur_proc_only
@H_403_68@if TRUE on error just dump our process bucket
@H_403_68@_trace_dump_static_only
@H_403_68@if TRUE filter trace dumps to always loaded dlls
@H_403_68@_trace_events
@H_403_68@trace events enabled at startup
@H_403_68@_trace_files_public
@H_403_68@Create publicly accessible trace files
@H_403_68@_trace_kqlidp
@H_403_68@trace kqlidp0 operation
@H_403_68@_trace_navigation_scope
@H_403_68@enabling trace navigation linking
@H_403_68@_trace_pin_time
@H_403_68@trace how long a current pin is held
@H_403_68@_trace_pool_size
@H_403_68@trace pool size in bytes
@H_403_68@_trace_processes
@H_403_68@enable KST tracing in process
@H_403_68@_trace_virtual_columns
@H_403_68@trace virtual columns exprs
@H_403_68@_transaction_auditing
@H_403_68@transaction auditing records generated in the redo log
@H_403_68@_transaction_recovery_servers
@H_403_68@max number of parallel recovery slaves that may be used
@H_403_68@_truncate_optimization_enabled
@H_403_68@do truncate optimization if set to TRUE
@H_403_68@_tsenc_tracing
@H_403_68@Enable TS encryption tracing
@H_403_68@_tsm_connect_string
@H_403_68@TSM test connect string
@H_403_68@_tsm_disable_auto_cleanup
@H_403_68@Disable TSM auto cleanup actions
@H_403_68@_tts_allow_charset_mismatch
@H_403_68@allow plugging in a tablespace with an incompatible character set
@H_403_68@_two_pass
@H_403_68@enable two-pass thread recovery
@H_403_68@_two_pass_reverse_polish_enabled
@H_403_68@uses two-pass reverse polish alg. to generate canonical forms
@H_403_68@_uga_cga_large_extent_size
@H_403_68@UGA/CGA large extent size
@H_403_68@_ultrafast_latch_statistics
@H_403_68@maintain fast-path statistics for ultrafast latches
@H_403_68@_undo_autotune
@H_403_68@enable auto tuning of undo_retention
@H_403_68@_undo_block_compression
@H_403_68@enable undo block compression
@H_403_68@_undo_debug_mode
@H_403_68@debug flag for undo related operations
@H_403_68@_undo_debug_usage
@H_403_68@invoke undo usage functions for testing
@H_403_68@_union_rewrite_for_gs
@H_403_68@YES_GSET_MVS
@H_403_68@expand queries with GSets into UNIONs for rewrite
@H_403_68@_unnest_subquery
@H_403_68@enables unnesting of correlated subqueries
@H_403_68@_unused_block_compression
@H_403_68@enable unused block compression
@H_403_68@_update_datafile_headers_with_space_information
@H_403_68@user requested update of datafile headers of locally managed datafiles with space information
@H_403_68@_use_best_fit
@H_403_68@use best fit to allocate space
@H_403_68@_use_column_stats_for_function
@H_403_68@enable the use of column statistics for DDP functions
@H_403_68@_use_ism
@H_403_68@Enable Shared Page Tables – ISM
@H_403_68@_use_ism_for_pga
@H_403_68@Use ISM for allocating large extents
@H_403_68@_use_nosegment_indexes
@H_403_68@use nosegment indexes in explain plan
@H_403_68@_use_realfree_heap
@H_403_68@use real-free based allocator for PGA memory
@H_403_68@_use_seq_process_cache
@H_403_68@whether to use process local seq cache
@H_403_68@_use_vector_post
@H_403_68@use vector post
@H_403_68@_use_zero_copy_io
@H_403_68@Should network vector IO interface be used for data transfer
@H_403_68@_validate_flashback_database
@H_403_68@Scan database to validate result of flashback database
@H_403_68@_vendor_lib_loc
@H_403_68@Vendor library search root directory
@H_403_68@_verify_flashback_redo
@H_403_68@Verify that the redo logs needed for flashback are available
@H_403_68@_verify_undo_quota
@H_403_68@TRUE – verify consistency of undo quota statistics
@H_403_68@_very_large_partitioned_table
@H_403_68@very_large_partitioned_table
@H_403_68@_virtual_column_overload_allowed
@H_403_68@overload virtual columns expression
@H_403_68@_wait_breakup_threshold_csecs
@H_403_68@Wait breakup threshold (in centiseconds)
@H_403_68@_wait_breakup_time_csecs
@H_403_68@Wait breakup time (in centiseconds)
@H_403_68@_wait_for_sync
@H_403_68@wait for sync on commit MUST BE ALWAYS TRUE
@H_403_68@_walk_insert_threshold
@H_403_68@maximum number of unusable blocks to walk across freelist
@H_403_68@_watchpoint_on
@H_403_68@is the watchpointing feature turned on?
@H_403_68@_wcr_control
@H_403_68@Oracle internal test WCR parameter used ONLY for testing!
@H_403_68@_windowfunc_optimization_settings
@H_403_68@settings for window function optimizations
@H_403_68@_with_subquery
@H_403_68@OPTIMIZER
@H_403_68@WITH subquery transformation
@H_403_68@_write_clones
@H_403_68@write clones flag
@H_403_68@_xpl_peeked_binds_log_size
@H_403_68@maximum bytes for logging peeked bind values for V$sql_PLAN (0 = OFF)
@H_403_68@_xpl_trace
@H_403_68@Explain Plan tracing parameter
@H_403_68@_xsolapi_auto_materialization_bound
@H_403_68@OLAP API lower bound for auto materialization.
@H_403_68@_xsolapi_auto_materialization_type
@H_403_68@PRED_AND_RC
@H_403_68@OLAP API behavior for auto materialization
@H_403_68@_xsolapi_build_trace
@H_403_68@OLAP API output build info to trace file
@H_403_68@_xsolapi_debug_output
@H_403_68@SUPPRESS
@H_403_68@OLAP API debug output disposition
@H_403_68@_xsolapi_densify_cubes
@H_403_68@TABULAR
@H_403_68@OLAP API cube densification
@H_403_68@_xsolapi_dimension_group_creation
@H_403_68@OVERFETCH
@H_403_68@OLAP API symmetric overfetch
@H_403_68@_xsolapi_dml_trace
@H_403_68@OLAP API output dml commands and expressions to trace file
@H_403_68@_xsolapi_fetch_type
@H_403_68@PARTIAL
@H_403_68@OLAP API fetch type
@H_403_68@_xsolapi_fix_vptrs
@H_403_68@OLAP API Enable vptr fixing logic in shared server mode
@H_403_68@_xsolapi_generate_with_clause
@H_403_68@OLAP API generates WITH clause?
@H_403_68@_xsolapi_hierarchy_value_type
@H_403_68@unique
@H_403_68@OLAP API hierarchy value type
@H_403_68@_xsolapi_load_at_process_start
@H_403_68@NEVER
@H_403_68@When to load OLAP API library at server process start
@H_403_68@_xsolapi_materialization_rowcache_min_rows_for_use
@H_403_68@OLAP API min number of rows required to use rowcache in query materialization
@H_403_68@_xsolapi_materialize_sources
@H_403_68@OLAP API Enable source materialization
@H_403_68@_xsolapi_Metadata_reader_mode
@H_403_68@11_ONLY
@H_403_68@OLAP API Metadata reader mode
@H_403_68@_xsolapi_odbo_mode
@H_403_68@OLAP API uses ODBO mode?
@H_403_68@_xsolapi_opt_aw_position
@H_403_68@OLAP API enables AW position and count optimization?
@H_403_68@_xsolapi_optimize_suppression
@H_403_68@OLAP API optimizes suppressions?
@H_403_68@_xsolapi_precompute_subquery
@H_403_68@OLAP API precomputes subqueries?
@H_403_68@_xsolapi_remove_columns_for_materialization
@H_403_68@OLAP API removes columns for materialization?
@H_403_68@_xsolapi_set_nls
@H_403_68@OLAP API sets NLS?
@H_403_68@_xsolapi_share_executors
@H_403_68@OLAP API share executors?
@H_403_68@_xsolapi_source_trace
@H_403_68@OLAP API output Source definitions to trace file
@H_403_68@_xsolapi_sql_all_multi_join_non_base_hints
@H_403_68@OLAP API multi-join non-base hints
@H_403_68@_xsolapi_sql_all_non_base_hints
@H_403_68@OLAP API non-base hints
@H_403_68@_xsolapi_sql_auto_dimension_hints
@H_403_68@OLAP API enable automatic dimension hints
@H_403_68@_xsolapi_sql_auto_measure_hints
@H_403_68@OLAP API enable automatic measure hints
@H_403_68@_xsolapi_sql_dimension_hints
@H_403_68@OLAP API dimension hints
@H_403_68@_xsolapi_sql_enable_aw_join
@H_403_68@OLAP API enables AW join?
@H_403_68@_xsolapi_sql_enable_aw_qdr_merge
@H_403_68@OLAP API enables AW QDR merge?
@H_403_68@_xsolapi_sql_hints
@H_403_68@OLAP API generic hints
@H_403_68@_xsolapi_sql_measure_hints
@H_403_68@OLAP API measure hints
@H_403_68@_xsolapi_sql_minus_threshold
@H_403_68@OLAP API sql MINUS threshold
@H_403_68@_xsolapi_sql_optimize
@H_403_68@OLAP API enable optimization
@H_403_68@_xsolapi_sql_prepare_stmt_cache_size
@H_403_68@OLAP API prepare statement cache size
@H_403_68@_xsolapi_sql_remove_columns
@H_403_68@OLAP API enable remove unused columns optimizations
@H_403_68@_xsolapi_sql_result_set_cache_size
@H_403_68@OLAP API result set cache size
@H_403_68@_xsolapi_sql_symmetric_predicate
@H_403_68@OLAP API enable symmetric predicate for dimension groups
@H_403_68@_xsolapi_sql_top_dimension_hints
@H_403_68@OLAP API top dimension hints
@H_403_68@_xsolapi_sql_top_measure_hints
@H_403_68@OLAP API top measure hints
@H_403_68@_xsolapi_sql_use_bind_variables
@H_403_68@OLAP API enable bind variables optimization
@H_403_68@_xsolapi_stringify_order_levels
@H_403_68@OLAP API stringifies order levels?
@H_403_68@_xsolapi_support_mtm
@H_403_68@OLAP API MTM mapping classes supported?
@H_403_68@_xsolapi_suppression_aw_mask_threshold
@H_403_68@OLAP API suppression AW mask threshold
@H_403_68@_xsolapi_suppression_chunk_size
@H_403_68@OLAP API suppression chunk size
@H_403_68@_xsolapi_use_models
@H_403_68@OLAP API uses models?
@H_403_68@_xsolapi_use_olap_dml
@H_403_68@OLAP API uses OLAP DML?
@H_403_68@_xsolapi_use_olap_dml_for_rank
@H_403_68@OLAP API uses OLAP DML for rank?
@H_403_68@_xt_coverage
@H_403_68@external tables code coverage parameter
@H_403_68@_xt_trace
@H_403_68@external tables trace parameter
@H_403_68@_xtbuffer_size
@H_403_68@buffer size in KB needed for populate/query operation
@H_403_68@_xtts_allow_pre10
@H_403_68@allow cross platform for pre10 compatible tablespace
@H_403_68@_xtts_set_platform_info
@H_403_68@set cross platform info during file header read
@H_403_68@_yield_check_interval
@H_403_68@interval to check whether actses should yield
原文链接:https://www.f2er.com/oracle/206995.html