Undocumented INIT.ORA Parameters

Snapshot Date: 10/28/02 00:32:25

Database: VENUS

PARAMETER	Value	Desc
_NUMA_instance_mapping	Not specified	Set of nodes that this instance should run on
_NUMA_pool_size	Not specified	aggregate size in bytes of NUMA pool
_PX_use_large_pool	FALSE	Use Large Pool as source of PX buffers
_abort_recovery_on_join	FALSE	if TRUE, abort recovery on join reconfigurations
_active_standby_fast_reconfiguration	TRUE	if TRUE optimize dlm reconfiguration for active/standby OPS
_adaptive_direct_read	TRUE	Adaptive Direct Read
_adaptive_fetch_enabled	TRUE	enable/disable adaptive fetch in parallel group by
_affinity_on	TRUE	enable/disable affinity at run time
_all_shared_dblinks		treat all dblinks as shared
_allocate_creation_order	FALSE	should files be examined in creation order during allocation
_allocation_update_interval	3	interval at which successful search in L1 should be updated
_allow_error_simulation	FALSE	Allow error simulation for testing
_allow_read_only_corruption	FALSE	allow read-only open even if database is corrupt
_allow_resetlogs_corruption	FALSE	allow resetlogs even if it will cause corruption
_allow_terminal_recovery_corruption	FALSE	Finish terminal recovery even if it may cause corruption
_always_anti_join	CHOOSE	always use this method for anti-join when possible
_always_semi_join	CHOOSE	always use this method for semi-join when possible
_always_star_transformation	FALSE	always favor use of star transformation
_app_ctx_vers	TRUE	enable app ctx versioning
_aq_tm_scanlimit	0	scan limit for Time Managers to clean up IOT
_arch_io_slaves	0	ARCH I/O slaves
_async_recovery_claims	TRUE	if TRUE, issue recovery claims asynchronously (DFS)
_async_recovery_reads	TRUE	if TRUE, issue recovery reads asynchronously (DFS)
_avoid_prepare	TRUE	if TRUE, do not prepare a buffer when the master is local (DFS)
_b_tree_bitmap_plans	TRUE	enable the use of bitmap plans for tables w. only B-tree indexes
_backup_disk_io_slaves	0	BACKUP Disk I/O slaves
_backup_io_pool_size	262144	memory to reserve from the large pool
_bitmap_or_improvement_enabled	TRUE	controls extensions to partition pruning for general predicates
_bump_highwater_mark_count	0	how many blocks should we allocate per free list on advancing HW
_bwr_for_flushed_pi	TRUE	if TRUE, generate a BWR for a flushed PI (DFS)
_cgs_send_timeout	300	CGS send timeout value
_check_block_after_checksum	TRUE	perform block check after checksum if both are turned on
_cleanup_rollback_entries	100	no. of undo entries to apply per transaction cleanup
_close_cached_open_cursors	FALSE	close cursors cached by PL/SQL at each commit
_collect_undo_stats	TRUE	Collect Statistics v$undostat
_column_elimination_off	FALSE	turn off predicate-only column elimination
_column_tracking_level	1	column usage tracking
_compatible_no_recovery	0.0.0	Database will be compatible unless crash or media recovery is ne
_complex_view_merging	TRUE	enable complex view merging
_controlfile_enqueue_timeout	900	control file enqueue timeout in seconds
_corrupted_rollback_segments		corrupted undo segment list
_cost_equality_semi_join	TRUE	enables costing of equality semi-join
_cpu_count	0	current number of cpu's for this instance
_cpu_to_io	0	divisor for converting CPU cost to I/O cost
_cr_grant_global_role	TRUE	if TRUE, grant lock for CR requests when block is in global role
_cr_grant_local_role	FALSE	if TRUE, grant lock for CR using 3way ping when block in local r
_cr_server_log_flush	TRUE	if TRUE, flush redo log before serving a CR buffer (DFS)
_cursor_db_buffers_pinned	24	additional number of buffers a cursor can pin at once
_cursor_plan_enabled	TRUE	enable collection and display of cursor plans
_db_aging_cool_count	1	Touch count set when buffer cooled
_db_aging_freeze_cr	FALSE	Make CR buffers always be too cold to keep in cache
_db_aging_hot_criteria	2	Touch count which sends a buffer to head of replacement list
_db_aging_stay_count	0	Touch count set when buffer moved to head of replacement list
_db_aging_touch_time	3	Touch count which sends a buffer to head of replacement list
_db_always_check_system_ts	TRUE	Always perform block check and checksum for System tablespace
_db_block_buffers	3916	Number of database blocks cached in memory: hidden parameter
_db_block_cache_clone	FALSE	Always clone data blocks on get (for debugging)
_db_block_cache_num_umap	0	number of unmapped buffers (for tracking swap calls on blocks)
_db_block_cache_protect	FALSE	protect database blocks (true only when debugging)
_db_block_check_for_debug	FALSE	Check more and dump block before image for debugging
_db_block_granule_interval	10	number of lru latches
_db_block_hash_buckets	7841	Number of database block hash buckets
_db_block_hash_latches	1024	Number of database block hash latches
_db_block_hi_priority_batch_size	0	Fraction of writes for high priority reasons
_db_block_lru_latches	8	number of lru latches
_db_block_max_cr_dba	6	Maximum Allowed Number of CR buffers per dba
_db_block_max_dirty_target	0	Upper bound on modified buffers/recovery reads
_db_block_max_scan_pct	40	Percentage of buffers to inspect when looking for free
_db_block_med_priority_batch_size	0	Fraction of writes for medium priority reasons
_db_block_numa	1	Number of NUMA nodes
_db_block_prefetch_quota	10	Prefetch quota as a percent of cache size
_db_block_trace_protect	FALSE	trace buffer protect calls
_db_cache_advice_batch_size	128	cache advisory simulation batch size
_db_cache_advice_sample_factor	4	cache advisory sampling factor
_db_file_direct_io_count	1048576	Sequential I/O buf size
_db_file_noncontig_mblock_read_count	11	number of noncontiguous db blocks to be prefetched
_db_handles	750	System-wide simultaneous buffer operations
_db_handles_cached	5	Buffer handles cached each process
_db_large_dirty_queue	25	Number of buffers which force dirty queue to be written
_db_mttr_advice	ON	MTTR advisory
_db_mttr_partitions	0	number of partitions for MTTR advisory
_db_mttr_sample_factor	64	MTTR simulation sampling factor
_db_mttr_sim_target		MTTR simulation targets
_db_mttr_sim_trace_size	256	MTTR simulation trace size
_db_mttr_trace_to_alert	FALSE	dump trace entries to alert file
_db_percent_hot_default	50	Percent of default buffer pool considered hot
_db_percent_hot_keep	0	Percent of keep buffer pool considered hot
_db_percent_hot_recycle	0	Percent of recycle buffer pool considered hot
_db_writer_chunk_writes	0	Number of writes DBWR should wait for
_db_writer_histogram_statistics	FALSE	maintain dbwr histogram statistics in x$kcbbhs
_db_writer_max_writes	0	Max number of outstanding DB Writer IOs
_db_writer_scan_depth_pct	25	Percentage of LRU buffers for dbwr to scan when looking for dirt
_dbg_proc_startup	FALSE	debug process startup
_dbwr_async_io	TRUE	Enable dbwriter asynchronous writes
_dbwr_scan_interval	10	dbwriter scan interval
_dbwr_tracing	0	Enable dbwriter tracing
_default_non_equality_sel_check	TRUE	sanity check on default selectivity for like/range predicate
_defer_multiple_waiters	TRUE	if TRUE, defer down converts when there were waiters (DFS)
_diag_daemon	TRUE	start DIAG daemon
_disable_file_locks	FALSE	disable file locks for control, data, redo log files
_disable_incremental_checkpoints	FALSE	Disable incremental checkpoints for thread recovery
_disable_kcbhxor_osd	FALSE	disable kcbh(c)xor OSD functionality
_disable_latch_free_SCN_writes_via_32cas	FALSE	disable latch-free SCN writes using 32-bit compare & swap
_disable_latch_free_SCN_writes_via_64cas	FALSE	disable latch-free SCN writes using 64-bit compare & swap
_disable_logging	FALSE	Disable logging
_disable_multiple_block_sizes	FALSE	disable multiple block size support (for debugging)
_disable_ntlog_events	FALSE	Disable logging to NT event log
_disable_odm	FALSE	disable odm feature
_disable_recoverable_recovery	FALSE	Disable the new recoverable recovery mechanism
_disable_system_state	FALSE	disable system state dump
_discrete_transactions_enabled	FALSE	enable 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)
_distributed_recovery_connection_hold_time	200	number of seconds RECO holds outbound connections open
_dlmtrace		Trace string of lock types(s)
_domain_index_batch_size	2000	maximum number of rows from one call to domain index fetch routi
_domain_index_dml_batch_size	200	maximum number of rows for one call to domain index dml routines
_dss_cache_flush	FALSE	enable full cache flush for parallel execution
_dump_MTTR_to_trace	FALSE	Dump High Availability MTTR infromation to CKPT trace file
_dump_system_state_scope	local	scope of sysstate dump during instance termination
_dynamic_rls_policies	TRUE	rls policies are dynamic
_dynamic_stats_threshold	30	delay threshold (in seconds) between sending statistics messages
_eliminate_common_subexpr	TRUE	enables elimination of common sub-expressions
_enable_NUMA_optimization	TRUE	Enable NUMA specific optimizations
_enable_block_level_transaction_recovery	TRUE	enable block level recovery
_enable_cscn_caching	FALSE	enable commit SCN caching for all transactions
_enable_default_affinity	0	to enable default implementation of affinity osds
_enable_kgh_policy	FALSE	temporary to disable/enable kgh policy
_enable_list_io	FALSE	Enable List I/O
_enable_multitable_sampling	FALSE	enable multitable sampling
_enable_type_dep_selectivity	TRUE	enable type dependent selectivity estimates
_enqueue_debug_multi_instance	FALSE	debug enqueue multi instance
_enqueue_hash	375	enqueue hash table length
_enqueue_hash_chain_latches	1	enqueue hash chain latches
_enqueue_locks	2230	locks for managed enqueues
_explain_rewrite_mode	FALSE	allow additional messages to be generated during explain rewrite
_fairness_threshold	4	number of times to CR serve before downgrading lock (DFS)
_fast_full_scan_enabled	TRUE	enable/disable index fast full scan
_fifth_spare_parameter		fifth spare parameter - string
_first_spare_parameter		first spare parameter - integer
_force_datefold_trunc	FALSE	force use of trunc for datefolding rewrite
_force_temptables_for_gsets	FALSE	executes concatenation of rollups using temp tables
_fourth_spare_parameter		fourth spare parameter - string
_full_pwise_join_enabled	TRUE	enable full partition-wise join when TRUE
_gby_onekey_enabled	TRUE	enable use of one comparison of all group by keys
_gc_defer_time	3	how long to defer down converts for hot buffers (DFS)
_gc_integrity_checks	TRUE	if TRUE, enable expensive integrity checks (DFS)
_gc_latches	2	number of latches per LMS process (DFS)
_gcs_fast_reconfig	TRUE	if TRUE, enable fast reconfiguration for gcs locks
_gcs_latches	128	number of gcs resource hash latches to be allocated
_gcs_resources		number of gcs resources to be allocated
_generalized_pruning_enabled	TRUE	controls extensions to partition pruning for general predicates
_groupby_nopushdown_cut_ratio	3	groupby nopushdown cut ratio
_groupby_orderby_combine	5000	groupby/orderby don't combine threshold
_gs_anti_semi_join_allowed	TRUE	enable anti/semi join for the GS query
_hard_protection	FALSE	if TRUE enable H.A.R.D specific format changes
_hash_multiblock_io_count	0	number of blocks hash join will read/write at once
_high_server_threshold	0	high server thresholds
_idl_conventional_index_maintenance	TRUE	enable conventional index maintenance for insert direct load
_ignore_desc_in_index	FALSE	ignore DESC in indexes, sort those columns ascending anyhow
_improved_outerjoin_card	TRUE	improved outer-join cardinality calculation
_improved_row_length_enabled	TRUE	enable the improvements for computing the average row length
_imr_active	TRUE	Activate Instance Membership Recovery feature
_imr_max_reconfig_delay	300	Maximum Reconfiguration delay (seconds)
_imr_splitbrain_res_wait	600	Maximum wait for split-brain resolution (seconds)
_index_join_enabled	TRUE	enable the use of index joins
_index_prefetch_factor	100	index prefetching factor
_init_sql_file	%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ	File containing SQL statements to execute upon database creation
_insert_enable_hwm_brokered	TRUE	during parallel inserts high water marks are brokered
_inst_locking_period	5	period an instance can retain a newly acquired level1 bitmap
_instance_type	RDBMS	type of instance to be executed
_interconnect_checksum	TRUE	if TRUE, checksum interconnect blocks (DFS)
_intrapart_pdml_enabled	TRUE	Enable intra-partition updates/deletes
_io_slaves_disabled	FALSE	Do not use I/O slaves
_ioslave_batch_count	1	Per attempt IOs picked
_ioslave_issue_count	500	IOs issued before completion check
_job_queue_interval	5	Wakeup interval in seconds for job queue co-ordinator
_kcl_commit	TRUE	if TRUE, call kjbcommit (DFS)
_kcl_conservative_log_flush	FALSE	if TRUE, conservatively log flush before CR serving (DFS)
_kcl_debug	TRUE	if TRUE, record le history (DFS)
_kcl_index_split	TRUE	if TRUE, reject pings on blocks in middle of a split (DFS)
_kcl_local_file_time	0	how often to check for local files (DFS)
_kcl_name_table_latches	8	number of name table latches (DFS)
_kcl_recovery_read_batch	8	recovery read batch size (DFS)
_kcl_undo_grouping	32	grouping for undo block locks (DFS)
_kcl_undo_locks	128	number of locks per undo segment (DFS)
_kcl_use_cr	TRUE	if TRUE, use Fusion CR buffers (DFS)
_kdbl_enable_post_allocation	FALSE	allocate dbas after populating data buffers
_keep_recovery_buffers	FALSE	if TRUE, make recovery buffers current (DFS)
_keep_remote_column_size	FALSE	remote column size does not get modified
_kghdsidx_count	1	max kghdsidx count
_kgl_bucket_count	9	index to the bucket count array
_kgl_latch_count	0	number of library cache latches
_kgl_multi_instance_invalidation	TRUE	whether KGL to support multi-instance invalidations
_kgl_multi_instance_lock	TRUE	whether KGL to support multi-instance locks
_kgl_multi_instance_pin	TRUE	whether KGL to support multi-instance pins
_kglsim_maxmem_percent	5	max percentage of shared pool size to be used for KGL advice
_kkfi_trace	FALSE	trace expression substitution
_kolfuseslf	FALSE	allow kolf to use slffopen
_ksdxw_cini_flg	0	ksdxw context initialization flag
_ksdxw_nbufs	1000	ksdxw number of buffers in buffered mode
_ksdxw_num_pgw	10	number of watchpoints on a per-process basis
_ksdxw_num_sgw	10	number of watchpoints to be shared by all processes
_ksdxw_stack_depth	4	number of PCs to collect in the stack when watchpoint is hit
_ksi_trace		KSI trace string of lock type(s)
_ksmg_granule_locking_status	1	granule locking status
_ksmg_granule_size	8388608	granule size in bytes
_ksu_diag_kill_time	5	number of seconds ksuitm waits before killing diag
_ktc_latches	0	number of ktc latches
_ktu_latches	0	number of KTU latches
_large_pool_min_alloc	16000	minimum allocation size in bytes for the large allocation pool
_last_allocation_period	5	period over which an instance can retain an active level1 bitmap
_latch_class_0		latch class 0
_latch_class_1		latch class 1
_latch_class_2		latch class 2
_latch_class_3		latch class 3
_latch_class_4		latch class 4
_latch_class_5		latch class 5
_latch_class_6		latch class 6
_latch_class_7		latch class 7
_latch_classes		latch classes override
_latch_miss_stat_sid	0	Sid of process for which to collect latch stats
_latch_recovery_alignment	998	align latch recovery structures
_ldr_io_size	262144	size of write IOs used during a load operation
_left_nested_loops_random	TRUE	enable random distribution method for left of nestedloops
_lgwr_async_io	TRUE	LGWR Asynchronous IO enabling boolean flag
_lgwr_delay_write	FALSE	LGWR write delay for debugging
_lgwr_io_slaves	0	LGWR I/O slaves
_lgwr_max_ns_wt	30	Maximum wait time for lgwr to allow NetServer to progress
_lgwr_ns_nl_max	1000	Variable to simulate network latency
_lgwr_ns_nl_min	500	Variable to simulate network latency
_lgwr_ns_sim_err	0	Variable to simulate errors lgwrns
_library_cache_advice	TRUE	whether KGL advice should be turned on
_like_with_bind_as_equality	FALSE	treat LIKE predicate with bind as an equality predicate
_lm_activate_lms_threshold	100	threshold value to activate an additional lms
_lm_cache_lvl0_cleanup	0	how often to cleanup level 0 cache res (in sec)
_lm_cache_res_cleanup	25	percentage of cached resources should be cleanup
_lm_cache_res_type		cache resource: string of lock types(s)
_lm_dd_interval	60	dd time interval in seconds
_lm_direct_sends	all	Processes which will do direct sends
_lm_drm_window	32	dynamic remastering bucket window size
_lm_dynamic_lms	FALSE	dynamic lms invocation
_lm_dynamic_load	TRUE	dynamic load adjustment
_lm_dynamic_remastering	FALSE	if TRUE enables dynamic remastering
_lm_enq_lock_freelist		Number of ges enqueue element freelist
_lm_enq_rcfg	TRUE	if TRUE enables enqueue reconfiguration
_lm_enqeue_freelist	3	Number of enqueue freelist
_lm_file_affinity		mapping between file id and master instance number
_lm_lmd_waittime	4	default wait time for lmd
_lm_lms	0	number of background global cache server processes to start
_lm_lms_waittime	1	default wait time for lms
_lm_locks	12000	number of enqueues configured for cluster database
_lm_master_weight	1	master resource weight for this instance
_lm_max_lms	0	max. number of background global cache server processes
_lm_min_lms	0	min. number of background global cache server processes
_lm_msg_batch_size	2048	GES batch message size
_lm_msg_cache_thresholds		GES message buffer caching threshold
_lm_msg_cleanup_interval	3000	GES message buffer cleanup interval time
_lm_node_join_opt	FALSE	cluster database node join optimization in reconfig
_lm_non_fault_tolerant	FALSE	disable cluster database fault-tolerance mode
_lm_num_pcmhv_latches	0	number of latches covering the PCM HV buckets in cgs
_lm_proc_freeze_timeout	300	reconfiguration: process freeze timeout
_lm_process_batching	TRUE	GES implicit process batching for IPC messages
_lm_procs	127	number of client processes configured for cluster database
_lm_rcfg_timeout	180000	Reconfiguration timeout
_lm_rcv_buffer_size	32768	the size of receive buffer
_lm_res_hash_bucket	0	number of resource hash buckets
_lm_res_part	1289	number of resource partition configured for gcs
_lm_ress	6000	number of resources configured for cluster database
_lm_send_buffers	10000	number of cluster database send buffers
_lm_send_queue_batching	TRUE	GES send queue message batching
_lm_send_queue_length	5000	GES send queue maximum length
_lm_share_lock_opt	FALSE	if TRUE enables share lock optimization
_lm_sq_batch_factor	2	GES send queue minimum batching factor
_lm_sync_timeout		Synchronization timeout for DLM reconfiguration steps
_lm_ticket_active_sendback		Flow control ticket active sendback threshold
_lm_tickets	1000	GES messaging tickets
_lm_tx_delta	16	TX lock localization delta
_lm_validate_resource_type	FALSE	if TRUE enables resource name validation
_lm_xids	139	number of transaction IDs configured for cluster database
_load_without_compile	NONE	Load PL/SQL or Database objects without compilation
_local_communication_costing_enabled	TRUE	enable local communication costing when TRUE
_local_communication_ratio	50	set the ratio between global and local communication (0..100)
_lock_sga_areas	0	Lock specified areas of the SGA in physical memory
_log_archive_buffer_size	2048	Size of each archival buffer in log file blocks
_log_archive_buffers	4	Number of buffers to allocate for archiving
_log_archive_callout		archival callout
_log_archive_delta_sync_wait	0	iterative sleep time in centiseconds seconds when SYNC=PARALLEL
_log_archive_net_timeout	0	maximum network wait time in seconds when SYNC=PARALLEL
_log_blocks_during_backup	TRUE	log block images when changed during backup
_log_buffers_corrupt	FALSE	corrupt redo buffers before write
_log_buffers_debug	FALSE	debug redo buffers (slows things down)
_log_checkpoint_recovery_check	0	# redo blocks to verify after checkpoint
_log_committime_block_cleanout	FALSE	Log commit-time block cleanout
_log_debug_multi_instance	FALSE	debug redo multi instance code
_log_io_size	0	automatically initiate log write if this many redo blocks in buf
_log_simultaneous_copies	2	number of simultaneous copies into redo buffer(# of copy latches
_log_space_errors	TRUE	should we report space errors to alert log
_log_switch_timeout	0	Maximum number of seconds redos in the current log could span
_low_server_threshold	0	low server thresholds
_master_direct_sends	31	direct sends for messages from master (DFS)
_mav_refresh_consistent_read	TRUE	refresh materialized views using consistent read snapshot
_mav_refresh_double_count_prevented	FALSE	materialized view MAV refreshes avoid double counting
_mav_refresh_opt	0	optimizations during refresh of materialized views
_mav_refresh_unionall_tables	3	# tables for union all expansion during materialized view refres
_max_exponential_sleep	0	max sleep during exponential backoff
_max_sleep_holding_latch	4	max time to sleep while holding a latch
_messages	300	message queue resources - dependent on # processes & # buffers
_minimal_stats_aggregation	TRUE	prohibit stats aggregation at compile/partition maintenance time
_minimum_giga_scn	0	Minimum SCN to start with in 2^30 units
_multi_join_key_table_lookup	TRUE	TRUE iff multi-join-key table lookup prefetch is enabled
_mv_refresh_delta_fraction	10	delta mv as fractional percentage of size of mv
_mv_refresh_eut	TRUE	refresh materialized views using EUT(partition)-based algorithm
_mv_refresh_new_setup_disabled	FALSE	materialized view MV refresh new setup disabling
_mv_refresh_selections	TRUE	create materialized views with selections and fast refresh
_mv_refresh_use_stats	TRUE	pass cardinality hints to refresh queries
_nchar_imp_cnv	TRUE	NLS allow Implicit Conversion between CHAR and NCHAR
_ncmb_readahead_enabled	0	enable multi-block readahead for an index scan
_ncmb_readahead_tracing	0	turn on multi-block readahead tracing
_nested_loop_fudge	100	nested loop fudge
_nested_mav_fast_oncommit_enabled	FALSE	nested MAV refresh fast on commit allowed
_new_initial_join_orders	TRUE	enable initial join orders based on new ordering heuristics
_new_sort_cost_estimate	TRUE	enables the use of new cost estimate for sort
_no_objects	FALSE	no object features are used
_no_or_expansion	FALSE	OR expansion during optimization disabled
_ns_max_flush_wt	30	Flush wait time for NetServer to flush oustanding writes
_num_longop_child_latches	1	number of child latches for long op array
_number_cached_attributes	10	maximum number of cached attributes per instance
_object_statistics	TRUE	enable the object level statistics collection
_offline_rollback_segments		offline undo segment list
_ogms_home		GMS home directory
_olap_aggregate_buffer_size	1048576	OLAP Aggregate max buffer size
_olap_aggregate_child_fragment_size	32	OLAP Aggregate child fragment size
_olap_aggregate_child_max_size	32768	OLAP Aggregate child list max size
_olap_aggregate_function_cache_enabled	TRUE	OLAP Aggregate function cache enabler
_olap_aggregate_function_merge_threshold	32768	OLAP Aggregate function merge threshold
_olap_aggregate_max_thread_tuples	5000	OLAP Aggregate max thread tuples creation
_olap_aggregate_min_buffer_size	1024	OLAP Aggregate min buffer size
_olap_aggregate_min_thread_status	64	OLAP Aggregate minimum cardinality of dimensions for thread
_olap_aggregate_statlen_thresh	1024	OLAP Aggregate status array usage threshold
_olap_aggregate_store_probability	100	OLAP Aggregate function storeback probability
_olap_aggregate_work_per_thread	1024	OLAP Aggregate max work parents
_olap_aggregate_worklist_max	5000	OLAP Aggregate max worklists generated at once
_olap_allocate_errorlog_format	%8p %8y %8z %e (%n)	OLAP Allocate Errorlog Format
_olap_allocate_errorlog_header	Dim Source Basis %-8d %-8s %-8b Description -------- -------- -------- -----------	OLAP Allocate Errorlog Header format
_olap_continuous_trace_file	FALSE	Specify TRUE to enable continuous OLAP tracing - otherwise only
_olap_dimsave_restore_cache_values	TRUE	OLAP Dimsave restores cached dimension values
_olap_eif_export_lob_size	2147483647	OLAP EIF Export BLOB size
_olap_parallel_update_threshold	1000	OLAP parallel update threshold in pages
_olap_poutlog_echo_to_eventlog	FALSE	OLAP POutLog copy output to event log (tracefile)
_old_connect_by_enabled	FALSE	enable/disable old connect by
_omf	enabled	enable/disable OMF
_oneside_colstat_for_equijoins	TRUE	sanity check on default selectivity for like/range predicate
_open_files_limit	4294967294	Limit on number of files opened by I/O subsystem
_optim_adjust_for_part_skews	TRUE	adjust stats for skews across partitions
_optim_enhance_nnull_detection	TRUE	TRUE to enable index [fast] full scan more often
_optim_new_default_join_sel	TRUE	improves the way default equijoin selectivity are computed
_optim_peek_user_binds	TRUE	enable peeking of user binds
_optimizer_adjust_for_nulls	TRUE	adjust selectivity for null values
_optimizer_choose_permutation	0	force the optimizer to use the specified permutation
_optimizer_cost_model	CHOOSE	optimizer cost model
_optimizer_degree	0	force the optimizer to use the same degree of parallelism
_optimizer_dyn_smp_blks	32	number of blocks for optimizer dynamic sampling
_optimizer_mode_force	TRUE	force setting of optimizer mode for user recursive SQL also
_optimizer_new_join_card_computation	TRUE	compute join cardinality using non-rounded input values
_optimizer_percent_parallel	101	optimizer percent parallel
_optimizer_search_limit	5	optimizer search limit
_optimizer_system_stats_usage	0	system statistics usage
_optimizer_undo_changes	FALSE	undo changes to query optimizer
_optimizer_undo_cost_change	9.2.0	optimizer undo cost change
_or_expand_nvl_predicate	TRUE	enable OR expanded plan for NVL/DECODE predicate
_oracle_trace_events		Oracle TRACE event flags
_oracle_trace_facility_version		Oracle TRACE facility version
_ordered_nested_loop	TRUE	enable ordered nested loop costing
_ordered_semijoin	TRUE	enable ordered semi-join subquery
_parallel_adaptive_max_users	1	maximum number of users running with default DOP
_parallel_broadcast_enabled	TRUE	enable broadcasting of small inputs to hash and sort merge joins
_parallel_default_max_instances	1	default maximum number of instances for parallel query
_parallel_execution_message_align	FALSE	Alignment of PX buffers to OS page boundary
_parallel_fake_class_pct	0	fake db-scheduler percent used for testing
_parallel_load_bal_unit	0	number of threads to allocate per instance
_parallel_load_balancing	TRUE	parallel execution load balanced slave allocation
_parallel_min_message_pool	64440	minimum size of shared pool memory to reserve for pq servers
_parallel_recovery_stopat	32767	stop at -position- to step through SMON
_parallel_server_idle_time	5	idle time before parallel query server dies
_parallel_server_sleep_time	10	sleep time between dequeue timeouts (in 1/100ths)
_parallel_txn_global	FALSE	enable parallel_txn hint with updates and deletes
_parallelism_cost_fudge_factor	350	set the parallelism cost fudge factor
_partial_pwise_join_enabled	TRUE	enable partial partition-wise join when TRUE
_passwordfile_enqueue_timeout	900	password file enqueue timeout in seconds
_pcm_shadow_locks		number of pcm shadow locks to be allocated
_pct_refresh_double_count_prevented	TRUE	materialized view PCT refreshes avoid double counting
_pdml_gim_sampling	5000	control separation of global index maintenance for PDML
_pdml_gim_staggered	FALSE	slaves start on different index when doing index maint
_pdml_slaves_diff_part	TRUE	slaves start on different partition when doing index maint
_pga_max_size	209715200	Maximum size of the PGA memory for one process
_ping_level	4	fusion ping level (DFS)
_plsql_dump_buffer_events		conditions upon which the PL/SQL circular buffer is dumped
_pmon_load_constants	300,192,64,3,10,10,0	server load balancing constants (S,P,D,I,L,C,M)
_pre_rewrite_push_pred	TRUE	push predicates into views before rewrite
_precompute_gid_values	TRUE	precompute gid values and copy them before returning a row
_pred_move_around	TRUE	enables predicate move-around
_predicate_elimination_enabled	TRUE	allow predicate elimination if set to TRUE
_project_view_columns	TRUE	enable projecting out unreferenced columns of a view
_push_join_predicate	TRUE	enable pushing join predicate inside a view
_push_join_union_view	TRUE	enable pushing join predicate inside a union view
_px_async_getgranule	FALSE	asynchronous get granule in the slave
_px_broadcast_fudge_factor	100	set the tq broadcasting fudge factor percentage
_px_dynamic_opt	TRUE	turn off/on restartable qerpx dynamic optimization
_px_dynamic_sample_size	50	num of samples for restartable qerpx dynamic optimization
_px_granule_size	100000	default size of a rowid range granule (in KB)
_px_index_sampling	200	parallel query sampling for index create (100000 = 100%)
_px_kxib_tracing	0	turn on kxib tracing
_px_load_publish_interval	200	interval at which LMON will check whether to publish PX load
_px_max_granules_per_slave	100	maximum number of rowid range granules to generate per slave
_px_min_granules_per_slave	13	minimum number of rowid range granules to generate per slave
_px_no_stealing	FALSE	prevent parallel granule stealing in shared nothing environment
_px_trace	none	px trace parameter
_query_cost_rewrite	TRUE	perform the cost based rewrite with materialized views
_query_rewrite_1	TRUE	perform query rewrite before&after or only before view merging
_query_rewrite_2	TRUE	perform query rewrite before&after or only after view merging
_query_rewrite_drj	TRUE	mv rewrite and drop redundant joins
_query_rewrite_expression	TRUE	rewrite with cannonical form for expressions
_query_rewrite_fpc	TRUE	mv rewrite fresh partition containment
_query_rewrite_fudge	90	cost based query rewrite with MVs fudge factor
_query_rewrite_jgmigrate	TRUE	mv rewrite with jg migration
_query_rewrite_maxdisjunct	257	query rewrite max disjuncts
_query_rewrite_or_error	FALSE	allow query rewrite, if referenced tables are not dataless
_query_rewrite_vop_cleanup	TRUE	prune frocol chain before rewrite after view-merging
_realfree_heap_free_threshold	4194303	threshold for performing real-free, in Kbytes
_realfree_heap_max_size	32768	minimum max total heap size, in Kbytes
_realfree_heap_mode	0	mode flags for real-free heap
_recovery_asserts	FALSE	if TRUE, enable expensive recovery sanity checks (DFS)
_recovery_claim_batch_size	10	number of messages to batch in a recovery claim message (DFS)
_recovery_percentage	50	recovery buffer cache percentage
_release_insert_threshold	5	maximum number of unusable blocks to unlink from freelist
_reliable_block_sends	FALSE	if TRUE, block sends across interconnect are reliable
_reuse_index_loop	5	number of blocks being examine for index block reuse
_rollback_segment_count	0	number of undo segments
_rollback_segment_initial	1	starting undo segment number
_row_cache_cursors	10	number of cached cursors for row cache management
_row_cr	FALSE	enable row cr for all sql
_rowsource_execution_statistics	FALSE	if TRUE, Oracle will collect rowsource level statistics
_scn_scheme		SCN scheme
_second_spare_parameter		second spare parameter - integer
_send_ast_to_foreground	TRUE	if TRUE, send ast message to foreground
_send_close_with_block	TRUE	if TRUE, send close with block even with direct sends
_send_requests_to_PI	TRUE	if TRUE, try to send CR requests to PI buffers (DFS)
_serial_direct_read	FALSE	enable direct read in serial
_session_idle_bit_latches	0	one latch per session or a latch per group of sessions
_seventh_spare_parameter		seventh spare parameter - string list
_shared_pool_reserved_min_alloc	4400	minimum allocation size in bytes for reserved area of shared poo
_shared_pool_reserved_pct	5	percentage memory of the shared pool allocated for the reserved
_shrunk_aggs_disable_threshold	60	percentage of exceptions at which to switch to full length aggs
_shrunk_aggs_enabled	TRUE	enable use of variable sized buffers for non-distinct aggregates
_side_channel_batch_size	100	number of messages to batch in a side channel message (DFS)
_side_channel_batch_timeout	5	timeout before shipping out all the batched side channel message
_single_process	FALSE	run without detached processes
_sixth_spare_parameter		sixth spare parameter - string list
_skip_assume_msg	TRUE	if TRUE, skip assume message for consigns at the master
_slave_mapping_enabled	TRUE	enable slave mapping when TRUE
_slave_mapping_group_size	0	force the number of slave group in a slave mapper
_small_table_threshold	78	threshold level of table size for direct reads
_smm_advice_enabled	TRUE	if TRUE, enable v$pga_advice
_smm_advice_log_size	0	overwrites default size of the PGA advice workarea history log
_smm_auto_cost_enabled	TRUE	if TRUE, use the AUTO size policy cost functions
_smm_auto_max_io_size	252	Maximum IO size (in KB) used by sort/hash-join in auto mode
_smm_auto_min_io_size	60	Minimum IO size (in KB) used by sort/hash-join in auto mode
_smm_bound	0	overwrites memory manager automatically computed bound
_smm_control	0	provides controls on the memory manager
_smm_max_size	614	maximum work area size in auto mode (serial)
_smm_min_size	128	minimum work area size in auto mode
_smm_px_max_size	3684	maximum work area size in auto mode (global)
_smm_trace	0	Turn on/off tracing for SQL memory manager
_smon_consume_post	FALSE	consume any extra posts after completion of transaction recovery
_smon_internal_errlimit	100	limit of SMON internal errors
_smu_debug_mode	0	- set debug event for testing SMU operations
_smu_error_simulation_site	0	site ID of error simulation in KTU code
_smu_error_simulation_type	0	error type for error simulation in KTU code
_sort_elimination_cost_ratio	0	cost ratio for sort eimination under first_rows mode
_sort_multiblock_read_count	2	multi-block read count for sort
_sort_space_for_write_buffers	1	tenths of sort_area_size devoted to direct write buffers
_sortmerge_inequality_join_off	FALSE	turns off sort-merge join on inequality
_spin_count	1	Amount to spin waiting for a latch
_sql_connect_capability_override	0	SQL Connect Capability Table Override
_sql_connect_capability_table		SQL Connect Capability Table (testing only)
_sqlexec_progression_cost	1000	sql execution progression monitoring cost threshold
_subquery_pruning_cost_factor	20	subquery pruning cost factor
_subquery_pruning_enabled	TRUE	enable the use of subquery predicates to perform pruning
_subquery_pruning_mv_enabled	FALSE	enable the use of subquery predicates with MVs to perform prunin
_subquery_pruning_reduction	50	subquery pruning reduction factor
_system_index_caching	0	optimizer percent system index caching
_system_trig_enabled	TRUE	are system triggers enabled
_table_lookup_prefetch_size	40	table lookup prefetch vector size
_table_lookup_prefetch_thresh	2	table lookup prefetch threshold
_table_scan_cost_plus_one	TRUE	bump estimated full table scan and index ffs cost by one
_temp_tran_block_threshold	100	number of blocks for a dimension before we temp transform
_temp_tran_cache	TRUE	determines if temp table is created with cache option
_test_ksusigskip	5	test the function ksusigskip
_test_param_1	25	test parmeter 1 - integer
_test_param_2		test parameter 2 - string
_test_param_3		test parameter 3 - string
_test_param_4		test parameter 4 - string list
_test_param_5	25	test parmeter 5 - deprecated integer
_test_param_6	0	test parmeter 6 - size (ub8)
_third_spare_parameter		third spare parameter - integer
_tq_dump_period	0	time period for duping of TQ statistics (s)
_trace_archive	FALSE	start DIAG process
_trace_buffer_flushes	FALSE	trace buffer flushes if otrace cacheIO event is set
_trace_buffer_gets	FALSE	trace kcb buffer gets if otrace cacheIO event is set
_trace_buffers	ALL:256	trace buffer sizes per process
_trace_cr_buffer_creates	FALSE	trace cr buffer creates if otrace cacheIO event is set
_trace_events		trace events enabled at startup
_trace_file_size	65536	maximum size of trace file (in number of trace records)
_trace_files_public	FALSE	Create publicly accessible trace files
_trace_flush_processes	ALL	trace data archived by DIAG for these processes
_trace_multi_block_reads	FALSE	trace multi_block reads if otrace cacheIO event is set
_trace_options	text,multiple	trace data flush options
_trace_pin_time	0	trace how long a current pin is held
_trace_processes	ALL	enable KST tracing in process
_transaction_recovery_servers	0	max number of parallel recovery slaves that may be used
_tts_allow_nchar_mismatch	FALSE	allow plugging in a tablespace with a different national charact
_two_pass	TRUE	enable two-pass thread recovery
_two_pass_reverse_polish_enabled	TRUE	uses two-pass reverse polish alg. to generate canonical forms
_union_rewrite_for_gs	CHOOSE	expand queries with GSets into UNIONs for rewrite
_unnest_notexists_sq	SINGLE	unnest NOT EXISTS subquery with one or more tables if possible
_unnest_subquery	TRUE	enables unnesting of correlated subqueries
_use_column_stats_for_function	TRUE	enable the use of column statistics for DDP functions
_use_ism	TRUE	Enable Shared Page Tables - ISM
_use_new_explain_plan	FALSE	if TRUE, use the AUTO size policy cost functions
_use_nosegment_indexes	FALSE	use nosegment indexes in explain plan
_use_realfree_heap	TRUE	use real-free based allocator for PGA memory
_use_seq_process_cache	TRUE	whether to use process local seq cache
_use_vector_post	TRUE	use vector post
_verify_undo_quota	FALSE	TRUE - verify consistency of undo quota statistics
_wait_for_sync	TRUE	wait for sync on commit MUST BE ALWAYS TRUE
_walk_insert_threshold	0	maximum number of unusable blocks to walk across freelist
_watchpoint_on	FALSE	is the watchpointing feature turned on?
_write_clones	3	write clones flag
_yield_check_interval	100000	interval to check whether actses should yield

Do NOT change any of these valuesunless instructed by ORACLE support.