воскресенье, 21 февраля 2010 г.

Oracle 10g Hidden Parameters

Список скрытых параметров в Oracle10g

Parameter Name Parameter Value Description
_4031_dump_bitvec67194879bitvec to specify dumps prior to 4031 error
_4031_dump_interval300Dump 4031 error once for each n-second interval
_4031_max_dumps100Maximum number of 4031 dumps for this process
_4031_sga_dump_interval3600Dump 4031 SGA heapdump error once for each n-second interval
_4031_sga_max_dumps10Maximum number of SGA heapdumps
_NUMA_instance_mappingNot specifiedSet of nodes that this instance should run on
_NUMA_pool_sizeNot specifiedaggregate size in bytes of NUMA pool
_PX_use_large_poolFALSEUse Large Pool as source of PX buffers
_abort_recovery_on_joinFALSEif TRUE, abort recovery on join reconfigurations
_accept_versions...List of parameters for rolling operation
_active_standby_fast_reconfigurationTRUEif TRUE optimize dlm reconfiguration for active/standby OPS
_adaptive_direct_readTRUEAdaptive Direct Read
_adaptive_fetch_enabledTRUEenable/disable adaptive fetch in parallel group by
_add_stale_mv_to_dependency_listTRUEadd stale mv to dependency list
_addm_auto_enableTRUEgoverns whether ADDM gets run automatically after every AWR snapshot
_addm_skiprules...comma-separated list of ADDM nodes to skip
_addm_version_checkTRUEgoverns whether ADDM checks the input AWR snapshot version
_adjust_literal_replacementFALSEIf TRUE, we will adjust the SQL/PLUS output
_affinity_onTRUEenable/disable affinity at run time
_aiowait_timeouts100Number of aiowait timeouts before error is reported
_alert_expiration604800seconds before an alert message is moved to exception queue
_alert_message_cleanup1Enable Alert Message Cleanup
_alert_message_purge1Enable Alert Message Purge
_alert_post_background1Enable Background Alert Posting
_all_shared_dblinks...treat all dblinks as shared
_allocate_creation_orderFALSEshould files be examined in creation order during allocation
_allocation_update_interval3interval at which successful search in L1 should be updated
_allow_commutativityTRUEallow for commutativity of +, * when comparing expressions
_allow_error_simulationFALSEAllow error simulation for testing
_allow_level_without_connect_byFALSEallow level without connect by
_allow_read_only_corruptionFALSEallow read-only open even if database is corrupt
_allow_resetlogs_corruptionFALSEallow resetlogs even if it will cause corruption
_allow_terminal_recovery_corruptionFALSEFinish terminal recovery even if it may cause corruption
_alternate_iot_leaf_block_split_pointsTRUEenable alternate index-organized table leaf-block split-points
_always_anti_joinCHOOSEalways use this method for anti-join when possible
_always_semi_joinCHOOSEalways use this method for semi-join when possible
_always_star_transformationFALSEalways favor use of star transformation
_app_ctx_versFALSEenable app ctx versioning
_aq_tm_scanlimit0scan limit for Time Managers to clean up IOT
_arch_corrupted_redo_log0Variable to simulate corruption errors during archivals
_arch_io_slaves0ARCH I/O slaves
_array_update_vector_read_enabledFALSEEnable array update vector read
_ash_disk_filter_ratio10Ratio of the number of in-memory samples to the number of samples actually written to disk
_ash_disk_write_enableTRUETo enable or disable Active Session History flushing
_ash_dummy_test_param0Oracle internal dummy ASH parameter used ONLY for testing!
_ash_eflush_trigger66The percentage above which if the in-memory ASH is full the emergency flusher will be triggered
_ash_enableTRUETo enable or disable Active Session sampling and flushing
_ash_sample_allFALSETo enable or disable sampling every connected session including ones waiting for idle waits
_ash_sampling_interval1000Time interval between two successive Active Session samples in millisecs
_ash_size1048618To set the size of the in-memory Active Session History buffers
_asm_acd_chunks1initial ACD chunks created
_asm_allow_only_raw_disksTRUEDiscovery only raw devices
_asm_allow_resilver_corruptionFALSEEnable disk resilvering for external redundancy
_asm_ausize1048576allocation unit size
_asm_blksize4096metadata block size
_asm_disk_repair_time14400seconds to wait before dropping a failing disk
_asm_droptimeout60timeout before offlined disks get dropped (in 3s ticks)
_asm_emulmax10000max number of concurrent disks to emulate I/O errors
_asm_emultimeout0timeout before emulation begins (in 3s ticks)
_asm_kfdpevent0KFDP event
_asm_librariesufslibrary search order for discovery
_asm_maxio1048576Maximum size of individual I/O request
_asm_skip_resize_checkFALSEskip the checking of the clients for s/w compatibility for resize
_asm_stripesize131072ASM file stripe size
_asm_stripewidth8ASM file stripe width
_asm_wait_time18Max/imum time to wait before asmb exits
_asmlib_test0Osmlib test event
_asmsidasmASM instance id
_assm_defaultTRUEASSM default
_async_object_flushTRUEif FALSE, disable asychronous object flush
_async_recovery_claimsTRUEif TRUE, issue recovery claims asynchronously
_async_recovery_readsTRUEif TRUE, issue recovery reads asynchronously
_avoid_prepareTRUEif TRUE, do not prepare a buffer when the master is local
_awr_corrupt_modeFALSEAWR Corrupt Mode
_awr_disabled_flush_tables...Disable flushing of specified AWR tables
_awr_flush_threshold_metricsFALSEEnable/Disable Flushing AWR Workload Metrics
_awr_flush_workload_metricsFALSEEnable/Disable Flushing AWR Workload Metrics
_awr_mmon_cpuusageTRUEEnable/disable AWR MMON CPU Usage Tracking
_awr_restrict_modeFALSEAWR Restrict Mode
_awr_sql_child_limit200Setting for AWR SQL Child Limit
_b_tree_bitmap_plansTRUEenable the use of bitmap plans for tables w. only B-tree indexes
_backup_disk_io_slaves0BACKUP Disk I/O slaves
_backup_io_pool_size1048576memory to reserve from the large pool
_backup_kgc_bufsz0specifies buffer size to be used for kgc compression
_backup_kgc_niters0specifies number of iterations used for kgc compression
_backup_kgc_type0specifies compression type used for kgc compression
_backup_ksfq_bufcnt0number of the ksfq buffers used for backup/restore
_backup_ksfq_bufsz0size of the ksfq buffer used for backup/restore
_backup_max_gap_size4294967294largest gap in an incremental/optimized backup buffer, in bytes
_bct_bitmaps_per_file8number of bitmaps to store for each datafile
_bct_buffer_allocation_max104857600maximum size of all change tracking buffer allocations, in bytes
_bct_buffer_allocation_min_extents1mininum number of extents to allocate per buffer allocation
_bct_buffer_allocation_size2097152size of one change tracking buffer allocation, in bytes
_bct_chunk_size0change tracking datafile chunk size, in bytes
_bct_crash_reserve_size262144change tracking reserved crash recovery SGA space, in bytes
_bct_file_block_size0block size of change tracking file, in bytes
_bct_file_extent_size0extent size of change tracking file, in bytes
_bct_fixtab_file...change tracking file for fixed tables
_bct_initial_private_dba_buffer_size0initial number of entries in the private change tracking dba buffers
_bct_public_dba_buffer_size0total size of all public change tracking dba buffers, in bytes
_bitmap_or_improvement_enabledTRUEcontrols extensions to partition pruning for general predicates
_block_change_trackingTRUEchange tracking possible
_blocks_per_cache_server128number of consecutive blocks per global cache server
_bloom_filter_debug0debug level for bloom filtering
_bloom_filter_enabledTRUEenables or disables bloom filter
_bt_mmv_query_rewrite_enabledTRUEallow rewrites with multiple MVs and base tables
_buffer_busy_wait_timeout100buffer busy wait time in centiseconds
_buffered_publisher_flow_control_threshold0Flow control threshold for buffered publishers except capture
_bufq_flow_control_thrsh0flow control threshold value
_bufq_max_msg_sz0maximum size of the message allowed in memory
_bufq_stop_flow_controlFALSEStop enforcing flow control for buffered queues
_build_deferred_mv_skipping_mvlog_updateFALSEDEFERRED MV creation skipping MV log setup update
_bump_highwater_mark_count0how many blocks should we allocate per free list on advancing HWM
_bwr_for_flushed_piTRUEif TRUE, generate a BWR for a flushed PI
_cache_stats_monitorFALSEif TRUE, enable cache stats monitoring
_capture_buffer_size65536To set the size of the PGA I/O recording buffers
_capture_publisher_flow_control_threshold0Flow control threshold for capture publishers
_cgs_reconfig_timeout120CGS reconfiguration timeout interval
_cgs_send_timeout300CGS send timeout value
_check_block_after_checksumTRUEperform block check after checksum if both are turned on
_check_ts_threshold0check tablespace thresholds
_cleanup_rollback_entries100no. of undo entries to apply per transaction cleanup
_close_cached_open_cursorsFALSEclose cursors cached by PL/SQL at each commit
_cluster_libraryclsscluster library selection
_collapse_wait_historyFALSEcollapse wait history
_collect_undo_statsTRUECollect Statistics v$undostat
_column_compression_factor0Column compression ratio
_column_elimination_offFALSEturn off predicate-only column elimination
_column_tracking_level1column usage tracking
_compilation_call_heap_extent_size16384Size of the compilation call heaps extents
_complex_view_mergingTRUEenable complex view merging
_controlfile_block_size0control file block size in bytes
_controlfile_enqueue_dumpFALSEdump the system states after controlfile enqueue timeout
_controlfile_enqueue_holding_time120control file enqueue max holding time in seconds
_controlfile_enqueue_timeout900control file enqueue timeout in seconds
_controlfile_section_init_size...control file initial section size
_controlfile_section_max_expand...control file max expansion rate
_controlfile_update_checkOFFcontrolfile update sanity check
_convert_set_to_joinFALSEenables conversion of set operator to join
_coord_message_buffer0parallel recovery coordinator side extra message buffer size
_corrupted_rollback_segments...corrupted undo segment list
_cost_equality_semi_joinTRUEenables costing of equality semi-join
_cpu_to_io0divisor for converting CPU cost to I/O cost
_cr_grant_global_roleTRUEif TRUE, grant lock for CR requests when block is in global role
_cr_grant_local_roleAUTOturn 3-way CR grants off, make it automatic, or turn it on
_cr_server_log_flushTRUEif TRUE, flush redo log before serving a CR buffer
_ctas_hwm_brokered_loadsTRUEEnable HWM brokered CTAS
_cursor_bind_capture_area_size400maximum size of the cursor bind capture area
_cursor_bind_capture_interval900interval (in seconds) between two bind capture for a cursor
_cursor_cache_frame_bind_memoryFALSEframe & bind buffer caching
_cursor_db_buffers_pinned44additional number of buffers a cursor can pin at once
_cursor_features_enabled2Shared cursor features enabled bits.
_cursor_plan_enabledTRUEenable collection and display of cursor plans
_cursor_plan_hash_version1version of cursor plan hash value
_cursor_plan_unparse_enabledTRUEenables/disables using unparse to build projection/predicates
_cursor_stats_bucket15Hash table buckets for cursor stats (2^).
_cursor_stats_heap4Heaps/latches for cursor stats.
_cvw_enable_weak_checkingTRUEenable weak view checking
_db_aging_cool_count1Touch count set when buffer cooled
_db_aging_freeze_crFALSEMake CR buffers always be too cold to keep in cache
_db_aging_hot_criteria2Touch count which sends a buffer to head of replacement list
_db_aging_stay_count0Touch count set when buffer moved to head of replacement list
_db_aging_touch_time3Touch count which sends a buffer to head of replacement list
_db_always_check_system_tsTRUEAlways perform block check and checksum for System tablespace
_db_block_adjcheckTRUEadjacent cache buffer checks - low blkchk overwrite parameter
_db_block_adjchk_level0adjacent cache buffer check level
_db_block_align_direct_readTRUEAlign Direct Reads
_db_block_buffers6986Number of database blocks cached in memory: hidden parameter
_db_block_cache_cloneFALSEAlways clone data blocks on get (for debugging)
_db_block_cache_history0buffer header tracing (non-zero only when debugging)
_db_block_cache_history_level2buffer header tracing level
_db_block_cache_num_umap0number of unmapped buffers (for tracking swap calls on blocks)
_db_block_cache_protectFALSEprotect database blocks (true only when debugging)
_db_block_cache_protect_internal0protect database blocks (for strictly internal use only)
_db_block_check_for_debugFALSECheck more and dump block before image for debugging
_db_block_check_objtypTRUEcheck objd and typ on cache disk read
_db_block_do_full_mbreadsFALSEdo full block read even if some blocks are in cache
_db_block_hash_buckets16384Number of database block hash buckets
_db_block_hash_latches1024Number of database block hash latches
_db_block_hi_priority_batch_size0Fraction of writes for high priority reasons
_db_block_known_clean_pct2Initial Percentage of buffers to maintain known clean
_db_block_lru_latches8number of lru latches
_db_block_max_cr_dba6Maximum Allowed Number of CR buffers per dba
_db_block_max_scan_pct40Percentage of buffers to inspect when looking for free
_db_block_med_priority_batch_size0Fraction of writes for medium priority reasons
_db_block_numa1Number of NUMA nodes
_db_block_prefetch_limit0Prefetch limit in blocks
_db_block_prefetch_quota10Prefetch quota as a percent of cache size
_db_block_table_scan_buffer_size4194304Size of shared table scan read buffer
_db_block_temp_redoFALSEgenerate redo for temp blocks
_db_block_trace_protectFALSEtrace buffer protect calls
_db_block_vlm_checkFALSEcheck of rvlm mapping leaks (for debugging)
_db_block_vlm_leak_threshold3Threshold for allowable vlm leaks
_db_blocks_per_hash_latch...Number of blocks per hash latch
_db_cache_advice_batch_size128cache advisory simulation batch size
_db_cache_advice_sample_factor4cache advisory sampling factor
_db_cache_crx_checkFALSEcheck for costly crx examination functions
_db_cache_pre_warmTRUEBuffer Cache Pre-Warm Enabled : hidden parameter
_db_cache_process_cr_pin_max...maximum number of cr pins a process may have
_db_change_notification_enableTRUEenable db change notification
_db_fast_obj_checkFALSEenable fast object drop sanity check
_db_fast_obj_ckptTRUEenable fast object checkpoint
_db_fast_obj_truncateTRUEenable fast object truncate
_db_file_direct_io_count1048576Sequential I/O buf size
_db_file_exec_read_count16multiblock read count for regular clients
_db_file_format_io_buffers4Block formatting I/O buf count
_db_file_noncontig_mblock_read_count11number of noncontiguous db blocks to be prefetched
_db_file_optimizer_read_count16multiblock read count for regular clients
_db_handles750System-wide simultaneous buffer operations
_db_handles_cached5Buffer handles cached each process
_db_hot_block_trackingFALSEtrack hot blocks for hash latch contention
_db_index_block_checkingTRUEindex block checking override parameter
_db_large_dirty_queue25Number of buffers which force dirty queue to be written
_db_lost_write_checkingFALSEEnable scn based lost write detection mechanism
_db_mttr_adviceONMTTR advisory
_db_mttr_partitions0number of partitions for MTTR advisory
_db_mttr_sample_factor64MTTR simulation sampling factor
_db_mttr_sim_target...MTTR simulation targets
_db_mttr_sim_trace_size256MTTR simulation trace size
_db_mttr_trace_to_alertFALSEdump trace entries to alert file
_db_obj_ckpt_orderedFALSEfast object checkpoint ordered by lrba
_db_obj_enable_ksrTRUEenable ksr in object checkpoint/reuse
_db_percent_hot_default50Percent of default buffer pool considered hot
_db_percent_hot_keep0Percent of keep buffer pool considered hot
_db_percent_hot_recycle0Percent of recycle buffer pool considered hot
_db_percpu_create_cachesize2size of cache created per cpu in deferred cache create
_db_recovery_temporal_file_dest...default database recovery temporal file location
_db_required_percent_fairshare_usage10percent of fairshare a processor group should always use
_db_row_overlap_checkingTRUErow overlap checking override parameter for data/index blocks
_db_todefer_cache_createTRUEbuffer cache deferred create
_db_writer_chunk_writes0Number of writes DBWR should wait for
_db_writer_coalesce_area_size573440Size of memory allocated to dbwriter for coalescing writes
_db_writer_coalesce_write_limit131072Limit on size of coalesced write
_db_writer_flush_imuTRUEIf FALSE, DBWR will not downgrade IMU txns for AGING
_db_writer_histogram_statisticsFALSEmaintain dbwr histogram statistics in x$kcbbhs
_db_writer_max_writes0Max number of outstanding DB Writer IOs
_db_writer_verify_writesFALSEEnable lost write detection mechanism
_dbg_proc_startupFALSEdebug process startup
_dbwr_async_ioTRUEEnable dbwriter asynchronous writes
_dbwr_scan_interval300dbwriter scan interval
_dbwr_tracing0Enable dbwriter tracing
_dead_process_scan_interval10PMON dead process scan interval
_dedicated_server_poll_count10dedicated server poll count
_dedicated_server_post_waitFALSEdedicated server post/wait
_dedicated_server_post_wait_callFALSEdedicated server post/wait call
_default_encrypt_alg0default encryption algorithm
_default_non_equality_sel_checkTRUEsanity check on default selectivity for like/range predicate
_delay_index_maintainTRUEdelays index maintenance until after MV is refreshed
_diag_daemonTRUEstart DIAG daemon
_diag_diagnosticsTRUETurn off diag diagnostics
_diag_dump_timeout30timeout parameter for SYNC dump
_dimension_skip_nullTRUEcontrol dimension skip when null feature
_disable_adaptive_shrunk_aggregationFALSEadaptive shrunk aggregation
_disable_datalayer_samplingFALSEdisable datalayer sampling
_disable_duplex_linkTRUETurn off connection duplexing
_disable_fast_aggregationFALSEfast aggregation
_disable_file_locksFALSEdisable file locks for control, data, redo log files
_disable_flashback_wait_callbackFALSEDisable flashback wait callback
_disable_function_based_indexFALSEdisable function-based index matching
_disable_health_checkFALSEDisable Health Check
_disable_image_checkFALSEDisable Oracle executable image checking
_disable_incremental_checkpointsFALSEDisable incremental checkpoints for thread recovery
_disable_incremental_recovery_ckptFALSEDisable incremental recovery checkpoint mechanism
_disable_instance_params_checkFALSEdisable instance type check for ksp
_disable_interface_checkingFALSEdisable interface checking at startup
_disable_kcbhxor_osdFALSEdisable kcbh(c)xor OSD functionality
_disable_latch_free_SCN_writes_via_32casFALSEdisable latch-free SCN writes using 32-bit compare & swap
_disable_latch_free_SCN_writes_via_64casFALSEdisable latch-free SCN writes using 64-bit compare & swap
_disable_loggingFALSEDisable logging
_disable_multiple_block_sizesFALSEdisable multiple block size support (for debugging)
_disable_odmFALSEdisable odm feature
_disable_recoverable_recoveryFALSEDisable the new recoverable recovery mechanism
_disable_recovery_read_skipFALSEDisable the read optimization during media recovery
_disable_sample_io_optimFALSEdisable row sampling IO optimization
_disable_savepoint_resetFALSEdisable the fix for bug 1402161
_disable_selftune_checkpointingFALSEDisable self-tune checkpointing
_disable_streams_pool_auto_tuningFALSEdisable streams pool auto tuning
_disable_sun_rsmTRUEDisable IPC OSD support for Sun RSMAPI
_disable_system_state4294967294disable system state dump
_disable_txn_alert0disable txn layer alert
_discrete_transactions_enabledFALSEenable OLTP mode
_dispatcher_rate_scale...scale to display rate statistic (100ths of a second)
_dispatcher_rate_ttl...time-to-live for rate statistic (100ths of a second)
_distinct_view_unnestingFALSEenables unnesting of in subquery into distinct view
_distributed_recovery_connection_hold_time200number of seconds RECO holds outbound connections open
_dlm_send_timeout30000DLM send timeout value
_dlmtrace...Trace string of global enqueue type(s)
_dm_max_shared_pool_pct1max percentage of the shared pool to use for a mining model
_dml_monitoring_enabledTRUEenable modification monitoring
_domain_index_batch_size2000maximum number of rows from one call to domain index fetch routine
_domain_index_dml_batch_size200maximum number of rows for one call to domain index dml routines
_drop_table_optimization_enabledTRUEreduce SGA memory use during drop of a partitioned table
_ds_iocount_iosize6553664Dynamic Sampling Service defaults: #IOs and IO Size
_dss_cache_flushFALSEenable full cache flush for parallel execution
_dtree_area_size131072size of Decision Tree Classification work area
_dtree_binning_enabledTRUEDecision Tree Binning Enabled
_dtree_bintest_id0Decision Tree Binning Test ID
_dtree_compressbmp_enabledTRUEDecision Tree Using Compressed Bitmaps Enabled
_dtree_max_surrogates1maximum number of surrogates
_dtree_pruning_enabledTRUEDecision Tree Pruning Enabled
_dummy_instanceFALSEdummy instance started by RMAN
_dump_common_subexpressionsFALSEdump common subexpressions
_dump_connect_by_loop_dataFALSEdump connect by loop error message into trc file
_dump_cursor_heap_sizesFALSEdump comp/exec heap sizes to tryace file
_dump_interval_limit120trace dump time interval limit (in seconds)
_dump_max_limit5max number of dump within dump interval
_dump_qbc_tree0dump top level query parse tree to trace
_dump_rcvr_ipcTRUEif TRUE enables IPC dump at instance eviction time
_dump_system_state_scopelocalscope of sysstate dump during instance termination
_dump_trace_scopeglobalscope of trace dump during a process crash
_dynamic_rls_policiesTRUErls policies are dynamic
_dynamic_stats_threshold30delay threshold (in seconds) between sending statistics messages
_eliminate_common_subexprTRUEenables elimination of common sub-expressions
_enable_NUMA_optimizationTRUEEnable NUMA specific optimizations
_enable_block_level_transaction_recoveryTRUEenable block level recovery
_enable_cscn_cachingFALSEenable commit SCN caching for all transactions
_enable_default_affinity0to enable default implementation of affinity osds
_enable_dml_lock_escalationTRUEenable dml lock escalation against partitioned tables if TRUE
_enable_exchange_validation_using_checkTRUEuse check constraints on the table for validation
_enable_fast_ref_after_mv_tbsFALSEenable fast refresh after move tablespace
_enable_hash_overflowFALSETRUE - enable hash cluster overflow based on SIZE
_enable_hwm_syncTRUEenable HWM synchronization
_enable_list_ioFALSEEnable List I/O
_enable_nativenet_tcpipFALSEEnable skgxp driver usage for native net
_enable_refresh_scheduleTRUEenable or disable MV refresh scheduling (revert to 9.2 behavior)
_enable_reliable_latch_waitsTRUEEnable reliable latch waits
_enable_rlbTRUEenable RLB metrics processing
_enable_row_shippingFALSEuse the row shipping optimization for wide table selects
_enable_shared_pool_durationsTRUEtemporary to disable/enable kgh policy
_enable_tablespace_alertsTRUEenable tablespace alerts
_enable_type_dep_selectivityTRUEenable type dependent selectivity estimates
_enqueue_deadlock_time_sec5requests with timeout <= this will not have deadlock detection
_enqueue_debug_multi_instanceFALSEdebug enqueue multi instance
_enqueue_hash375enqueue hash table length
_enqueue_hash_chain_latches1enqueue hash chain latches
_enqueue_locks2260locks for managed enqueues
_enqueue_resources968resources for enqueues
_expand_aggregatesTRUEexpand aggregates
_explain_rewrite_modeFALSEallow additional messages to be generated during explain rewrite
_extended_pruning_enabledTRUEdo runtime pruning in iterator if set to TRUE
_fair_remote_cvtFALSEif TRUE enables fair remote convert
_fairness_threshold4number of times to CR serve before downgrading lock
_fast_dual_enabledTRUEenable/disable fast dual
_fast_full_scan_enabledTRUEenable/disable index fast full scan
_fast_start_instance_recovery_target0instance recovery target time in RAC environment
_fg_sync_sleep_usecs0Log file sync via usleep
_fic_algorithm_setautomaticSet Frequent Itemset Counting Algorithm
_fic_area_size131072size of Frequent Itemset Counting work area
_fic_max_length20Frequent Itemset Counting Maximum Itemset Length
_fic_min_bmsize1024Frequent Itemset Counting Minimum BITMAP Size
_fic_outofmem_candidatesFALSEFrequent Itemset Counting Out Of Memory Candidates Generation
_fifth_spare_parameter...fifth spare parameter - string
_filemap_dir...FILEMAP directory
_first_k_rows_dynamic_prorationTRUEenable the use of dynamic proration of join cardinalities
_first_spare_parameter...first spare parameter - integer
_fix_control...bug fix control parameter
_flashback_allow_noarchivelogFALSEAllow enabling flashback on noarchivelog database
_flashback_barrier_interval1800Flashback barrier interval in seconds
_flashback_copy_latches10Number of flashback copy latches
_flashback_fuzzy_barrierTRUEUse flashback fuzzy barrier
_flashback_generation_buffer_size4194304flashback generation buffer size
_flashback_hint_barrier_percent20Flashback hint barrier percent
_flashback_log_io_error_behavior0Specify Flashback log I/O error behavior
_flashback_log_min_size100Minimum flashback log size
_flashback_log_size1000Flashback log size
_flashback_logfile_enqueue_timeout600flashback logfile enqueue timeout for opens
_flashback_marker_cache_enabledTRUEEnable flashback database marker cache
_flashback_marker_cache_size328Size of flashback database marker cache
_flashback_max_log_size0Maximum flashback log size in bytes (OS limit)
_flashback_max_n_log_per_thread2048Maximum number of flashback logs per flashback thread
_flashback_n_log_per_thread128Desired number of flashback logs per flashback thread
_flashback_standby_barrier_interval1800Flashback standby barrier interval in seconds
_flashback_verbose_infoFALSEPrint verbose information about flashback database
_flashback_write_size_qm4Desired flashback write size in quarter MB
_force_datefold_truncFALSEforce use of trunc for datefolding rewrite
_force_rewrite_enableFALSEcontrol new query rewrite features
_force_temptables_for_gsetsFALSEexecutes concatenation of rollups using temp tables
_fourth_spare_parameter...fourth spare parameter - string
_full_pwise_join_enabledTRUEenable full partition-wise join when TRUE
_gby_hash_aggregation_enabledTRUEenable group-by and aggregation using hash scheme
_gby_onekey_enabledTRUEenable use of one comparison of all group by keys
_gc_affinity_limit50dynamic affinity limit
_gc_affinity_minimum6000dynamic affinity minimum activity per minute
_gc_affinity_time10if non zero, enable dynamic object affinity
_gc_async_memcpyFALSEif TRUE, use async memcpy
_gc_check_bscnTRUEif TRUE, check for stale blocks
_gc_coalesce_recovery_readsTRUEif TRUE, coalesce recovery reads
_gc_defer_time3how long to defer down converts for hot buffers
_gc_dissolve_undo_affinityFALSEif TRUE, dissolve undo affinity after an offline
_gc_dynamic_affinity_locksTRUEif TRUE, get dynamic affinity locks
_gc_element_percent103global cache element percent
_gc_global_lruAUTOturn global lru off, make it automatic, or turn it on
_gc_initiate_undo_affinityTRUEif TRUE, initiate undo affinity after an online
_gc_integrity_checks1set the integrity check level
_gc_keep_recovery_buffersTRUEif TRUE, make recovery buffers current
_gc_latches8number of latches per LMS process
_gc_maximum_bids0maximum number of bids which can be prepared
_gc_statisticsTRUEif TRUE, kcl statistics are maintained
_gc_undo_affinityTRUEif TRUE, enable dynamic undo affinity
_gc_undo_affinity_locksTRUEif TRUE, get affinity locks for undo
_gc_use_crTRUEif TRUE, allow CR pins on PI and WRITING buffers
_gc_vector_readTRUEif TRUE, vector read current buffers
_gcs_fast_reconfigTRUEif TRUE, enable fast reconfiguration for gcs locks
_gcs_latches0number of gcs resource hash latches to be allocated per LMS process
_gcs_process_in_recoveryTRUEif TRUE, process gcs requests during instance recovery
_gcs_resources...number of gcs resources to be allocated
_gcs_shadow_locks...number of pcm shadow locks to be allocated
_gcs_testing0GCS testing parameter
_generalized_pruning_enabledTRUEcontrols extensions to partition pruning for general predicates
_ges_dd_debug1if 1 or higher enables GES deadlock detection debug diagnostics
_ges_diagnosticsTRUEif TRUE enables GES diagnostics
_ges_health_check1if greater than 0 enables GES system health check
_globalindex_pnum_filter_enabledTRUEenables filter for global index with partition extended syntax
_groupby_nopushdown_cut_ratio3groupby nopushdown cut ratio
_groupby_orderby_combine5000groupby/orderby don't combine threshold
_gs_anti_semi_join_allowedTRUEenable anti/semi join for the GS query
_hang_analysis_num_call_stacks3hang analysis num call stacks
_hang_detection0Hang Management detection interval
_hard_protectionFALSEif TRUE enable H.A.R.D specific format changes
_hash_join_enabledTRUEenable/disable hash join
_hash_multiblock_io_count0number of blocks hash join will read/write at once
_high_priority_process_num_yields_before_sleep1000the number of yields performed by high priority processesbefore they sleep
_high_priority_processesLMS*High Priority Process Name Mask
_high_server_threshold0high server thresholds
_hj_bit_filter_threshold50hash-join bit filtering threshold (0 always enabled)
_hwm_sync_threshold10HWM synchronization threshold in percentage
_idl_conventional_index_maintenanceTRUEenable conventional index maintenance for insert direct load
_idxrb_rowincr100000000proportionality constant for dop vs. rows in index rebuild
_ignore_desc_in_indexFALSEignore DESC in indexes, sort those columns ascending anyhow
_immediate_commit_propagationTRUEif TRUE, propagate commit SCN immediately
_improved_outerjoin_cardTRUEimproved outer-join cardinality calculation
_improved_row_length_enabledTRUEenable the improvements for computing the average row length
_imr_activeTRUEActivate Instance Membership Recovery feature
_imr_disk_voting_interval3Maximum wait for IMR disk voting (seconds)
_imr_max_reconfig_delay300Maximum Reconfiguration delay (seconds)
_imr_splitbrain_res_wait600Maximum wait for split-brain resolution (seconds)
_imr_systemload_checkTRUEPerform the system load check during IMR
_imu_pools3in memory undo pools
_in_memory_undoTRUEMake in memory undo for top level transactions
_incremental_recovery_ckpt_min_batch30Minimum number of writes for incremental recovery ckpt every 3 sec
_index_join_enabledTRUEenable the use of index joins
_index_prefetch_factor100index prefetching factor
_init_granule_interval10number of granules to process for deferred cache
_init_sql_file?/rdbms/admin/sql.bsqFile containing SQL statements to execute upon database creation
_inject_startup_fault0inject fault in the startup code
_inline_sql_in_plsqlFALSEinline SQL in PL/SQL
_inquiry_retry_interval3if greater than 0 enables inquiry retry after specified interval
_insert_ctas_dependencyFALSEdetermines if ctas cursors insert a dependency on the base table
_insert_enable_hwm_brokeredTRUEduring parallel inserts high water marks are brokered
_inst_locking_period5period an instance can retain a newly acquired level1 bitmap
_interconnect_checksumTRUEif TRUE, checksum interconnect blocks
_intrapart_pdml_enabledTRUEEnable intra-partition updates/deletes
_intrapart_pdml_randomlocal_enabledTRUEEnable intra-partition updates/deletes with random local dist
_io_shared_pool_size4194304Size of I/O buffer pool from SGA
_io_slaves_disabledFALSEDo not use I/O slaves
_ior_serialize_fault0inject fault in the ior serialize code
_ioslave_batch_count1Per attempt IOs picked
_ioslave_issue_count500IOs issued before completion check
_ipc_fail_network0Simulate cluster network failer
_ipc_test_failover0Test transparent cluster network failover
_ipc_test_mult_nets0simulate multiple cluster networks
_job_queue_interval5Wakeup interval in seconds for job queue co-ordinator
_kcl_commitTRUEif TRUE, call kjbcommit
_kcl_conservative_log_flushFALSEif TRUE, conservatively log flush before CR serving
_kcl_debugTRUEif TRUE, record le history
_kcl_index_splitTRUEif TRUE, reject pings on blocks in middle of a split
_kcl_undo_grouping32grouping for undo block locks
_kcl_undo_locks128number of locks per undo segment
_kdbl_enable_post_allocationFALSEallocate dbas after populating data buffers
_keep_remote_column_sizeFALSEremote column size does not get modified
_kernel_message_network_driverFALSEkernel message network driver
_kffmap_hash_size1024size of kffmap_hash table
_kffmop_hash_size2048size of kffmop_hash table
_kghdsidx_count1max kghdsidx count
_kgl_bucket_count9index to the bucket count array
_kgl_fixed_extentsTRUEfixed extent size for library cache memory allocations
_kgl_hash_collisionFALSEwhether KGL hash collision is possible
_kgl_heap_size1024extent size for library cache heap 0
_kgl_keep_cache_pct30KGL keep cache minimum threshold
_kgl_keep_cache_retain_pct20KGL keep cache retain threshold
_kgl_large_heap_warning_threshold52428800maximum heap size before KGL writes warnings to the alert log
_kgl_latch_count0number of library cache latches
_kgl_multi_instance_invalidationTRUEwhether KGL to support multi-instance invalidations
_kgl_multi_instance_lockTRUEwhether KGL to support multi-instance locks
_kgl_multi_instance_pinTRUEwhether KGL to support multi-instance pins
_kgl_session_cached_objects10maximum length of the KGL object cache lru
_kgl_time_to_wait_for_locks15time to wait for locks and pins before timing out
_kglsim_maxmem_percent5max percentage of shared pool size to be used for KGL advice
_kgx_latches512# of mutex latches if CAS is not supported.
_kgx_spin_count255third spare parameter - integer
_kill_controlfile_enqueue_blockerTRUEenable killing controlfile enqueue blocker on timeout
_kill_diagnostics_timeout60timeout delay in seconds before killing enqueue blocker
_kill_enqueue_blocker3if greater than 0 enables killing enqueue blocker
_kill_java_threads_on_eocFALSEKill Java threads and do sessionspace migration at end of call
_kkdlgon_max_iter20000kkdlgon maximum number of iterations
_kkfi_traceFALSEtrace expression substitution
_kks_free_cursor_stat_pct10percentage of cursor stats buckets to scan on each load, in 1/10th of a percent
_kks_use_mutex_pinTRUETurning on this will make KKS use mutex for cursor pins.
_kolfuseslfFALSEallow kolf to use slffopen
_kql_subheap_trace0tracing level for library cache subheap level pins
_ksb_disable_diagpidFALSEdisable the call to ksb_diagpid
_ksb_restart_clean_time30000process uptime for restarts
_ksb_restart_policy_times...process restart policy times in seconds
_ksd_test_param999KSD test parmeter
_ksdxdocmd_default_timeout_ms30000default timeout for internal oradebug commands
_ksdxw_cini_flg0ksdxw context initialization flag
_ksdxw_nbufs1000ksdxw number of buffers in buffered mode
_ksdxw_num_pgw10number of watchpoints on a per-process basis
_ksdxw_num_sgw10number of watchpoints to be shared by all processes
_ksdxw_stack_depth4number of PCs to collect in the stack when watchpoint is hit
_kse_die_timeout60000amount of time a dying process is spared by PMON (in centi-secs)
_kse_pc_table_size256kse pc table cache size
_ksfd_verify_writeFALSEverify asynchronous writes issued through ksfd
_ksi_trace...KSI trace string of lock type(s)
_ksmg_granule_locking_status1granule locking status
_ksmg_granule_size4194304granule size in bytes
_ksmg_lock_check_interval...timeout action interval in minutes
_ksmg_lock_reacquire_count5repeat count for acquisition of locks
_ksu_diag_kill_time5number of seconds ksuitm waits before killing diag
_ksuitm_dont_kill_dumperFALSEdelay inst. termination to allow processes to dump
_ksxp_diagmodeOFFset to OFF to disable automatic slowsend diagnostics
_ksxp_reporting_processLMD0reporting process for KSXP
_ksxp_send_timeout300set timeout for sends queued with the inter-instance IPC
_ksxp_testing0KSXP test parameter
_ktc_debug0for ktc debug
_ktc_latches0number of ktc latches
_ktu_latches0number of KTU latches
_ku_tracenonedatapump trace parameter
_large_pool_min_alloc65536minimum allocation size in bytes for the large allocation pool
_last_allocation_period5period over which an instance can retain an active level1 bitmap
_latch_class_0...latch class 0
_latch_class_1...latch class 1
_latch_class_2...latch class 2
_latch_class_3...latch class 3
_latch_class_4...latch class 4
_latch_class_5...latch class 5
_latch_class_6...latch class 6
_latch_class_7...latch class 7
_latch_classes...latch classes override
_latch_miss_stat_sid0Sid of process for which to collect latch stats
_latch_recovery_alignment998align latch recovery structures
_ldr_io_size262144size of write IOs used during a load operation
_left_nested_loops_randomTRUEenable random distribution method for left of nestedloops
_lgwr_async_broadcastsTRUELGWR Asynchronous Broadcasts enabling boolean flag
_lgwr_async_ioFALSELGWR Asynchronous IO enabling boolean flag
_lgwr_delay_writeFALSELGWR write delay for debugging
_lgwr_io_slaves0LGWR I/O slaves
_lgwr_max_ns_wt1Maximum wait time for lgwr to allow NetServer to progress
_lgwr_ns_nl_max1000Variable to simulate network latency or buffer threshold
_lgwr_ns_nl_min500Variable to simulate network latency or buffer threshold
_lgwr_ns_sim_err0Variable to simulate errors lgwrns
_lgwr_ta_sim_err0Variable to simulate errors lgwr true async
_library_cache_adviceTRUEwhether KGL advice should be turned on
_lightweight_hdrsTRUELightweight headers for redo
_like_with_bind_as_equalityFALSEtreat LIKE predicate with bind as an equality predicate
_lm_activate_lms_threshold100threshold value to activate an additional lms
_lm_better_ddvictimTRUEGES better deadlock victim
_lm_cache_lvl0_cleanup0how often to cleanup level 0 cache res (in sec)
_lm_cache_res_cleanup25percentage of cached resources should be cleanup
_lm_cache_res_typeTMHWDIcache resource: string of lock types(s)
_lm_checksum_batch_msgFALSEGES checksum batch messages
_lm_contiguous_res_count128number of contiguous blocks that will hash to the same HV bucket
_lm_dd_interval60dd time interval in seconds
_lm_dd_max_search_time180max dd search time per token
_lm_dd_scan_interval5dd scan interval in seconds
_lm_dd_search_cnt3number of dd search per token get
_lm_drm_max_requests100dynamic remastering maximum affinity requests processed together
_lm_drm_window0dynamic remastering bucket window size
_lm_drm_xlatch0dynamic remastering forced exclusive latches
_lm_dynamic_lmsFALSEdynamic lms invocation
_lm_dynamic_loadTRUEdynamic load adjustment
_lm_dynamic_remasteringFALSEif TRUE enables dynamic remastering
_lm_enq_lock_freelist...Number of ges enqueue element freelist
_lm_enq_rcfgTRUEif TRUE enables enqueue reconfiguration
_lm_enqueue_freelist3Number of enqueue freelist
_lm_file_affinity...mapping between file id and master instance number
_lm_global_postsTRUEif TRUE deliver global posts to remote nodes
_lm_lmd_waittime8default wait time for lmd in centiseconds
_lm_lms0number of background gcs server processes to start
_lm_lms_waittime8default wait time for lms in centiseconds
_lm_locks12000number of enqueues configured for cluster database
_lm_master_weight1master resource weight for this instance
_lm_max_lms0max. number of background global cache server processes
_lm_min_lms0min. number of background global cache server processes
_lm_msg_batch_size0GES batch message size
_lm_msg_cache_thresholds...GES message buffer caching threshold
_lm_msg_cleanup_interval3000GES message buffer cleanup interval time
_lm_node_join_optFALSEcluster database node join optimization in reconfig
_lm_non_fault_tolerantFALSEdisable cluster database fault-tolerance mode
_lm_num_pcmhv_latches0number of latches covering the PCM HV buckets in cgs
_lm_num_pt_buckets4096number of buckets in the object affinity hash table
_lm_num_pt_latches128number of latches in the object affinity hash table
_lm_postevent_buffer_size256postevent buffer size
_lm_proc_freeze_timeout300reconfiguration: process freeze timeout
_lm_process_batchingTRUEGES implicit process batching for IPC messages
_lm_procs320number of client processes configured for cluster database
_lm_rcfg_timeout180000Reconfiguration timeout
_lm_rcv_buffer_size32768the size of receive buffer
_lm_rcvr_hang_allow_time200receiver hang allow time in seconds
_lm_rcvr_hang_check_frequency60receiver hang check frequency in seconds
_lm_rcvr_hang_killFALSEto kill receiver hang
_lm_res_hash_bucket0number of resource hash buckets
_lm_res_part128number of resource partition configured for gcs
_lm_ress6000number of resources configured for cluster database
_lm_send_buffers10000number of cluster database send buffers
_lm_send_modeautoGES send mode
_lm_send_queue_batchingTRUEGES send queue message batching
_lm_send_queue_length5000GES send queue maximum length
_lm_sendproxy_reserve25GES percentage of send proxy reserve of send tickets
_lm_share_lock_optFALSEif TRUE enables share lock optimization
_lm_sq_batch_factor2GES send queue minimum batching factor
_lm_sq_batch_typeautoGES send queue batching mechanism
_lm_sq_batch_waittick3GES send queue batching waittime in tick
_lm_sync_timeout...Synchronization timeout for DLM reconfiguration steps
_lm_ticket_active_sendback...Flow control ticket active sendback threshold
_lm_tickets1000GES messaging tickets
_lm_tx_delta16TX lock localization delta
_lm_validate_resource_typeFALSEif TRUE enables resource name validation
_lm_xids352number of transaction IDs configured for cluster database
_load_without_compileNONELoad PL/SQL or Database objects without compilation
_local_communication_costing_enabledTRUEenable local communication costing when TRUE
_local_communication_ratio50set the ratio between global and local communication (0..100)
_lock_sga_areas0Lock specified areas of the SGA in physical memory
_log_archive_avoid_memcpyTRUElog archive avoid memcpy
_log_archive_buffer_size2048Size of each archival buffer in log file blocks
_log_archive_buffers10Number of buffers to allocate for archiving
_log_archive_callout...archival callout
_log_archive_compress_enableFALSEBypass database rules for enabling archivelog compression
_log_archive_delta_sync_wait0iterative sleep time in centiseconds seconds when SYNC=PARALLEL
_log_archive_net_timeout0maximum network wait time in seconds when SYNC=PARALLEL
_log_archive_network_redo_size10Log archive network redo buffer size used by ARCH
_log_archive_prot_auto_demoteFALSElog archive protection auto demotion
_log_archive_security_enabledTRUElog archive security enabled
_log_blocks_during_backupTRUElog block images when changed during backup
_log_buffers_corruptFALSEcorrupt redo buffers before write
_log_buffers_debugFALSEdebug redo buffers (slows things down)
_log_checkpoint_recovery_check0# redo blocks to verify after checkpoint
_log_committime_block_cleanoutFALSELog commit-time block cleanout
_log_debug_multi_instanceFALSEdebug redo multi instance code
_log_deletion_policymandatoryarchivelog deletion policy for mandatory/all destination
_log_event_queues0number of the log writer event queues
_log_io_size0automatically initiate log write if this many redo blocks in buffer
_log_parallelism1Number of log buffer strands
_log_parallelism_dynamicTRUEEnable dynamic strands
_log_parallelism_max1Maximum number of log buffer strands
_log_private_mul5Private strand multiplier for log space preallocation
_log_private_parallelismFALSENumber of private log buffer strands for zero-copy redo
_log_private_parallelism_mul10Active sessions multiplier to deduce number of private strands
_log_simultaneous_copies2number of simultaneous copies into redo buffer(# of copy latches)
_log_space_errorsTRUEshould we report space errors to alert log
_log_switch_timeout0Maximum number of seconds redos in the current log could span
_logout_storm_rate0number of processes that can logout in a second
_logout_storm_retrycnt600maximum retry count for logouts
_logout_storm_timeout5timeout in centi-seconds for time to wait between retries
_longops_enabledTRUElongops stats enabled
_low_server_threshold0low server thresholds
_master_direct_sends31direct sends for messages from master (DFS)
_mav_refresh_consistent_readTRUErefresh materialized views using consistent read snapshot
_mav_refresh_double_count_preventedFALSEmaterialized view MAV refreshes avoid double counting
_mav_refresh_opt0optimizations during refresh of materialized views
_mav_refresh_unionall_tables3# tables for union all expansion during materialized view refresh
_max_arch_lns_wait120Maximum wait by ARCH to allow NetServer to complete archival
_max_exponential_sleep0max sleep during exponential backoff
_max_lns_shutdown_archival_time30Maximum time spent by LNS to archive last log during shutdown
_max_protocol_support10000Max occurrence protocols supported in a process
_max_rfs_connections0maximum number of connections used for remote archival
_max_shrink_obj_stats0number of segments for which shrink stats will be maintained
_max_sleep_holding_latch4max time to sleep while holding a latch
_media_recovery_read_batch128media recovery block read batch
_media_recovery_reap_time3media recovery reap time
_mem_annotation_pr_lev0private memory annotation collection level
_mem_annotation_scale1memory annotation pre-allocation scaling
_mem_annotation_sh_lev0shared memory annotation collection level
_mem_annotation_storeFALSEmemory annotation in-memory store
_mem_std_extent_size4096standard extent size for fixed-size-extent heaps
_memory_broker_log_stat_entries5memory broker num stat entries
_memory_broker_marginal_utility_bc10Marginal Utility threshold pct for bc
_memory_broker_marginal_utility_sp4Marginal Utility threshold pct for sp
_memory_broker_shrink_heaps15memory broker allow policy to shrink shared pool
_memory_broker_shrink_java_heaps900memory broker allow policy to shrink java pool
_memory_broker_shrink_streams_pool900memory broker allow policy to shrink streams pool
_memory_broker_shrink_timeout60000000memory broker policy to timeout shrink shared/java pool
_memory_broker_stat_interval30memory broker statistics gathering interval
_memory_management_tracing0trace memory management activity
_memory_sanity_check0partial granule sanity check
_messages300message queue resources - dependent on # processes & # buffers
_minfree_plus0max percentage of block space + minfree before we mark block full
_minimal_stats_aggregationTRUEprohibit stats aggregation at compile/partition maintenance time
_minimum_blocks_to_shrink0minimum number freeable blocks for shrink to be present
_minimum_extents_to_shrink1minimum number freeable extents for shrink to be present
_minimum_giga_scn0Minimum SCN to start with in 2^30 units
_mirror_redo_buffersFALSESave buffers for debugging redo corruptions
_mmv_query_rewrite_enabledTRUEallow rewrites with multiple MVs and/or base tables
_multi_join_key_table_lookupTRUETRUE iff multi-join-key table lookup prefetch is enabled
_multiple_instance_recoveryFALSEuse multiple instances for media recovery
_mv_refresh_ana0what percent to analyze after complete/PCT refresh
_mv_refresh_costingrulerefresh decision based on cost or on rules
_mv_refresh_delta_fraction10delta mv as fractional percentage of size of mv
_mv_refresh_eutTRUErefresh materialized views using EUT(partition)-based algorithm
_mv_refresh_force_parallel_query0force materialized view refreshes to use parallel query
_mv_refresh_new_setup_disabledFALSEmaterialized view MV refresh new setup disabling
_mv_refresh_rebuild_percentage10minimum percentage change required in MV to force an index rebuild
_mv_refresh_selectionsTRUEcreate materialized views with selections and fast refresh
_mv_refresh_use_statsFALSEpass cardinality hints to refresh queries
_mv_refsched_timeincr300000proportionality constant for dop vs. time in MV refresh
_mv_rolling_invFALSEcreate/alter mv uses rolling cursor invalidation instead of immediate
_mwin_scheduleTRUEEnable/disable Maintenance Window Schedules
_nchar_imp_cnvTRUENLS allow Implicit Conversion between CHAR and NCHAR
_nchar_imp_convTRUEshould implicit conversion bewteen clob and nclob be allowed
_ncmb_readahead_enabled0enable multi-block readahead for an index scan
_ncmb_readahead_tracing0turn on multi-block readahead tracing
_nested_loop_fudge100nested loop fudge
_nested_mav_fast_oncommit_enabledTRUEnested MAV refresh fast on commit allowed
_new_initial_join_ordersTRUEenable initial join orders based on new ordering heuristics
_new_sort_cost_estimateTRUEenables the use of new cost estimate for sort
_newsort_enabledTRUEcontrols whether new sorts can be used as system sort
_newsort_ordered_pct63controls when new sort avoids sorting ordered input
_newsort_type0specifies options for the new sort algorithm
_no_objectsFALSEno object features are used
_no_or_expansionFALSEOR expansion during optimization disabled
_no_recovery_through_resetlogsFALSEno recovery through this resetlogs operation
_notify_crsFALSEnotify cluster ready services of startup and shutdown
_ns_max_flush_wt1Flush wait time for NetServer to flush oustanding writes
_ns_max_send_delay15Data Loss Time Bound for NetServer
_num_longop_child_latches1number of child latches for long op array
_number_cached_attributes10maximum number of cached attributes per instance
_object_reuse_bast2if 1 or higher, handle object reuse
_object_statisticsTRUEenable the object level statistics collection
_offline_rollback_segments...offline undo segment list
_ogms_home...GMS home directory
_olap_aggregate_buffer_size1048576OLAP Aggregate max buffer size
_olap_aggregate_flags0OLAP Aggregate debug flags
_olap_aggregate_function_cache_enabledTRUEOLAP Aggregate function cache enabler
_olap_aggregate_function_merge_threshold529OLAP Aggregate function merge threshold
_olap_aggregate_max_thread_tuples5000OLAP Aggregate max thread tuples creation
_olap_aggregate_min_buffer_size1024OLAP Aggregate min buffer size
_olap_aggregate_min_thread_status64OLAP Aggregate minimum cardinality of dimensions for thread
_olap_aggregate_multipath_hierFALSEOLAP Aggregate Multi-path Hierarhies enabled
_olap_aggregate_statlen_thresh1024OLAP Aggregate status array usage threshold
_olap_aggregate_store_probability100OLAP Aggregate function storeback probability
_olap_aggregate_work_per_thread1024OLAP Aggregate max work parents
_olap_aggregate_worklist_max5000OLAP Aggregate max worklists generated at once
_olap_allocate_errorlog_format%8p %8y %8z %e (%n)OLAP Allocate Errorlog Format
_olap_allocate_errorlog_headerDim Source Basis %-8d %-8s %-8b Description -------- -------- -------- -----------OLAP Allocate Errorlog Header format
_olap_continuous_trace_fileFALSESpecify TRUE to enable continuous OLAP tracing - otherwise only exceptional events will be logged
_olap_dbgoutfile_echo_to_eventlogFALSEOLAP DbgOutfile copy output to event log (tracefile)
_olap_dimension_corehash_class1OLAP Dimension In-Core Hash Table Class
_olap_dimension_corehash_max10000OLAP Dimension In-Core Hash Table Maximum Size
_olap_eif_export_lob_size2147483647OLAP EIF Export BLOB size
_olap_lmgen_dim_size100Limitmap generator dimension column size
_olap_lmgen_meas_size1000Limitmap generator measure column size
_olap_object_hash_class2OLAP Object Hash Table Class
_olap_page_pool_expand_rate20OLAP Page Pool Expand Rate
_olap_page_pool_hi50OLAP Page Pool High Watermark
_olap_page_pool_hit_target100OLAP Page Pool Hit Target
_olap_page_pool_low262144OLAP Page Pool Low Watermark
_olap_page_pool_pressure90OLAP Page Pool Pressure Threshold
_olap_page_pool_shrink_rate50OLAP Page Pool Shrink Rate
_olap_parallel_update_small_group400OLAP parallel update pagespace by group
_olap_parallel_update_small_threshold1000OLAP parallel update threshold for number of small pagespaces
_olap_parallel_update_threshold1000OLAP parallel update threshold in pages
_olap_poutlog_echo_to_eventlogFALSEOLAP POutLog copy output to event log (tracefile)
_olap_sesscache_enabledTRUEOLAP Session Cache knob
_olap_sort_buffer_size262144OLAP Sort Buffer Size
_olap_statbool_corebits20000000OLAP Status Boolean max incore bits
_olap_statbool_threshold8100OLAP Status Boolean CBM threshold
_olap_table_function_statisticsFALSESpecify TRUE to output OLAP table function timed statistics trace
_olap_wrap_errorsFALSEWrap error messages to OLAP outfile
_olapi_history_retentionFALSEenable olapi history retention
_olapi_iface_object_history1000enable olapi interface object history collection
_olapi_iface_object_history_retentionFALSEenable olapi interface object history retention
_olapi_iface_operation_history_retentionFALSEenable olapi interface operation history retention
_olapi_interface_operation_history1000enable olapi interface operation history collection
_olapi_memory_operation_history1000enable olapi memory alloc/free history collection
_olapi_memory_operation_history_pause_at_seqno0enable olapi memory alloc/free history collection pausing
_olapi_memory_operation_history_retentionFALSEenable olapi memory operation history retention
_olapi_session_history300enable olapi session history collection
_olapi_session_history_retentionFALSEenable olapi session history retention
_old_connect_by_enabledFALSEenable/disable old connect by
_ols_cleanup_taskTRUEClean up unnecessary entries in OLS sessinfo table
_omfenabledenable/disable OMF
_oneside_colstat_for_equijoinsTRUEsanity check on default selectivity for like/range predicate
_optim_adjust_for_part_skewsTRUEadjust stats for skews across partitions
_optim_dict_stats_at_db_cr_upgTRUEenable/disable dictionary stats gathering at db create/upgrade
_optim_enhance_nnull_detectionTRUETRUE to enable index [fast] full scan more often
_optim_new_default_join_selTRUEimproves the way default equijoin selectivity are computed
_optim_peek_user_bindsTRUEenable peeking of user binds
_optimizer_adjust_for_nullsTRUEadjust selectivity for null values
_optimizer_autostats_jobTRUEenable/disable auto stats collection job
_optimizer_better_inlist_costingALLenable improved costing of index access using in-list(s)
_optimizer_block_size8192standard block size used by optimizer
_optimizer_cache_statsFALSEcost with cache statistics
_optimizer_cartesian_enabledTRUEoptimizer cartesian join enabled
_optimizer_cbqt_factor50cost factor for cost-based query transformation
_optimizer_cbqt_no_size_restrictionTRUEdisable cost based transformation query size restriction
_optimizer_ceil_costTRUECEIL cost in CBO
_optimizer_choose_permutation0force the optimizer to use the specified permutation
_optimizer_complex_pred_selectivityTRUEenable selectivity estimation for builtin functions
_optimizer_compute_index_statsTRUEforce index stats collection on index creation/rebuild
_optimizer_connect_by_combine_swTRUEcombine no filtering connect by and start with
_optimizer_connect_by_cost_basedTRUEuse cost-based transformation for connect by
_optimizer_correct_sq_selectivityTRUEforce correct computation of subquery selectivity
_optimizer_cost_based_transformationLINEARenables cost-based query transformation
_optimizer_cost_filter_predFALSEenables costing of filter predicates in IO cost model
_optimizer_cost_hjsmj_multimatchTRUEadd cost of generating result set when #rows per key > 1
_optimizer_cost_modelCHOOSEoptimizer cost model
_optimizer_degree0force the optimizer to use the same degree of parallelism
_optimizer_dim_subq_join_selTRUEuse join selectivity in choosing star transformation dimensions
_optimizer_disable_strans_sanity_checks0disable star transformation sanity checks
_optimizer_dyn_smp_blks32number of blocks for optimizer dynamic sampling
_optimizer_enable_density_improvementsFALSEuse improved density computation for selectivity estimation
_optimizer_enhanced_filter_pushTRUEpush filters before trying cost-based query transformation
_optimizer_extended_cursor_sharingUDOoptimizer extended cursor sharing
_optimizer_filter_pred_pullupTRUEuse cost-based flter predicate pull up transformation
_optimizer_fkr_index_cost_bias10Optimizer index bias over FTS/IFFS under first K rows mode
_optimizer_ignore_hintsFALSEenables the embedded hints to be ignored
_optimizer_invalidation_period18000time window for invalidation of cursors of analyzed objects
_optimizer_join_elimination_enabledTRUEoptimizer join elimination enabled
_optimizer_join_order_control3controls the optimizer join order search algorithm
_optimizer_join_sel_sanity_checkTRUEenable/disable sanity check for multi-column join selectivity
_optimizer_max_permutations2000optimizer maximum join permutations per query block
_optimizer_min_cache_blocks10set minimum cached blocks
_optimizer_mjc_enabledTRUEenable merge join cartesian
_optimizer_mode_forceTRUEforce setting of optimizer mode for user recursive SQL also
_optimizer_multiple_cenv...generate and run plans using several compilation environments
_optimizer_native_full_outer_joinoffexecute full outer join using native implementaion
_optimizer_new_join_card_computationTRUEcompute join cardinality using non-rounded input values
_optimizer_or_expansionDEPTHcontrol or expansion approach used
_optimizer_or_expansion_subheapTRUEUse subheap for optimizer or-expansion
_optimizer_order_by_elimination_enabledTRUEEliminates order bys from views before query transformation
_optimizer_outer_to_anti_enabledTRUEEnable transformation of outer-join to anti-join if possible
_optimizer_percent_parallel101optimizer percent parallel
_optimizer_push_down_distinct0push down distinct from query block to table
_optimizer_push_pred_cost_basedTRUEuse cost-based query transformation for push pred optimization
_optimizer_random_plan0optimizer seed value for random plans
_optimizer_rownum_bind_default10Default value to use for rownum bind
_optimizer_rownum_pred_based_fkrTRUEenable the use of first K rows due to rownum predicate
_optimizer_save_statsTRUEenable/disable saving old versions of optimizer stats
_optimizer_search_limit5optimizer search limit
_optimizer_self_induced_cache_costFALSEaccount for self-induced caching
_optimizer_skip_scan_enabledTRUEenable/disable index skip scan
_optimizer_skip_scan_guessFALSEconsider index skip scan for predicates with guessed selectivity
_optimizer_sortmerge_join_enabledTRUEenable/disable sort-merge join method
_optimizer_sortmerge_join_inequalityTRUEenable/disable sort-merge join using inequality predicates
_optimizer_squ_bottomupTRUEenables unnesting of subquery in a bottom-up manner
_optimizer_star_tran_in_with_clauseTRUEenable/disable star transformation in with clause queries
_optimizer_star_trans_min_cost0optimizer star transformation minimum cost
_optimizer_star_trans_min_ratio0optimizer star transformation minimum ratio
_optimizer_starplan_enabledTRUEoptimizer star plan enabled
_optimizer_system_stats_usageTRUEsystem statistics usage
_optimizer_tracenoneoptimizer trace parameter
_optimizer_transitivity_retainTRUEretain equi-join pred upon transitive equality pred generation
_optimizer_undo_changesFALSEundo changes to query optimizer
_optimizer_undo_cost_change10.2.0.4optimizer undo cost change
_optimizer_use_histogramsTRUEControls whether to use histograms
_optimizer_use_subheapTRUEEnables physical optimizer subheap
_or_expand_nvl_predicateTRUEenable OR expanded plan for NVL/DECODE predicate
_oradbg_pathname...path of oradbg script
_oradebug_forceFALSEforce target processes to execute oradebug commands?
_ordered_nested_loopTRUEenable ordered nested loop costing
_ordered_semijoinTRUEenable ordered semi-join subquery
_os_sched_high_priority1OS high priority level
_other_wait_event_exclusion...exclude event names from _other_wait_threshold calculations
_other_wait_threshold0threshold wait percentage for event wait class Other
_outline_bitmap_treeTRUEBITMAP_TREE hint enabled in outline
_parallel_adaptive_max_users2maximum number of users running with default DOP
_parallel_broadcast_enabledTRUEenable broadcasting of small inputs to hash and sort merge joins
_parallel_default_max_instances1default maximum number of instances for parallel query
_parallel_execution_message_alignFALSEAlignment of PX buffers to OS page boundary
_parallel_fake_class_pct0fake db-scheduler percent used for testing
_parallel_fixwrite_bucket1000Number of buckets for each round of fix write
_parallel_load_bal_unit0number of threads to allocate per instance
_parallel_load_balancingTRUEparallel execution load balanced slave allocation
_parallel_min_message_pool206208minimum size of shared pool memory to reserve for pq servers
_parallel_recovery_stopat32767stop at -position- to step through SMON
_parallel_replay_msg_limit4000Number of messages for each round of parallel replay
_parallel_server_idle_time30000idle time before parallel query server dies (in 1/100 sec)
_parallel_server_sleep_time10sleep time between dequeue timeouts (in 1/100ths)
_parallel_slave_acquisition_wait1time(in seconds) to wait before retrying slave acquisition
_parallel_txn_globalFALSEenable parallel_txn hint with updates and deletes
_parallelism_cost_fudge_factor350set the parallelism cost fudge factor
_parameter_table_block_size1024parameter table block size
_partial_pwise_join_enabledTRUEenable partial partition-wise join when TRUE
_partition_view_enabledTRUEenable/disable partitioned views
_passwordfile_enqueue_timeout900password file enqueue timeout in seconds
_pct_refresh_double_count_preventedTRUEmaterialized view PCT refreshes avoid double counting
_pdml_gim_sampling5000control separation of global index maintenance for PDML
_pdml_gim_staggeredFALSEslaves start on different index when doing index maint
_pdml_slaves_diff_partTRUEslaves start on different partition when doing index maint
_percent_flashback_buf_partial_full50Percent of flashback buffer filled to be considered partial full
_pga_large_extent_size1048576PGA large extent size
_pga_max_size209715200Maximum size of the PGA memory for one process
_ping_level3fusion ping level
_pkt_enableFALSEenable progressive kill test
_pkt_pmon_interval50PMON process clean-up interval (cs)
_pkt_startFALSEstart progressive kill test instrumention
_plan_outline_dataTRUEexplain plan outline data enabled
_plsql_anon_block_code_typeINTERPRETEDPL/SQL anonymous block code-type
_plsql_cache_enableTRUEPL/SQL Function Cache Enabled
_plsql_dump_buffer_events...conditions upon which the PL/SQL circular buffer is dumped
_plsql_minimum_cache_hit_percent20plsql minimum cache hit percentage required to keep caching active
_plsql_nvl_optimizeFALSEPL/SQL NVL optimize
_pmon_load_constants300,192,64,3,10,10,0,0server load balancing constants (S,P,D,I,L,C,M)
_pre_rewrite_push_predTRUEpush predicates into views before rewrite
_precompute_gid_valuesTRUEprecompute gid values and copy them before returning a row
_pred_move_aroundTRUEenables predicate move-around
_predicate_elimination_enabledTRUEallow predicate elimination if set to TRUE
_prescommFALSEpresume commit of IMU transactions
_print_refresh_schedulefalseenable dbms_output of materialized view refresh schedule
_private_memory_address...Start address of large extent memory segment
_project_view_columnsTRUEenable projecting out unreferenced columns of a view
_projection_pushdownTRUEprojection pushdown
_projection_pushdown_debug0level for projection pushdown debugging
_push_join_predicateTRUEenable pushing join predicate inside a view
_push_join_union_viewTRUEenable pushing join predicate inside a union all view
_push_join_union_view2TRUEenable pushing join predicate inside a union view
_px_async_getgranuleFALSEasynchronous get granule in the slave
_px_bind_peek_sharingTRUEenables sharing of px cursors that were built using bind peeking
_px_broadcast_fudge_factor100set the tq broadcasting fudge factor percentage
_px_buffer_ttl30ttl for px mesg buffers in seconds
_px_compilation_debug0debug level for parallel compilation
_px_compilation_trace0tracing level for parallel compilation
_px_dynamic_optTRUEturn off/on restartable qerpx dynamic optimization
_px_dynamic_sample_size50num of samples for restartable qerpx dynamic optimization
_px_granule_size100000default size of a rowid range granule (in KB)
_px_index_sampling200parallel query sampling for index create (100000 = 100%)
_px_kxib_tracing0turn on kxib tracing
_px_load_publish_interval200interval at which LMON will check whether to publish PX load
_px_loc_msg_cost1000CPU cost to send a PX message via shared memory
_px_max_granules_per_slave100maximum number of rowid range granules to generate per slave
_px_min_granules_per_slave13minimum number of rowid range granules to generate per slave
_px_minus_intersectTRUEenables pq for minus/interect operators
_px_net_msg_cost10000CPU cost to send a PX message over the internconnect
_px_no_granule_sortFALSEprevent parallel partition granules to be sorted on size
_px_no_stealingFALSEprevent parallel granule stealing in shared nothing environment
_px_nss_planbTRUEenables or disables NSS Plan B reparse with outline
_px_proc_constrainTRUEreduce parallel_max_servers if greater than (processes - fudge)
_px_pwg_enabledTRUEparallel partition wise group by enabled
_px_rownum_pdTRUEturn off/on parallel rownum pushdown optimization
_px_send_timeout300IPC message send timeout value in seconds
_px_slaves_share_cursors0slaves share cursors with QC
_px_tracenonepx trace parameter
_px_ual_serial_inputTRUEenables new pq for UNION operators
_px_xtgranule_size10000default size of a external table granule (in KB)
_qa_control0Oracle internal parameter to control QA
_qa_lrg_type0Oracle internal parameter to specify QA lrg type
_query_cost_rewriteTRUEperform the cost based rewrite with materialized views
_query_execution_cache_max_size65536max size of query execution cache
_query_rewrite_1TRUEperform query rewrite before&after or only before view merging
_query_rewrite_2TRUEperform query rewrite before&after or only after view merging
_query_rewrite_drjTRUEmv rewrite and drop redundant joins
_query_rewrite_expressionTRUErewrite with cannonical form for expressions
_query_rewrite_fpcTRUEmv rewrite fresh partition containment
_query_rewrite_fudge90cost based query rewrite with MVs fudge factor
_query_rewrite_jgmigrateTRUEmv rewrite with jg migration
_query_rewrite_maxdisjunct257query rewrite max disjuncts
_query_rewrite_or_errorFALSEallow query rewrite, if referenced tables are not dataless
_query_rewrite_setopgrw_enableTRUEperform general rewrite using set operator summaries
_query_rewrite_vop_cleanupTRUEprune frocol chain before rewrite after view-merging
_rcfg_disable_verifyFALSEif TRUE disables verify at reconfiguration
_rcfg_parallel_fixwriteTRUEif TRUE enables parallel fixwrite at reconfiguration
_rcfg_parallel_replayTRUEif TRUE enables parallel replay and cleanup at reconfiguration
_rcfg_parallel_verifyTRUEif TRUE enables parallel verify at reconfiguration
_real_time_apply_arch_delay0Archival delay with real time apply
_real_time_apply_sim0Simulation value with real time apply
_realfree_heap_max_size32768minimum max total heap size, in Kbytes
_realfree_heap_mode0mode flags for real-free heap
_realfree_heap_pagesize_hint65536hint for real-free page size in bytes
_recoverable_recovery_batch_percent50Recoverable recovery batch size (percentage of buffer cache)
_recovery_assertsFALSEif TRUE, enable expensive integrity checks
_recovery_percentage50recovery buffer cache percentage
_recovery_skip_cfseq_checkFALSEallow media recovery even if controlfile seq check fails
_recovery_verify_writesFALSEenable thread recovery write verify
_recursive_imu_transactionsFALSErecursive transactions may be IMU
_redo_compatibility_checkFALSEgeneral and redo/undo compatibility sanity check
_release_insert_threshold5maximum number of unusable blocks to unlink from freelist
_reliable_block_sendsFALSEif TRUE, block sends across interconnect are reliable
_remove_aggr_subqueryTRUEenables removal of subsumed aggregated subquery
_resource_manager_always_onTRUEenable the resource manager always
_restore_spfile...restore spfile to this location
_reuse_index_loop5number of blocks being examine for index block reuse
_right_outer_hash_enableTRUERight Outer/Semi/Anti Hash Enabled
_rm_numa_sched_enableFALSEIs Resource Manager (RM) related NUMA scheduled policy enabled
_rm_numa_simulation_cpus0number of cpus per PG for numa simulation in resource manager
_rm_numa_simulation_pgs0number of PGs for numa simulation in resource manager
_rman_io_priority3priority at which rman backup i/o's are done
_rollback_segment_count0number of undo segments
_rollback_segment_initial1starting undo segment number
_rollback_stopat0stop at -position to step rollback
_row_cache_cursors20number of cached cursors for row cache management
_row_crTRUEenable row cr for all sql
_row_shipping_explainFALSEenable row shipping explain plan support
_row_shipping_threshold80row shipping column selection threshold
_rowsource_execution_statisticsTRUEif TRUE, Oracle will collect rowsource statistics
_rowsource_statistics_sampfreq128frequency of rowsource statistic sampling (must be a power of 2)
_rowsrc_trace_level0Row source tree tracing level
_sample_rows_per_block4number of rows per block used for sampling IO optimization
_scatter_gcs_resourcesFALSEif TRUE, gcs resources are scattered uniformly across sub pools
_scatter_gcs_shadowsFALSEif TRUE, gcs shadows are scattered uniformly across sub pools
_second_spare_parameter...second spare parameter - integer
_selfjoin_mv_duplicatesTRUEcontrol rewrite self-join algorithm
_selftune_checkpoint_write_pct3Percentage of total physical i/os for self-tune ckpt
_selftune_checkpointing_lag300Self-tune checkpointing lag the tail of the redo log
_send_ast_to_foregroundTRUEif TRUE, send ast message to foreground
_send_close_with_blockTRUEif TRUE, send close with block even with direct sends
_send_requests_to_piTRUEif TRUE, try to send CR requests to PI buffers
_serial_direct_readFALSEenable direct read in serial
_serial_recoveryFALSEforce serial recovery or parallel recovery
_session_cached_instantiations60Number of pl/sql instantiations to cache in a session.
_session_context_size10000session app context size
_session_idle_bit_latches0one latch per session or a latch per group of sessions
_session_idle_check_interval60Resource Manager session idle limit check interval in seconds
_session_kept_cursor_pins0Number of cursors pins to keep in a session
_session_wait_history10enable session wait history collection
_seventh_spare_parameter...seventh spare parameter - string list
_shared_pool_max_size0shared pool maximum size when auto SGA enabled
_shared_pool_minsize_onFALSEshared pool minimum size when auto SGA enabled
_shared_pool_reserved_min_alloc4400minimum allocation size in bytes for reserved area of shared pool
_shared_pool_reserved_pct5percentage memory of the shared pool allocated for the reserved area
_short_stack_timeout_ms30000short stack timeout in ms
_shrunk_aggs_disable_threshold60percentage of exceptions at which to switch to full length aggs
_shrunk_aggs_enabledTRUEenable use of variable sized buffers for non-distinct aggregates
_side_channel_batch_size200number of messages to batch in a side channel message (DFS)
_side_channel_batch_timeout6timeout before shipping out the batched side channelmessages in seconds
_side_channel_batch_timeout_ms500timeout before shipping out the batched side channelmessages in milliseconds
_simple_view_mergingTRUEcontrol simple view merging performed by the optimizer
_simulator_bucket_mindelta8192LRU bucket minimum delta
_simulator_internal_bound10simulator internal bound percent
_simulator_lru_rebalance_sizthr2LRU list rebalance threshold (size)
_simulator_lru_rebalance_thresh10240LRU list rebalance threshold (count)
_simulator_lru_scan_count8LRU scan count
_simulator_pin_inval_maxcnt16maximum count of invalid chunks on pin list
_simulator_reserved_heap_count4096simulator reserved heap count
_simulator_reserved_obj_count1024simulator reserved object count
_simulator_sampling_factor2sampling factor for the simulator
_simulator_upper_bound_multiple2upper bound multiple of pool size
_single_processFALSErun without detached processes
_sixth_spare_parameter...sixth spare parameter - string list
_skgxp_reaping1000tune skgxp OSD reaping limit
_skgxp_udp_ach_reaping_time0time in minutes before idle ach's are reaped
_skgxp_udp_hiwat_warn1000ach hiwat mark warning interval
_skgxp_udp_interface_detection_time_secs60time in seconds between interface detection checks
_skgxp_udp_keep_alive_ping_timer_secs300connection idle time in seconds before keep alive is initiated. min: 30 sec max: 1800 sec default: 300 sec
_skgxp_udp_lmp_mtusize0MTU size for UDP LMP testing
_skgxp_udp_lmp_onFALSEenable UDP long message protection
_skgxp_udp_timed_wait_buffering1024diagnostic log buffering space (in bytes) for timed wait (0 means unbufferd
_skgxp_udp_timed_wait_seconds5time in seconds before timed wait is invoked
_skip_assume_msgTRUEif TRUE, skip assume message for consigns at the master
_slave_mapping_enabledTRUEenable slave mapping when TRUE
_slave_mapping_group_size0force the number of slave group in a slave mapper
_small_table_threshold139threshold level of table size for direct reads
_smm_advice_enabledTRUEif TRUE, enable v$pga_advice
_smm_advice_log_size0overwrites default size of the PGA advice workarea history log
_smm_auto_cost_enabledTRUEif TRUE, use the AUTO size policy cost functions
_smm_auto_max_io_size248Maximum IO size (in KB) used by sort/hash-join in auto mode
_smm_auto_min_io_size56Minimum IO size (in KB) used by sort/hash-join in auto mode
_smm_bound0overwrites memory manager automatically computed bound
_smm_control0provides controls on the memory manager
_smm_freeable_retain5120value in KB of the instance freeable PGA memory to retain
_smm_isort_cap102400maximum work area for insertion sort(v1)
_smm_max_size3276maximum work area size in auto mode (serial)
_smm_min_size128minimum work area size in auto mode
_smm_px_max_size8192maximum work area size in auto mode (global)
_smm_retain_size0work area retain size in SGA for shared server sessions (0 for AUTO)
_smm_trace0Turn on/off tracing for SQL memory manager
_smon_internal_errlimit100limit of SMON internal errors
_smon_undo_seg_rescan_limit10limit of SMON continous undo segments re-scan
_smu_debug_mode0 - set debug event for testing SMU operations
_smu_error_simulation_site0site ID of error simulation in KTU code
_smu_error_simulation_type0error type for error simulation in KTU code
_smu_timeouts...comma-separated *AND double-quoted* list of AUM timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl
_sort_elimination_cost_ratio0cost ratio for sort eimination under first_rows mode
_sort_multiblock_read_count2multi-block read count for sort
_spin_count1Amount to spin waiting for a latch
_spr_max_rules10000maximum number of rules in sql spreadsheet
_spr_push_pred_refsprTRUEpush predicates through reference spreadsheet
_spr_use_AW_ASTRUEenable AW for hash table in spreadsheet
_spr_use_hash_tableFALSEuse hash table for spreadsheet
_sql_connect_capability_override0SQL Connect Capability Table Override
_sql_connect_capability_table...SQL Connect Capability Table (testing only)
_sql_hash_debug0Hash value of the SQL statement to debug
_sql_model_unfold_forloopsRUN_TIMEspecifies compile-time unfolding of sql model forloops
_sqlexec_progression_cost1000sql execution progression monitoring cost threshold
_sqltune_category_parsedDEFAULTParsed category qualifier for applying hintsets
_sta_control0SQL Tuning Advisory control parameter
_stack_guard_level0stack guard level
_static_backgrounds...static backgrounds
_stn_trace0SQL tracing parameter
_streams_pool_max_size0streams pool maximum size when auto SGA enabled
_subquery_pruning_cost_factor20subquery pruning cost factor
_subquery_pruning_enabledTRUEenable the use of subquery predicates to perform pruning
_subquery_pruning_mv_enabledFALSEenable the use of subquery predicates with MVs to perform pruning
_subquery_pruning_reduction50subquery pruning reduction factor
_swrf_metric_frequent_modeFALSEEnable/disable SWRF Metric Frequent Mode Collection
_swrf_mmon_dbfusTRUEEnable/disable SWRF MMON DB Feature Usage
_swrf_mmon_flushTRUEEnable/disable SWRF MMON FLushing
_swrf_mmon_metricsTRUEEnable/disable SWRF MMON Metrics Collection
_swrf_on_disk_enabledTRUEParameter to enable/disable SWRF
_swrf_test_action0test action parameter for SWRF
_swrf_test_dbfusFALSEEnable/disable DB Feature Usage Testing
_synonym_repoint_tracingFALSEwhether to trace metadata comparisons for synonym repointing
_sysaux_test_param1test parameter for SYSAUX
_system_index_caching0optimizer percent system index caching
_system_trig_enabledTRUEare system triggers enabled
_ta_lns_wait_for_arch_log20LNS Wait time for arhcived version of online log
_table_lookup_prefetch_size40table lookup prefetch vector size
_table_lookup_prefetch_thresh2table lookup prefetch threshold
_table_scan_cost_plus_oneTRUEbump estimated full table scan and index ffs cost by one
_target_rba_max_lag_percentage90target rba max log lag percentage
_tdb_debug_mode16set debug mode for testing transportable database
_temp_tran_block_threshold100number of blocks for a dimension before we temp transform
_temp_tran_cacheTRUEdetermines if temp table is created with cache option
_test_ksusigskip5test the function ksusigskip
_test_param_125test parmeter 1 - integer
_test_param_2...test parameter 2 - string
_test_param_3...test parameter 3 - string
_test_param_4...test parameter 4 - string list
_test_param_525test parmeter 5 - deprecated integer
_test_param_60test parmeter 6 - size (ub8)
_third_spare_parameter...third spare parameter - integer
_threshold_alerts_enable1if 1, issue threshold-based alerts
_total_large_extent_memory0Total memory for allocating large extents
_tq_dump_period0time period for duping of TQ statistics (s)
_trace_archiveFALSEstart DIAG process
_trace_buffer_flushesFALSEtrace buffer flushes if otrace cacheIO event is set
_trace_buffer_getsFALSEtrace kcb buffer gets if otrace cacheIO event is set
_trace_buffer_wait_timeouts0trace buffer busy wait timeouts
_trace_buffer_wrap_timestampTRUEenable KST timestamp on trace buffer wrap
_trace_buffersALL:256trace buffer sizes per process
_trace_cr_buffer_createsFALSEtrace cr buffer creates if otrace cacheIO event is set
_trace_events...trace events enabled at startup
_trace_file_size65536maximum size of trace file (in bytes)
_trace_files_publicFALSECreate publicly accessible trace files
_trace_flush_processesALLtrace data archived by DIAG for these processes
_trace_multi_block_readsFALSEtrace multi_block reads if otrace cacheIO event is set
_trace_navigation_scopeglobalenabling trace navigation linking
_trace_optionstext,multipletrace data flush options
_trace_pin_time0trace how long a current pin is held
_trace_processesALLenable KST tracing in process
_transaction_auditingTRUEtransaction auditing records generated in the redo log
_transaction_recovery_servers0max number of parallel recovery slaves that may be used
_truncate_optimization_enabledTRUEdo truncate optimization if set to TRUE
_tsm_connect_string...TSM test connect string
_tsm_disable_auto_cleanup1Disable TSM auto cleanup actions
_tts_allow_charset_mismatchFALSEallow plugging in a tablespace with an incompatible character set
_two_passTRUEenable two-pass thread recovery
_two_pass_reverse_polish_enabledTRUEuses two-pass reverse polish alg. to generate canonical forms
_uga_cga_large_extent_size262144UGA/CGA large extent size
_ultrafast_latch_statisticsTRUEmaintain fast-path statistics for ultrafast latches
_undo_autotuneTRUEenable auto tuning of undo_retention
_undo_debug_mode0debug flag for undo related operations
_undo_debug_usage0invoke undo usage functions for testing
_union_rewrite_for_gsYES_GSET_MVSexpand queries with GSets into UNIONs for rewrite
_unnest_subqueryTRUEenables unnesting of correlated subqueries
_unused_block_compressionTRUEenable unused block compression
_use_column_stats_for_functionTRUEenable the use of column statistics for DDP functions
_use_ismTRUEEnable Shared Page Tables - ISM
_use_ism_for_pgaTRUEUse ISM for allocating large extents
_use_nosegment_indexesFALSEuse nosegment indexes in explain plan
_use_realfree_heapTRUEuse real-free based allocator for PGA memory
_use_seq_process_cacheTRUEwhether to use process local seq cache
_use_vector_postTRUEuse vector post
_validate_flashback_databaseFALSEScan database to validate result of flashback database
_vendor_lib_loc...Vendor library search root directory
_verify_flashback_redoTRUEVerify that the redo logs needed for flashback are available
_verify_undo_quotaFALSETRUE - verify consistency of undo quota statistics
_wait_for_syncTRUEwait for sync on commit MUST BE ALWAYS TRUE
_walk_insert_threshold0maximum number of unusable blocks to walk across freelist
_watchpoint_onFALSEis the watchpointing feature turned on?
_wcr_control0Oracle internal test WCR parameter used ONLY for testing!
_windowfunc_optimization_settings0settings for window function optimizations
_write_clones3write clones flag
_xpl_peeked_binds_log_size8192maximum bytes for logging peeked bind values for V$SQL_PLAN (0 = OFF)
_xpl_trace0Explain Plan tracing parameter
_xsolapi_auto_materialization_bound20OLAP API lower bound for auto materialization.
_xsolapi_auto_materialization_typePRED_AND_RCOLAP API behavior for auto materialization
_xsolapi_debug_output...OLAP API debug output disposition
_xsolapi_densify_cubesTABULAROLAP API cube densification
_xsolapi_dimension_group_creationOVERFETCHOLAP API symmetric overfetch
_xsolapi_fetch_typePARTIALOLAP API fetch type
_xsolapi_generate_with_clauseFALSEOLAP API generates WITH clause?
_xsolapi_hierarchy_value_typeuniqueOLAP API hierarchy value type
_xsolapi_load_at_process_startNEVERWhen to load OLAP API library at server process start
_xsolapi_materialization_rowcache_min_rows_for_use1OLAP API min number of rows required to use rowcache in query materialization
_xsolapi_materialize_sourcesTRUEOLAP API Enable source materialization
_xsolapi_metadata_reader_modeALLOLAP API metadata reader mode
_xsolapi_odbo_modeFALSEOLAP API uses ODBO mode?
_xsolapi_optimize_suppressionTRUEOLAP API optimizes suppressions?
_xsolapi_precompute_subqueryTRUEOLAP API precomputes subqueries?
_xsolapi_remove_columns_for_materializationTRUEOLAP API removes columns for materialization?
_xsolapi_set_nlsTRUEOLAP API sets NLS?
_xsolapi_share_executorsTRUEOLAP API share executors?
_xsolapi_source_traceFALSEOLAP API output Source definitions to trace file
_xsolapi_sql_all_multi_join_non_base_hints...OLAP API multi-join non-base hints
_xsolapi_sql_all_non_base_hints...OLAP API non-base hints
_xsolapi_sql_auto_dimension_hintsFALSEOLAP API enable automatic dimension hints
_xsolapi_sql_auto_measure_hintsTRUEOLAP API enable automatic measure hints
_xsolapi_sql_dimension_hints...OLAP API dimension hints
_xsolapi_sql_enable_aw_joinTRUEOLAP API enables AW join?
_xsolapi_sql_enable_aw_qdr_mergeTRUEOLAP API enables AW QDR merge?
_xsolapi_sql_hints...OLAP API generic hints
_xsolapi_sql_measure_hints...OLAP API measure hints
_xsolapi_sql_minus_threshold1000OLAP API SQL MINUS threshold
_xsolapi_sql_optimizeTRUEOLAP API enable optimization
_xsolapi_sql_prepare_stmt_cache_size16OLAP API prepare statement cache size
_xsolapi_sql_remove_columnsTRUEOLAP API enable remove unused columns optimizations
_xsolapi_sql_result_set_cache_size32OLAP API result set cache size
_xsolapi_sql_symmetric_predicateTRUEOLAP API enable symmetric predicate for dimension groups
_xsolapi_sql_top_dimension_hints...OLAP API top dimension hints
_xsolapi_sql_top_measure_hints...OLAP API top measure hints
_xsolapi_sql_use_bind_variablesTRUEOLAP API enable bind variables optimization
_xsolapi_stringify_order_levelsFALSEOLAP API stringifies order levels?
_xsolapi_suppression_aw_mask_threshold1000OLAP API suppression AW mask threshold
_xsolapi_suppression_chunk_size4000OLAP API suppression chunk size
_xsolapi_use_modelsTRUEOLAP API uses models?
_xsolapi_use_olap_dmlTRUEOLAP API uses OLAP DML?
_xsolapi_use_olap_dml_for_rankFALSEOLAP API uses OLAP DML for rank?
_xt_coveragenoneexternal tables code coverage parameter
_xt_tracenoneexternal tables trace parameter
_xtbuffer_size0buffer size in KB needed for populate/query operation
_xtts_allow_pre10FALSEallow cross platform for pre10 compatible tablespace
_xtts_set_platform_infoFALSEset cross platform info during file header read
_yield_check_interval100000interval to check whether actses should yield

Комментариев нет:

Отправить комментарий