by-nc-sa     개발자, DBA가 함께 만들어가는 구루비 지식창고!

Parameters




Hidden Parameters 조회방법

아래의 SQL을 통해 조회가 가능하다.

SELECT A.KSPPINM  NAME,
       B.KSPPSTVL VALUE,
       B.KSPPSTDF DEF_YN,
       A.KSPPDESC DESCRIPTION
FROM   X$KSPPI  A,
       X$KSPPSV B
WHERE  A.INDX = B.INDX
ORDER  BY 1
;

목차(10.2.0.3 기준)

Count Parameters Description
1 O7_DICTIONARY_ACCESSIBILITY Version 7 Dictionary Accessibility Support
2 _4031_dump_bitvec bitvec to specify dumps prior to 4031 error
3 _4031_dump_interval Dump 4031 error once for each n-second interval
4 _4031_max_dumps Maximum number of 4031 dumps for this process
5 _4031_sga_dump_interval Dump 4031 SGA heapdump error once for each n-second interval
6 _4031_sga_max_dumps Maximum number of SGA heapdumps
7 _NUMA_instance_mapping Set of nodes that this instance should run on
8 _NUMA_pool_size aggregate size in bytes of NUMA pool
9 _PX_use_large_pool Use Large Pool as source of PX buffers
10 __db_cache_size Actual size of DEFAULT buffer pool for standard block size buffers
11 __dg_broker_service_names service names for broker use
12 __java_pool_size Actual size in bytes of java pool
13 __large_pool_size Actual size in bytes of large pool
14 __shared_pool_size Actual size in bytes of shared pool
15 __streams_pool_size Actual size in bytes of streams pool
16 _abort_recovery_on_join if TRUE, abort recovery on join reconfigurations
17 _accept_versions List of parameters for rolling operation
18 _active_standby_fast_reconfiguration if TRUE optimize dlm reconfiguration for active/standby OPS
19 _adaptive_direct_read Adaptive Direct Read
20 _adaptive_fetch_enabled enable/disable adaptive fetch in parallel group by
21 _add_stale_mv_to_dependency_list add stale mv to dependency list
22 _addm_auto_enable governs whether ADDM gets run automatically after every AWR snapshot
23 _addm_skiprules comma-separated list of ADDM nodes to skip
24 _addm_version_check governs whether ADDM checks the input AWR snapshot version
25 _adjust_literal_replacement If TRUE, we will adjust the SQL/PLUS output
26 _affinity_on enable/disable affinity at run time
27 _aiowait_timeouts Number of aiowait timeouts before error is reported
28 _alert_expiration seconds before an alert message is moved to exception queue
29 _alert_message_cleanup Enable Alert Message Cleanup
30 _alert_message_purge Enable Alert Message Purge
31 _alert_post_background Enable Background Alert Posting
32 _all_shared_dblinks treat all dblinks as shared
33 _allocate_creation_order should files be examined in creation order during allocation
34 _allocation_update_interval interval at which successful search in L1 should be updated
35 _allow_commutativity allow for commutativity of +, * when comparing expressions
36 _allow_error_simulation Allow error simulation for testing
37 _allow_level_without_connect_by allow level without connect by
38 _allow_read_only_corruption allow read-only open even if database is corrupt
39 _allow_resetlogs_corruption allow resetlogs even if it will cause corruption
40 _allow_terminal_recovery_corruption Finish terminal recovery even if it may cause corruption
41 _alternate_iot_leaf_block_split_points enable alternate index-organized table leaf-block split-points
42 _always_anti_join always use this method for anti-join when possible
43 _always_semi_join always use this method for semi-join when possible
44 _always_star_transformation always favor use of star transformation
45 _app_ctx_vers enable app ctx versioning
46 _aq_tm_scanlimit scan limit for Time Managers to clean up IOT
47 _arch_io_slaves ARCH I/O slaves
48 _array_update_vector_read_enabled Enable array update vector read
49 _ash_disk_filter_ratio Ratio of the number of in-memory samples to the number of samples actually written to disk
50 _ash_disk_write_enable To enable or disable Active Session History flushing
51 _ash_dummy_test_param Oracle internal dummy ASH parameter used ONLY for testing!
52 _ash_eflush_trigger The percentage above which if the in-memory ASH is full the emergency flusher will be triggered
53 _ash_enable To enable or disable Active Session sampling and flushing
54 _ash_sample_all To enable or disable sampling every connected session including ones waiting for idle waits
55 _ash_sampling_interval Time interval between two successive Active Session samples in millisecs
56 _ash_size To set the size of the in-memory Active Session History buffers
57 _asm_acd_chunks initial ACD chunks created
58 _asm_allow_only_raw_disks Discovery only raw devices
59 _asm_allow_resilver_corruption Enable disk resilvering for external redundancy
60 _asm_ausize allocation unit size
61 _asm_blksize metadata block size
62 _asm_disk_repair_time seconds to wait before dropping a failing disk
63 _asm_droptimeout timeout before offlined disks get dropped (in 3s ticks)
64 _asm_emulmax max number of concurrent disks to emulate I/O errors
65 _asm_emultimeout timeout before emulation begins (in 3s ticks)
66 _asm_kfdpevent KFDP event
67 _asm_libraries library search order for discovery
68 _asm_maxio Maximum size of individual I/O request
69 _asm_stripesize ASM file stripe size
70 _asm_stripewidth ASM file stripe width
71 _asm_wait_time Max/imum time to wait before asmb exits
72 _asmlib_test Osmlib test event
73 _asmsid ASM instance id
74 _assm_default ASSM default
75 _async_object_flush if FALSE, disable asychronous object flush
76 _async_recovery_claims if TRUE, issue recovery claims asynchronously
77 _async_recovery_reads if TRUE, issue recovery reads asynchronously
78 _avoid_prepare if TRUE, do not prepare a buffer when the master is local
79 _awr_corrupt_mode AWR Corrupt Mode
80 _awr_disabled_flush_tables Disable flushing of specified AWR tables
81 _awr_flush_threshold_metrics Enable/Disable Flushing AWR Workload Metrics
82 _awr_flush_workload_metrics Enable/Disable Flushing AWR Workload Metrics
83 _awr_mmon_cpuusage Enable/disable AWR MMON CPU Usage Tracking
84 _awr_restrict_mode AWR Restrict Mode
85 _awr_sql_child_limit Setting for AWR SQL Child Limit
86 _b_tree_bitmap_plans enable the use of bitmap plans for tables w. only B-tree indexes
87 _backup_disk_io_slaves BACKUP Disk I/O slaves
88 _backup_io_pool_size memory to reserve from the large pool
89 _backup_kgc_bufsz specifies buffer size to be used for kgc compression
90 _backup_kgc_niters specifies number of iterations used for kgc compression
91 _backup_kgc_type specifies compression type used for kgc compression
92 _backup_ksfq_bufcnt number of the ksfq buffers used for backup/restore
93 _backup_ksfq_bufsz size of the ksfq buffer used for backup/restore
94 _backup_max_gap_size largest gap in an incremental/optimized backup buffer, in bytes
95 _bct_bitmaps_per_file number of bitmaps to store for each datafile
96 _bct_buffer_allocation_max maximum size of all change tracking buffer allocations, in bytes
97 _bct_buffer_allocation_min_extents mininum number of extents to allocate per buffer allocation
98 _bct_buffer_allocation_size size of one change tracking buffer allocation, in bytes
99 _bct_chunk_size change tracking datafile chunk size, in bytes
100 _bct_crash_reserve_size change tracking reserved crash recovery SGA space, in bytes
101 _bct_file_block_size block size of change tracking file, in bytes
102 _bct_file_extent_size extent size of change tracking file, in bytes
103 _bct_fixtab_file change tracking file for fixed tables
104 _bct_initial_private_dba_buffer_size initial number of entries in the private change tracking dba buffers
105 _bct_public_dba_buffer_size total size of all public change tracking dba buffers, in bytes
106 _bitmap_or_improvement_enabled controls extensions to partition pruning for general predicates
107 _block_change_tracking change tracking possible
108 _blocks_per_cache_server number of consecutive blocks per global cache server
109 _bloom_filter_debug debug level for bloom filtering
110 _bloom_filter_enabled enables or disables bloom filter
111 _bt_mmv_query_rewrite_enabled allow rewrites with multiple MVs and base tables
112 _buffer_busy_wait_timeout buffer busy wait time in centiseconds
113 _bufq_flow_control_thrsh flow control threshold value
114 _bufq_max_msg_sz maximum size of the message allowed in memory
115 _bufq_stop_flow_control Stop enforcing flow control for buffered queues
116 _build_deferred_mv_skipping_mvlog_update DEFERRED MV creation skipping MV log setup update
117 _bump_highwater_mark_count how many blocks should we allocate per free list on advancing HWM
118 _bwr_for_flushed_pi if TRUE, generate a BWR for a flushed PI
119 _cache_stats_monitor if TRUE, enable cache stats monitoring
120 _cgs_reconfig_timeout CGS reconfiguration timeout interval
121 _cgs_send_timeout CGS send timeout value
122 _check_block_after_checksum perform block check after checksum if both are turned on
123 _check_ts_threshold check tablespace thresholds
124 _cleanup_rollback_entries no. of undo entries to apply per transaction cleanup
125 _close_cached_open_cursors close cursors cached by PL/SQL at each commit
126 _cluster_library cluster library selection
127 _collapse_wait_history collapse wait history
128 _collect_undo_stats Collect Statistics v$undostat
129 _column_compression_factor Column compression ratio
130 _column_elimination_off turn off predicate-only column elimination
131 _column_tracking_level column usage tracking
132 _compilation_call_heap_extent_size Size of the compilation call heaps extents
133 _complex_view_merging enable complex view merging
134 _controlfile_block_size control file block size in bytes
135 _controlfile_enqueue_dump dump the system states after controlfile enqueue timeout
136 _controlfile_enqueue_timeout control file enqueue timeout in seconds
137 _controlfile_section_init_size control file initial section size
138 _controlfile_section_max_expand control file max expansion rate
139 _controlfile_update_check controlfile update sanity check
140 _convert_set_to_join enables conversion of set operator to join
141 _coord_message_buffer parallel recovery coordinator side extra message buffer size
142 _corrupted_rollback_segments corrupted undo segment list
143 _cost_equality_semi_join enables costing of equality semi-join
144 _cpu_to_io divisor for converting CPU cost to I/O cost
145 _cr_grant_global_role if TRUE, grant lock for CR requests when block is in global role
146 _cr_grant_local_role turn 3-way CR grants off, make it automatic, or turn it on
147 _cr_server_log_flush if TRUE, flush redo log before serving a CR buffer
148 _ctas_hwm_brokered_loads Enable HWM brokered CTAS
149 _cursor_bind_capture_area_size maximum size of the cursor bind capture area
150 _cursor_bind_capture_interval interval (in seconds) between two bind capture for a cursor
151 _cursor_cache_frame_bind_memory frame & bind buffer caching
152 _cursor_db_buffers_pinned additional number of buffers a cursor can pin at once
153 _cursor_features_enabled Shared cursor features enabled bits.
154 _cursor_plan_enabled enable collection and display of cursor plans
155 _cursor_plan_hash_version version of cursor plan hash value
156 _cursor_plan_unparse_enabled enables/disables using unparse to build projection/predicates
157 _cursor_stats_bucket Hash table buckets for cursor stats (2^).
158 _cursor_stats_heap Heaps/latches for cursor stats.
159 _db_aging_cool_count Touch count set when buffer cooled
160 _db_aging_freeze_cr Make CR buffers always be too cold to keep in cache
161 _db_aging_hot_criteria Touch count which sends a buffer to head of replacement list
162 _db_aging_stay_count Touch count set when buffer moved to head of replacement list
163 _db_aging_touch_time Touch count which sends a buffer to head of replacement list
164 _db_always_check_system_ts Always perform block check and checksum for System tablespace
165 _db_block_adjcheck adjacent cache buffer checks - low blkchk overwrite parameter
166 _db_block_adjchk_level adjacent cache buffer check level
167 _db_block_align_direct_read Align Direct Reads
168 _db_block_buffers Number of database blocks cached in memory: hidden parameter
169 _db_block_cache_clone Always clone data blocks on get (for debugging)
170 _db_block_cache_history buffer header tracing (non-zero only when debugging)
171 _db_block_cache_history_level buffer header tracing level
172 _db_block_cache_num_umap number of unmapped buffers (for tracking swap calls on blocks)
173 _db_block_cache_protect protect database blocks (true only when debugging)
174 _db_block_cache_protect_internal protect database blocks (for strictly internal use only)
175 _db_block_check_for_debug Check more and dump block before image for debugging
176 _db_block_check_objtyp check objd and typ on cache disk read
177 _db_block_do_full_mbreads do full block read even if some blocks are in cache
178 _db_block_hash_buckets Number of database block hash buckets
179 _db_block_hash_latches Number of database block hash latches
180 _db_block_hi_priority_batch_size Fraction of writes for high priority reasons
181 _db_block_known_clean_pct Initial Percentage of buffers to maintain known clean
182 _db_block_lru_latches number of lru latches
183 _db_block_max_cr_dba Maximum Allowed Number of CR buffers per dba
184 _db_block_max_scan_pct Percentage of buffers to inspect when looking for free
185 _db_block_med_priority_batch_size Fraction of writes for medium priority reasons
186 _db_block_numa Number of NUMA nodes
187 _db_block_prefetch_limit Prefetch limit in blocks
188 _db_block_prefetch_quota Prefetch quota as a percent of cache size
189 _db_block_table_scan_buffer_size Size of shared table scan read buffer
190 _db_block_temp_redo generate redo for temp blocks
191 _db_block_trace_protect trace buffer protect calls
192 _db_blocks_per_hash_latch Number of blocks per hash latch
193 _db_cache_advice_batch_size cache advisory simulation batch size
194 _db_cache_advice_sample_factor cache advisory sampling factor
195 _db_cache_crx_check check for costly crx examination functions
196 _db_cache_pre_warm Buffer Cache Pre-Warm Enabled : hidden parameter
197 _db_cache_process_cr_pin_max maximum number of cr pins a process may have
198 _db_change_notification_enable enable db change notification
199 _db_fast_obj_check enable fast object drop sanity check
200 _db_fast_obj_ckpt enable fast object checkpoint
201 _db_fast_obj_truncate enable fast object truncate
202 _db_file_direct_io_count Sequential I/O buf size
203 _db_file_exec_read_count multiblock read count for regular clients
204 _db_file_format_io_buffers Block formatting I/O buf count
205 _db_file_noncontig_mblock_read_count number of noncontiguous db blocks to be prefetched
206 _db_file_optimizer_read_count multiblock read count for regular clients
207 _db_handles System-wide simultaneous buffer operations
208 _db_handles_cached Buffer handles cached each process
209 _db_hot_block_tracking track hot blocks for hash latch contention
210 _db_index_block_checking index block checking override parameter
211 _db_large_dirty_queue Number of buffers which force dirty queue to be written
212 _db_lost_write_checking Enable scn based lost write detection mechanism
213 _db_mttr_advice MTTR advisory
214 _db_mttr_partitions number of partitions for MTTR advisory
215 _db_mttr_sample_factor MTTR simulation sampling factor
216 _db_mttr_sim_target MTTR simulation targets
217 _db_mttr_sim_trace_size MTTR simulation trace size
218 _db_mttr_trace_to_alert dump trace entries to alert file
219 _db_obj_ckpt_ordered fast object checkpoint ordered by lrba
220 _db_obj_enable_ksr enable ksr in object checkpoint/reuse
221 _db_percent_hot_default Percent of default buffer pool considered hot
222 _db_percent_hot_keep Percent of keep buffer pool considered hot
223 _db_percent_hot_recycle Percent of recycle buffer pool considered hot
224 _db_percpu_create_cachesize size of cache created per cpu in deferred cache create
225 _db_recovery_temporal_file_dest default database recovery temporal file location
226 _db_row_overlap_checking row overlap checking override parameter for data/index blocks
227 _db_todefer_cache_create buffer cache deferred create
228 _db_writer_chunk_writes Number of writes DBWR should wait for
229 _db_writer_coalesce_area_size Size of memory allocated to dbwriter for coalescing writes
230 _db_writer_coalesce_write_limit Limit on size of coalesced write
231 _db_writer_flush_imu If FALSE, DBWR will not downgrade IMU txns for AGING
232 _db_writer_histogram_statistics maintain dbwr histogram statistics in x$kcbbhs
233 _db_writer_max_writes Max number of outstanding DB Writer IOs
234 _db_writer_verify_writes Enable lost write detection mechanism
235 _dbg_proc_startup debug process startup
236 _dbwr_async_io Enable dbwriter asynchronous writes
237 _dbwr_scan_interval dbwriter scan interval
238 _dbwr_tracing Enable dbwriter tracing
239 _dead_process_scan_interval PMON dead process scan interval
240 _dedicated_server_poll_count dedicated server poll count
241 _dedicated_server_post_wait dedicated server post/wait
242 _dedicated_server_post_wait_call dedicated server post/wait call
243 _default_encrypt_alg default encryption algorithm
244 _default_non_equality_sel_check sanity check on default selectivity for like/range predicate
245 _delay_index_maintain delays index maintenance until after MV is refreshed
246 _diag_daemon start DIAG daemon
247 _diag_diagnostics Turn off diag diagnostics
248 _diag_dump_timeout timeout parameter for SYNC dump
249 _dimension_skip_null control dimension skip when null feature
250 _disable_adaptive_shrunk_aggregation adaptive shrunk aggregation
251 _disable_datalayer_sampling disable datalayer sampling
252 _disable_duplex_link Turn off connection duplexing
253 _disable_fast_aggregation fast aggregation
254 _disable_file_locks disable file locks for control, data, redo log files
255 _disable_function_based_index disable function-based index matching
256 _disable_health_check Disable Health Check
257 _disable_image_check Disable Oracle executable image checking
258 _disable_incremental_checkpoints Disable incremental checkpoints for thread recovery
259 _disable_incremental_recovery_ckpt Disable incremental recovery checkpoint mechanism
260 _disable_instance_params_check disable instance type check for ksp
261 _disable_interface_checking disable interface checking at startup
262 _disable_kcbhxor_osd disable kcbh(c)xor OSD functionality
263 _disable_latch_free_SCN_writes_via_32cas disable latch-free SCN writes using 32-bit compare & swap
264 _disable_latch_free_SCN_writes_via_64cas disable latch-free SCN writes using 64-bit compare & swap
265 _disable_logging Disable logging
266 _disable_multiple_block_sizes disable multiple block size support (for debugging)
267 _disable_odm disable odm feature
268 _disable_recoverable_recovery Disable the new recoverable recovery mechanism
269 _disable_recovery_read_skip Disable the read optimization during media recovery
270 _disable_sample_io_optim disable row sampling IO optimization
271 _disable_savepoint_reset disable the fix for bug 1402161
272 _disable_selftune_checkpointing Disable self-tune checkpointing
273 _disable_streams_pool_auto_tuning disable streams pool auto tuning
274 _disable_sun_rsm Disable IPC OSD support for Sun RSMAPI
275 _disable_system_state disable system state dump
276 _disable_txn_alert disable txn layer alert
277 _discrete_transactions_enabled enable OLTP mode
278 _dispatcher_rate_scale scale to display rate statistic (100ths of a second)
279 _dispatcher_rate_ttl time-to-live for rate statistic (100ths of a second)
280 _distinct_view_unnesting enables unnesting of in subquery into distinct view
281 _distributed_recovery_connection_hold_time number of seconds RECO holds outbound connections open
282 _dlm_send_timeout DLM send timeout value
283 _dlmtrace Trace string of global enqueue type(s)
284 _dm_max_shared_pool_pct max percentage of the shared pool to use for a mining model
285 _dml_monitoring_enabled enable modification monitoring
286 _domain_index_batch_size maximum number of rows from one call to domain index fetch routine
287 _domain_index_dml_batch_size maximum number of rows for one call to domain index dml routines
288 _drop_table_granule drop_table_granule
289 _drop_table_optimization_enabled reduce SGA memory use during drop of a partitioned table
290 _ds_iocount_iosize Dynamic Sampling Service defaults: #IOs and IO Size
291 _dss_cache_flush enable full cache flush for parallel execution
292 _dtree_area_size size of Decision Tree Classification work area
293 _dtree_binning_enabled Decision Tree Binning Enabled
294 _dtree_bintest_id Decision Tree Binning Test ID
295 _dtree_compressbmp_enabled Decision Tree Using Compressed Bitmaps Enabled
296 _dtree_max_surrogates maximum number of surrogates
297 _dtree_pruning_enabled Decision Tree Pruning Enabled
298 _dummy_instance dummy instance started by RMAN
299 _dump_common_subexpressions dump common subexpressions
300 _dump_connect_by_loop_data dump connect by loop error message into trc file
301 _dump_cursor_heap_sizes dump comp/exec heap sizes to tryace file
302 _dump_interval_limit trace dump time interval limit (in seconds)
303 _dump_max_limit max number of dump within dump interval
304 _dump_qbc_tree dump top level query parse tree to trace
305 _dump_rcvr_ipc if TRUE enables IPC dump at instance eviction time
306 _dump_system_state_scope scope of sysstate dump during instance termination
307 _dump_trace_scope scope of trace dump during a process crash
308 _dynamic_rls_policies rls policies are dynamic
309 _dynamic_stats_threshold delay threshold (in seconds) between sending statistics messages
310 _eliminate_common_subexpr enables elimination of common sub-expressions
311 _enable_NUMA_optimization Enable NUMA specific optimizations
312 _enable_block_level_transaction_recovery enable block level recovery
313 _enable_cscn_caching enable commit SCN caching for all transactions
314 _enable_default_affinity to enable default implementation of affinity osds
315 _enable_dml_lock_escalation enable dml lock escalation against partitioned tables if TRUE
316 _enable_exchange_validation_using_check use check constraints on the table for validation
317 _enable_fast_ref_after_mv_tbs enable fast refresh after move tablespace
318 _enable_hash_overflow TRUE - enable hash cluster overflow based on SIZE
319 _enable_hwm_sync enable HWM synchronization
320 _enable_list_io Enable List I/O
321 _enable_nativenet_tcpip Enable skgxp driver usage for native net
322 _enable_refresh_schedule enable or disable MV refresh scheduling (revert to 9.2 behavior)
323 _enable_rlb enable RLB metrics processing
324 _enable_row_shipping use the row shipping optimization for wide table selects
325 _enable_shared_pool_durations temporary to disable/enable kgh policy
326 _enable_tablespace_alerts enable tablespace alerts
327 _enable_type_dep_selectivity enable type dependent selectivity estimates
328 _enqueue_deadlock_time_sec requests with timeout <= this will not have deadlock detection
329 _enqueue_debug_multi_instance debug enqueue multi instance
330 _enqueue_hash enqueue hash table length
331 _enqueue_hash_chain_latches enqueue hash chain latches
332 _enqueue_locks locks for managed enqueues
333 _enqueue_resources resources for enqueues
334 _expand_aggregates expand aggregates
335 _explain_rewrite_mode allow additional messages to be generated during explain rewrite
336 _extended_pruning_enabled do runtime pruning in iterator if set to TRUE
337 _fair_remote_cvt if TRUE enables fair remote convert
338 _fairness_threshold number of times to CR serve before downgrading lock
339 _fast_dual_enabled enable/disable fast dual
340 _fast_full_scan_enabled enable/disable index fast full scan
341 _fast_start_instance_recovery_target instance recovery target time in RAC environment
342 _fic_algorithm_set Set Frequent Itemset Counting Algorithm
343 _fic_area_size size of Frequent Itemset Counting work area
344 _fic_max_length Frequent Itemset Counting Maximum Itemset Length
345 _fic_min_bmsize Frequent Itemset Counting Minimum BITMAP Size
346 _fic_outofmem_candidates Frequent Itemset Counting Out Of Memory Candidates Generation
347 _fifth_spare_parameter fifth spare parameter - string
348 _filemap_dir FILEMAP directory
349 _first_k_rows_dynamic_proration enable the use of dynamic proration of join cardinalities
350 _first_spare_parameter Maximum number of CR rollbacks per block (LMS)
351 _fix_control bug fix control parameter
352 _flashback_allow_noarchivelog Allow enabling flashback on noarchivelog database
353 _flashback_barrier_interval Flashback barrier interval in seconds
354 _flashback_copy_latches Number of flashback copy latches
355 _flashback_fuzzy_barrier Use flashback fuzzy barrier
356 _flashback_generation_buffer_size flashback generation buffer size
357 _flashback_hint_barrier_percent Flashback hint barrier percent
358 _flashback_log_io_error_behavior Specify Flashback log I/O error behavior
359 _flashback_log_min_size Minimum flashback log size
360 _flashback_log_size Flashback log size
361 _flashback_logfile_enqueue_timeout flashback logfile enqueue timeout for opens
362 _flashback_max_log_size Maximum flashback log size in bytes (OS limit)
363 _flashback_max_n_log_per_thread Maximum number of flashback logs per flashback thread
364 _flashback_n_log_per_thread Desired number of flashback logs per flashback thread
365 _flashback_standby_barrier_interval Flashback standby barrier interval in seconds
366 _flashback_verbose_info Print verbose information about flashback database
367 _flashback_write_size_qm Desired flashback write size in quarter MB
368 _force_datefold_trunc force use of trunc for datefolding rewrite
369 _force_rewrite_enable control new query rewrite features
370 _force_temptables_for_gsets executes concatenation of rollups using temp tables
371 _fourth_spare_parameter fourth spare parameter - string
372 _full_pwise_join_enabled enable full partition-wise join when TRUE
373 _gby_hash_aggregation_enabled enable group-by and aggregation using hash scheme
374 _gby_onekey_enabled enable use of one comparison of all group by keys
375 _gc_affinity_limit dynamic affinity limit
376 _gc_affinity_minimum dynamic affinity minimum activity per minute
377 _gc_affinity_time if non zero, enable dynamic object affinity
378 _gc_async_memcpy if TRUE, use async memcpy
379 _gc_check_bscn if TRUE, check for stale blocks
380 _gc_coalesce_recovery_reads if TRUE, coalesce recovery reads
381 _gc_defer_time how long to defer down converts for hot buffers
382 _gc_dissolve_undo_affinity if TRUE, dissolve undo affinity after an offline
383 _gc_dynamic_affinity_locks if TRUE, get dynamic affinity locks
384 _gc_element_percent global cache element percent
385 _gc_global_lru turn global lru off, make it automatic, or turn it on
386 _gc_initiate_undo_affinity if TRUE, initiate undo affinity after an online
387 _gc_integrity_checks set the integrity check level
388 _gc_keep_recovery_buffers if TRUE, make recovery buffers current
389 _gc_latches number of latches per LMS process
390 _gc_maximum_bids maximum number of bids which can be prepared
391 _gc_statistics if TRUE, kcl statistics are maintained
392 _gc_undo_affinity if TRUE, enable dynamic undo affinity
393 _gc_undo_affinity_locks if TRUE, get affinity locks for undo
394 _gc_use_cr if TRUE, allow CR pins on PI and WRITING buffers
395 _gc_vector_read if TRUE, vector read current buffers
396 _gcs_fast_reconfig if TRUE, enable fast reconfiguration for gcs locks
397 _gcs_latches number of gcs resource hash latches to be allocated per LMS process
398 _gcs_process_in_recovery if TRUE, process gcs requests during instance recovery
399 _gcs_resources number of gcs resources to be allocated
400 _gcs_shadow_locks number of pcm shadow locks to be allocated
401 _gcs_testing GCS testing parameter
402 _generalized_pruning_enabled controls extensions to partition pruning for general predicates
403 _ges_dd_debug if 1 or higher enables GES deadlock detection debug diagnostics
404 _ges_diagnostics if TRUE enables GES diagnostics
405 _ges_health_check if greater than 0 enables GES system health check
406 _globalindex_pnum_filter_enabled enables filter for global index with partition extended syntax
407 _groupby_nopushdown_cut_ratio groupby nopushdown cut ratio
408 _groupby_orderby_combine groupby/orderby don't combine threshold
409 _gs_anti_semi_join_allowed enable anti/semi join for the GS query
410 _hang_analysis_num_call_stacks hang analysis num call stacks
411 _hang_detection Hang Management detection interval
412 _hard_protection if TRUE enable H.A.R.D specific format changes
413 _hash_join_enabled enable/disable hash join
414 _hash_multiblock_io_count number of blocks hash join will read/write at once
415 _high_priority_processes High Priority Process Name Mask
416 _high_server_threshold high server thresholds
417 _hj_bit_filter_threshold hash-join bit filtering threshold (0 always enabled)
418 _hwm_sync_threshold HWM synchronization threshold in percentage
419 _idl_conventional_index_maintenance enable conventional index maintenance for insert direct load
420 _idxrb_rowincr proportionality constant for dop vs. rows in index rebuild
421 _ignore_desc_in_index ignore DESC in indexes, sort those columns ascending anyhow
422 _immediate_commit_propagation if TRUE, propagate commit SCN immediately
423 _improved_outerjoin_card improved outer-join cardinality calculation
424 _improved_row_length_enabled enable the improvements for computing the average row length
425 _imr_active Activate Instance Membership Recovery feature
426 _imr_disk_voting_interval Maximum wait for IMR disk voting (seconds)
427 _imr_max_reconfig_delay Maximum Reconfiguration delay (seconds)
428 _imr_splitbrain_res_wait Maximum wait for split-brain resolution (seconds)
429 _imr_systemload_check Perform the system load check during IMR
430 _imu_pools in memory undo pools
431 _in_memory_undo Make in memory undo for top level transactions
432 _incremental_recovery_ckpt_min_batch Minimum number of writes for incremental recovery ckpt every 3 sec
433 _index_join_enabled enable the use of index joins
434 _index_prefetch_factor index prefetching factor
435 _init_granule_interval number of granules to process for deferred cache
436 _init_sql_file File containing SQL statements to execute upon database creation
437 _inject_startup_fault inject fault in the startup code
438 _inline_sql_in_plsql inline SQL in PL/SQL
439 _insert_enable_hwm_brokered during parallel inserts high water marks are brokered
440 _inst_locking_period period an instance can retain a newly acquired level1 bitmap
441 _interconnect_checksum if TRUE, checksum interconnect blocks
442 _intrapart_pdml_enabled Enable intra-partition updates/deletes
443 _intrapart_pdml_randomlocal_enabled Enable intra-partition updates/deletes with random local dist
444 _io_shared_pool_size Size of I/O buffer pool from SGA
445 _io_slaves_disabled Do not use I/O slaves
446 _ior_serialize_fault inject fault in the ior serialize code
447 _ioslave_batch_count Per attempt IOs picked
448 _ioslave_issue_count IOs issued before completion check
449 _ipc_fail_network Simulate cluster network failer
450 _ipc_test_failover Test transparent cluster network failover
451 _ipc_test_mult_nets simulate multiple cluster networks
452 _job_queue_interval Wakeup interval in seconds for job queue co-ordinator
453 _kcl_commit if TRUE, call kjbcommit
454 _kcl_conservative_log_flush if TRUE, conservatively log flush before CR serving
455 _kcl_debug if TRUE, record le history
456 _kcl_index_split if TRUE, reject pings on blocks in middle of a split
457 _kcl_undo_grouping grouping for undo block locks
458 _kcl_undo_locks number of locks per undo segment
459 _kdbl_enable_post_allocation allocate dbas after populating data buffers
460 _keep_remote_column_size remote column size does not get modified
461 _kernel_message_network_driver kernel message network driver
462 _kffmap_hash_size size of kffmap_hash table
463 _kffmop_hash_size size of kffmop_hash table
464 _kghdsidx_count max kghdsidx count
465 _kgl_bucket_count index to the bucket count array
466 _kgl_fixed_extents fixed extent size for library cache memory allocations
467 _kgl_hash_collision whether KGL hash collision is possible
468 _kgl_heap_size extent size for library cache heap 0
469 _kgl_keep_cache_pct KGL keep cache minimum threshold
470 _kgl_keep_cache_retain_pct KGL keep cache retain threshold
471 _kgl_large_heap_warning_threshold maximum heap size before KGL writes warnings to the alert log
472 _kgl_latch_count number of library cache latches
473 _kgl_multi_instance_invalidation whether KGL to support multi-instance invalidations
474 _kgl_multi_instance_lock whether KGL to support multi-instance locks
475 _kgl_multi_instance_pin whether KGL to support multi-instance pins
476 _kgl_session_cached_objects maximum length of the KGL object cache lru
477 _kgl_time_to_wait_for_locks time to wait for locks and pins before timing out
478 _kglsim_maxmem_percent max percentage of shared pool size to be used for KGL advice
479 _kgx_latches
  1. of mutex latches if CAS is not supported.
480 _kill_controlfile_enqueue_blocker enable killing controlfile enqueue blocker on timeout
481 _kill_enqueue_blocker if greater than 0 enables killing enqueue blocker
482 _kill_java_threads_on_eoc Kill Java threads and do sessionspace migration at end of call
483 _kkfi_trace trace expression substitution
484 _kks_free_cursor_stat_pct percentage of cursor stats buckets to scan on each load, in 1/10th of a percent
485 _kks_use_mutex_pin Turning on this will make KKS use mutex for cursor pins.
486 _kolfuseslf allow kolf to use slffopen
487 _kql_subheap_trace tracing level for library cache subheap level pins
488 _ksb_disable_diagpid disable the call to ksb_diagpid
489 _ksd_test_param KSD test parmeter
490 _ksdxdocmd_default_timeout_ms default timeout for internal oradebug commands
491 _ksdxw_cini_flg ksdxw context initialization flag
492 _ksdxw_nbufs ksdxw number of buffers in buffered mode
493 _ksdxw_num_pgw number of watchpoints on a per-process basis
494 _ksdxw_num_sgw number of watchpoints to be shared by all processes
495 _ksdxw_stack_depth number of PCs to collect in the stack when watchpoint is hit
496 _kse_die_timeout amount of time a dying process is spared by PMON (in centi-secs)
497 _kse_pc_table_size kse pc table cache size
498 _ksfd_verify_write verify asynchronous writes issued through ksfd
499 _ksi_trace KSI trace string of lock type(s)
500 _ksmg_granule_locking_status granule locking status
501 _ksmg_granule_size granule size in bytes
502 _ksmg_lock_check_interval timeout action interval in minutes
503 _ksmg_lock_reacquire_count repeat count for acquisition of locks
504 _ksu_diag_kill_time number of seconds ksuitm waits before killing diag
505 _ksuitm_dont_kill_dumper delay inst. termination to allow processes to dump
506 _ksxp_diagmode set to OFF to disable automatic slowsend diagnostics
507 _ksxp_reporting_process reporting process for KSXP
508 _ksxp_send_timeout set timeout for sends queued with the inter-instance IPC
509 _ktc_debug for ktc debug
510 _ktc_latches number of ktc latches
511 _ktu_latches number of KTU latches
512 _ku_trace datapump trace parameter
513 _large_pool_min_alloc minimum allocation size in bytes for the large allocation pool
514 _last_allocation_period period over which an instance can retain an active level1 bitmap
515 _latch_class_0 latch class 0
516 _latch_class_1 latch class 1
517 _latch_class_2 latch class 2
518 _latch_class_3 latch class 3
519 _latch_class_4 latch class 4
520 _latch_class_5 latch class 5
521 _latch_class_6 latch class 6
522 _latch_class_7 latch class 7
523 _latch_classes latch classes override
524 _latch_miss_stat_sid Sid of process for which to collect latch stats
525 _latch_recovery_alignment align latch recovery structures
526 _ldr_io_size size of write IOs used during a load operation
527 _left_nested_loops_random enable random distribution method for left of nestedloops
528 _lgwr_async_broadcasts LGWR Asynchronous Broadcasts enabling boolean flag
529 _lgwr_async_io LGWR Asynchronous IO enabling boolean flag
530 _lgwr_delay_write LGWR write delay for debugging
531 _lgwr_io_slaves LGWR I/O slaves
532 _lgwr_max_ns_wt Maximum wait time for lgwr to allow NetServer to progress
533 _lgwr_ns_nl_max Variable to simulate network latency or buffer threshold
534 _lgwr_ns_nl_min Variable to simulate network latency or buffer threshold
535 _lgwr_ns_sim_err Variable to simulate errors lgwrns
536 _lgwr_ta_sim_err Variable to simulate errors lgwr true async
537 _library_cache_advice whether KGL advice should be turned on
538 _lightweight_hdrs Lightweight headers for redo
539 _like_with_bind_as_equality treat LIKE predicate with bind as an equality predicate
540 _lm_activate_lms_threshold threshold value to activate an additional lms
541 _lm_cache_lvl0_cleanup how often to cleanup level 0 cache res (in sec)
542 _lm_cache_res_cleanup percentage of cached resources should be cleanup
543 _lm_cache_res_type cache resource: string of lock types(s)
544 _lm_checksum_batch_msg GES checksum batch messages
545 _lm_contiguous_res_count number of contiguous blocks that will hash to the same HV bucket
546 _lm_dd_interval dd time interval in seconds
547 _lm_dd_scan_interval dd scan interval in seconds
548 _lm_drm_max_requests dynamic remastering maximum affinity requests processed together
549 _lm_drm_window dynamic remastering bucket window size
550 _lm_drm_xlatch dynamic remastering forced exclusive latches
551 _lm_dynamic_lms dynamic lms invocation
552 _lm_dynamic_load dynamic load adjustment
553 _lm_dynamic_remastering if TRUE enables dynamic remastering
554 _lm_enq_lock_freelist Number of ges enqueue element freelist
555 _lm_enq_rcfg if TRUE enables enqueue reconfiguration
556 _lm_enqueue_freelist Number of enqueue freelist
557 _lm_file_affinity mapping between file id and master instance number
558 _lm_global_posts if TRUE deliver global posts to remote nodes
559 _lm_lmd_waittime default wait time for lmd in centiseconds
560 _lm_lms number of background gcs server processes to start
561 _lm_lms_waittime default wait time for lms in centiseconds
562 _lm_locks number of enqueues configured for cluster database
563 _lm_master_weight master resource weight for this instance
564 _lm_max_lms max. number of background global cache server processes
565 _lm_min_lms min. number of background global cache server processes
566 _lm_msg_batch_size GES batch message size
567 _lm_msg_cache_thresholds GES message buffer caching threshold
568 _lm_msg_cleanup_interval GES message buffer cleanup interval time
569 _lm_node_join_opt cluster database node join optimization in reconfig
570 _lm_non_fault_tolerant disable cluster database fault-tolerance mode
571 _lm_num_pcmhv_latches number of latches covering the PCM HV buckets in cgs
572 _lm_num_pt_buckets number of buckets in the object affinity hash table
573 _lm_num_pt_latches number of latches in the object affinity hash table
574 _lm_proc_freeze_timeout reconfiguration: process freeze timeout
575 _lm_process_batching GES implicit process batching for IPC messages
576 _lm_procs number of client processes configured for cluster database
577 _lm_rcfg_timeout Reconfiguration timeout
578 _lm_rcv_buffer_size the size of receive buffer
579 _lm_res_hash_bucket number of resource hash buckets
580 _lm_res_part number of resource partition configured for gcs
581 _lm_ress number of resources configured for cluster database
582 _lm_send_buffers number of cluster database send buffers
583 _lm_send_mode GES send mode
584 _lm_send_queue_batching GES send queue message batching
585 _lm_send_queue_length GES send queue maximum length
586 _lm_sendproxy_reserve GES percentage of send proxy reserve of send tickets
587 _lm_share_lock_opt if TRUE enables share lock optimization
588 _lm_sq_batch_factor GES send queue minimum batching factor
589 _lm_sq_batch_type GES send queue batching mechanism
590 _lm_sq_batch_waittick GES send queue batching waittime in tick
591 _lm_sync_timeout Synchronization timeout for DLM reconfiguration steps
592 _lm_ticket_active_sendback Flow control ticket active sendback threshold
593 _lm_tickets GES messaging tickets
594 _lm_tx_delta TX lock localization delta
595 _lm_validate_resource_type if TRUE enables resource name validation
596 _lm_xids number of transaction IDs configured for cluster database
597 _load_without_compile Load PL/SQL or Database objects without compilation
598 _local_communication_costing_enabled enable local communication costing when TRUE
599 _local_communication_ratio set the ratio between global and local communication (0..100)
600 _lock_sga_areas Lock specified areas of the SGA in physical memory
601 _log_archive_avoid_memcpy log archive avoid memcpy
602 _log_archive_buffer_size Size of each archival buffer in log file blocks
603 _log_archive_buffers Number of buffers to allocate for archiving
604 _log_archive_callout archival callout
605 _log_archive_compress_enable Bypass database rules for enabling archivelog compression
606 _log_archive_delta_sync_wait iterative sleep time in centiseconds seconds when SYNC=PARALLEL
607 _log_archive_net_timeout maximum network wait time in seconds when SYNC=PARALLEL
608 _log_archive_network_redo_size Log archive network redo buffer size used by ARCH
609 _log_archive_prot_auto_demote log archive protection auto demotion
610 _log_archive_security_enabled log archive security enabled
611 _log_blocks_during_backup log block images when changed during backup
612 _log_buffers_corrupt corrupt redo buffers before write
613 _log_buffers_debug debug redo buffers (slows things down)
614 _log_checkpoint_recovery_check
  1. redo blocks to verify after checkpoint
615 _log_committime_block_cleanout Log commit-time block cleanout
616 _log_debug_multi_instance debug redo multi instance code
617 _log_deletion_policy archivelog deletion policy for mandatory/all destination
618 _log_event_queues number of the log writer event queues
619 _log_io_size automatically initiate log write if this many redo blocks in buffer
620 _log_parallelism Number of log buffer strands
621 _log_parallelism_dynamic Enable dynamic strands
622 _log_parallelism_max Maximum number of log buffer strands
623 _log_private_mul Private strand multiplier for log space preallocation
624 _log_private_parallelism Number of private log buffer strands for zero-copy redo
625 _log_private_parallelism_mul Active sessions multiplier to deduce number of private strands
626 _log_simultaneous_copies number of simultaneous copies into redo buffer(# of copy latches)
627 _log_space_errors should we report space errors to alert log
628 _log_switch_timeout Maximum number of seconds redos in the current log could span
629 _logout_storm_rate number of processes that can logout in a second
630 _logout_storm_retrycnt maximum retry count for logouts
631 _logout_storm_timeout timeout in centi-seconds for time to wait between retries
632 _longops_enabled longops stats enabled
633 _low_server_threshold low server thresholds
634 _master_direct_sends direct sends for messages from master (DFS)
635 _mav_refresh_consistent_read refresh materialized views using consistent read snapshot
636 _mav_refresh_double_count_prevented materialized view MAV refreshes avoid double counting
637 _mav_refresh_opt optimizations during refresh of materialized views
638 _mav_refresh_unionall_tables
  1. tables for union all expansion during materialized view refresh
639 _max_arch_lns_wait Maximum wait by ARCH to allow NetServer to complete archival
640 _max_exponential_sleep max sleep during exponential backoff
641 _max_lns_shutdown_archival_time Maximum time spent by LNS to archive last log during shutdown
642 _max_protocol_support Max occurrence protocols supported in a process
643 _max_rfs_connections maximum number of connections used for remote archival
644 _max_shrink_obj_stats number of segments for which shrink stats will be maintained
645 _max_sleep_holding_latch max time to sleep while holding a latch
646 _media_recovery_read_batch media recovery block read batch
647 _media_recovery_reap_time media recovery reap time
648 _mem_annotation_pr_lev private memory annotation collection level
649 _mem_annotation_scale memory annotation pre-allocation scaling
650 _mem_annotation_sh_lev shared memory annotation collection level
651 _mem_annotation_store memory annotation in-memory store
652 _mem_std_extent_size standard extent size for fixed-size-extent heaps
653 _memory_broker_log_stat_entries memory broker num stat entries
654 _memory_broker_marginal_utility_bc Marginal Utility threshold pct for bc
655 _memory_broker_marginal_utility_sp Marginal Utility threshold pct for sp
656 _memory_broker_shrink_heaps memory broker allow policy to shrink shared pool
657 _memory_broker_shrink_java_heaps memory broker allow policy to shrink java pool
658 _memory_broker_shrink_streams_pool memory broker allow policy to shrink streams pool
659 _memory_broker_shrink_timeout memory broker policy to timeout shrink shared/java pool
660 _memory_broker_stat_interval memory broker statistics gathering interval
661 _memory_management_tracing trace memory management activity
662 _memory_sanity_check partial granule sanity check
663 _messages message queue resources - dependent on # processes & # buffers
664 _minfree_plus max percentage of block space + minfree before we mark block full
665 _minimal_stats_aggregation prohibit stats aggregation at compile/partition maintenance time
666 _minimum_blocks_to_shrink minimum number freeable blocks for shrink to be present
667 _minimum_extents_to_shrink minimum number freeable extents for shrink to be present
668 _minimum_giga_scn Minimum SCN to start with in 2^30 units
669 _mirror_redo_buffers Save buffers for debugging redo corruptions
670 _mmv_query_rewrite_enabled allow rewrites with multiple MVs and/or base tables
671 _multi_join_key_table_lookup TRUE iff multi-join-key table lookup prefetch is enabled
672 _multiple_instance_recovery use multiple instances for media recovery
673 _mv_refresh_ana what percent to analyze after complete/PCT refresh
674 _mv_refresh_costing refresh decision based on cost or on rules
675 _mv_refresh_delta_fraction delta mv as fractional percentage of size of mv
676 _mv_refresh_eut refresh materialized views using EUT(partition)-based algorithm
677 _mv_refresh_force_parallel_query force materialized view refreshes to use parallel query
678 _mv_refresh_new_setup_disabled materialized view MV refresh new setup disabling
679 _mv_refresh_rebuild_percentage minimum percentage change required in MV to force an index rebuild
680 _mv_refresh_selections create materialized views with selections and fast refresh
681 _mv_refresh_use_stats pass cardinality hints to refresh queries
682 _mv_refsched_timeincr proportionality constant for dop vs. time in MV refresh
683 _mv_rolling_inv create/alter mv uses rolling cursor invalidation instead of immediate
684 _mwin_schedule Enable/disable Maintenance Window Schedules
685 _nchar_imp_cnv NLS allow Implicit Conversion between CHAR and NCHAR
686 _nchar_imp_conv should implicit conversion bewteen clob and nclob be allowed
687 _ncmb_readahead_enabled enable multi-block readahead for an index scan
688 _ncmb_readahead_tracing turn on multi-block readahead tracing
689 _nested_loop_fudge nested loop fudge
690 _nested_mav_fast_oncommit_enabled nested MAV refresh fast on commit allowed
691 _new_initial_join_orders enable initial join orders based on new ordering heuristics
692 _new_sort_cost_estimate enables the use of new cost estimate for sort
693 _newsort_enabled controls whether new sorts can be used as system sort
694 _newsort_ordered_pct controls when new sort avoids sorting ordered input
695 _newsort_type specifies options for the new sort algorithm
696 _no_objects no object features are used
697 _no_or_expansion OR expansion during optimization disabled
698 _no_recovery_through_resetlogs no recovery through this resetlogs operation
699 _notify_crs notify cluster ready services of startup and shutdown
700 _ns_max_flush_wt Flush wait time for NetServer to flush oustanding writes
701 _ns_max_send_delay Data Loss Time Bound for NetServer
702 _num_longop_child_latches number of child latches for long op array
703 _number_cached_attributes maximum number of cached attributes per instance
704 _object_statistics enable the object level statistics collection
705 _offline_rollback_segments offline undo segment list
706 _ogms_home GMS home directory
707 _olap_aggregate_buffer_size OLAP Aggregate max buffer size
708 _olap_aggregate_flags OLAP Aggregate debug flags
709 _olap_aggregate_function_cache_enabled OLAP Aggregate function cache enabler
710 _olap_aggregate_function_merge_threshold OLAP Aggregate function merge threshold
711 _olap_aggregate_max_thread_tuples OLAP Aggregate max thread tuples creation
712 _olap_aggregate_min_buffer_size OLAP Aggregate min buffer size
713 _olap_aggregate_min_thread_status OLAP Aggregate minimum cardinality of dimensions for thread
714 _olap_aggregate_multipath_hier OLAP Aggregate Multi-path Hierarhies enabled
715 _olap_aggregate_statlen_thresh OLAP Aggregate status array usage threshold
716 _olap_aggregate_store_probability OLAP Aggregate function storeback probability
717 _olap_aggregate_work_per_thread OLAP Aggregate max work parents
718 _olap_aggregate_worklist_max OLAP Aggregate max worklists generated at once
719 _olap_allocate_errorlog_format OLAP Allocate Errorlog Format
720 _olap_allocate_errorlog_header OLAP Allocate Errorlog Header format
721 _olap_continuous_trace_file Specify TRUE to enable continuous OLAP tracing - otherwise only exceptional events will be logged
722 _olap_dbgoutfile_echo_to_eventlog OLAP DbgOutfile copy output to event log (tracefile)
723 _olap_dimension_corehash_class OLAP Dimension In-Core Hash Table Class
724 _olap_dimension_corehash_max OLAP Dimension In-Core Hash Table Maximum Size
725 _olap_eif_export_lob_size OLAP EIF Export BLOB size
726 _olap_lmgen_dim_size Limitmap generator dimension column size
727 _olap_lmgen_meas_size Limitmap generator measure column size
728 _olap_object_hash_class OLAP Object Hash Table Class
729 _olap_page_pool_expand_rate OLAP Page Pool Expand Rate
730 _olap_page_pool_hi OLAP Page Pool High Watermark
731 _olap_page_pool_hit_target OLAP Page Pool Hit Target
732 _olap_page_pool_low OLAP Page Pool Low Watermark
733 _olap_page_pool_pressure OLAP Page Pool Pressure Threshold
734 _olap_page_pool_shrink_rate OLAP Page Pool Shrink Rate
735 _olap_parallel_update_small_group OLAP parallel update pagespace by group
736 _olap_parallel_update_small_threshold OLAP parallel update threshold for number of small pagespaces
737 _olap_parallel_update_threshold OLAP parallel update threshold in pages
738 _olap_poutlog_echo_to_eventlog OLAP POutLog copy output to event log (tracefile)
739 _olap_sesscache_enabled OLAP Session Cache knob
740 _olap_sort_buffer_size OLAP Sort Buffer Size
741 _olap_statbool_corebits OLAP Status Boolean max incore bits
742 _olap_statbool_threshold OLAP Status Boolean CBM threshold
743 _olap_table_function_statistics Specify TRUE to output OLAP table function timed statistics trace
744 _olap_wrap_errors Wrap error messages to OLAP outfile
745 _olapi_history_retention enable olapi history retention
746 _olapi_iface_object_history enable olapi interface object history collection
747 _olapi_iface_object_history_retention enable olapi interface object history retention
748 _olapi_iface_operation_history_retention enable olapi interface operation history retention
749 _olapi_interface_operation_history enable olapi interface operation history collection
750 _olapi_memory_operation_history enable olapi memory alloc/free history collection
751 _olapi_memory_operation_history_pause_at_seqno enable olapi memory alloc/free history collection pausing
752 _olapi_memory_operation_history_retention enable olapi memory operation history retention
753 _olapi_session_history enable olapi session history collection
754 _olapi_session_history_retention enable olapi session history retention
755 _old_connect_by_enabled enable/disable old connect by
756 _ols_cleanup_task Clean up unnecessary entries in OLS sessinfo table
757 _omf enable/disable OMF
758 _oneside_colstat_for_equijoins sanity check on default selectivity for like/range predicate
759 _optim_adjust_for_part_skews adjust stats for skews across partitions
760 _optim_dict_stats_at_db_cr_upg enable/disable dictionary stats gathering at db create/upgrade
761 _optim_enhance_nnull_detection TRUE to enable index [fast] full scan more often
762 _optim_new_default_join_sel improves the way default equijoin selectivity are computed
763 _optim_peek_user_binds enable peeking of user binds
764 _optimizer_adjust_for_nulls adjust selectivity for null values
765 _optimizer_autostats_job enable/disable auto stats collection job
766 _optimizer_better_inlist_costing enable improved costing of index access using in-list(s)
767 _optimizer_block_size standard block size used by optimizer
768 _optimizer_cache_stats cost with cache statistics
769 _optimizer_cartesian_enabled optimizer cartesian join enabled
770 _optimizer_cbqt_factor cost factor for cost-based query transformation
771 _optimizer_cbqt_no_size_restriction disable cost based transformation query size restriction
772 _optimizer_ceil_cost CEIL cost in CBO
773 _optimizer_choose_permutation force the optimizer to use the specified permutation
774 _optimizer_complex_pred_selectivity enable selectivity estimation for builtin functions
775 _optimizer_compute_index_stats force index stats collection on index creation/rebuild
776 _optimizer_connect_by_cost_based use cost-based transformation for connect by
777 _optimizer_correct_sq_selectivity force correct computation of subquery selectivity
778 _optimizer_cost_based_transformation enables cost-based query transformation
779 _optimizer_cost_filter_pred enables costing of filter predicates in IO cost model
780 _optimizer_cost_hjsmj_multimatch add cost of generating result set when #rows per key > 1
781 _optimizer_cost_model optimizer cost model
782 _optimizer_degree force the optimizer to use the same degree of parallelism
783 _optimizer_dim_subq_join_sel use join selectivity in choosing star transformation dimensions
784 _optimizer_disable_strans_sanity_checks disable star transformation sanity checks
785 _optimizer_dyn_smp_blks number of blocks for optimizer dynamic sampling
786 _optimizer_enhanced_filter_push push filters before trying cost-based query transformation
787 _optimizer_extended_cursor_sharing optimizer extended cursor sharing
788 _optimizer_filter_pred_pullup use cost-based flter predicate pull up transformation
789 _optimizer_ignore_hints enables the embedded hints to be ignored
790 _optimizer_invalidation_period time window for invalidation of cursors of analyzed objects
791 _optimizer_join_elimination_enabled optimizer join elimination enabled
792 _optimizer_join_order_control controls the optimizer join order search algorithm
793 _optimizer_join_sel_sanity_check enable/disable sanity check for multi-column join selectivity
794 _optimizer_max_permutations optimizer maximum join permutations per query block
795 _optimizer_min_cache_blocks set minimum cached blocks
796 _optimizer_mjc_enabled enable merge join cartesian
797 _optimizer_mode_force force setting of optimizer mode for user recursive SQL also
798 _optimizer_multiple_cenv generate and run plans using several compilation environments
799 _optimizer_native_full_outer_join execute full outer join using native implementaion
800 _optimizer_new_join_card_computation compute join cardinality using non-rounded input values
801 _optimizer_or_expansion control or expansion approach used
802 _optimizer_order_by_elimination_enabled Eliminates order bys from views before query transformation
803 _optimizer_outer_to_anti_enabled Enable transformation of outer-join to anti-join if possible
804 _optimizer_percent_parallel optimizer percent parallel
805 _optimizer_push_down_distinct push down distinct from query block to table
806 _optimizer_push_pred_cost_based use cost-based query transformation for push pred optimization
807 _optimizer_random_plan optimizer seed value for random plans
808 _optimizer_rownum_bind_default Default value to use for rownum bind
809 _optimizer_rownum_pred_based_fkr enable the use of first K rows due to rownum predicate
810 _optimizer_save_stats enable/disable saving old versions of optimizer stats
811 _optimizer_search_limit optimizer search limit
812 _optimizer_self_induced_cache_cost account for self-induced caching
813 _optimizer_skip_scan_enabled enable/disable index skip scan
814 _optimizer_skip_scan_guess consider index skip scan for predicates with guessed selectivity
815 _optimizer_sortmerge_join_enabled enable/disable sort-merge join method
816 _optimizer_squ_bottomup enables unnesting of subquery in a bottom-up manner
817 _optimizer_star_tran_in_with_clause enable/disable star transformation in with clause queries
818 _optimizer_starplan_enabled optimizer star plan enabled
819 _optimizer_system_stats_usage system statistics usage
820 _optimizer_trace optimizer trace parameter
821 _optimizer_transitivity_retain retain equi-join pred upon transitive equality pred generation
822 _optimizer_undo_changes undo changes to query optimizer
823 _optimizer_undo_cost_change optimizer undo cost change
824 _or_expand_nvl_predicate enable OR expanded plan for NVL/DECODE predicate
825 _oradbg_pathname path of oradbg script
826 _oradebug_force force target processes to execute oradebug commands?
827 _ordered_nested_loop enable ordered nested loop costing
828 _ordered_semijoin enable ordered semi-join subquery
829 _os_sched_high_priority OS high priority level
830 _other_wait_event_exclusion exclude event names from _other_wait_threshold calculations
831 _other_wait_threshold threshold wait percentage for event wait class Other
832 _outline_bitmap_tree BITMAP_TREE hint enabled in outline
833 _parallel_adaptive_max_users maximum number of users running with default DOP
834 _parallel_broadcast_enabled enable broadcasting of small inputs to hash and sort merge joins
835 _parallel_default_max_instances default maximum number of instances for parallel query
836 _parallel_execution_message_align Alignment of PX buffers to OS page boundary
837 _parallel_fake_class_pct fake db-scheduler percent used for testing
838 _parallel_fixwrite_bucket Number of buckets for each round of fix write
839 _parallel_load_bal_unit number of threads to allocate per instance
840 _parallel_load_balancing parallel execution load balanced slave allocation
841 _parallel_min_message_pool minimum size of shared pool memory to reserve for pq servers
842 _parallel_recovery_stopat stop at position to step through SMON
843 _parallel_replay_msg_limit Number of messages for each round of parallel replay
844 _parallel_server_idle_time idle time before parallel query server dies (in 1/100 sec)
845 _parallel_server_sleep_time sleep time between dequeue timeouts (in 1/100ths)
846 _parallel_slave_acquisition_wait time(in seconds) to wait before retrying slave acquisition
847 _parallel_txn_global enable parallel_txn hint with updates and deletes
848 _parallelism_cost_fudge_factor set the parallelism cost fudge factor
849 _parameter_table_block_size parameter table block size
850 _partial_pwise_join_enabled enable partial partition-wise join when TRUE
851 _partition_view_enabled enable/disable partitioned views
852 _passwordfile_enqueue_timeout password file enqueue timeout in seconds
853 _pct_refresh_double_count_prevented materialized view PCT refreshes avoid double counting
854 _pdml_gim_sampling control separation of global index maintenance for PDML
855 _pdml_gim_staggered slaves start on different index when doing index maint
856 _pdml_slaves_diff_part slaves start on different partition when doing index maint
857 _percent_flashback_buf_partial_full Percent of flashback buffer filled to be considered partial full
858 _pga_large_extent_size PGA large extent size
859 _pga_max_size Maximum size of the PGA memory for one process
860 _ping_level fusion ping level
861 _pkt_enable enable progressive kill test
862 _pkt_pmon_interval PMON process clean-up interval (cs)
863 _pkt_start start progressive kill test instrumention
864 _plan_outline_data explain plan outline data enabled
865 _plsql_anon_block_code_type PL/SQL anonymous block code-type
866 _plsql_cache_enable PL/SQL Function Cache Enabled
867 _plsql_dump_buffer_events conditions upon which the PL/SQL circular buffer is dumped
868 _plsql_minimum_cache_hit_percent plsql minimum cache hit percentage required to keep caching active
869 _plsql_nvl_optimize PL/SQL NVL optimize
870 _pmon_load_constants server load balancing constants (S,P,D,I,L,C,M)
871 _pre_rewrite_push_pred push predicates into views before rewrite
872 _precompute_gid_values precompute gid values and copy them before returning a row
873 _pred_move_around enables predicate move-around
874 _predicate_elimination_enabled allow predicate elimination if set to TRUE
875 _prescomm presume commit of IMU transactions
876 _print_refresh_schedule enable dbms_output of materialized view refresh schedule
877 _private_memory_address Start address of large extent memory segment
878 _project_view_columns enable projecting out unreferenced columns of a view
879 _projection_pushdown projection pushdown
880 _projection_pushdown_debug level for projection pushdown debugging
881 _push_join_predicate enable pushing join predicate inside a view
882 _push_join_union_view enable pushing join predicate inside a union all view
883 _push_join_union_view2 enable pushing join predicate inside a union view
884 _px_async_getgranule asynchronous get granule in the slave
885 _px_broadcast_fudge_factor set the tq broadcasting fudge factor percentage
886 _px_buffer_ttl ttl for px mesg buffers in seconds
887 _px_compilation_debug debug level for parallel compilation
888 _px_compilation_trace tracing level for parallel compilation
889 _px_dynamic_opt turn off/on restartable qerpx dynamic optimization
890 _px_dynamic_sample_size num of samples for restartable qerpx dynamic optimization
891 _px_granule_size default size of a rowid range granule (in KB)
892 _px_index_sampling parallel query sampling for index create (100000 = 100%)
893 _px_kxib_tracing turn on kxib tracing
894 _px_load_publish_interval interval at which LMON will check whether to publish PX load
895 _px_loc_msg_cost CPU cost to send a PX message via shared memory
896 _px_max_granules_per_slave maximum number of rowid range granules to generate per slave
897 _px_min_granules_per_slave minimum number of rowid range granules to generate per slave
898 _px_minus_intersect enables pq for minus/interect operators
899 _px_net_msg_cost CPU cost to send a PX message over the internconnect
900 _px_no_granule_sort prevent parallel partition granules to be sorted on size
901 _px_no_stealing prevent parallel granule stealing in shared nothing environment
902 _px_nss_planb enables or disables NSS Plan B reparse with outline
903 _px_proc_constrain reduce parallel_max_servers if greater than (processes - fudge)
904 _px_pwg_enabled parallel partition wise group by enabled
905 _px_rownum_pd turn off/on parallel rownum pushdown optimization
906 _px_send_timeout IPC message send timeout value in seconds
907 _px_slaves_share_cursors slaves share cursors with QC
908 _px_trace px trace parameter
909 _px_xtgranule_size default size of a external table granule (in KB)
910 _qa_control Oracle internal parameter to control QA
911 _qa_lrg_type Oracle internal parameter to specify QA lrg type
912 _query_cost_rewrite perform the cost based rewrite with materialized views
913 _query_execution_cache_max_size max size of query execution cache
914 _query_rewrite_1 perform query rewrite before&after or only before view merging
915 _query_rewrite_2 perform query rewrite before&after or only after view merging
916 _query_rewrite_drj mv rewrite and drop redundant joins
917 _query_rewrite_expression rewrite with cannonical form for expressions
918 _query_rewrite_fpc mv rewrite fresh partition containment
919 _query_rewrite_fudge cost based query rewrite with MVs fudge factor
920 _query_rewrite_jgmigrate mv rewrite with jg migration
921 _query_rewrite_maxdisjunct query rewrite max disjuncts
922 _query_rewrite_or_error allow query rewrite, if referenced tables are not dataless
923 _query_rewrite_setopgrw_enable perform general rewrite using set operator summaries
924 _query_rewrite_vop_cleanup prune frocol chain before rewrite after view-merging
925 _rcfg_parallel_fixwrite if TRUE enables parallel fixwrite at reconfiguration
926 _rcfg_parallel_replay if TRUE enables parallel replay and cleanup at reconfiguration
927 _rcfg_parallel_verify if TRUE enables parallel verify at reconfiguration
928 _real_time_apply_arch_delay Archival delay with real time apply
929 _real_time_apply_sim Simulation value with real time apply
930 _realfree_heap_max_size minimum max total heap size, in Kbytes
931 _realfree_heap_mode mode flags for real-free heap
932 _realfree_heap_pagesize_hint hint for real-free page size in bytes
933 _recoverable_recovery_batch_percent Recoverable recovery batch size (percentage of buffer cache)
934 _recovery_asserts if TRUE, enable expensive integrity checks
935 _recovery_percentage recovery buffer cache percentage
936 _recovery_verify_writes enable thread recovery write verify
937 _recursive_imu_transactions recursive transactions may be IMU
938 _redo_compatibility_check general and redo/undo compatibility sanity check
939 _release_insert_threshold maximum number of unusable blocks to unlink from freelist
940 _reliable_block_sends if TRUE, block sends across interconnect are reliable
941 _remove_aggr_subquery enables removal of subsumed aggregated subquery
942 _resource_manager_always_on enable the resource manager always
943 _restore_spfile restore spfile to this location
944 _reuse_index_loop number of blocks being examine for index block reuse
945 _right_outer_hash_enable Right Outer/Semi/Anti Hash Enabled
946 _rman_io_priority priority at which rman backup i/o's are done
947 _rollback_segment_count number of undo segments
948 _rollback_segment_initial starting undo segment number
949 _rollback_stopat stop at -position to step rollback
950 _row_cache_cursors number of cached cursors for row cache management
951 _row_cr enable row cr for all sql
952 _row_locking row-locking
953 _row_shipping_explain enable row shipping explain plan support
954 _row_shipping_threshold row shipping column selection threshold
955 _rowsource_execution_statistics if TRUE, Oracle will collect rowsource statistics
956 _rowsource_statistics_sampfreq frequency of rowsource statistic sampling (must be a power of 2)
957 _rowsrc_trace_level Row source tree tracing level
958 _sample_rows_per_block number of rows per block used for sampling IO optimization
959 _second_spare_parameter second spare parameter - integer
960 _selfjoin_mv_duplicates control rewrite self-join algorithm
961 _selftune_checkpoint_write_pct Percentage of total physical i/os for self-tune ckpt
962 _selftune_checkpointing_lag Self-tune checkpointing lag the tail of the redo log
963 _send_ast_to_foreground if TRUE, send ast message to foreground
964 _send_close_with_block if TRUE, send close with block even with direct sends
965 _send_requests_to_pi if TRUE, try to send CR requests to PI buffers
966 _serial_direct_read enable direct read in serial
967 _serial_recovery force serial recovery or parallel recovery
968 _serializable serializable
969 _session_cached_instantiations Number of pl/sql instantiations to cache in a session.
970 _session_context_size session app context size
971 _session_idle_bit_latches one latch per session or a latch per group of sessions
972 _session_idle_check_interval Resource Manager session idle limit check interval in seconds
973 _session_kept_cursor_pins Number of cursors pins to keep in a session
974 _session_wait_history enable session wait history collection
975 _seventh_spare_parameter seventh spare parameter - string list
976 _shared_pool_max_size shared pool maximum size when auto SGA enabled
977 _shared_pool_minsize_on shared pool minimum size when auto SGA enabled
978 _shared_pool_reserved_min_alloc minimum allocation size in bytes for reserved area of shared pool
979 _shared_pool_reserved_pct percentage memory of the shared pool allocated for the reserved area
980 _shared_server_spare_param1 _shared_server_spare_param1
981 _shared_server_spare_param2 _shared_server_spare_param2
982 _shared_server_spare_param3 _shared_server_spare_param3
983 _short_stack_timeout_ms short stack timeout in ms
984 _shrunk_aggs_disable_threshold percentage of exceptions at which to switch to full length aggs
985 _shrunk_aggs_enabled enable use of variable sized buffers for non-distinct aggregates
986 _side_channel_batch_size number of messages to batch in a side channel message (DFS)
987 _side_channel_batch_timeout timeout before shipping out the batched side channelmessages
988 _simple_view_merging control simple view merging performed by the optimizer
989 _simulator_bucket_mindelta LRU bucket minimum delta
990 _simulator_internal_bound simulator internal bound percent
991 _simulator_lru_rebalance_sizthr LRU list rebalance threshold (size)
992 _simulator_lru_rebalance_thresh LRU list rebalance threshold (count)
993 _simulator_lru_scan_count LRU scan count
994 _simulator_pin_inval_maxcnt maximum count of invalid chunks on pin list
995 _simulator_reserved_heap_count simulator reserved heap count
996 _simulator_reserved_obj_count simulator reserved object count
997 _simulator_sampling_factor sampling factor for the simulator
998 _simulator_upper_bound_multiple upper bound multiple of pool size
999 _single_process run without detached processes
1000 _sixth_spare_parameter sixth spare parameter - string list
1001 _skgxp_reaping tune skgxp OSD reaping limit
1002 _skgxp_udp_ach_reaping_time time in minutes before idle ach's are reaped
1003 _skgxp_udp_hiwat_warn ach hiwat mark warning interval
1004 _skgxp_udp_interface_detection_time_secs time in seconds between interface detection checks
1005 _skgxp_udp_keep_alive_ping_timer_secs connection idle time in seconds before keep alive is initiated. min: 30 sec max: 1800 sec default: 300 sec
1006 _skgxp_udp_timed_wait_buffering diagnostic log buffering space (in bytes) for timed wait (0 means unbufferd
1007 _skgxp_udp_timed_wait_seconds time in seconds before timed wait is invoked
1008 _skip_assume_msg if TRUE, skip assume message for consigns at the master
1009 _slave_mapping_enabled enable slave mapping when TRUE
1010 _slave_mapping_group_size force the number of slave group in a slave mapper
1011 _small_table_threshold threshold level of table size for direct reads
1012 _smm_advice_enabled if TRUE, enable v$pga_advice
1013 _smm_advice_log_size overwrites default size of the PGA advice workarea history log
1014 _smm_auto_cost_enabled if TRUE, use the AUTO size policy cost functions
1015 _smm_auto_max_io_size Maximum IO size (in KB) used by sort/hash-join in auto mode
1016 _smm_auto_min_io_size Minimum IO size (in KB) used by sort/hash-join in auto mode
1017 _smm_bound overwrites memory manager automatically computed bound
1018 _smm_control provides controls on the memory manager
1019 _smm_freeable_retain value in KB of the instance freeable PGA memory to retain
1020 _smm_isort_cap maximum work area for insertion sort(v1)
1021 _smm_max_size maximum work area size in auto mode (serial)
1022 _smm_min_size minimum work area size in auto mode
1023 _smm_px_max_size maximum work area size in auto mode (global)
1024 _smm_retain_size work area retain size in SGA for shared server sessions (0 for AUTO)
1025 _smm_trace Turn on/off tracing for SQL memory manager
1026 _smon_internal_errlimit limit of SMON internal errors
1027 _smu_debug_mode <debug-flag> - set debug event for testing SMU operations
1028 _smu_error_simulation_site site ID of error simulation in KTU code
1029 _smu_error_simulation_type error type for error simulation in KTU code
1030 _smu_timeouts comma-separated AND double-quoted list of AUM timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl
1031 _sort_elimination_cost_ratio cost ratio for sort eimination under first_rows mode
1032 _sort_multiblock_read_count multi-block read count for sort
1033 _spin_count Amount to spin waiting for a latch
1034 _spr_max_rules maximum number of rules in sql spreadsheet
1035 _spr_push_pred_refspr push predicates through reference spreadsheet
1036 _spr_use_AW_AS enable AW for hash table in spreadsheet
1037 _spr_use_hash_table use hash table for spreadsheet
1038 _sql_connect_capability_override SQL Connect Capability Table Override
1039 _sql_connect_capability_table SQL Connect Capability Table (testing only)
1040 _sql_hash_debug Hash value of the SQL statement to debug
1041 _sql_model_unfold_forloops specifies compile-time unfolding of sql model forloops
1042 _sqlexec_progression_cost sql execution progression monitoring cost threshold
1043 _sqltune_category_parsed Parsed category qualifier for applying hintsets
1044 _sta_control SQL Tuning Advisory control parameter
1045 _stack_guard_level stack guard level
1046 _static_backgrounds static backgrounds
1047 _stn_trace SQL tracing parameter
1048 _streams_pool_max_size streams pool maximum size when auto SGA enabled
1049 _subquery_pruning_cost_factor subquery pruning cost factor
1050 _subquery_pruning_enabled enable the use of subquery predicates to perform pruning
1051 _subquery_pruning_mv_enabled enable the use of subquery predicates with MVs to perform pruning
1052 _subquery_pruning_reduction subquery pruning reduction factor
1053 _swrf_metric_frequent_mode Enable/disable SWRF Metric Frequent Mode Collection
1054 _swrf_mmon_dbfus Enable/disable SWRF MMON DB Feature Usage
1055 _swrf_mmon_flush Enable/disable SWRF MMON FLushing
1056 _swrf_mmon_metrics Enable/disable SWRF MMON Metrics Collection
1057 _swrf_on_disk_enabled Parameter to enable/disable SWRF
1058 _swrf_test_action test action parameter for SWRF
1059 _swrf_test_dbfus Enable/disable DB Feature Usage Testing
1060 _synonym_repoint_tracing whether to trace metadata comparisons for synonym repointing
1061 _sysaux_test_param test parameter for SYSAUX
1062 _system_index_caching optimizer percent system index caching
1063 _system_trig_enabled are system triggers enabled
1064 _ta_lns_wait_for_arch_log LNS Wait time for arhcived version of online log
1065 _table_lookup_prefetch_size table lookup prefetch vector size
1066 _table_lookup_prefetch_thresh table lookup prefetch threshold
1067 _table_scan_cost_plus_one bump estimated full table scan and index ffs cost by one
1068 _target_rba_max_lag_percentage target rba max log lag percentage
1069 _tdb_debug_mode set debug mode for testing transportable database
1070 _temp_tran_block_threshold number of blocks for a dimension before we temp transform
1071 _temp_tran_cache determines if temp table is created with cache option
1072 _test_ksusigskip test the function ksusigskip
1073 _test_param_1 test parmeter 1 - integer
1074 _test_param_2 test parameter 2 - string
1075 _test_param_3 test parameter 3 - string
1076 _test_param_4 test parameter 4 - string list
1077 _test_param_5 test parmeter 5 - deprecated integer
1078 _test_param_6 test parmeter 6 - size (ub8)
1079 _third_spare_parameter third spare parameter - integer
1080 _threshold_alerts_enable if 1, issue threshold-based alerts
1081 _total_large_extent_memory Total memory for allocating large extents
1082 _tq_dump_period time period for duping of TQ statistics (s)
1083 _trace_archive start DIAG process
1084 _trace_buffer_flushes trace buffer flushes if otrace cacheIO event is set
1085 _trace_buffer_gets trace kcb buffer gets if otrace cacheIO event is set
1086 _trace_buffer_wait_timeouts trace buffer busy wait timeouts
1087 _trace_buffer_wrap_timestamp enable KST timestamp on trace buffer wrap
1088 _trace_buffers trace buffer sizes per process
1089 _trace_cr_buffer_creates trace cr buffer creates if otrace cacheIO event is set
1090 _trace_events trace events enabled at startup
1091 _trace_file_size maximum size of trace file (in bytes)
1092 _trace_files_public Create publicly accessible trace files
1093 _trace_flush_processes trace data archived by DIAG for these processes
1094 _trace_multi_block_reads trace multi_block reads if otrace cacheIO event is set
1095 _trace_navigation_scope enabling trace navigation linking
1096 _trace_options trace data flush options
1097 _trace_pin_time trace how long a current pin is held
1098 _trace_processes enable KST tracing in process
1099 _transaction_auditing transaction auditing records generated in the redo log
1100 _transaction_recovery_servers max number of parallel recovery slaves that may be used
1101 _truncate_optimization_enabled do truncate optimization if set to TRUE
1102 _tsm_connect_string TSM test connect string
1103 _tsm_disable_auto_cleanup Disable TSM auto cleanup actions
1104 _tts_allow_charset_mismatch allow plugging in a tablespace with an incompatible character set
1105 _two_pass enable two-pass thread recovery
1106 _two_pass_reverse_polish_enabled uses two-pass reverse polish alg. to generate canonical forms
1107 _uga_cga_large_extent_size UGA/CGA large extent size
1108 _ultrafast_latch_statistics maintain fast-path statistics for ultrafast latches
1109 _undo_autotune enable auto tuning of undo_retention
1110 _undo_debug_mode debug flag for undo related operations
1111 _undo_debug_usage invoke undo usage functions for testing
1112 _union_rewrite_for_gs expand queries with GSets into UNIONs for rewrite
1113 _unnest_subquery enables unnesting of correlated subqueries
1114 _unused_block_compression enable unused block compression
1115 _use_column_stats_for_function enable the use of column statistics for DDP functions
1116 _use_ism Enable Shared Page Tables - ISM
1117 _use_ism_for_pga Use ISM for allocating large extents
1118 _use_nosegment_indexes use nosegment indexes in explain plan
1119 _use_realfree_heap use real-free based allocator for PGA memory
1120 _use_seq_process_cache whether to use process local seq cache
1121 _use_vector_post use vector post
1122 _validate_flashback_database Scan database to validate result of flashback database
1123 _vendor_lib_loc Vendor library search root directory
1124 _verify_flashback_redo Verify that the redo logs needed for flashback are available
1125 _verify_undo_quota TRUE - verify consistency of undo quota statistics
1126 _very_large_partitioned_table very_large_partitioned_table
1127 _wait_for_sync wait for sync on commit MUST BE ALWAYS TRUE
1128 _walk_insert_threshold maximum number of unusable blocks to walk across freelist
1129 _watchpoint_on is the watchpointing feature turned on?
1130 _windowfunc_optimization_settings settings for window function optimizations
1131 _write_clones write clones flag
1132 _xpl_peeked_binds_log_size maximum bytes for logging peeked bind values for V$SQL_PLAN (0 = OFF)
1133 _xpl_trace Explain Plan tracing parameter
1134 _xsolapi_auto_materialization_bound OLAP API lower bound for auto materialization.
1135 _xsolapi_auto_materialization_type OLAP API behavior for auto materialization
1136 _xsolapi_debug_output OLAP API debug output disposition
1137 _xsolapi_densify_cubes OLAP API cube densification
1138 _xsolapi_dimension_group_creation OLAP API symmetric overfetch
1139 _xsolapi_fetch_type OLAP API fetch type
1140 _xsolapi_generate_with_clause OLAP API generates WITH clause?
1141 _xsolapi_hierarchy_value_type OLAP API hierarchy value type
1142 _xsolapi_load_at_process_start When to load OLAP API library at server process start
1143 _xsolapi_materialization_rowcache_min_rows_for_use OLAP API min number of rows required to use rowcache in query materialization
1144 _xsolapi_materialize_sources OLAP API Enable source materialization
1145 _xsolapi_metadata_reader_mode OLAP API metadata reader mode
1146 _xsolapi_odbo_mode OLAP API uses ODBO mode?
1147 _xsolapi_optimize_suppression OLAP API optimizes suppressions?
1148 _xsolapi_precompute_subquery OLAP API precomputes subqueries?
1149 _xsolapi_remove_columns_for_materialization OLAP API removes columns for materialization?
1150 _xsolapi_set_nls OLAP API sets NLS?
1151 _xsolapi_share_executors OLAP API share executors?
1152 _xsolapi_source_trace OLAP API output Source definitions to trace file
1153 _xsolapi_sql_all_multi_join_non_base_hints OLAP API multi-join non-base hints
1154 _xsolapi_sql_all_non_base_hints OLAP API non-base hints
1155 _xsolapi_sql_auto_dimension_hints OLAP API enable automatic dimension hints
1156 _xsolapi_sql_auto_measure_hints OLAP API enable automatic measure hints
1157 _xsolapi_sql_dimension_hints OLAP API dimension hints
1158 _xsolapi_sql_enable_aw_join OLAP API enables AW join?
1159 _xsolapi_sql_enable_aw_qdr_merge OLAP API enables AW QDR merge?
1160 _xsolapi_sql_hints OLAP API generic hints
1161 _xsolapi_sql_measure_hints OLAP API measure hints
1162 _xsolapi_sql_minus_threshold OLAP API SQL MINUS threshold
1163 _xsolapi_sql_optimize OLAP API enable optimization
1164 _xsolapi_sql_prepare_stmt_cache_size OLAP API prepare statement cache size
1165 _xsolapi_sql_remove_columns OLAP API enable remove unused columns optimizations
1166 _xsolapi_sql_result_set_cache_size OLAP API result set cache size
1167 _xsolapi_sql_symmetric_predicate OLAP API enable symmetric predicate for dimension groups
1168 _xsolapi_sql_top_dimension_hints OLAP API top dimension hints
1169 _xsolapi_sql_top_measure_hints OLAP API top measure hints
1170 _xsolapi_sql_use_bind_variables OLAP API enable bind variables optimization
1171 _xsolapi_stringify_order_levels OLAP API stringifies order levels?
1172 _xsolapi_suppression_aw_mask_threshold OLAP API suppression AW mask threshold
1173 _xsolapi_suppression_chunk_size OLAP API suppression chunk size
1174 _xsolapi_use_models OLAP API uses models?
1175 _xsolapi_use_olap_dml OLAP API uses OLAP DML?
1176 _xsolapi_use_olap_dml_for_rank OLAP API uses OLAP DML for rank?
1177 _xt_coverage external tables code coverage parameter
1178 _xt_trace external tables trace parameter
1179 _xtbuffer_size buffer size in KB needed for populate/query operation
1180 _xtts_allow_pre10 allow cross platform for pre10 compatible tablespace
1181 _xtts_set_platform_info set cross platform info during file header read
1182 _yield_check_interval interval to check whether actses should yield
1183 active_instance_count number of active instances in the cluster database
1184 aq_tm_processes number of AQ Time Managers to start
1185 archive_lag_target Maximum number of seconds of redos the standby could lose
1186 asm_diskgroups disk groups to mount automatically
1187 asm_diskstring disk set locations for discovery
1188 asm_power_limit number of processes for disk rebalancing
1189 audit_file_dest Directory in which auditing files are to reside
1190 audit_sys_operations enable sys auditing
1191 audit_syslog_level Syslog facility and level
1192 audit_trail enable system auditing
1193 background_core_dump Core Size for Background Processes
1194 background_dump_dest Detached process dump directory
1195 backup_tape_io_slaves BACKUP Tape I/O slaves
1196 bitmap_merge_area_size maximum memory allow for BITMAP MERGE
1197 blank_trimming blank trimming semantics parameter
1198 buffer_pool_keep Number of database blocks/latches in keep buffer pool
1199 buffer_pool_recycle Number of database blocks/latches in recycle buffer pool
1200 circuits max number of circuits
1201 cluster_database if TRUE startup in cluster database mode
1202 cluster_database_instances number of instances to use for sizing cluster db SGA structures
1203 cluster_interconnects interconnects for RAC use
1204 commit_point_strength Bias this node has toward not preparing in a two-phase commit
1205 commit_write transaction commit log write behaviour
1206 compatible Database will be completely compatible with this software version
1207 control_file_record_keep_time control file record keep time in days
1208 control_files control file names list
1209 core_dump_dest Core dump directory
1210 cpu_count number of CPUs for this instance
1211 create_bitmap_area_size size of create bitmap buffer for bitmap index
1212 create_stored_outlines create stored outlines for DML statements
1213 cursor_sharing cursor sharing mode
1214 cursor_space_for_time use more memory in order to get faster execution
1215 db_16k_cache_size Size of cache for 16K buffers
1216 db_2k_cache_size Size of cache for 2K buffers
1217 db_32k_cache_size Size of cache for 32K buffers
1218 db_4k_cache_size Size of cache for 4K buffers
1219 db_8k_cache_size Size of cache for 8K buffers
1220 db_block_buffers Number of database blocks cached in memory
1221 db_block_checking header checking and data and index block checking
1222 db_block_checksum store checksum in db blocks and check during reads
1223 db_block_size Size of database block in bytes
1224 db_cache_advice Buffer cache sizing advisory
1225 db_cache_size Size of DEFAULT buffer pool for standard block size buffers
1226 db_create_file_dest default database location
1227 db_create_online_log_dest_1 online log/controlfile destination #1
1228 db_create_online_log_dest_2 online log/controlfile destination #2
1229 db_create_online_log_dest_3 online log/controlfile destination #3
1230 db_create_online_log_dest_4 online log/controlfile destination #4
1231 db_create_online_log_dest_5 online log/controlfile destination #5
1232 db_domain directory part of global database name stored with CREATE DATABASE
1233 db_file_multiblock_read_count db block to be read each IO
1234 db_file_name_convert datafile name convert patterns and strings for standby/clone db
1235 db_files max allowable # db files
1236 db_flashback_retention_target Maximum Flashback Database log retention time in minutes.
1237 db_keep_cache_size Size of KEEP buffer pool for standard block size buffers
1238 db_name database name specified in CREATE DATABASE
1239 db_recovery_file_dest default database recovery file location
1240 db_recovery_file_dest_size database recovery files size limit
1241 db_recycle_cache_size Size of RECYCLE buffer pool for standard block size buffers
1242 db_unique_name Database Unique Name
1243 db_writer_processes number of background database writer processes to start
1244 dbwr_io_slaves DBWR I/O slaves
1245 ddl_wait_for_locks Disable NOWAIT DML lock acquisitions
1246 dg_broker_config_file1 data guard broker configuration file #1
1247 dg_broker_config_file2 data guard broker configuration file #2
1248 dg_broker_start start Data Guard broker framework (DMON process)
1249 disk_asynch_io Use asynch I/O for random access devices
1250 dispatchers specifications of dispatchers
1251 distributed_lock_timeout number of seconds a distributed transaction waits for a lock
1252 dml_locks dml locks - one for each table modified in a transaction
1253 drs_start start DG Broker monitor (DMON process)
1254 event debug event control - default null string
1255 fal_client FAL client
1256 fal_server FAL server list
1257 fast_start_io_target Upper bound on recovery reads
1258 fast_start_mttr_target MTTR target of forward crash recovery in seconds
1259 fast_start_parallel_rollback max number of parallel recovery slaves that may be used
1260 file_mapping enable file mapping
1261 fileio_network_adapters Network Adapters for File I/O
1262 filesystemio_options IO operations on filesystem files
1263 fixed_date fixed SYSDATE value
1264 gc_files_to_locks mapping between file numbers and global cache locks
1265 gcs_server_processes number of background gcs server processes to start
1266 global_context_pool_size Global Application Context Pool Size in Bytes
1267 global_names enforce that database links have same name as remote database
1268 hash_area_size size of in-memory hash work area
1269 hi_shared_memory_address SGA starting address (high order 32-bits on 64-bit platforms)
1270 hs_autoregister enable automatic server DD updates in HS agent self-registration
1271 ifile include file in init.ora
1272 instance_groups list of instance group names
1273 instance_name instance name supported by the instance
1274 instance_number instance number
1275 instance_type type of instance to be executed
1276 java_max_sessionspace_size max allowed size in bytes of a Java sessionspace
1277 java_pool_size size in bytes of java pool
1278 java_soft_sessionspace_limit warning limit on size in bytes of a Java sessionspace
1279 job_queue_processes number of job queue slave processes
1280 large_pool_size size in bytes of large pool
1281 ldap_directory_access RDBMS's LDAP access option
1282 license_max_sessions maximum number of non-system user sessions allowed
1283 license_max_users maximum number of named users that can be created in the database
1284 license_sessions_warning warning level for number of non-system user sessions
1285 local_listener local listener
1286 lock_name_space lock name space used for generating lock names for standby/clone database
1287 lock_sga Lock entire SGA in physical memory
1288 log_archive_config log archive config parameter
1289 log_archive_dest archival destination text string
1290 log_archive_dest_1 archival destination #1 text string
1291 log_archive_dest_10 archival destination #10 text string
1292 log_archive_dest_2 archival destination #2 text string
1293 log_archive_dest_3 archival destination #3 text string
1294 log_archive_dest_4 archival destination #4 text string
1295 log_archive_dest_5 archival destination #5 text string
1296 log_archive_dest_6 archival destination #6 text string
1297 log_archive_dest_7 archival destination #7 text string
1298 log_archive_dest_8 archival destination #8 text string
1299 log_archive_dest_9 archival destination #9 text string
1300 log_archive_dest_state_1 archival destination #1 state text string
1301 log_archive_dest_state_10 archival destination #10 state text string
1302 log_archive_dest_state_2 archival destination #2 state text string
1303 log_archive_dest_state_3 archival destination #3 state text string
1304 log_archive_dest_state_4 archival destination #4 state text string
1305 log_archive_dest_state_5 archival destination #5 state text string
1306 log_archive_dest_state_6 archival destination #6 state text string
1307 log_archive_dest_state_7 archival destination #7 state text string
1308 log_archive_dest_state_8 archival destination #8 state text string
1309 log_archive_dest_state_9 archival destination #9 state text string
1310 log_archive_duplex_dest duplex archival destination text string
1311 log_archive_format archival destination format
1312 log_archive_local_first Establish EXPEDITE attribute default value
1313 log_archive_max_processes maximum number of active ARCH processes
1314 log_archive_min_succeed_dest minimum number of archive destinations that must succeed
1315 log_archive_start start archival process on SGA initialization
1316 log_archive_trace Establish archivelog operation tracing level
1317 log_buffer redo circular buffer size
1318 log_checkpoint_interval
  1. redo blocks checkpoint threshold
1319 log_checkpoint_timeout Maximum time interval between checkpoints in seconds
1320 log_checkpoints_to_alert log checkpoint begin/end to alert file
1321 log_file_name_convert logfile name convert patterns and strings for standby/clone db
1322 logmnr_max_persistent_sessions maximum number of threads to mine
1323 max_commit_propagation_delay Max age of new snapshot in .01 seconds
1324 max_dispatchers max number of dispatchers
1325 max_dump_file_size Maximum size (blocks) of dump file
1326 max_enabled_roles max number of roles a user can have enabled
1327 max_shared_servers max number of shared servers
1328 nls_calendar NLS calendar system name
1329 nls_comp NLS comparison
1330 nls_currency NLS local currency symbol
1331 nls_date_format NLS Oracle date format
1332 nls_date_language NLS date language name
1333 nls_dual_currency Dual currency symbol
1334 nls_iso_currency NLS ISO currency territory name
1335 nls_language NLS language name
1336 nls_length_semantics create columns using byte or char semantics by default
1337 nls_nchar_conv_excp NLS raise an exception instead of allowing implicit conversion
1338 nls_numeric_characters NLS numeric characters
1339 nls_sort NLS linguistic definition name
1340 nls_territory NLS territory name
1341 nls_time_format time format
1342 nls_time_tz_format time with timezone format
1343 nls_timestamp_format time stamp format
1344 nls_timestamp_tz_format timestampe with timezone format
1345 object_cache_max_size_percent percentage of maximum size over optimal of the user session's object cache
1346 object_cache_optimal_size optimal size of the user session's object cache in bytes
1347 olap_page_pool_size size of the olap page pool in bytes
1348 open_cursors max # cursors per session
1349 open_links max # open links per session
1350 open_links_per_instance max # open links per instance
1351 optimizer_dynamic_sampling optimizer dynamic sampling
1352 optimizer_features_enable optimizer plan compatibility parameter
1353 optimizer_index_caching optimizer percent index caching
1354 optimizer_index_cost_adj optimizer index cost adjustment
1355 optimizer_mode optimizer mode
1356 optimizer_secure_view_merging optimizer secure view merging and predicate pushdown/movearound
1357 os_authent_prefix prefix for auto-logon accounts
1358 os_roles retrieve roles from the operating system
1359 parallel_adaptive_multi_user enable adaptive setting of degree for multiple user streams
1360 parallel_automatic_tuning enable intelligent defaults for parallel execution parameters
1361 parallel_execution_message_size message buffer size for parallel execution
1362 parallel_instance_group instance group to use for all parallel operations
1363 parallel_max_servers maximum parallel query servers per instance
1364 parallel_min_percent minimum percent of threads required for parallel query
1365 parallel_min_servers minimum parallel query servers per instance
1366 parallel_server if TRUE startup in parallel server mode
1367 parallel_server_instances number of instances to use for sizing OPS SGA structures
1368 parallel_threads_per_cpu number of parallel execution threads per CPU
1369 pga_aggregate_target Target size for the aggregate PGA memory consumed by the instance
1370 plsql_ccflags PL/SQL ccflags
1371 plsql_code_type PL/SQL code-type
1372 plsql_compiler_flags PL/SQL compiler flags
1373 plsql_debug PL/SQL debug
1374 plsql_native_library_dir plsql native library dir
1375 plsql_native_library_subdir_count plsql native library number of subdirectories
1376 plsql_optimize_level PL/SQL optimize level
1377 plsql_v2_compatibility PL/SQL version 2.x compatibility flag
1378 plsql_warnings PL/SQL compiler warnings settings
1379 pre_page_sga pre-page sga for process
1380 processes user processes
1381 query_rewrite_enabled allow rewrite of queries using materialized views if enabled
1382 query_rewrite_integrity perform rewrite using materialized views with desired integrity
1383 rdbms_server_dn RDBMS's Distinguished Name
1384 read_only_open_delayed if TRUE delay opening of read only files until first access
1385 recovery_parallelism number of server processes to use for parallel recovery
1386 recyclebin recyclebin processing
1387 remote_archive_enable remote archival enable setting
1388 remote_dependencies_mode remote-procedure-call dependencies mode parameter
1389 remote_listener remote listener
1390 remote_login_passwordfile password file usage parameter
1391 remote_os_authent allow non-secure remote clients to use auto-logon accounts
1392 remote_os_roles allow non-secure remote clients to use os roles
1393 replication_dependency_tracking tracking dependency for Replication parallel propagation
1394 resource_limit master switch for resource limit
1395 resource_manager_plan resource mgr top plan
1396 resumable_timeout set resumable_timeout
1397 rollback_segments undo segment list
1398 serial_reuse reuse the frame segments
1399 service_names service names supported by the instance
1400 session_cached_cursors Number of cursors to cache in a session.
1401 session_max_open_files maximum number of open files allowed per session
1402 sessions user and system sessions
1403 sga_max_size max total SGA size
1404 sga_target Target size of SGA
1405 shadow_core_dump Core Size for Shadow Processes
1406 shared_memory_address SGA starting address (low order 32-bits on 64-bit platforms)
1407 shared_pool_reserved_size size in bytes of reserved area of shared pool
1408 shared_pool_size size in bytes of shared pool
1409 shared_server_sessions max number of shared server sessions
1410 shared_servers number of shared servers to start up
1411 skip_unusable_indexes skip unusable indexes if set to TRUE
1412 smtp_out_server utl_smtp server and port configuration parameter
1413 sort_area_retained_size size of in-memory sort work area retained between fetch calls
1414 sort_area_size size of in-memory sort work area
1415 spfile server parameter file
1416 sql92_security require select privilege for searched update/delete
1417 sql_trace enable SQL trace
1418 sql_version sql language version parameter for compatibility issues
1419 sqltune_category Category qualifier for applying hintsets
1420 standby_archive_dest standby database archivelog destination text string
1421 standby_file_management if auto then files are created/dropped automatically on standby
1422 star_transformation_enabled enable the use of star transformation
1423 statistics_level statistics level
1424 streams_pool_size size in bytes of the streams pool
1425 tape_asynch_io Use asynch I/O requests for tape devices
1426 thread Redo thread to mount
1427 timed_os_statistics internal os statistic gathering interval in seconds
1428 timed_statistics maintain internal timing statistics
1429 trace_enabled enable KST tracing
1430 tracefile_identifier trace file custom identifier
1431 transactions max. number of concurrent active transactions
1432 transactions_per_rollback_segment number of active transactions per rollback segment
1433 undo_management instance runs in SMU mode if TRUE, else in RBU mode
1434 undo_retention undo retention in seconds
1435 undo_tablespace use/switch undo tablespace
1436 use_indirect_data_buffers Enable indirect data buffers (very large SGA on 32-bit platforms)
1437 use_sigio Use SIGIO signal
1438 user_dump_dest User process dump directory
1439 utl_file_dir utl_file accessible directories list
1440 workarea_size_policy policy used to size SQL working areas (MANUAL/AUTO)

_db_block_buffers

문서정보

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.