Validation of Sort Sizes in an Oracle10g Database
Undocumented Initialization Parameters
Download 3.53 Mb.
|
Undocumented Initialization ParametersIn the interest of full disclosure, here is the complete list of undocumented parameters at the start of the test. Mon Sep 05 page 1 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _4031_dump_bitvec bitvec to specify 20479 20479 dumps prior to 4031 error _4031_dump_interval Dump 4031 error once 300 300 for each n-second interval _4031_max_dumps Maximum number of 100 100 4031 dumps for this process _4031_sga_dump_interval Dump 4031 SGA 3600 3600 heapdump error once for each n-second interval _4031_sga_max_dumps Maximum number of 10 10 SGA heapdumps _NUMA_instance_mapping Set of nodes that Not specified Not specified this instance should run on
_NUMA_pool_size aggregate size in Not specified Not specified bytes of NUMA pool _PX_use_large_pool Use Large Pool as FALSE FALSE source of PX buffers __db_cache_size Actual size of 717225984 717225984 DEFAULT buffer pool for standard block size buffers __java_pool_size Actual size in bytes 8388608 8388608 of java pool __large_pool_size Actual size in bytes 4194304 4194304 of large pool __shared_pool_size Actual size in bytes 234881024 234881024 of shared pool _abort_recovery_on_join if TRUE, abort FALSE FALSE recovery on join reconfigurations _active_standby_fast_reconfiguration if TRUE optimize dlm TRUE TRUE reconfiguration for Mon Sep 05 page 2 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- active/standby OPS _adaptive_direct_read Adaptive Direct Read TRUE TRUE _adaptive_fetch_enabled enable/disable TRUE TRUE adaptive fetch in parallel group by _add_stale_mv_to_dependency_list add stale mv to TRUE TRUE dependency list _addm_auto_enable governs whether ADDM TRUE TRUE gets run automatically after every AWR snapshot _addm_skiprules comma-separated list of ADDM nodes to skip
_affinity_on enable/disable TRUE TRUE affinity at run time _aiowait_timeouts Number of aiowait 100 100 timeouts before error is reported _alert_expiration seconds before an 604800 604800 alert message is moved to exception queue _all_shared_dblinks treat all dblinks as shared _allocate_creation_order should files be FALSE FALSE examined in creation order during allocation _allocation_update_interval interval at which 3 3 successful search in L1 should be updated _allow_commutativity allow for TRUE TRUE commutativity of +, * when comparing expressions _allow_error_simulation Allow error FALSE FALSE simulation for Mon Sep 05 page 3 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- testing _allow_level_without_connect_by allow level without FALSE FALSE connect by _allow_read_only_corruption allow read-only open FALSE FALSE even if database is corrupt
_allow_resetlogs_corruption allow resetlogs even FALSE FALSE if it will cause corruption _allow_terminal_recovery_corruption Finish terminal FALSE FALSE recovery even if it may cause corruption _always_anti_join always use this CHOOSE CHOOSE method for anti-join when possible _always_semi_join always use this CHOOSE CHOOSE method for semi-join when possible _always_star_transformation always favor use of FALSE FALSE star transformation _app_ctx_vers enable app ctx FALSE FALSE versioning _aq_tm_scanlimit scan limit for Time 0 0 Managers to clean up IOT _arch_io_slaves ARCH I/O slaves 0 0 _array_update_vector_read_enabled Enable array update FALSE FALSE vector read _ash_disk_filter_ratio Ratio of the number 10 10 of in-memory samples to the number of samples actually written to disk _ash_disk_write_enable To enable or disable TRUE TRUE Active Session History flushing _ash_dummy_test_param Oracle internal 0 0 Mon Sep 05 page 4 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- dummy ASH parameter used ONLY for testing! _ash_eflush_trigger The percentage above 66 66 which if the in-memory ASH is full the emergency flusher will be triggered _ash_enable To enable or disable TRUE TRUE Active Session sampling and flushing _ash_sample_all To enable or disable FALSE FALSE sampling every connected session including ones waiting for idle waits _ash_sampling_interval Time interval 1000 1000 between two successive Active Session samples in millisecs _ash_size To set the size of 1048618 1048618 the in-memory Active Session History buffers
_asm_acd_chunks initial ACD chunks 1 1 created
_asm_allow_only_raw_disks Discovery only raw TRUE TRUE devices
_asm_ausize allocation unit size 1048576 1048576 _asm_blksize metadata block size 4096 4096 _asm_disk_repair_time seconds to wait 14400 14400 before dropping a failing disk _asm_libraries library search order ufs ufs for discovery _asm_maxio Maximum size of 1048576 1048576 Mon Sep 05 page 5 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- individual I/O request
_asm_stripesize ASM file stripe size 131072 131072 _asm_stripewidth ASM file stripe 8 8 width _asm_wait_time Max/imum time to 18 18 wait before asmb exits
_asmlib_test Osmlib test event 0 0 _asmsid ASM instance id asm asm _async_recovery_claims if TRUE, issue TRUE TRUE recovery claims asynchronously (DFS) _async_recovery_reads if TRUE, issue TRUE TRUE recovery reads asynchronously (DFS) _avoid_prepare if TRUE, do not TRUE TRUE prepare a buffer when the master is local (DFS) _awr_corrupt_mode AWR Corrupt Mode FALSE FALSE _awr_restrict_mode AWR Restrict Mode FALSE FALSE _b_tree_bitmap_plans enable the use of TRUE TRUE bitmap plans for tables w. only B-tree indexes _backup_disk_io_slaves BACKUP Disk I/O 0 0 slaves
_backup_io_pool_size memory to reserve 1048576 1048576 from the large pool _backup_kgc_bufsz specifies buffer 0 0 size to be used for kgc compression _backup_kgc_niters specifies number of 0 0 iterations used for kgc compression _backup_kgc_type specifies 0 0 compression type used for kgc Mon Sep 05 page 6 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- compression _backup_ksfq_bufcnt number of the ksfq 0 0 buffers used for backup/restore _backup_ksfq_bufsz size of the ksfq 0 0 buffer used for backup/restore _bct_bitmaps_per_file number of bitmaps to 8 8 store for each datafile _bct_buffer_allocation_max maximum size of all 104857600 104857600 change tracking buffer allocations, in bytes _bct_buffer_allocation_min_extents mininum number of 1 1 extents to allocate per buffer allocation _bct_buffer_allocation_size size of one change 2097152 2097152 tracking buffer allocation, in bytes _bct_chunk_size change tracking 0 0 datafile chunk size, in bytes _bct_crash_reserve_size change tracking 262144 262144 reserved crash recovery SGA space, in bytes _bct_file_block_size block size of change 0 0 tracking file, in bytes _bct_file_extent_size extent size of 0 0 change tracking file, in bytes _bct_initial_private_dba_buffer_size initial number of 0 0 entries in the private change tracking dba buffers Mon Sep 05 page 7 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _bct_public_dba_buffer_size total size of all 0 0 public change tracking dba buffers, in bytes _bitmap_or_improvement_enabled controls extensions TRUE TRUE to partition pruning for general predicates _block_change_tracking change tracking TRUE TRUE possible _blocks_per_cache_server number of 128 128 consecutive blocks per global cache server
_bt_mmv_query_rewrite_enabled allow rewrites with TRUE TRUE multiple MVs and base tables _buffer_busy_wait_timeout buffer busy wait 100 100 time in centiseconds _bufq_stop_flow_control Stop enforcing flow FALSE FALSE control for buffered queues
_bump_highwater_mark_count how many blocks 0 0 should we allocate per free list on advancing HWM _bwr_for_flushed_pi if TRUE, generate a TRUE TRUE BWR for a flushed PI (DFS) _cache_stats_monitor if TRUE, enable TRUE TRUE cache stats monitoring _cgs_send_timeout CGS send timeout 300 300 value
_check_block_after_checksum perform block check TRUE TRUE after checksum if both are turned on _check_ts_threshold check tablespace 0 0 Mon Sep 05 page 8 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- thresholds _cleanup_rollback_entries no. of undo entries 100 100 to apply per transaction cleanup _close_cached_open_cursors close cursors cached FALSE FALSE by PL/SQL at each commit _cluster_library cluster library clss clss selection _collapse_wait_history collapse wait FALSE FALSE history _collect_undo_stats Collect Statistics TRUE TRUE v$undostat _column_compression_factor Column compression 0 0 ratio _column_elimination_off turn off FALSE FALSE predicate-only column elimination _column_tracking_level column usage 1 1 tracking _complex_view_merging enable complex view TRUE TRUE merging
_controlfile_block_size control file block 0 0 size in bytes _controlfile_enqueue_dump dump the system FALSE FALSE states after controlfile enqueue timeout
_controlfile_enqueue_timeout control file enqueue 900 900 timeout in seconds _controlfile_update_check controlfile update OFF OFF sanity check _convert_set_to_join enables conversion FALSE FALSE of set operator to join Mon Sep 05 page 9 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _coord_message_buffer parallel recovery 0 0 coordinator side extra message buffer size
_corrupted_rollback_segments corrupted undo segment list _cost_equality_semi_join enables costing of TRUE TRUE equality semi-join _cpu_to_io divisor for 0 0 converting CPU cost to I/O cost _cr_grant_global_role if TRUE, grant lock TRUE TRUE for CR requests when block is in global role _cr_grant_local_role if TRUE, grant lock FALSE FALSE for CR using 3way ping when block in local role _cr_server_log_flush if TRUE, flush redo TRUE TRUE log before serving a CR buffer (DFS) _cursor_bind_capture_area_size maximum size of the 400 400 cursor bind capture area _cursor_bind_capture_interval interval (in 900 900 seconds) between two bind capture for a cursor _cursor_cache_frame_bind_memory frame & bind buffer FALSE FALSE caching _cursor_db_buffers_pinned additional number of 140 140 buffers a cursor can pin at once _cursor_plan_enabled enable collection TRUE TRUE and display of cursor plans _cursor_plan_hash_version version of cursor 1 1 Mon Sep 05 page 10 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- plan hash value _cursor_plan_unparse_enabled enables/disables TRUE TRUE using unparse to build
projection/predicate s _db_aging_cool_count Touch count set when 1 1 buffer cooled _db_aging_freeze_cr Make CR buffers FALSE FALSE always be too cold to keep in cache _db_aging_hot_criteria Touch count which 2 2 sends a buffer to head of replacement list
_db_aging_stay_count Touch count set when 0 0 buffer moved to head of replacement list _db_aging_touch_time Touch count which 3 3 sends a buffer to head of replacement list _db_always_check_system_ts Always perform block TRUE TRUE check and checksum for System tablespace _db_block_buffers Number of database 85671 85671 blocks cached in memory: hidden parameter _db_block_cache_clone Always clone data FALSE FALSE blocks on get (for debugging) _db_block_cache_history buffer header 0 0 tracing (non-zero only when debugging) _db_block_cache_num_umap number of unmapped 0 0 buffers (for tracking swap calls Mon Sep 05 page 11 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- on blocks) _db_block_cache_protect protect database FALSE FALSE blocks (true only when debugging) _db_block_check_for_debug Check more and dump FALSE FALSE block before image for debugging _db_block_granule_interval number of granules 10 10 to process _db_block_hash_buckets Number of database 262144 262144 block hash buckets _db_block_hash_latches Number of database 1024 1024 block hash latches _db_block_hi_priority_batch_size Fraction of writes 0 0 for high priority reasons
_db_block_known_clean_pct Initial Percentage 2 2 of buffers to maintain known clean _db_block_lru_latches number of lru 56 56 latches _db_block_max_cr_dba Maximum Allowed 6 6 Number of CR buffers per dba
_db_block_max_scan_pct Percentage of 40 40 buffers to inspect when looking for free
_db_block_med_priority_batch_size Fraction of writes 0 0 for medium priority reasons _db_block_numa Number of NUMA nodes 1 1 _db_block_prefetch_limit Prefetch limit in 0 0 blocks
_db_block_prefetch_quota Prefetch quota as a 10 10 percent of cache size Mon Sep 05 page 12 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _db_block_trace_protect trace buffer protect FALSE FALSE calls
_db_cache_advice_batch_size cache advisory 128 128 simulation batch size _db_cache_advice_sample_factor cache advisory 4 4 sampling factor _db_cache_crx_check check for costly crx FALSE FALSE examination functions _db_cache_pre_warm Buffer Cache TRUE TRUE Pre-Warm Enabled : hidden parameter _db_fast_obj_check enable fast object FALSE FALSE drop sanity check _db_fast_obj_truncate enable fast object TRUE TRUE truncate _db_file_direct_io_count Sequential I/O buf 1048576 1048576 size _db_file_format_io_buffers Block formatting I/O 4 4 buf count _db_file_noncontig_mblock_read_count number of 11 11 noncontiguous db blocks to be prefetched _db_handles System-wide 3000 3000 simultaneous buffer operations _db_handles_cached Buffer handles 5 5 cached each process _db_large_dirty_queue Number of buffers 25 25 which force dirty queue to be written _db_mttr_advice MTTR advisory ON ON _db_mttr_partitions number of partitions 0 0 for MTTR advisory Mon Sep 05 page 13 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _db_mttr_sample_factor MTTR simulation 64 64 sampling factor _db_mttr_sim_target MTTR simulation targets
_db_mttr_sim_trace_size MTTR simulation 256 256 trace size _db_mttr_trace_to_alert dump trace entries FALSE FALSE to alert file _db_percent_hot_default Percent of default 50 50 buffer pool considered hot _db_percent_hot_keep Percent of keep 0 0 buffer pool considered hot _db_percent_hot_recycle Percent of recycle 0 0 buffer pool considered hot _db_percpu_create_cachesize size of cache 2 2 created per cpu in deferred cache create _db_recovery_temporal_file_dest default database recovery temporal file location _db_todefer_cache_create buffer cache FALSE FALSE deferred create _db_writer_chunk_writes Number of writes 0 0 DBWR should wait for _db_writer_coalesce_area_size Size of memory 1048576 1048576 allocated to dbwriter for coalescing writes _db_writer_coalesce_write_limit Limit on size of 131072 131072 coalesced write _db_writer_flush_imu If FALSE, DBWR will TRUE TRUE not downgrade IMU Mon Sep 05 page 14 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- txns for AGING _db_writer_histogram_statistics maintain dbwr FALSE FALSE histogram statistics in x$kcbbhs _db_writer_max_writes Max number of 0 0 outstanding DB Writer IOs _db_writer_scan_depth_pct Percentage of LRU 25 25 buffers for dbwr to scan when looking for dirty _dbg_proc_startup debug process FALSE FALSE startup _dbwr_async_io Enable dbwriter TRUE TRUE asynchronous writes _dbwr_scan_interval dbwriter scan 300 300 interval _dbwr_tracing Enable dbwriter 0 0 tracing _dedicated_server_post_wait dedicated server FALSE FALSE post/wait _dedicated_server_post_wait_call dedicated server FALSE FALSE post/wait call _default_non_equality_sel_check sanity check on TRUE TRUE default selectivity for like/range predicate _delay_index_maintain delays index TRUE TRUE maintenance until after MV is refreshed _diag_daemon start DIAG daemon TRUE TRUE _disable_datalayer_sampling disable datalayer FALSE FALSE sampling _disable_file_locks disable file locks FALSE FALSE for control, data, redo log files Mon Sep 05 page 15 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _disable_function_based_index disable FALSE FALSE function-based index matching _disable_health_check Disable Health Check FALSE FALSE _disable_image_check Disable Oracle FALSE FALSE executable image checking _disable_incremental_checkpoints Disable incremental FALSE FALSE checkpoints for thread recovery _disable_kcbhxor_osd disable kcbh(c)xor FALSE FALSE OSD functionality _disable_latch_free_SCN_writes_via_32 disable latch-free FALSE FALSE cas SCN writes using 32-bit compare & swap
_disable_latch_free_SCN_writes_via_64 disable latch-free FALSE FALSE cas SCN writes using 64-bit compare & swap
_disable_logging Disable logging FALSE FALSE _disable_multiple_block_sizes disable multiple FALSE FALSE block size support (for debugging) _disable_odm disable odm feature FALSE FALSE _disable_recoverable_recovery Disable the new FALSE FALSE recoverable recovery mechanism _disable_sample_io_optim disable row sampling FALSE FALSE IO optimization _disable_savepoint_reset disable the fix for FALSE FALSE bug 1402161 _disable_selftune_checkpointing Disable self-tune FALSE FALSE checkpointing _disable_sun_rsm Disable IPC OSD TRUE TRUE support for Sun RSMAPI Mon Sep 05 page 16 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _disable_system_state disable system state FALSE FALSE dump
_disable_txn_alert disable txn layer 0 0 alert
_discrete_transactions_enabled enable OLTP mode FALSE FALSE _dispatcher_rate_scale scale to display rate statistic (100ths of a second) _dispatcher_rate_ttl time-to-live for rate statistic (100ths of a second) _distinct_view_unnesting enables unnesting of FALSE FALSE in subquery into distinct view _distributed_recovery_connection_hold number of seconds 200 200 _time RECO holds outbound connections open _dlm_send_timeout DLM send timeout 30000 30000 value _dlmtrace Trace string of global enqueue type(s)
_dml_monitoring_enabled enable modification TRUE TRUE monitoring _domain_index_batch_size maximum number of 2000 2000 rows from one call to domain index fetch routine _domain_index_dml_batch_size maximum number of 200 200 rows for one call to domain index dml routines _ds_iocount_iosize Dynamic Sampling 6553664 6553664 Service defaults: #IOs and IO Size _dss_cache_flush enable full cache FALSE FALSE flush for parallel execution Mon Sep 05 page 17 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _dump_common_subexpressions dump common FALSE FALSE subexpressions _dump_connect_by_loop_data dump connect by loop FALSE FALSE error message into trc file _dump_cursor_heap_sizes dump comp/exec heap FALSE FALSE sizes to tryace file _dump_interval_limit trace dump time 120 120 interval limit (in seconds) _dump_max_limit max number of dump 5 5 within dump interval _dump_system_state_scope scope of sysstate local local dump during instance termination _dump_trace_scope scope of trace dump global global during a process crash
_dynamic_rls_policies rls policies are TRUE TRUE dynamic
_dynamic_stats_threshold delay threshold (in 30 30 seconds) between sending statistics messages _eliminate_common_subexpr enables elimination TRUE TRUE of common sub-expressions _enable_NUMA_optimization Enable NUMA specific TRUE TRUE optimizations _enable_block_level_transaction_recov enable block level TRUE TRUE ery recovery _enable_cscn_caching enable commit SCN FALSE FALSE caching for all transactions _enable_default_affinity to enable default 0 0 implementation of Mon Sep 05 page 18 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- affinity osds _enable_fast_ref_after_mv_tbs enable fast refresh FALSE FALSE after move tablespace _enable_hash_overflow TRUE - enable hash FALSE FALSE cluster overflow based on SIZE _enable_kgh_policy temporary to FALSE FALSE disable/enable kgh policy
_enable_list_io Enable List I/O FALSE FALSE _enable_nativenet_tcpip Enable skgxp driver FALSE FALSE usage for native net _enable_refresh_schedule enable or disable MV TRUE TRUE refresh scheduling (revert to 9.2 behavior) _enable_tablespace_alerts enable tablespace TRUE TRUE alerts _enable_type_dep_selectivity enable type TRUE TRUE dependent selectivity estimates _enqueue_debug_multi_instance debug enqueue multi FALSE FALSE instance _enqueue_hash enqueue hash table 1365 1365 length _enqueue_hash_chain_latches enqueue hash chain 2 2 latches _enqueue_locks locks for managed 8150 8150 enqueues _expand_aggregates expand aggregates TRUE TRUE _explain_rewrite_mode allow additional FALSE FALSE messages to be generated during explain rewrite _fair_remote_cvt if TRUE enables fair FALSE FALSE Mon Sep 05 page 19 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- remote convert _fairness_threshold number of times to 4 4 CR serve before downgrading lock (DFS) _fast_dual_enabled enable/disable fast TRUE TRUE dual _fast_full_scan_enabled enable/disable index TRUE TRUE fast full scan _fast_start_instance_recovery_target cluster availability 0 0 target time in RAC environment _fic_algorithm_set Set Frequent Itemset automatic automatic Counting Algorithm _fic_area_size size of Frequent 131072 131072 Itemset Counting work area _fic_max_length Frequent Itemset 20 20 Counting Maximum Itemset Length _fic_outofmem_candidates Frequent Itemset FALSE FALSE Counting Out Of Memory Candidates Generation _fifth_spare_parameter fifth spare parameter - string _first_spare_parameter first spare parameter - integer _flashback_allow_noarchivelog Allow enabling FALSE FALSE flashback on noarchivelog database _flashback_barrier_interval Flashback barrier 1800 1800 interval in seconds _flashback_copy_latches Number of flashback 10 10 copy latches Mon Sep 05 page 20 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _flashback_fuzzy_barrier Use flashback fuzzy TRUE TRUE barrier
_flashback_generation_buffer_size flashback generation 2097152 2097152 buffer size _flashback_hint_barrier_percent Flashback hint 20 20 barrier percent _flashback_log_min_size Minimum flashback 100 100 log size _flashback_log_size Flashback log size 1000 1000 _flashback_logfile_enqueue_timeout flashback logfile 600 600 enqueue timeout for opens
_flashback_max_log_size Maximum flashback 0 0 log size in bytes (OS limit) _flashback_n_log_per_thread Desired number of 128 128 flashback logs per flashback thread _flashback_standby_barrier_interval Flashback standby 1800 1800 barrier interval in seconds _flashback_verbose_info Print verbose FALSE FALSE information about flashback database _flashback_write_size_qm Desired flashback 4 4 write size in quarter MB _force_datefold_trunc force use of trunc FALSE FALSE for datefolding rewrite
_force_temptables_for_gsets executes FALSE FALSE concatenation of rollups using temp tables
_fourth_spare_parameter fourth spare parameter - string _full_pwise_join_enabled enable full TRUE TRUE Mon Sep 05 page 21 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- partition-wise join when TRUE _gby_onekey_enabled enable use of one TRUE TRUE comparison of all group by keys _gc_affinity_limit dynamic affinity 50 50 limit (DFS) _gc_affinity_minimum dynamic affinity 1200 1200 minimum activity per minute (DFS) _gc_affinity_time how often in minutes 10 10 to check affinity (DFS) _gc_check_bscn if TRUE, check for TRUE TRUE stale blocks (DFS) _gc_defer_time how long to defer 3 3 down converts for hot buffers (DFS) _gc_element_percent global cache element 103 103 percent (DFS) _gc_global_lru if TRUE, enable FALSE FALSE global lru (DFS) _gc_integrity_checks if TRUE, enable TRUE TRUE expensive integrity checks (DFS) _gc_keep_recovery_buffers if TRUE, make FALSE FALSE recovery buffers current (DFS) _gc_latches number of latches 5 5 per LMS process (DFS) _gc_statistics if TRUE, kcl TRUE TRUE statistics are maintained (DFS) _gc_use_cr if TRUE, allow CR TRUE TRUE pins on PI and WRITING buffers Mon Sep 05 page 22 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- (DFS) _gc_vector_read if TRUE, vector read TRUE TRUE current buffers (DFS)
_gcs_fast_reconfig if TRUE, enable fast TRUE TRUE reconfiguration for gcs locks _gcs_latches number of gcs 0 0 resource hash latches to be allocated per LMS process
_gcs_process_in_recovery if TRUE, process gcs TRUE TRUE requests during instance recovery _gcs_resources number of gcs resources to be allocated _gcs_shadow_locks number of pcm shadow locks to be allocated _generalized_pruning_enabled controls extensions TRUE TRUE to partition pruning for general predicates _ges_dd_debug if TRUE enables GES FALSE FALSE deadlock detection debug diagnostics _ges_diagnostics if TRUE enables GES TRUE TRUE diagnostics _ges_trace if TRUE enables TRUE TRUE GES/GCS debug traces _groupby_nopushdown_cut_ratio groupby nopushdown 3 3 cut ratio _groupby_orderby_combine groupby/orderby 5000 5000 don't combine threshold Mon Sep 05 page 23 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _gs_anti_semi_join_allowed enable anti/semi TRUE TRUE join for the GS query _hang_detection Hang Management 0 0 detection interval _hard_protection if TRUE enable FALSE FALSE H.A.R.D specific format changes _hash_join_enabled enable/disable hash TRUE TRUE join
_hash_multiblock_io_count number of blocks 0 0 hash join will read/write at once _high_server_threshold high server 0 0 thresholds _hj_bit_filter_threshold hash-join bit 50 50 filtering threshold (0 always enabled) _idl_conventional_index_maintenance enable conventional TRUE TRUE index maintenance for insert direct load
_idxrb_rowincr proportionality 100000000 100000000 constant for dop vs. rows in index rebuild
_ignore_desc_in_index ignore DESC in FALSE FALSE indexes, sort those columns ascending anyhow
_improved_outerjoin_card improved outer-join TRUE TRUE cardinality calculation _improved_row_length_enabled enable the TRUE TRUE improvements for computing the average row length _imr_active Activate Instance TRUE TRUE Mon Sep 05 page 24 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- Membership Recovery feature
_imr_max_reconfig_delay Maximum 300 300 Reconfiguration delay (seconds) _imr_splitbrain_res_wait Maximum wait for 600 600 split-brain resolution (seconds) _imu_pools in memory undo pools 3 3 _in_memory_undo Make in memory undo TRUE TRUE for top level transactions _index_join_enabled enable the use of TRUE TRUE index joins _index_prefetch_factor index prefetching 100 100 factor
_init_sql_file File containing SQL ?/rdbms/admin ?/rdbms/admin/s statements to /sql.bsq ql.bsq execute upon database creation _init_tempfile_on_open if TRUE re-init FALSE FALSE tempfile bitmaps on db open whenever possible _insert_enable_hwm_brokered during parallel TRUE TRUE inserts high water marks are brokered _inst_locking_period period an instance 5 5 can retain a newly acquired level1 bitmap _interconnect_checksum if TRUE, checksum TRUE TRUE interconnect blocks (DFS)
_intrapart_pdml_enabled Enable TRUE TRUE intra-partition updates/deletes _intrapart_pdml_randomlocal_enabled Enable TRUE TRUE Mon Sep 05 page 25 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- intra-partition updates/deletes with random local dist _io_slaves_disabled Do not use I/O FALSE FALSE slaves _ioslave_batch_count Per attempt IOs 1 1 picked _ioslave_issue_count IOs issued before 500 500 completion check _ipc_fail_network Simulate cluster 0 0 network failer _ipc_test_failover Test transparent 0 0 cluster network failover _ipc_test_mult_nets simulate multiple 0 0 cluster networks _job_queue_interval Wakeup interval in 5 5 seconds for job queue co-ordinator _kcl_commit if TRUE, call TRUE TRUE kjbcommit (DFS) _kcl_conservative_log_flush if TRUE, FALSE FALSE conservatively log flush before CR serving (DFS) _kcl_debug if TRUE, record le TRUE TRUE history (DFS) _kcl_index_split if TRUE, reject TRUE TRUE pings on blocks in middle of a split (DFS) _kcl_undo_grouping grouping for undo 32 32 block locks (DFS) _kcl_undo_locks number of locks per 128 128 undo segment (DFS) _kdbl_enable_post_allocation allocate dbas after FALSE FALSE Mon Sep 05 page 26 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- populating data buffers
_keep_remote_column_size remote column size FALSE FALSE does not get modified _kernel_message_network_driver kernel message FALSE FALSE network driver _kffmap_hash_size size of kffmap_hash 1024 1024 table _kffmop_hash_size size of kffmop_hash 2048 2048 table _kghdsidx_count max kghdsidx count 1 1 _kgl_bucket_count index to the bucket 9 9 count array _kgl_hash_collision whether KGL hash FALSE FALSE collision is possible _kgl_keep_cache_pct KGL keep cache 30 30 minimum threshold _kgl_keep_cache_retain_pct KGL keep cache 20 20 retain threshold _kgl_latch_count number of library 0 0 cache latches _kgl_multi_instance_invalidation whether KGL to TRUE TRUE support multi-instance invalidations _kgl_multi_instance_lock whether KGL to TRUE TRUE support multi-instance locks _kgl_multi_instance_pin whether KGL to TRUE TRUE support
multi-instance pins _kgl_session_cached_objects maximum length of 10 10 the KGL object cache lru
Mon Sep 05 page 27 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _kgl_time_to_wait_for_locks time to wait for 15 15 locks and pins before timing out _kglsim_maxmem_percent max percentage of 5 5 shared pool size to be used for KGL advice _kill_java_threads_on_eoc Kill Java threads FALSE FALSE and do sessionspace migration at end of call _kkfi_trace trace expression FALSE FALSE substitution _kolfuseslf allow kolf to use FALSE FALSE slffopen _ksdxw_cini_flg ksdxw context 0 0 initialization flag _ksdxw_nbufs ksdxw number of 1000 1000 buffers in buffered mode
_ksdxw_num_pgw number of 10 10 watchpoints on a per-process basis _ksdxw_num_sgw number of 10 10 watchpoints to be shared by all processes _ksdxw_stack_depth number of PCs to 4 4 collect in the stack when watchpoint is hit _kse_die_timeout amount of time a 60000 60000 dying process is spared by PMON (in centi-secs) _ksi_trace KSI trace string of lock type(s) _ksmg_granule_locking_status granule locking 1 1 Mon Sep 05 page 28 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- status _ksmg_granule_size granule size in 4194304 4194304 bytes _ksmg_lock_check_interval timeout action interval in minutes _ksmg_lock_reacquire_count repeat count for 5 5 acquisition of locks _kspptbl_mem_usage amount of memory 1556016 1556016 used for unused session parameter tables _ksu_diag_kill_time number of seconds 5 5 ksuitm waits before killing diag _ktc_debug for ktc debug 0 0 _ktc_latches number of ktc 0 0 latches _ktu_latches number of KTU 0 0 latches _ku_trace datapump trace none none parameter _large_pool_min_alloc minimum allocation 3 3 size in bytes for the large allocation pool _last_allocation_period period over which an 5 5 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 Mon Sep 05 page 29 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _latch_miss_stat_sid Sid of process for 0 0 which to collect latch stats _latch_recovery_alignment align latch recovery 998 998 structures _ldr_io_size size of write IOs 262144 262144 used during a load operation _left_nested_loops_random enable random TRUE TRUE distribution method for left of nestedloops _lgwr_async_broadcasts LGWR Asynchronous TRUE TRUE Broadcasts enabling boolean flag _lgwr_async_io LGWR Asynchronous IO FALSE FALSE enabling boolean flag
_lgwr_delay_write LGWR write delay for FALSE FALSE debugging _lgwr_io_slaves LGWR I/O slaves 0 0 _lgwr_max_ns_wt Maximum wait time 1 1 for lgwr to allow NetServer to progress _lgwr_ns_nl_max Variable to simulate 1000 1000 network latency or buffer threshold _lgwr_ns_nl_min Variable to simulate 500 500 network latency or buffer threshold _lgwr_ns_sim_err Variable to simulate 0 0 errors lgwrns _library_cache_advice whether KGL advice TRUE TRUE should be turned on _lightweight_hdrs Lightweight headers TRUE TRUE for redo Mon Sep 05 page 30 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _like_with_bind_as_equality treat LIKE predicate FALSE FALSE with bind as an equality predicate _lm_activate_lms_threshold threshold value to 100 100 activate an additional lms _lm_cache_lvl0_cleanup how often to cleanup 0 0 level 0 cache res (in sec) _lm_cache_res_cleanup percentage of cached 25 25 resources should be cleanup
_lm_cache_res_type cache resource: TMHW TMHW string of lock types(s) _lm_dd_interval dd time interval in 60 60 seconds _lm_drm_max_requests dynamic remastering 100 100 maximum affinity requests processed together _lm_drm_window dynamic remastering 0 0 bucket window size _lm_dynamic_lms dynamic lms FALSE FALSE invocation _lm_dynamic_load dynamic load TRUE TRUE adjustment _lm_dynamic_remastering if TRUE enables FALSE FALSE dynamic remastering _lm_enq_lock_freelist Number of ges enqueue element freelist _lm_enq_rcfg if TRUE enables TRUE TRUE enqueue
reconfiguration _lm_enqueue_freelist Number of enqueue 3 3 Mon Sep 05 page 31 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- freelist _lm_file_affinity mapping between file id and master instance number _lm_global_posts if TRUE deliver TRUE TRUE global posts to remote nodes _lm_lmd_waittime default wait time 8 8 for lmd in centiseconds _lm_lms number of background 0 0 gcs server processes to start _lm_lms_waittime default wait time 8 8 for lms in centiseconds _lm_locks number of enqueues 12000 12000 configured for cluster database _lm_master_weight master resource 1 1 weight for this instance _lm_max_lms max. number of 0 0 background global cache server processes _lm_min_lms min. number of 0 0 background global cache server processes _lm_msg_batch_size GES batch message 0 0 size
_lm_msg_cache_thresholds GES message buffer caching threshold _lm_msg_cleanup_interval GES message buffer 3000 3000 cleanup interval time Mon Sep 05 page 32 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _lm_node_join_opt cluster database FALSE FALSE node join optimization in reconfig _lm_non_fault_tolerant disable cluster FALSE FALSE database fault-tolerance mode _lm_num_pcmhv_latches number of latches 0 0 covering the PCM HV buckets in cgs _lm_proc_freeze_timeout reconfiguration: 300 300 process freeze timeout _lm_process_batching GES implicit process TRUE TRUE batching for IPC messages _lm_procs number of client 127 127 processes configured for cluster database _lm_rcfg_timeout Reconfiguration 180000 180000 timeout _lm_rcv_buffer_size the size of receive 32768 32768 buffer _lm_res_hash_bucket number of resource 0 0 hash buckets _lm_res_part number of resource 1289 1289 partition configured for gcs
_lm_ress number of resources 6000 6000 configured for cluster database _lm_send_buffers number of cluster 10000 10000 database send buffers
_lm_send_mode GES send mode auto auto _lm_send_queue_batching GES send queue TRUE TRUE message batching Mon Sep 05 page 33 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _lm_send_queue_length GES send queue 5000 5000 maximum length _lm_sendproxy_reserve GES percentage of 25 25 send proxy reserve of send tickets _lm_share_lock_opt if TRUE enables FALSE FALSE share lock optimization _lm_sq_batch_factor GES send queue 2 2 minimum batching factor _lm_sq_batch_type GES send queue auto auto batching mechanism _lm_sq_batch_waittick GES send queue 3 3 batching waittime in tick
_lm_sync_timeout Synchronization timeout for DLM reconfiguration steps
_lm_ticket_active_sendback Flow control ticket active sendback threshold _lm_tickets GES messaging 1000 1000 tickets _lm_tx_delta TX lock localization 16 16 delta _lm_validate_resource_type if TRUE enables FALSE FALSE resource name validation _lm_xids number of 139 139 transaction IDs configured for cluster database _load_without_compile Load PL/SQL or none none Database objects without compilation Mon Sep 05 page 34 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _local_communication_costing_enabled enable local TRUE TRUE communication costing when TRUE _local_communication_ratio set the ratio 50 50 between global and local communication (0..100) _lock_sga_areas Lock specified areas 0 0 of the SGA in physical memory _log_archive_buffer_size Size of each 2048 2048 archival buffer in log file blocks _log_archive_buffers Number of buffers to 10 10 allocate for archiving _log_archive_callout archival callout _log_archive_compress_enable Bypass database FALSE FALSE rules for enabling archivelog compression _log_archive_delta_sync_wait iterative sleep time 0 0 in centiseconds seconds when SYNC=PARALLEL _log_archive_net_timeout maximum network wait 0 0 time in seconds when SYNC=PARALLEL _log_archive_prot_auto_demote log archive FALSE FALSE protection auto demotion _log_archive_security_enabled log archive security TRUE TRUE enabled _log_blocks_during_backup log block images TRUE TRUE when changed during backup
_log_buffers_corrupt corrupt redo buffers FALSE FALSE before write Mon Sep 05 page 35 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _log_buffers_debug debug redo buffers FALSE FALSE (slows things down) _log_checkpoint_recovery_check # redo blocks to 0 0 verify after checkpoint _log_committime_block_cleanout Log commit-time FALSE FALSE block cleanout _log_debug_multi_instance debug redo multi FALSE FALSE instance code _log_deletion_policy archivelog deletion mandatory mandatory policy for mandatory/all destination _log_io_size automatically 0 0 initiate log write if this many redo blocks in buffer _log_parallelism Number of log buffer 1 1 strands _log_parallelism_dynamic Enable dynamic TRUE TRUE strands _log_parallelism_max Maximum number of 2 2 log buffer strands _log_private_mul Private strand 5 5 multiplier for log space preallocation _log_private_parallelism Number of private FALSE FALSE log buffer strands for zero-copy redo _log_private_parallelism_mul Active sessions 10 10 multiplier to deduce number of private strands _log_simultaneous_copies number of 4 4 simultaneous copies into redo buffer(# of copy latches) Mon Sep 05 page 36 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _log_space_errors should we report TRUE TRUE space errors to alert log _log_switch_timeout Maximum number of 0 0 seconds redos in the current log could span _longops_enabled longops stats TRUE TRUE enabled _low_server_threshold low server 0 0 thresholds _master_direct_sends direct sends for 31 31 messages from master (DFS)
_mav_refresh_consistent_read refresh materialized TRUE TRUE views using consistent read snapshot _mav_refresh_double_count_prevented materialized view FALSE FALSE MAV refreshes avoid double counting _mav_refresh_opt optimizations during 0 0 refresh of materialized views _mav_refresh_unionall_tables # tables for union 3 3 all expansion during materialized view refresh
_max_exponential_sleep max sleep during 0 0 exponential backoff _max_protocol_support Max occurrence 10000 10000 protocols supported in a process _max_shrink_obj_stats number of segments 0 0 for which shrink stats will be maintained _max_sleep_holding_latch max time to sleep 4 4 Mon Sep 05 page 37 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- while holding a latch
_media_recovery_read_batch media recovery block 128 128 read batch _mem_annotation_pr_lev private memory 0 0 annotation collection level _mem_annotation_scale memory annotation 1 1 pre-allocation scaling
_mem_annotation_sh_lev shared memory 0 0 annotation collection level _mem_annotation_store memory annotation FALSE FALSE in-memory store _memory_broker_log_stat_entries memory broker num 9 9 stat entries _memory_broker_shrink_heaps memory broker allow 0 0 policy to shrink shared pool _memory_broker_shrink_java_heaps memory broker allow 900 900 policy to shrink java pool _memory_broker_shrink_timeout memory broker allow 60000000 60000000 policy to shrink shared/java pool _memory_broker_stat_interval memory broker 300 300 statistics gathering interval _memory_management_tracing trace memory 0 0 management activity _messages message queue 1200 1200 resources - dependent on # processes & # buffers
_minimal_stats_aggregation prohibit stats TRUE TRUE Mon Sep 05 page 38 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- aggregation at compile/partition maintenance time _minimum_blocks_to_shrink minimum number 0 0 freeable blocks for shrink to be present _minimum_extents_to_shrink minimum number 1 1 freeable extents for shrink to be present _minimum_giga_scn Minimum SCN to start 0 0 with in 2^30 units _mirror_redo_buffers Save buffers for FALSE FALSE debugging redo corruptions _mmv_query_rewrite_enabled allow rewrites with FALSE FALSE multiple MVs and/or base tables _multi_join_key_table_lookup TRUE iff TRUE TRUE multi-join-key table lookup prefetch is enabled _multiple_instance_recovery use multiple FALSE FALSE instances for media recovery _mv_refresh_ana what percent to 0 0 analyze after complete/PCT refresh _mv_refresh_costing refresh decision rule rule based on cost or on rules
_mv_refresh_delta_fraction delta mv as 10 10 fractional percentage of size of mv
_mv_refresh_eut refresh materialized TRUE TRUE views using EUT(partition)-based algorithm Mon Sep 05 page 39 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _mv_refresh_force_parallel_query force materialized 0 0 view refreshes to use parallel query _mv_refresh_new_setup_disabled materialized view MV FALSE FALSE refresh new setup disabling _mv_refresh_rebuild_percentage minimum percentage 10 10 change required in MV to force an index rebuild
_mv_refresh_selections create materialized TRUE TRUE views with selections and fast refresh
_mv_refresh_use_stats pass cardinality TRUE TRUE hints to refresh queries _mv_refsched_timeincr proportionality 300000 300000 constant for dop vs. time in MV refresh _mwin_schedule Enable/disable TRUE TRUE Maintenance Window Schedules _nchar_imp_cnv NLS allow Implicit TRUE TRUE Conversion between CHAR and NCHAR _nchar_imp_conv should implicit TRUE TRUE conversion bewteen clob and nclob be allowed
_ncmb_readahead_enabled enable multi-block 0 0 readahead for an index scan _ncmb_readahead_tracing turn on multi-block 0 0 readahead tracing _nested_loop_fudge nested loop fudge 100 100 _nested_mav_fast_oncommit_enabled nested MAV refresh TRUE TRUE fast on commit allowed Mon Sep 05 page 40 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _new_initial_join_orders enable initial join TRUE TRUE orders based on new ordering heuristics _new_sort_cost_estimate enables the use of TRUE TRUE new cost estimate for sort _no_objects no object features FALSE FALSE are used _no_or_expansion OR expansion during FALSE FALSE optimization disabled _notify_crs notify cluster ready FALSE FALSE services of startup and shutdown _ns_max_flush_wt Flush wait time for 1 1 NetServer to flush oustanding writes _num_longop_child_latches number of child 2 2 latches for long op array
_number_cached_attributes maximum number of 10 10 cached attributes per instance _object_statistics enable the object TRUE TRUE level statistics collection _offline_rollback_segments offline undo segment list
_ogms_home GMS home directory _olap_aggregate_buffer_size OLAP Aggregate max 1048576 1048576 buffer size _olap_aggregate_flags OLAP Aggregate debug 0 0 flags _olap_aggregate_function_cache_enable OLAP Aggregate TRUE TRUE d function cache enabler
Mon Sep 05 page 41 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _olap_aggregate_function_merge_thresh OLAP Aggregate 32768 32768 old function merge threshold _olap_aggregate_max_thread_tuples OLAP Aggregate max 5000 5000 thread tuples creation _olap_aggregate_min_buffer_size OLAP Aggregate min 1024 1024 buffer size _olap_aggregate_min_thread_status OLAP Aggregate 64 64 minimum cardinality of dimensions for thread
_olap_aggregate_multipath_hier OLAP Aggregate FALSE FALSE Multi-path Hierarhies enabled _olap_aggregate_statlen_thresh OLAP Aggregate 1024 1024 status array usage threshold _olap_aggregate_store_probability OLAP Aggregate 100 100 function storeback probability _olap_aggregate_work_per_thread OLAP Aggregate max 1024 1024 work parents _olap_aggregate_worklist_max OLAP Aggregate max 5000 5000 worklists generated at once
_olap_allocate_errorlog_format OLAP Allocate %8p %8y %8z % %8p %8y %8z %e Errorlog Format e (%n) (%n) _olap_allocate_errorlog_header OLAP Allocate Dim Sour Dim Source Errorlog Header ce Basis Basis format %-8d %-8s %-8 %-8d %-8s %-8b b Description Description -------- ------ -------- ---- -- -------- --- ---- -------- -------- ----------- _olap_continuous_trace_file Specify TRUE to FALSE FALSE enable continuous OLAP tracing - Mon Sep 05 page 42 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- otherwise only exceptional events will be logged _olap_dbgoutfile_echo_to_eventlog OLAP DbgOutfile copy FALSE FALSE output to event log (tracefile) _olap_dimension_corehash_class OLAP Dimension 1 1 In-Core Hash Table Class _olap_dimension_corehash_max OLAP Dimension 10000 10000 In-Core Hash Table Maximum Size _olap_dimsave_restore_cache_values OLAP Dimsave TRUE TRUE restores cached dimension values _olap_eif_export_lob_size OLAP EIF Export BLOB 2147483647 2147483647 size _olap_object_hash_class OLAP Object Hash 2 2 Table Class _olap_page_pool_expand_rate OLAP Page Pool 20 20 Expand Rate _olap_page_pool_hi OLAP Page Pool High 50 50 Watermark _olap_page_pool_hit_target OLAP Page Pool Hit 100 100 Target _olap_page_pool_low OLAP Page Pool Low 262144 262144 Watermark _olap_page_pool_pressure OLAP Page Pool 90 90 Pressure Threshold _olap_page_pool_shrink_rate OLAP Page Pool 50 50 Shrink Rate _olap_parallel_update_threshold OLAP parallel update 1000 1000 threshold in pages _olap_poutlog_echo_to_eventlog OLAP POutLog copy FALSE FALSE output to event log (tracefile) Mon Sep 05 page 43 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _olap_sesscache_enabled OLAP Session Cache TRUE TRUE knob
_olap_sort_buffer_size OLAP Sort Buffer 262144 262144 Size
_olap_statbool_corebits OLAP Status Boolean 20000000 20000000 max incore bits _olap_statbool_threshold OLAP Status Boolean 8100 8100 CBM threshold _olap_table_function_statistics Specify TRUE to FALSE FALSE output OLAP table function timed statistics trace _olapi_history_retention enable olapi history FALSE FALSE retention _olapi_iface_object_history enable olapi 1000 1000 interface object history collection _olapi_iface_object_history_retention enable olapi FALSE FALSE interface object history retention _olapi_iface_operation_history_retent enable olapi FALSE FALSE ion interface operation history retention _olapi_interface_operation_history enable olapi 1000 1000 interface operation history collection _olapi_memory_operation_history enable olapi memory 1000 1000 alloc/free history collection _olapi_memory_operation_history_pause enable olapi memory 0 0 _at_seqno alloc/free history collection pausing _olapi_memory_operation_history_reten enable olapi memory FALSE FALSE tion operation history retention _olapi_session_history enable olapi session 300 300 Mon Sep 05 page 44 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- history collection _olapi_session_history_retention enable olapi session FALSE FALSE history retention _old_connect_by_enabled enable/disable old FALSE FALSE connect by _omf enable/disable OMF enabled enabled _oneside_colstat_for_equijoins sanity check on TRUE TRUE default selectivity for like/range predicate _optim_adjust_for_part_skews adjust stats for TRUE TRUE skews across partitions _optim_dict_stats_at_db_cr_upg enable/disable TRUE TRUE dictionary stats gathering at db create/upgrade _optim_enhance_nnull_detection TRUE to enable index TRUE TRUE [fast] full scan more often _optim_new_default_join_sel improves the way TRUE TRUE default equijoin selectivity are computed _optim_peek_user_binds enable peeking of TRUE TRUE user binds _optimizer_adjust_for_nulls adjust selectivity TRUE TRUE for null values _optimizer_autostats_job enable/disable auto TRUE TRUE stats collection job _optimizer_block_size standard block size 8192 8192 used by optimizer _optimizer_cache_stats cost with cache FALSE FALSE statistics _optimizer_cbqt_factor cost factor for 50 50 cost-based query transformation Mon Sep 05 page 45 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _optimizer_ceil_cost CEIL cost in CBO TRUE TRUE _optimizer_choose_permutation force the optimizer 0 0 to use the specified permutation _optimizer_compute_index_stats force index stats TRUE TRUE collection on index creation/rebuild _optimizer_correct_sq_selectivity force correct TRUE TRUE computation of subquery selectivity _optimizer_cost_based_transformation enables cost-based LINEAR LINEAR query transformation _optimizer_cost_filter_pred enables costing of FALSE FALSE filter predicates in IO cost model _optimizer_cost_model optimizer cost model CHOOSE CHOOSE _optimizer_degree force the optimizer 0 0 to use the same degree of parallelism _optimizer_dim_subq_join_sel use join selectivity TRUE TRUE in choosing star transformation dimensions _optimizer_disable_strans_sanity_chec disable star 0 0 ks transformation sanity checks _optimizer_dyn_smp_blks number of blocks for 32 32 optimizer dynamic sampling _optimizer_ignore_hints enables the embedded FALSE FALSE hints to be ignored _optimizer_invalidation_period time window for 18000 18000 invalidation of cursors of analyzed objects
_optimizer_join_order_control controls the 3 3 optimizer join order Mon Sep 05 page 46 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- search algorithm _optimizer_join_sel_sanity_check enable/disable TRUE TRUE sanity check for multi-column join selectivity _optimizer_max_permutations optimizer maximum 2000 2000 join permutations per query block _optimizer_mjc_enabled enable merge join TRUE TRUE cartesian _optimizer_mode_force force setting of TRUE TRUE optimizer mode for user recursive SQL also
_optimizer_new_join_card_computation compute join TRUE TRUE cardinality using non-rounded input values
_optimizer_percent_parallel optimizer percent 101 101 parallel _optimizer_push_down_distinct push down distinct 0 0 from query block to table _optimizer_push_pred_cost_based use cost-based query TRUE TRUE transformation for push pred optimization _optimizer_random_plan optimizer seed value 0 0 for random plans _optimizer_save_stats enable/disable TRUE TRUE saving old versions of optimizer stats _optimizer_search_limit optimizer search 5 5 limit
_optimizer_skip_scan_enabled enable/disable index TRUE TRUE skip scan _optimizer_sortmerge_join_enabled enable/disable TRUE TRUE Mon Sep 05 page 47 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- sort-merge join method
_optimizer_squ_bottomup enables unnesting of TRUE TRUE subquery in a bottom-up manner _optimizer_system_stats_usage system statistics TRUE TRUE usage _optimizer_undo_changes undo changes to FALSE FALSE query optimizer _optimizer_undo_cost_change optimizer undo cost 10.1.0.3 10.1.0.3 change _or_expand_nvl_predicate enable OR expanded TRUE TRUE plan for NVL/DECODE predicate _oradbg_pathname path of oradbg script
_ordered_nested_loop enable ordered TRUE TRUE nested loop costing _ordered_semijoin enable ordered TRUE TRUE semi-join subquery _parallel_adaptive_max_users maximum number of 2 2 users running with default DOP _parallel_broadcast_enabled enable broadcasting TRUE TRUE of small inputs to hash and sort merge joins _parallel_default_max_instances default maximum 1 1 number of instances for parallel query _parallel_execution_message_align Alignment of PX FALSE FALSE buffers to OS page boundary _parallel_fake_class_pct fake db-scheduler 0 0 percent used for testing
Mon Sep 05 page 48 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _parallel_fixwrite_bucket Number of buckets 1000 1000 for each round of fix write _parallel_load_bal_unit number of threads to 0 0 allocate per instance _parallel_load_balancing parallel execution TRUE TRUE load balanced slave allocation _parallel_min_message_pool minimum size of 902160 902160 shared pool memory to reserve for pq servers _parallel_recovery_stopat stop at -position- 32767 32767 to step through SMON _parallel_replay_bucket Number of buckets 1000 1000 for each round of parallel replay _parallel_server_idle_time idle time before 30000 30000 parallel query server dies (in 1/100 sec) _parallel_server_sleep_time sleep time between 10 10 dequeue timeouts (in 1/100ths) _parallel_slave_acquisition_wait time(in seconds) to 1 1 wait before retrying slave acquisition _parallel_txn_global enable parallel_txn FALSE FALSE hint with updates and deletes _parallelism_cost_fudge_factor set the parallelism 350 350 cost fudge factor _partial_pwise_join_enabled enable partial TRUE TRUE partition-wise join when TRUE _partition_view_enabled enable/disable TRUE TRUE partitioned views Mon Sep 05 page 49 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _passwordfile_enqueue_timeout password file 900 900 enqueue timeout in seconds _pct_refresh_double_count_prevented materialized view TRUE TRUE PCT refreshes avoid double counting _pdml_gim_sampling control separation 5000 5000 of global index maintenance for PDML _pdml_gim_staggered slaves start on FALSE FALSE different index when doing index maint _pdml_slaves_diff_part slaves start on TRUE TRUE different partition when doing index maint
_percent_flashback_buf_partial_full Percent of flashback 50 50 buffer filled to be considered partial full
_pga_large_extent_size PGA large extent 1048576 1048576 size
_pga_max_size Maximum size of the 209715200 209715200 PGA memory for one process _ping_level fusion ping level 3 3 (DFS) _pkt_enable enable progressive FALSE FALSE kill test _pkt_pmon_interval PMON process 50 50 clean-up interval (cs)
_pkt_start start progressive FALSE FALSE kill test instrumention _plsql_anon_block_code_type PL/SQL anonymous INTERPRETED INTERPRETED block code-type Mon Sep 05 page 50 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _plsql_dump_buffer_events conditions upon which the PL/SQL circular buffer is dumped
_pmon_load_constants server load 300,192,64,3, 300,192,64,3,10 balancing constants 10,10,0 ,10,0 (S,P,D,I,L,C,M) _pre_rewrite_push_pred push predicates into TRUE TRUE views before rewrite _precompute_gid_values precompute gid TRUE TRUE values and copy them before returning a row _pred_move_around enables predicate TRUE TRUE move-around _predicate_elimination_enabled allow predicate TRUE TRUE elimination if set to TRUE
_prescomm presume commit of FALSE FALSE IMU transactions _print_refresh_schedule enable dbms_output false false of materialized view refresh schedule _private_memory_address Start address of large extent memory segment
_project_view_columns enable projecting TRUE TRUE out unreferenced columns of a view _projection_pushdown projection pushdown TRUE TRUE _projection_pushdown_debug level for projection 0 0 pushdown debugging _push_join_predicate enable pushing join TRUE TRUE predicate inside a view _push_join_union_view enable pushing join TRUE TRUE predicate inside a Mon Sep 05 page 51 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- union all view _push_join_union_view2 enable pushing join TRUE TRUE predicate inside a union view _px_async_getgranule asynchronous get FALSE FALSE granule in the slave _px_broadcast_fudge_factor set the tq 100 100 broadcasting fudge factor percentage _px_buffer_ttl ttl for px mesg 30 30 buffers in seconds _px_compilation_debug debug level for 0 0 parallel compilation _px_compilation_trace tracing level for 0 0 parallel compilation _px_dynamic_opt turn off/on TRUE TRUE restartable qerpx dynamic optimization _px_dynamic_sample_size num of samples for 50 50 restartable qerpx dynamic optimization _px_granule_size default size of a 100000 100000 rowid range granule (in KB)
_px_index_sampling parallel query 200 200 sampling for index create (100000 = 100%)
_px_kxib_tracing turn on kxib tracing 0 0 _px_load_publish_interval interval at which 200 200 LMON will check whether to publish PX load _px_loc_msg_cost CPU cost to send a 1000 1000 PX message via shared memory _px_max_granules_per_slave maximum number of 100 100 Mon Sep 05 page 52 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- rowid range granules to generate per slave _px_min_granules_per_slave minimum number of 13 13 rowid range granules to generate per slave _px_net_msg_cost CPU cost to send a 10000 10000 PX message over the internconnect _px_no_granule_sort prevent parallel FALSE FALSE partition granules to be sorted on size _px_no_stealing prevent parallel FALSE FALSE granule stealing in shared nothing environment _px_proc_constrain reduce TRUE TRUE parallel_max_servers if greater than (processes - fudge) _px_send_timeout IPC message send 300 300 timeout value in seconds
_px_slaves_share_cursors slaves share cursors 0 0 with QC
_px_trace px trace parameter none none _px_xtgranule_size default size of a 10000 10000 external table granule (in KB) _qa_control Oracle internal 0 0 parameter to control QA _qa_lrg_type Oracle internal 0 0 parameter to specify QA lrg type _query_cost_rewrite perform the cost TRUE TRUE based rewrite with materialized views Mon Sep 05 page 53 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _query_execution_cache_max_size max size of query 65536 65536 execution cache _query_rewrite_1 perform query TRUE TRUE rewrite before&after or only before view merging
_query_rewrite_2 perform query TRUE TRUE rewrite before&after or only after view merging
_query_rewrite_drj mv rewrite and drop TRUE TRUE redundant joins _query_rewrite_expression rewrite with TRUE TRUE cannonical form for expressions _query_rewrite_fpc mv rewrite fresh TRUE TRUE partition containment _query_rewrite_fudge cost based query 90 90 rewrite with MVs fudge factor _query_rewrite_jgmigrate mv rewrite with jg TRUE TRUE migration _query_rewrite_maxdisjunct query rewrite max 257 257 disjuncts _query_rewrite_or_error allow query rewrite, FALSE FALSE if referenced tables are not dataless _query_rewrite_setopgrw_enable perform general TRUE TRUE rewrite using set operator summaries _query_rewrite_vop_cleanup prune frocol chain TRUE TRUE before rewrite after view-merging _rcfg_parallel_cleanup if TRUE enables TRUE TRUE parallel cleanup at reconfiguration Mon Sep 05 page 54 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _rcfg_parallel_fixwrite if TRUE enables TRUE TRUE parallel fixwrite at reconfiguration _rcfg_parallel_replay if TRUE enables TRUE TRUE parallel replay at reconfiguration _rcfg_parallel_verify if TRUE enables TRUE TRUE parallel verify at reconfiguration _real_time_apply_arch_delay Archival delay with 0 0 real time apply _real_time_apply_sim Simulation value 0 0 with real time apply _realfree_heap_max_size minimum max total 32768 32768 heap size, in Kbytes _realfree_heap_mode mode flags for 0 0 real-free heap _realfree_heap_pagesize_hint hint for real-free 65536 65536 page size in bytes _recoverable_recovery_batch_percent Recoverable recovery 50 50 batch size (percentage of buffer cache) _recovery_asserts if TRUE, enable FALSE FALSE expensive recovery sanity checks (DFS) _recovery_percentage recovery buffer 50 50 cache percentage _recursive_imu_transactions recursive FALSE FALSE transactions may be IMU _recyclebin recyclebin TRUE TRUE processing _release_insert_threshold maximum number of 5 5 unusable blocks to unlink from freelist Mon Sep 05 page 55 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _reliable_block_sends if TRUE, block sends FALSE FALSE across interconnect are reliable _remove_aggr_subquery enables removal of TRUE TRUE subsumed aggregated subquery _reuse_index_loop number of blocks 5 5 being examine for index block reuse _right_outer_hash_enable Right TRUE TRUE Outer/Semi/Anti Hash Enabled
_rollback_segment_count number of undo 0 0 segments _rollback_segment_initial starting undo 1 1 segment number _rollback_stopat stop at -position to 0 0 step rollback _row_cache_cursors number of cached 10 10 cursors for row cache management _row_cr enable row cr for FALSE FALSE all sql _row_locking row-locking always always _rowsource_execution_statistics if TRUE, Oracle will FALSE FALSE collect rowsource statistics _rowsource_statistics_sampfreq frequency of 128 128 rowsource statistic sampling (must be a power of 2) _sample_rows_per_block number of rows per 4 4 block used for sampling IO optimization _scn_scheme SCN scheme _second_spare_parameter second spare Mon Sep 05 page 56 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- parameter - integer _selftune_checkpoint_write_pct Percentage of total 3 3 physical i/os for self-tune ckpt _selftune_checkpointing_lag Self-tune 300 300 checkpointing lag the tail of the redo log
_send_ast_to_foreground if TRUE, send ast TRUE TRUE message to foreground _send_close_with_block if TRUE, send close TRUE TRUE with block even with direct sends _send_requests_to_pi if TRUE, try to send TRUE TRUE CR requests to PI buffers (DFS) _serial_direct_read enable direct read FALSE FALSE in serial _serial_recovery force serial FALSE FALSE recovery or parallel recovery _serializable serializable FALSE FALSE _session_idle_bit_latches one latch per 0 0 session or a latch per group of sessions _session_idle_check_interval Resource Manager 60 60 session idle limit check interval in seconds _session_wait_history enable session wait 10 10 history collection _seventh_spare_parameter seventh spare parameter - string list
_shared_pool_max_size shared pool maximum 0 0 size when auto SGA Mon Sep 05 page 57 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- enabled _shared_pool_reserved_min_alloc minimum allocation 4400 4400 size in bytes for reserved area of shared pool _shared_pool_reserved_pct percentage memory of 5 5 the shared pool allocated for the reserved area _shrunk_aggs_disable_threshold percentage of 60 60 exceptions at which to switch to full length aggs _shrunk_aggs_enabled enable use of TRUE TRUE variable sized buffers for non-distinct aggregates _side_channel_batch_size number of messages 200 200 to batch in a side channel message (DFS)
_side_channel_batch_timeout timeout before 5 5 shipping out all the batched side channelmessages _simulator_bucket_mindelta LRU bucket minimum 8192 8192 delta
_simulator_internal_bound simulator internal 10 10 bound percent _simulator_lru_rebalance_sizthr LRU list rebalance 2 2 threshold (size) _simulator_lru_rebalance_thresh LRU list rebalance 10240 10240 threshold (count) _simulator_lru_scan_count LRU scan count 8 8 _simulator_pin_inval_maxcnt maximum count of 16 16 invalid chunks on pin list Mon Sep 05 page 58 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _simulator_reserved_heap_count simulator reserved 4096 4096 heap count _simulator_reserved_obj_count simulator reserved 1024 1024 object count _simulator_sampling_factor sampling factor for 2 2 the simulator _simulator_upper_bound_multiple upper bound multiple 2 2 of pool size _single_process run without detached FALSE FALSE processes _sixth_spare_parameter sixth spare parameter - string list _skip_assume_msg if TRUE, skip assume TRUE TRUE message for consigns at the master _slave_mapping_enabled enable slave mapping TRUE TRUE when TRUE _slave_mapping_group_size force the number of 0 0 slave group in a slave mapper _small_table_threshold threshold level of 1713 1713 table size for direct reads _smm_advice_enabled if TRUE, enable TRUE TRUE v$pga_advice _smm_advice_log_size overwrites default 0 0 size of the PGA advice workarea history log _smm_auto_cost_enabled if TRUE, use the TRUE TRUE AUTO size policy cost functions _smm_auto_max_io_size Maximum IO size (in 248 248 KB) used by sort/hash-join in auto mode Mon Sep 05 page 59 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _smm_auto_min_io_size Minimum IO size (in 56 56 KB) used by sort/hash-join in auto mode _smm_bound overwrites memory 0 0 manager
automatically computed bound _smm_control provides controls on 0 0 the memory manager _smm_freeable_retain value in KB of the 5120 5120 instance freeable PGA memory to retain _smm_max_size maximum work area 52428 52428 size in auto mode (serial) _smm_min_size minimum work area 1024 1024 size in auto mode _smm_px_max_size maximum work area 314571 314571 size in auto mode (global) _smm_retain_size work area retain 0 0 size in SGA for shared server sessions (0 for AUTO)
_smm_trace Turn on/off tracing 0 0 for SQL memory manager _smon_internal_errlimit limit of SMON 100 100 internal errors _smu_debug_mode debug event for testing SMU operations _smu_error_simulation_site site ID of error 0 0 simulation in KTU code
Mon Sep 05 page 60 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _smu_error_simulation_type error type for error 0 0 simulation in KTU code _smu_timeouts comma-separated *AND double-quoted* list of AUM timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl _sort_elimination_cost_ratio cost ratio for sort 0 0 eimination under first_rows mode _sort_multiblock_read_count multi-block read 2 2 count for sort _sort_space_for_write_buffers tenths of 1 1 sort_area_size devoted to direct write buffers _spin_count Amount to spin 2000 2000 waiting for a latch _spr_max_rules maximum number of 10000 10000 rules in sql spreadsheet _spr_push_pred_refspr push predicates TRUE TRUE through reference spreadsheet _spr_use_AW_AS enable AW for hash TRUE TRUE table in spreadsheet _spr_use_hash_table use hash table for FALSE FALSE spreadsheet _sql_connect_capability_override SQL Connect 0 0 Capability Table Override _sql_connect_capability_table SQL Connect Capability Table (testing only) Mon Sep 05 page 61 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _sqlexec_progression_cost sql execution 1000 1000 progression monitoring cost threshold _sqltune_category_parsed Parsed category DEFAULT DEFAULT qualifier for applying hintsets _sta_control SQL Tuning Advisory 0 0 control parameter _stn_trace SQL tracing 0 0 parameter _subquery_pruning_cost_factor subquery pruning 20 20 cost factor _subquery_pruning_enabled enable the use of TRUE TRUE subquery predicates to perform pruning _subquery_pruning_mv_enabled enable the use of FALSE FALSE subquery predicates with MVs to perform pruning
_subquery_pruning_reduction subquery pruning 50 50 reduction factor _swrf_metric_frequent_mode Enable/disable SWRF TRUE TRUE Metric Frequent Mode Collection _swrf_mmon_dbfus Enable/disable SWRF TRUE TRUE MMON DB Feature Usage
_swrf_mmon_flush Enable/disable SWRF TRUE TRUE MMON FLushing _swrf_mmon_metrics Enable/disable SWRF TRUE TRUE MMON Metrics Collection _swrf_on_disk_enabled Parameter to TRUE TRUE enable/disable SWRF _swrf_test_action test action 0 0 parameter for SWRF Mon Sep 05 page 62 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _swrf_test_dbfus Enable/disable DB FALSE FALSE Feature Usage Testing _sysaux_test_param test parameter for 1 1 SYSAUX _system_index_caching optimizer percent 0 0 system index caching _system_trig_enabled are system triggers TRUE TRUE enabled _table_lookup_prefetch_size table lookup 40 40 prefetch vector size _table_lookup_prefetch_thresh table lookup 2 2 prefetch threshold _table_scan_cost_plus_one bump estimated full TRUE TRUE table scan and index ffs cost by one _temp_tran_block_threshold number of blocks for 100 100 a dimension before we temp transform _temp_tran_cache determines if temp TRUE TRUE table is created with cache option _test_ksusigskip test the function 5 5 ksusigskip _test_param_1 test parmeter 1 - 25 25 integer
_test_param_2 test parameter 2 - string
_test_param_3 test parameter 3 - string
_test_param_4 test parameter 4 - string list _test_param_5 test parmeter 5 - 25 25 deprecated integer Mon Sep 05 page 63 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _test_param_6 test parmeter 6 - 0 0 size (ub8) _third_spare_parameter third spare parameter - integer _threshold_alerts_enable if 1, issue 1 1 threshold-based alerts _total_large_extent_memory Total memory for 0 0 allocating large extents
_tq_dump_period time period for 0 0 duping of TQ statistics (s) _trace_archive start DIAG process FALSE FALSE _trace_buffer_flushes trace buffer flushes FALSE FALSE if otrace cacheIO event is set _trace_buffer_gets trace kcb buffer FALSE FALSE gets if otrace cacheIO event is set _trace_buffer_wait_timeouts trace buffer busy 0 0 wait timeouts _trace_buffers trace buffer sizes ALL:256 ALL:256 per process _trace_cr_buffer_creates trace cr buffer FALSE FALSE creates if otrace cacheIO event is set _trace_events trace events enabled at startup _trace_file_size maximum size of 65536 65536 trace file (in bytes)
_trace_files_public Create publicly FALSE FALSE accessible trace files _trace_flush_processes trace data archived ALL ALL by DIAG for these Mon Sep 05 page 64 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- processes _trace_instance_termination trace instance FALSE FALSE termination actions _trace_multi_block_reads trace multi_block FALSE FALSE reads if otrace cacheIO event is set _trace_navigation_scope enabling trace global global navigation linking _trace_options trace data flush text,multiple text,multiple options
_trace_pin_time trace how long a 0 0 current pin is held _trace_processes enable KST tracing ALL ALL in process _transaction_auditing transaction auditing TRUE TRUE records generated in the redo log _transaction_recovery_servers max number of 0 0 parallel recovery slaves that may be used _tts_allow_charset_mismatch allow plugging in a FALSE FALSE tablespace with an incompatible character set _two_pass enable two-pass TRUE TRUE thread recovery _two_pass_reverse_polish_enabled uses two-pass TRUE TRUE reverse polish alg. to generate canonical forms _uga_cga_large_extent_size UGA/CGA large extent 262144 262144 size _ultrafast_latch_statistics maintain fast-path TRUE TRUE statistics for ultrafast latches Mon Sep 05 page 65 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _undo_autotune enable auto tuning TRUE TRUE of undo_retention _undo_debug_usage invoke undo usage 0 0 functions for testing _union_rewrite_for_gs expand queries with YES_GSET_MVS YES_GSET_MVS GSets into UNIONs for rewrite _unnest_subquery enables unnesting of TRUE TRUE correlated subqueries _use_column_stats_for_function enable the use of TRUE TRUE column statistics for DDP functions _use_ism Enable Shared Page TRUE TRUE Tables - ISM _use_ism_for_pga Use ISM for TRUE TRUE allocating large extents _use_new_explain_plan if TRUE, use the FALSE FALSE AUTO size policy cost functions _use_nosegment_indexes use nosegment FALSE FALSE indexes in explain plan _use_realfree_heap use real-free based TRUE TRUE allocator for PGA memory
_use_seq_process_cache whether to use TRUE TRUE process local seq cache _use_vector_post use vector post TRUE TRUE _validate_flashback_database Scan database to FALSE FALSE validate result of flashback database _vendor_lib_loc Vendor library search root directory Mon Sep 05 page 66 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _verify_flashback_redo Verify that the redo TRUE TRUE logs needed for flashback are available _verify_undo_quota TRUE - verify FALSE FALSE consistency of undo quota statistics _wait_for_sync wait for sync on TRUE TRUE commit MUST BE ALWAYS TRUE _walk_insert_threshold maximum number of 0 0 unusable blocks to walk across freelist _watchpoint_on is the watchpointing FALSE FALSE feature turned on? _write_clones write clones flag 3 3 _xsolapi_auto_materialization_bound OLAP API lower bound 20 20 for auto materialization. _xsolapi_auto_materialization_type OLAP API behavior PRED_ONLY PRED_ONLY for auto materialization _xsolapi_cursor_max_rows_to_cache_per OLAP API max rows to 15000 15000 _req cache per request _xsolapi_cursor_max_time_for_partial_ OLAP API cursor max 5000 5000 cache execute time for partial cache _xsolapi_cursor_use_row_cache OLAP API enable TRUE TRUE cursor caching _xsolapi_debug_output OLAP API debug output disposition _xsolapi_densify_cubes OLAP API cube TABULAR TABULAR densification _xsolapi_dimension_group_creation OLAP API symmetric OVERFETCH OVERFETCH overfetch _xsolapi_fetch_type OLAP API fetch type PARTIAL PARTIAL Mon Sep 05 page 67 Undocumented Oracle Parameters TEST Database Parameter Description Session Value Instance Value ------------------------------------- -------------------- ------------- --------------- _xsolapi_load_at_process_start When to load OLAP NEVER NEVER API library at server process start _xsolapi_materialization_rowcache_min OLAP API min number 1 1 _rows_for_use of rows required to use rowcache in query materialization _xsolapi_materialize_sources OLAP API Enable TRUE TRUE source
materialization _xsolapi_sql_all_multi_join_non_base_ OLAP API multi-join hints non-base hints _xsolapi_sql_all_non_base_hints OLAP API non-base hints _xsolapi_sql_auto_dimension_hints OLAP API enable FALSE FALSE automatic dimension hints
_xsolapi_sql_auto_measure_hints OLAP API enable TRUE TRUE automatic measure hints _xsolapi_sql_dimension_hints OLAP API dimension hints _xsolapi_sql_hints OLAP API generic hints _xsolapi_sql_measure_hints OLAP API measure hints _xsolapi_sql_optimize OLAP API enable TRUE TRUE optimization _xsolapi_sql_prepare_stmt_cache_size OLAP API prepare 16 16 statement cache size _xsolapi_sql_remove_columns OLAP API enable TRUE TRUE remove unused columns
optimizations _xsolapi_sql_result_set_cache_size OLAP API result set 32 32 cache size Mon Sep 05 page 68 Undocumented Oracle Parameters TEST Database
------------------------------------- -------------------- ------------- --------------- _xsolapi_sql_symmetric_predicate OLAP API enable TRUE TRUE symmetric predicate for dimension groups _xsolapi_sql_top_dimension_hints OLAP API top dimension hints _xsolapi_sql_top_measure_hints OLAP API top measure hints _xsolapi_sql_use_bind_variables OLAP API enable bind TRUE TRUE variables optimization _xt_coverage external tables code none none coverage parameter _xt_trace external tables none none trace parameter _xtbuffer_size buffer size in KB 0 0 needed for populate/query operation _xtts_allow_pre10 allow cross platform FALSE FALSE for pre10 compatible tablespace _xtts_set_platform_info set cross platform FALSE FALSE info during file header read _yield_check_interval interval to check 100000 100000 whether actses should yield
918 rows selected. Download 3.53 Mb. Share with your friends:
|