|
Undocumented INIT.ORA Parameters
|
| Parameter (1) |
Value |
Desc |
| _affinity_on |
TRUE |
enable/disable affinity at run time |
| _allow_resetlogs_corruption |
FALSE |
allow resetlogs even if it will cause corruption |
| _bump_highwater_mark_count |
0 |
how many blocks should we allocate per free list on advancing HW |
| _controlfile_enqueue_timeout |
900 |
control file enqueue timeout in seconds |
| _corrupt_blocks_on_stuck_recovery |
0 |
number of times to corrupt a block when media recovery stuck |
| _corrupted_rollback_segments |
NULL |
corrupted undo segment list |
| _cr_deadtime |
6 |
global cache lock CR deadlock timeout in seconds |
| _db_block_cache_clone |
FALSE |
Always clone data blocks on get (for debugging) |
| _db_block_cache_protect |
FALSE |
protect database blocks (true only when debugging) |
| _db_block_hash_buckets |
250 |
Number of database block hash buckets |
| _db_block_max_cr_dba |
10 |
Maximum Allowed Number of CR buffers per dba |
| _db_block_max_scan_cnt |
10000 |
Maximum number of buffers to inspect when looking for free |
| _db_block_multiple_hashchain_latches |
TRUE |
Use one latch per hash chain (vs one latch for all changes) |
| _db_block_no_idle_writes |
FALSE |
Disable periodic writes of buffers when idle |
| _db_block_write_batch |
512 |
Number of blocks to group in each DB Writer IO |
| _db_handles |
2100 |
System-wide simultaneous buffer operations |
| _db_handles_cached |
3 |
Buffer handles cached each process |
| _db_large_dirty_queue |
0 |
Number of buffers which force dirty queue to be written |
| _db_no_mount_lock |
FALSE |
do not get a mount lock |
| _db_writer_scan_depth |
0 |
Number of LRU buffers for dbwr to scan when looking for dirty |
| _db_writer_scan_depth_decrement |
0 |
Subtract from dbwr scan depth when dbwr is working too hard |
| _db_writer_scan_depth_increment |
0 |
Add to dbwr scan depth when dbwr is behind |
| _dbwr_slave_batch_size |
1 |
DBWR slave I/O batch size |
| _debug_sga |
FALSE |
debug sga |
| _disable_blocking_waiters |
FALSE |
Don't allow waiters to block PCM lock release |
| _disable_logging |
FALSE |
Disable logging |
| _disable_oracle_resilvering |
FALSE |
disable oracle resilvering for fast instance recovery |
| _enable_dba_locking |
FALSE |
enable persistent locking |
| _enqueue_debug_multi_instance |
FALSE |
debug enqueue multi instance |
| _enqueue_hash |
1145 |
enqueue hash table length |
| _enqueue_hash_chain_latches |
4 |
enqueue hash chain latches |
| _enqueue_locks |
6754 |
locks for managed enqueues |
| _gc_recovery_scan_smon |
FALSE |
if TRUE, do recovery scans in SMON stead of LCK processes |
| _init_sql_file |
?/dbs/sql.bsq |
File containing SQL statements to execute upon database creation |
| _kgl_bucket_count |
0 |
index to the bucket count array |
| _kgl_latch_count |
0 |
number of library cache latches |
| _kgl_multi_instance_invalidation |
TRUE |
whether KGL to support multi-instance invalidations |
| _kgl_multi_instance_lock |
TRUE |
whether KGL to support multi-instance locks |
| _kgl_multi_instance_pin |
TRUE |
whether KGL to support multi-instance pins |
| _latch_recovery_alignment |
60 |
align latch recovery structures |
| _latch_spin_count |
100 |
amount to spin waiting for a latch |
| _latch_wait_posting |
1 |
post sleeping processes when free latch |
| _log_blocks_during_backup |
TRUE |
log block images when changed during backup |
| _log_buffers_debug |
FALSE |
debug redo buffers (slows things down) |
| _log_checkpoint_recovery_check |
0 |
# redo blocks to verify after checkpoint |
| _log_debug_multi_instance |
FALSE |
debug redo multi instance code |
| _log_entry_prebuild_threshold |
0 |
redo entries larger than this will be prebuilt before getting la |
| _log_io_size |
0 |
automatically initiate log write if this many redo blocks in buf |
| _log_space_errors |
TRUE |
should we report space errors to alert log |
| _max_exponential_sleep |
0 |
max sleep during exponential backoff |
| _max_sleep_holding_latch |
4 |
max time to sleep while holding a latch |
| _messages |
1015 |
message queue resources - dependent on # processes & # buffers |
| _minimum_giga_scn |
0 |
Minimum SCN to start with in 2^30 units |
| _mts_fastpath |
TRUE |
dispatcher network fastpath |
| _mts_listener_retry |
120 |
listener connection retry rate (secs) |
| _mts_load_constants |
3,0.75,0.25,0.1 |
server load balancing constants (S,P,D,I) |
| _number_cached_attributes |
10 |
maximum number of cached attributes per instance |
| _offline_rollback_segments |
NULL |
offline undo segment list |
| _optimizer_undo_changes |
FALSE |
undo changes to query optimizer |
| _oracle_trace_events |
NULL |
Oracle TRACE event flags |
| _oracle_trace_facility_version |
NULL |
Oracle TRACE facility version |
| _parallel_allocation |
wide |
allocation method for parallel query servers |
| _parallel_min_message_pool |
19332 |
minimum size of shared pool memory to reserve for pq servers |
| _parallel_server_sleep_time |
10 |
sleep time between dequeue timeouts (in 1/100ths) |
| _passwordfile_enqueue_timeout |
900 |
password file enqueue timeout in seconds |
| _plsql_dump_buffer_events |
NULL |
conditions upon which the PL/SQL circular buffer is dumped |
| _release_insert_threshold |
5 |
maximum number of unusable blocks to unlink from freelist |
| _reuse_index_loop |
5 |
number of blocks being examine for index block reuse |
| _rollback_segment_count |
0 |
number of undo segments |
| _rollback_segment_initial |
1 |
starting undo segment number |
| _row_cache_buffer_size |
200 |
size of row cache circular buffer |
| _row_cache_instance_locks |
100 |
number of row cache instance locks |
| _session_idle_bit_latches |
0 |
one latch per session or a latch per group of sessions |
| _shared_session_sort_fetch_buffer |
0 |
size of in-memory merge buffer for mts or xa fetch calls |
| _single_process |
FALSE |
run without detached processes |
| _small_table_threshold |
512 |
threshold level of table size for forget-bit enabled during scan |
| _sql_connect_capability_override |
0 |
SQL Connect Capability Table Override |
| _sql_connect_capability_table |
NULL |
SQL Connect Capability Table (testing only) |
| _standby_lock_name_space |
NULL |
lock name space used for generating lock names for standby datab |
| _star_transformation_enabled |
FALSE |
enable the use of semi-join transformations |
| _test_param_1 |
25 |
test parmeter 1 |
| _test_param_2 |
NULL |
test parameter 2 |
| _test_param_3 |
NULL |
test parameter 3 |
| _trace_archive_dest |
?/rdbms/log |
trace archival destination |
| _trace_archive_start |
FALSE |
start trace process on SGA initialization |
| _trace_block_size |
2048 |
trace block size |
| _trace_buffers_per_process |
0 |
trace buffers per process |
| _trace_enabled |
TRUE |
Should tracing be enabled at startup |
| _trace_events |
NULL |
turns on and off trace events |
| _trace_file_size |
10000 |
trace file size |
| _trace_files_public |
TRUE |
Create publicly accessible trace files |
| _trace_flushing |
FALSE |
TRWR should try to keep tracing buffers clean |
| _trace_instance_termination |
FALSE |
trace instance termination actions |
| _trace_write_batch_size |
32 |
trace write batch size |
| _wait_for_sync |
TRUE |
wait for sync on commit MUST BE ALWAYS TRUE |
| _wakeup_timeout |
100 |
wakeup monitor timeout value |
| _walk_insert_threshold |
0 |
maximum number of unusable blocks to walk across freelist |