oracle 隐含参数

对于oracle，有一些参数参数是隐含的，可能对于大家常规参数都知道什么意思，但是，当oracle需要处理一些不是常规能解决的问题的时候，可能就需要了解隐含参数了，下面这个参数基本包含了oracle所有的隐含参数。这个参是虽然是到oracle 9i，但是oracle10g以后也基本可以使用

O7_DICTIONARY_ACCESSIBILITY	803, 804, 805, 806, 815, 816, 817, 901, 920	Version 7 Dictionary Accessibility Support
_DECUnix_reserved_1	732, 803, 804, 805, 806
_DECUnix_reserved_2	732, 733, 734, 803, 804, 805, 806
_DECUnix_reserved_3	732, 733, 734, 734, 803, 804, 805, 806
_DECUnix_reserved_4	732, 733, 734, 734, 803, 804, 805, 806
_DECUnix_reserved_5	732, 733, 734, 734, 803, 804, 805, 806
_DECUnix_reserved_6	732, 733, 734, 734, 803, 804, 805, 806
_DECUnix_reserved_7	732, 733, 734, 734, 803, 804, 805, 806
_NUMA_instance_mapping	815, 816, 817, 901, 920	Set of nodes that this instance should run on
_NUMA_pool_size	815, 816, 817, 901, 920	aggregate size in bytes of NUMA pool
_PX_use_large_pool	815, 816, 817, 901, 920	Use Large Pool as source of PX buffers
_abort_recovery_on_join	901, 920	if TRUE, abort recovery on join reconfigurations
_active_standby_fast_reconfiguration	815, 816, 817, 901, 920	if TRUE optimize dlm reconfiguration for active/standby OPS
_adaptive_direct_read	901, 920	Adaptive Direct Read
_adaptive_fetch_enabled	901, 920	enable/disable adaptive fetch in parallel group by
_advanced_dss_features	803, 804, 805, 806, 815, 816, 817, 901	enable advanced dss features
_affinity_on	733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enable/disable affinity at run time
_all_shared_dblinks	803, 804, 805, 806, 815, 816, 817, 901, 920	treat all dblinks as shared
_allocate_creation_order	815, 816, 817, 901, 920	should files be examined in creation order during allocation
_allocation_update_interval	901, 920	interval at which successful search in L1 should be updated
_allow_error_simulation	816, 817, 901, 920	Allow error simulation for testing
_allow_read_only_corruption	815, 816, 817, 901, 920	allow read-only open even if database is corrupt
_allow_resetlogs_corruption	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	allow resetlogs even if it will cause corruption
_allow_terminal_recovery_corruption	920	Finish terminal recovery even if it may cause corruption
_always_anti_join	901, 920	always use this method for anti-join when possible
_always_semi_join	901, 920	always use this method for semi-join when possible
_always_star_transformation	803, 804, 805, 806, 815, 816, 817, 901, 920	always favor use of star transformation
_app_ctx_vers	920	enable app ctx versioning
_aq_tm_scanlimit	817, 901	scan limit for Time Managers to clean up IOT
_arch_io_slaves	815, 816, 817, 901, 920	ARCH I/O slaves
_async_bsp	816, 817, 901	if TRUE, BSP flushes log asynchronously (DFS)
_average_dirties_half_life	815, 816, 817
_async_recovery_claims	901, 920	if TRUE, issue recovery claims asynchronouslyif TRUE, issue recovery claims asynchronously (DFS)
_async_recovery_reads	901, 920	if TRUE, issue recovery reads asynchronouslyif TRUE, issue recovery reads asynchronously (DFS)
_avoid_prepare	901, 920	if TRUE, do not prepare a buffer when the master is localif TRUE, do not prepare a buffer when the master is local (DFS)
_b_tree_bitmap_plans	815, 816, 817, 901, 920	enable the use of bitmap plans for tables w. only B-tree indexes
_backup_disk_io_slaves	815, 816, 817, 901, 920	BACKUP Disk I/O slaves
_backup_io_pool_size	815, 816, 817, 901, 920	memory to reserve from the large pool
_bsp_log_flush	816, 817, 901	if TRUE, flush redo log before serving a CR buffer (DFS)
_bitmap_or_improvement_enabled	920	controls extensions to partition pruning for general predicates
_bump_highwater_mark_count	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	how many blocks should we allocate per free list on advancing HW
_cache_db_files	716, 723, 732, 733, 734
_bwr_for_flushed_pi	920	if TRUE, generate a BWR for a flushed PI (DFS)
_cgs_send_timeout	901, 920	CGS send timeout value
_check_block_after_checksum	816, 817, 901, 920	perform block check after checksum if both are turned on
_cleanup_rollback_entries	815, 816, 817, 901, 920	no. of undo entries to apply per transaction cleanup
_close_cached_open_cursors	815, 816, 817, 901, 920	close cursors cached by PL/SQL at each commit
_collect_undo_stats	901, 920	Collect Statistics v$undostat
_column_elimination_off	803, 804, 805, 806, 815, 816, 817, 901, 920	turn off predicate-only column elimination
_column_tracking_level	901, 920	column usage tracking
_compatible_no_recovery	815, 816, 817, 901, 920	Database will be compatible unless crash or media recovery is ne
_complex_view_merging	815, 816, 817, 901, 920	enable complex view merging
_controlfile_enqueue_timeout	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	control file enqueue timeout in seconds
_corrupt_blocks_on_stuck_recovery	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_corrupted_rollback_segments	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	corrupted undo segment list
_cost_equality_semi_join	920	enables costing of equality semi-join
_cpu_count	716, 901, 920	current number of cpu's for this instance
_cpu_to_io	815, 816, 817, 901, 920	divisor for converting CPU cost to I/O cost
_cr_deadtime	733, 734, 803, 804, 805, 806
_cr_server	815, 816, 817
_cr_server_extn	817
_cr_grant_global_role	901, 920	if TRUE, grant lock for CR requests when block is in global role
_cr_grant_local_role	901, 920	if TRUE, grant lock for CR using 3way ping when block in local r
_cr_server_log_flush	920	if TRUE, flush redo log before serving a CR buffer (DFS)
_cursor_db_buffers_pinned	803, 804, 805, 806, 815, 816, 817, 901, 920	additional number of buffers a cursor can pin at once
_cursor_plan_enabled	901, 920	enable collection and display of cursor plans
_db_aging_cool_count	815, 816, 817, 901, 920	Touch count set when buffer cooled
_db_aging_freeze_cr	815, 816, 817, 901, 920	Make CR buffers always be too cold to keep in cache
_db_aging_hot_criteria	815, 816, 817, 901, 920	Touch count which sends a buffer to head of replacement list
_db_aging_stay_count	815, 816, 817, 901, 920	Touch count set when buffer moved to head of replacement list
_db_aging_touch_time	815, 816, 817, 901, 920	Touch count which sends a buffer to head of replacement list
_db_always_check_system_ts	816, 817, 901, 920	Always perform block check and checksum for System tablespace
_db_block_buffers	901, 920	Number of database blocks cached in memory: hidden parameter
_db_block_cache_clone	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Always clone data blocks on get (for debugging)
_db_block_cache_map	803, 804, 805, 806, 815, 816, 817, 901	Map / unmap and track reference counts on blocks (for debugging)
_db_block_cache_num_umap	920	number of unmapped buffers (for tracking swap calls on blocks)
_db_block_cache_protect	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	protect database blocks (true only when debugging)
_db_block_check_for_debug	816, 817, 901, 920	Check more and dump block before image for debugging
_db_block_compute_checksums	716
_db_block_granule_interval	901, 920	number of lru latches
_db_block_hash_buckets	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Number of database block hash buckets
_db_block_hash_latches	816, 817, 901, 920	Number of database block hash latches
_db_block_hi_priority_batch_size	803, 804, 805, 806, 815, 816, 817, 901, 920	Fraction of writes for high priority reasons
_db_block_lru_latches	901, 920	number of lru latches
_db_block_max_cr_dba	723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Maximum Allowed Number of CR buffers per dba
_db_block_max_scan_cnt	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_db_block_max_dirty_target	901, 920	Upper bound on modified buffers/recovery reads
_db_block_max_scan_pct	901, 920	Percentage of buffers to inspect when looking for free
_db_block_med_priority_batch_size	803, 804, 805, 806, 815, 816, 817, 901, 920	Fraction of writes for medium priority reasons
_db_block_multiple_hashchain_latches	716, 723, 732, 733, 734
_db_block_no_idle_writes	732, 733, 734, 803, 804, 805, 806
_db_block_numa	815, 816, 817, 901, 920	Number of NUMA nodes
_db_block_write_batch	716, 723, 732, 733, 734, 803, 804, 805, 806
_db_cache_advice	817
_db_block_prefetch_quota	901, 920	Prefetch quota as a percent of cache size
_db_block_trace_protect	901, 920	trace buffer protect calls
_db_cache_advice_batch_size	920	cache advisory simulation batch size
_db_cache_advice_sample_factor	920	cache advisory sampling factor
_db_file_direct_io_count	901, 920	Sequential I/O buf size
_db_file_noncontig_mblock_read_count	815, 816, 817, 901, 920	number of noncontiguous db blocks to be prefetched
_db_handles	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	System-wide simultaneous buffer operations
_db_handles_cached	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Buffer handles cached each process
_db_large_dirty_queue	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Number of buffers which force dirty queue to be written
_db_no_mount_lock	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901	do not get a mount lock
_db_mttr_advice	920	MTTR advisory
_db_mttr_partitions	920	number of partitions for MTTR advisory
_db_mttr_sample_factor	920	MTTR simulation sampling factor
_db_mttr_sim_target	920	MTTR simulation targets
_db_mttr_sim_trace_size	920	MTTR simulation trace size
_db_mttr_trace_to_alert	920	dump trace entries to alert file
_db_percent_hot_default	815, 816, 817, 901, 920	Percent of default buffer pool considered hot
_db_percent_hot_keep	815, 816, 817, 901, 920	Percent of keep buffer pool considered hot
_db_percent_hot_recycle	815, 816, 817, 901, 920	Percent of recycle buffer pool considered hot
_db_writer_chunk_writes	815, 816, 817, 901, 920	Number of writes DBWR should wait for
_db_writer_histogram_statistics	815, 816, 817, 901, 920	maintain dbwr histogram statistics in x$kcbbhs
_db_writer_max_writes	815, 816, 817, 901, 920	Max number of outstanding DB Writer IOs
_db_writer_scan_depth	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_db_writer_scan_depth_decrement	716, 723, 732, 733, 734, 803, 804, 805, 806, 815
_db_writer_scan_depth_increment	716, 723, 732, 733, 734, 803, 804, 805, 806, 815
_db_writer_scan_depth_pct	901, 920	Percentage of LRU buffers for dbwr to scan when looking for dirt
_dbg_proc_startup	920	debug process startup
_dbwr_async_io	815, 816, 817, 901, 920	Enable dbwriter asynchronous writes
_dbwr_scan_interval	816, 817, 901, 920	dbwriter scan interval
_dbwr_slave_batch_size	723, 732, 733, 734
_dbwr_tracing	815, 816, 817, 901, 920	Enable dbwriter tracing
_debug_sga	716, 723, 732, 733, 734, 803, 804, 805, 806
_default_non_equality_sel_check	817, 901, 920	sanity check on default selectivity for like/range predicate
_defer_multiple_waiters	815, 816, 817, 901, 920	if TRUE, defer down converts when there were waiters (DFS)
_disable_blocking_waiters	716, 723, 732, 733, 734
_diag_daemon	901, 920	start DIAG daemon
_disable_file_locks	815, 816, 817, 901, 920	disable file locks for control, data, redo log files
_disable_incremental_checkpoints	803, 804, 805, 806, 815, 816, 817, 901, 920	Disable incremental checkpoints for thread recovery
_disable_kcbhxor_osd	920	disable kcbh(c)xor OSD functionality
_disable_latch_free_SCN_writes_via_32cas	803, 804, 805, 806, 815, 816, 817, 901, 920	disable latch-free SCN writes using 32-bit compare & swap
_disable_latch_free_SCN_writes_via_64cas	803, 804, 805, 806, 815, 816, 817, 901, 920	disable latch-free SCN writes using 64-bit compare & swap
_disable_logging	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Disable logging
_disable_oracle_resilvering	733, 734
_disable_multiple_block_sizes	901, 920	disable multiple block size support (for debugging)
_disable_odm	920	disable odm feature
_disable_recoverable_recovery	920	Disable the new recoverable recovery mechanism
_disable_sun_rsm	901, 920	Disable IPC OSD support for Sun RSMAPI
_disable_system_state	920	disable system state dump
_discrete_transactions_enabled	815, 816, 817, 901, 920	enable OLTP mode
_disk_get_lock	816, 817
_dispatcher_rate_scale	901, 920	scale to display rate statistic (100ths of a second)
_dispatcher_rate_ttl	901, 920	time-to-live for rate statistic (100ths of a second)
_distributed_lock_timeout	815, 816, 817, 901	number of seconds a distributed transaction waits for a lock
_distributed_recovery_connection_hold_ti	815, 816, 817
_dlm_domain	716, 723, 732, 733, 734, 803, 804, 805, 806
_distributed_recovery_connection_hold_time	901, 920	number of seconds RECO holds outbound connections open
_dlmtrace	901, 920	Trace string of lock types(s)
_domain_index_batch_size	815, 816, 817, 901, 920	maximum number of rows from one call to domain index fetch routi
_domain_index_dml_batch_size	815, 816, 817, 901, 920	maximum number of rows for one call to domain index dml routines
_dss_cache_flush	803, 804, 805, 806, 815, 816, 817, 901, 920	enable full cache flush for parallel execution
_dump_MTTR_to_trace	815, 816, 817, 901, 920	Dump High Availability MTTR infromation to CKPT trace file
_dump_system_state_scope	920	scope of sysstate dump during instance termination
_dynamic_rls_policies	920	rls policies are dynamic
_dynamic_stats_threshold	803, 804, 805, 806, 815, 816, 817, 901, 920	delay threshold (in seconds) between sending statistics messages
_eliminate_common_subexpr	816, 817, 901, 920	enables elimination of common sub-expressions
_enable_NUMA_optimization	815, 816, 817, 901, 920	Enable NUMA specific optimizations
_enable_block_level_transaction_recovery	815, 816, 817, 901, 920	enable block level recovery
_enable_cscn_caching	803, 804, 805, 806, 815, 816, 817, 901, 920	enable commit SCN caching for all transactions
_enable_dba_locking	732, 733, 734
_enable_default_affinity	815, 816, 817, 901, 920	to enable default implementation of affinity osds
_enable_kgh_policy	901, 920	temporary to disable/enable kgh policy
_enable_list_io	815, 816, 817, 901, 920	Enable List I/O
_enable_multi_statement_pdml	803, 804, 805, 806
_enable_multitable_sampling	815, 816, 817, 901, 920	enable multitable sampling
_enable_type_dep_selectivity	816, 817, 901, 920	enable type dependent selectivity estimates
_enqueue_debug_multi_instance	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	debug enqueue multi instance
_enqueue_hash	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enqueue hash table length
_enqueue_hash_chain_latches	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enqueue hash chain latches
_enqueue_locks	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	locks for managed enqueues
_explain_rewrite_mode	901, 920	allow additional messages to be generated during explain rewrite
_fairness_pi	901	if TRUE, allow spontaneous PI buffers
_fairness_threshold	815, 816, 817, 901, 920	number of times to CR serve before downgrading lock (DFS)
_fast_full_scan_enabled	803, 804, 805, 806, 815, 816, 817, 901, 920	enable/disable index fast full scan
_fifth_spare_parameter	815, 816, 817, 901, 920	fifth spare parameter - string
_filesystemio_options	817, 901	IO operations on filesystem files
_first_spare_parameter	815, 816, 817, 901, 920	first spare parameter - integer
_foreground_locks	815
_force_datefold_trunc	920	force use of trunc for datefolding rewrite
_force_temptables_for_gsets	901, 920	executes concatenation of rollups using temp tables
_fourth_spare_parameter	815, 816, 817, 901, 920	fourth spare parameter - string
_freeze_DB_for_fast_instance_recovery	815, 816, 817
_full_pwise_join_enabled	815, 816, 817, 901, 920	enable full partition-wise join when TRUE
_gc_bsp_procs	816, 817, 901	number of buffer server processes to start (DFS)
_gc_class_locks	803, 804, 805, 806, 815, 816, 817
_gby_onekey_enabled	920	enable use of one comparison of all group by keys
_gc_defer_time	901, 920	how long to defer down converts for hot buffers (DFS)
_gc_integrity_checks	920	if TRUE, enable expensive integrity checks (DFS)
_gc_latches	815, 816, 817, 901, 920	number of latches per lock process (DFS)number of latches per LMS process (DFS)
_gc_lck_procs	815, 816, 817, 901	number of background parallel server lock processes to start
_gc_recovery_scan_smon	723, 732, 733, 734
_gc_releasable_locks	901	number of global cache locks (DFS)
_gcs_fast_reconfig	920	if TRUE, enable fast reconfiguration for gcs locks
_gcs_latches	920	number of gcs resource hash latches to be allocated
_gcs_resources	920	number of gcs resources to be allocated
_generalized_pruning_enabled	920	controls extensions to partition pruning for general predicates
_groupby_nopushdown_cut_ratio	815, 816, 817, 901, 920	groupby nopushdown cut ratio
_groupby_orderby_combine	816, 817, 901, 920	groupby/orderby don't combine threshold
_gs_anti_semi_join_allowed	901, 920	enable anti/semi join for the GS query
_hard_protection	920	if TRUE enable H.A.R.D specific format changes
_hash_multiblock_io_count	901, 920	number of blocks hash join will read/write at once
_high_server_threshold	815, 816, 817, 901, 920	high server thresholds
_huge_sga_base_address	716
_idl_conventional_index_maintenance	803, 804, 805, 806, 815, 816, 817, 901, 920	enable conventional index maintenance for insert direct load
_ignore_desc_in_index	816, 817, 901, 920	ignore DESC in indexes, sort those columns ascending anyhow
_ignore_failed_escalates	803, 804, 805, 806
_improved_outerjoin_card	816, 817, 901, 920	improved outer-join cardinality calculation
_improved_row_length_enabled	815, 816, 817, 901, 920	enable the improvements for computing the average row length
_imr_active	901, 920	Activate Instance Membership Recovery feature
_imr_max_reconfig_delay	901, 920	Maximum Reconfiguration delay (seconds)
_imr_splitbrain_res_wait	920	Maximum wait for split-brain resolution (seconds)
_index_join_enabled	816, 817, 901, 920	enable the use of index joins
_index_prefetch_factor	815, 816, 817, 901, 920	index prefetching factor
_init_sql_file	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	File containing SQL statements to execute upon database creation
_insert_enable_hwm_brokered	901, 920	during parallel inserts high water marks are brokered
_inst_locking_period	901, 920	period an instance can retain a newly acquired level1 bitmap
_instance_type	920	type of instance to be executed
_interconnect_checksum	816, 817, 901, 920	if TRUE, checksum interconnect blocks (DFS)
_intrapart_pdml_enabled	920	Enable intra-partition updates/deletes
_io_slaves_disabled	803, 804, 805, 806, 815, 816, 817, 901, 920	Do not use I/O slaves
_ioslave_batch_count	803, 804, 805, 806, 815, 816, 817, 901, 920	Per attempt IOs picked
_ioslave_issue_count	803, 804, 805, 806, 815, 816, 817, 901, 920	IOs issued before completion check
_ipc_fail_network	816, 817, 901, 920	Simulate cluster network failer
_ipc_test_failover	816, 817, 901, 920	Test transparent cluster network failover
_ipc_test_mult_nets	816, 817, 901, 920	simulate multiple cluster networks
_ipq_use_udp	733, 734
_job_queue_interval	901, 920	Wakeup interval in seconds for job queue co-ordinator
_kcl_commit	920	if TRUE, call kjbcommit (DFS)
_kcl_conservative_log_flush	920	if TRUE, conservatively log flush before CR serving (DFS)
_kcl_debug	815, 816, 817, 901, 920	if TRUE, record le history (DFS)
_kcl_dispatch	901	if TRUE, dispatch requests to bsp and lck (DFS)
_kcl_index_split	920	if TRUE, reject pings on blocks in middle of a split (DFS)
_kcl_local_file_time	920	how often to check for local files (DFS)
_kcl_name_table_latches	901, 920	number of name table latches (DFS)
_kcl_partition	901	if TRUE, dynamically remaster partitioned files (DFS)
_kcl_recovery_read_batch	920	recovery read batch size (DFS)
_kcl_undo_grouping	920	grouping for undo block locks (DFS)
_kcl_undo_locks	920	number of locks per undo segment (DFS)
_kcl_use_cr	901, 920	if TRUE, use Fusion CR buffers (DFS)
_kdbl_enable_post_allocation	901, 920	allocate dbas after populating data buffers
_keep_recovery_buffers	901, 920	if TRUE, make recovery buffers currentif TRUE, make recovery buffers current (DFS)
_keep_remote_column_size	901, 920	remote column size does not get modified
_kghdsidx_count	901, 920	max kghdsidx count
_kgl_bucket_count	723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	index to the bucket count array
_kgl_latch_count	723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	number of library cache latches
_kgl_multi_instance_invalidation	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	whether KGL to support multi-instance invalidations
_kgl_multi_instance_lock	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	whether KGL to support multi-instance locks
_kgl_multi_instance_pin	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	whether KGL to support multi-instance pins
_kglsim_maxmem_percent	920	max percentage of shared pool size to be used for KGL advice
_kkfi_trace	815, 816, 817, 901, 920	trace expression substitution
_kolfuseslf	920	allow kolf to use slffopen
_ksdxw_cini_flg	920	ksdxw context initialization flag
_ksdxw_nbufs	920	ksdxw number of buffers in buffered mode
_ksdxw_num_pgw	920	number of watchpoints on a per-process basis
_ksdxw_num_sgw	920	number of watchpoints to be shared by all processes
_ksdxw_stack_depth	920	number of PCs to collect in the stack when watchpoint is hit
_ksi_trace	816, 817, 901, 920	KSI trace string of lock type(s)
_ksmg_granule_locking_status	920	granule locking status
_ksmg_granule_size	901, 920	granule size in bytes
_ksu_diag_kill_time	901, 920	number of seconds ksuitm waits before killing diag
_ktc_latches	920	number of ktc latches
_ktu_latches	920	number of KTU latches
_large_pool_min_alloc	815, 816, 817, 901, 920	minimum allocation size in bytes for the large allocation pool
_last_allocation_period	901, 920	period over which an instance can retain an active level1 bitmap
_latch_class_0	920	latch class 0
_latch_class_1	920	latch class 1
_latch_class_2	920	latch class 2
_latch_class_3	920	latch class 3
_latch_class_4	920	latch class 4
_latch_class_5	920	latch class 5
_latch_class_6	920	latch class 6
_latch_class_7	920	latch class 7
_latch_classes	920	latch classes override
_latch_miss_stat_sid	815, 816, 817, 901, 920	Sid of process for which to collect latch stats
_latch_recovery_alignment	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	align latch recovery structures
_latch_spin_count	716, 723, 732, 733, 734
_latch_wait_posting	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_lazy_freelist_close	815, 816, 817
_le_lru_scan	817
_ldr_io_size	901, 920	size of write IOs used during a load operation
_left_nested_loops_random	815, 816, 817, 901, 920	enable random distribution method for left of nestedloops
_lgwr_async_io	815, 816, 817, 901, 920	LGWR Asynchronous IO enabling boolean flag
_lgwr_delay_write	920	LGWR write delay for debugging
_lgwr_io_slaves	815, 816, 817, 901, 920	LGWR I/O slaves
_lgwr_max_ns_wt	901, 920	Maximum wait time for lgwr to allow NetServer to progress
_lgwr_ns_nl_max	901, 920	Variable to simulate network latency
_lgwr_ns_nl_min	901, 920	Variable to simulate network latency
_lgwr_ns_sim_err	901, 920	Variable to simulate errors during lgwr-network server testingVariable to simulate errors lgwrns
_library_cache_advice	920	whether KGL advice should be turned on
_like_with_bind_as_equality	816, 817, 901, 920	treat LIKE predicate with bind as an equality predicate
_lm_ast_option	803, 804, 805, 806, 815, 816, 817
_lm_activate_lms_threshold	901, 920	threshold value to activate an additional lms
_lm_cache_lvl0_cleanup	920	how often to cleanup level 0 cache res (in sec)
_lm_cache_res_cleanup	816, 817, 901, 920	percentage of cached resources should be cleanup
_lm_cache_res_type	920	cache resource: string of lock types(s)
_lm_dd_interval	816, 817, 901, 920	dd time interval in seconds
_lm_direct_sends	803, 804, 805, 806, 815, 816, 817, 901, 920	Processes which will do direct lock manager sendsProcesses which will do direct sends
_lm_dlmd_procs	803, 804, 805, 806, 815, 816, 817
_lm_domains	803, 804, 805, 806, 815, 816, 817
_lm_groups	803, 804, 805, 806, 815, 816, 817
_lm_dispatch_nonpcm	901	dispatching non-pcm messages to LMS
_lm_dispatch_pcm	901	dispatching pcm messages to LMS
_lm_drm_window	920	dynamic remastering bucket window size
_lm_dynamic_lms	901, 920	dynamic lms invocation
_lm_dynamic_load	920	dynamic load adjustment
_lm_dynamic_remastering	901, 920	if TRUE enables dynamic remastering
_lm_enq_lock_freelist	920	Number of ges enqueue element freelist
_lm_enq_rcfg	920	if TRUE enables enqueue reconfiguration
_lm_enqeue_freelist	920	Number of enqueue freelist
_lm_file_affinity	920	mapping between file id and master instance number
_lm_lmd_waittime	920	default wait time for lmd
_lm_lms	901, 920	number of background lock manager server processes to startnumber of background global cache server processes to start
_lm_lms_waittime	920	default wait time for lms
_lm_locks	901, 920	number of locks configured for the lock managernumber of enqueues configured for cluster database
_lm_master_weight	901, 920	master resource weight for this instance
_lm_max_lms	901, 920	max. number of background lock manager server processesmax. number of background global cache server processes
_lm_min_lms	901, 920	min. number of background lock manager server processesmin. number of background global cache server processes
_lm_msg_batch_size	901, 920	DLM batch message sizeGES batch message size
_lm_msg_cache_thresholds	920	GES message buffer caching threshold
_lm_msg_cleanup_interval	920	GES message buffer cleanup interval time
_lm_node_join_opt	901, 920	lock manager node join optimization in reconfigcluster database node join optimization in reconfig
_lm_non_fault_tolerant	803, 804, 805, 806, 815, 816, 817, 901, 920	disable lock manager fault-tolerance modedisable cluster database fault-tolerance mode
_lm_num_pcmhv_latches	920	number of latches covering the PCM HV buckets in cgs
_lm_proc_freeze_timeout	901, 920	reconfiguration: process freeze timeout
_lm_process_batching	920	GES implicit process batching for IPC messages
_lm_procs	816, 817, 901, 920	number of client processes configured for the lock managernumber of client processes configured for cluster database
_lm_rcfg_timeout	920	Reconfiguration timeout
_lm_rcv_buffer_size	816, 817, 901, 920	the size of receive buffer
_lm_res_cache	817
_lm_res_cache_interval	817
_lm_res_hash_bucket	920	number of resource hash buckets
_lm_res_part	901, 920	number of resource partition configured for the lock managernumber of resource partition configured for gcs
_lm_ress	901, 920	number of resources configured for the lock managernumber of resources configured for cluster database
_lm_send_buffers	803, 804, 805, 806, 815, 816, 817, 901, 920	number of lock manager send buffersnumber of cluster database send buffers
_lm_statistics	803, 804, 805, 806, 815, 816, 817
_lm_send_queue_batching	920	GES send queue message batching
_lm_send_queue_length	901, 920	KJCT send queue maximum lengthGES send queue maximum length
_lm_share_lock_opt	920	if TRUE enables share lock optimization
_lm_sq_batch_factor	920	GES send queue minimum batching factor
_lm_sync_timeout	816, 817, 901, 920	Synchronization timeout for DLM reconfiguration steps
_lm_ticket_active_sendback	817, 901, 920	Flow control ticket active sendback threshold
_lm_tickets	901, 920	DLM messaging ticketsGES messaging tickets
_lm_tx_delta	901, 920	TX lock localization delta
_lm_validate_resource_type	901, 920	if TRUE enables resource name validation
_lm_xids	803, 804, 805, 806, 815, 816, 817, 901, 920	number of transaction IDs configured for the lock managernumber of transaction IDs configured for cluster database
_load_without_compile	920	Load PL/SQL or Database objects without compilation
_local_communication_costing_enabled	901, 920	enable local communication costing when TRUE
_local_communication_ratio	901, 920	set the ratio between global and local communication (0..100)
_lock_sga_areas	815, 816, 817, 901, 920	Lock specified areas of the SGA in physical memory
_log_archive_buffer_size	815, 816, 817, 901, 920	Size of each archival buffer in log file blocks
_log_archive_buffers	815, 816, 817, 901, 920	Number of buffers to allocate for archiving
_log_archive_callout	920	archival callout
_log_archive_delta_sync_wait	920	iterative sleep time in centiseconds seconds when SYNC=PARALLEL
_log_archive_net_timeout	920	maximum network wait time in seconds when SYNC=PARALLEL
_log_blocks_during_backup	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	log block images when changed during backup
_log_buffers_corrupt	816, 817, 901, 920	corrupt redo buffers before write
_log_buffers_debug	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	debug redo buffers (slows things down)
_log_checkpoint_recovery_check	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	# redo blocks to verify after checkpoint
_log_committime_block_cleanout	920	Log commit-time block cleanout
_log_debug_multi_instance	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	debug redo multi instance code
_log_entry_prebuild_threshold	716, 723, 732, 733, 734, 803, 804, 805, 806
_log_file_block_size	733, 734
_log_io_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	automatically initiate log write if this many redo blocks in buf
_log_simultaneous_copies	815, 816, 817, 901, 920	number of simultaneous copies into redo buffer(# of copy latches
_log_space_errors	723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	should we report space errors to alert log
_log_switch_timeout	901, 920	Maximum number of seconds redos in the current log could span
_low_server_threshold	815, 816, 817, 901, 920	low server thresholds
_master_direct_sends	901, 920	direct sends for messages from master (DFS)
_mav_refresh_consistent_read	920	refresh materialized views using consistent read snapshot
_mav_refresh_double_count_prevented	920	materialized view MAV refreshes avoid double counting
_mav_refresh_opt	901, 920	optimizations during refresh of materialized views
_mav_refresh_unionall_tables	901, 920	# tables for union all expansion during materialized view refres
_max_exponential_sleep	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max sleep during exponential backoff
_max_sleep_holding_latch	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max time to sleep while holding a latch
_max_transaction_branches	815, 816, 817
_messages	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	message queue resources - dependent on # processes & # buffers
_minimal_stats_aggregation	817, 901, 920	prohibit stats aggregation at compile/partition maintenance time
_minimum_giga_scn	723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Minimum SCN to start with in 2^30 units
_mts_fastpath	716, 723, 732, 733, 734
_mts_listener_retry	716, 723, 732, 733, 734
_mts_load_constants	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_mts_rate_log_size	815
_mts_rate_scale	815, 816, 817
_mts_rate_ttl	816, 817
_multi_join_key_table_lookup	901, 920	TRUE iff multi-join-key table lookup prefetch is enabled
_mv_refresh_delta_fraction	901, 920	delta mv as fractional percentage of size of mv
_mv_refresh_eut	901, 920	refresh materialized views using EUT(partition)-based algorithm
_mv_refresh_new_setup_disabled	920	materialized view MV refresh new setup disabling
_mv_refresh_selections	817, 901, 920	create materialized views with selections and fast refresh
_mv_refresh_use_stats	901, 920	pass cardinality hints to refresh queries
_nchar_imp_cnv	901, 920	NLS allow Implicit Conversion between CHAR and NCHAR
_ncmb_readahead_enabled	815, 816, 817, 901, 920	enable multi-block readahead for an index scan
_ncmb_readahead_tracing	815, 816, 817, 901, 920	turn on multi-block readahead tracing
_nested_loop_fudge	815, 816, 817, 901, 920	nested loop fudge
_new_connect_by_enabled	816, 817
_nested_mav_fast_oncommit_enabled	920	nested MAV refresh fast on commit allowed
_new_initial_join_orders	817, 901, 920	enable initial join orders based on new ordering heuristics
_new_sort_cost_estimate	901, 920	enables the use of new cost estimate for sort
_no_objects	803, 804, 805, 806, 815, 816, 817, 901, 920	no object features are used
_no_or_expansion	815, 816, 817, 901, 920	OR expansion during optimization disabled
_no_preempt	803, 804, 805, 806
_no_status_for_current	815
_ns_max_flush_wt	901, 920	Flush wait time for NetServer to flush oustanding writes
_num_longop_child_latches	920	number of child latches for long op array
_number_cached_attributes	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maximum number of cached attributes per instance
_object_statistics	920	enable the object level statistics collection
_offline_rollback_segments	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	offline undo segment list
_ogms_home	815, 816, 817, 901, 920	GMS home directory
_olap_aggregate_buffer_size	920	OLAP Aggregate max buffer size
_olap_aggregate_child_fragment_size	920	OLAP Aggregate child fragment size
_olap_aggregate_child_max_size	920	OLAP Aggregate child list max size
_olap_aggregate_function_cache_enabled	920	OLAP Aggregate function cache enabler
_olap_aggregate_function_merge_threshold	920	OLAP Aggregate function merge threshold
_olap_aggregate_max_thread_tuples	920	OLAP Aggregate max thread tuples creation
_olap_aggregate_min_buffer_size	920	OLAP Aggregate min buffer size
_olap_aggregate_min_thread_status	920	OLAP Aggregate minimum cardinality of dimensions for thread
_olap_aggregate_statlen_thresh	920	OLAP Aggregate status array usage threshold
_olap_aggregate_store_probability	920	OLAP Aggregate function storeback probability
_olap_aggregate_work_per_thread	920	OLAP Aggregate max work parents
_olap_aggregate_worklist_max	920	OLAP Aggregate max worklists generated at once
_olap_allocate_errorlog_format	920	OLAP Allocate Errorlog Format
_olap_allocate_errorlog_header	920	OLAP Allocate Errorlog Header format
_olap_continuous_trace_file	920	Specify TRUE to enable continuous OLAP tracing - otherwise only
_olap_dimsave_restore_cache_values	920	OLAP Dimsave restores cached dimension values
_olap_eif_export_lob_size	920	OLAP EIF Export BLOB size
_olap_parallel_update_threshold	920	OLAP parallel update threshold in pages
_olap_poutlog_echo_to_eventlog	920	OLAP POutLog copy output to event log (tracefile)
_old_connect_by_enabled	901, 920	enable/disable old connect by
_omf	920	enable/disable OMF
_oneside_colstat_for_equijoins	817, 901, 920	sanity check on default selectivity for like/range predicate
_open_files_limit	803, 804, 805, 806, 815, 816, 817, 901, 920	Limit on number of files opened by I/O subsystem
_optim_adjust_for_part_skews	920	adjust stats for skews across partitions
_optim_enhance_nnull_detection	816, 817, 901, 920	TRUE to enable index [fast] full scan more often
_optim_new_default_join_sel	901, 920	improves the way default equijoin selectivity are computed
_optim_peek_user_binds	901, 920	enable peeking of user binds
_optimizer_adjust_for_nulls	816, 817, 901, 920	adjust selectivity for null values
_optimizer_choose_permutation	816, 817, 901, 920	force the optimizer to use the specified permutation
_optimizer_cost_model	901, 920	optimizer cost model
_optimizer_degree	816, 817, 901, 920	force the optimizer to use the same degree of parallelism
_optimizer_dyn_smp_blks	920	number of blocks for optimizer dynamic sampling
_optimizer_mode_force	816, 817, 901, 920	force setting of optimizer mode for user recursive SQL also
_optimizer_new_mbio	901	enables the use of new costing I/O with mbio
_optimizer_new_join_card_computation	920	compute join cardinality using non-rounded input values
_optimizer_percent_parallel	901, 920	optimizer percent parallel
_optimizer_search_limit	816, 817, 901, 920	optimizer search limit
_optimizer_system_stats_usage	920	system statistics usage
_optimizer_undo_changes	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	undo changes to query optimizer
_optimizer_undo_cost_change	920	optimizer undo cost change
_or_expand_nvl_predicate	816, 817, 901, 920	enable OR expanded plan for NVL/DECODE predicate
_oracle_trace_events	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Oracle TRACE event flags
_oracle_trace_facility_version	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Oracle TRACE facility version
_ordered_nested_loop	815, 816, 817, 901, 920	enable ordered nested loop costing
_ordered_semijoin	816, 817, 901, 920	enable ordered semi-join subquery
_parallel_adaptive_max_users	815, 816, 817, 901, 920	maximum number of users running with default DOP
_parallel_allocation	716, 723, 732, 733, 734
_parallel_broadcast_enabled	920	enable broadcasting of small inputs to hash and sort merge joins
_parallel_default_max_instances	815, 816, 817, 901, 920	default maximum number of instances for parallel query
_parallel_execution_message_align	815, 816, 817, 901, 920	Alignment of PX buffers to OS page boundary
_parallel_fake_class_pct	815, 816, 817, 901, 920	fake db-scheduler percent used for testing
_parallel_load_bal_unit	815, 816, 817, 901, 920	number of threads to allocate per instance
_parallel_load_balancing	815, 816, 817, 901, 920	parallel execution load balanced slave allocation
_parallel_min_message_pool	732, 733, 734, 815, 816, 817, 901, 920	minimum size of shared pool memory to reserve for pq servers
_parallel_recovery_stopat	815, 816, 817, 901, 920	stop at -position- to step through SMON
_parallel_server_idle_time	815, 816, 817, 901, 920	idle time before parallel query server dies
_parallel_server_sleep_time	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	sleep time between dequeue timeouts (in 1/100ths)
_parallel_txn_global	816, 817, 901, 920	enable parallel_txn hint with updates and deletes
_parallelism_cost_fudge_factor	815, 816, 817, 901, 920	set the parallelism cost fudge factor
_partial_pwise_join_enabled	815, 816, 817, 901, 920	enable partial partition-wise join when TRUE
_passwordfile_enqueue_timeout	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	password file enqueue timeout in seconds
_pcm_fast_reconfig	901	if TRUE, enable fast reconfiguration for pcm locks
_pcm_latches	901	number of pcm resource hash latches to be allocated
_pcm_resources	901	number of pcm resources to be allocated
_pcm_shadow_locks	901, 920	number of pcm shadow locks to be allocated
_pct_refresh_double_count_prevented	920	materialized view PCT refreshes avoid double counting
_pdml_gim_sampling	815, 816, 817, 901, 920	control separation of global index maintenance for PDML
_pdml_gim_staggered	816, 817, 901, 920	slaves start on different index when doing index maint
_pdml_slaves_diff_part	815, 816, 817, 901, 920	slaves start on different partition when doing index maint
_pga_max_size	901, 920	Maximum size of the PGA memory for one process
_ping_level	901, 920	fusion ping level (DFS)
_plsql_dump_buffer_events	815, 816, 817, 901, 920	conditions upon which the PL/SQL circular buffer is dumped
_plsql_load_without_compile	816, 817, 901	PL/SQL load without compilation flag
_pmon_load_constants	901, 920	server load balancing constants (S,P,D,I,L,C,M)
_pre_rewrite_push_pred	920	push predicates into views before rewrite
_precompute_gid_values	920	precompute gid values and copy them before returning a row
_pred_move_around	901, 920	enables predicate move-around
_predicate_elimination_enabled	803, 804, 805, 806, 815, 816, 817, 901, 920	allow predicate elimination if set to TRUE
_project_view_columns	815, 816, 817, 901, 920	enable projecting out unreferenced columns of a view
_push_join_predicate	815, 816, 817, 901, 920	enable pushing join predicate inside a view
_push_join_union_view	816, 817, 901, 920	enable pushing join predicate inside a union view
_px_async_getgranule	817, 901, 920	asynchronous get granule in the slave
_px_broadcast_fudge_factor	815, 816, 817, 901, 920	set the tq broadcasting fudge factor percentage
_px_broadcast_trace	815
_px_disable_broadcast	803, 804, 805, 806
_px_dynamic_opt	920	turn off/on restartable qerpx dynamic optimization
_px_dynamic_sample_size	920	num of samples for restartable qerpx dynamic optimization
_px_granule_size	815, 816, 817, 901, 920	default size of a rowid range granule (in KB)
_px_index_sampling	815, 816, 817, 901, 920	parallel query sampling for index create (100000 = 100%)
_px_kxib_tracing	815, 816, 817, 901, 920	turn on kxib tracing
_px_load_publish_interval	815, 816, 817, 901, 920	interval at which LMON will check whether to publish PX load
_px_max_granules_per_slave	815, 816, 817, 901, 920	maximum number of rowid range granules to generate per slave
_px_min_granules_per_slave	815, 816, 817, 901, 920	minimum number of rowid range granules to generate per slave
_px_no_stealing	815, 816, 817, 901, 920	prevent parallel granule stealing in shared nothing environment
_px_trace	901, 920	px trace parameter
_query_cost_rewrite	815, 816, 817, 901, 920	perform the cost based rewrite with materialized views
_query_rewrite_1	901, 920	perform query rewrite before&after or only before view merging
_query_rewrite_2	815, 816, 817, 901, 920	perform query rewrite before&after or only after view merging
_query_rewrite_drj	920	mv rewrite and drop redundant joins
_query_rewrite_expression	816, 817, 901, 920	rewrite with cannonical form for expressions
_query_rewrite_fpc	920	mv rewrite fresh partition containment
_query_rewrite_fudge	816, 817, 901, 920	cost based query rewrite with MVs fudge factor
_query_rewrite_jgmigrate	920	mv rewrite with jg migration
_query_rewrite_maxdisjunct	920	query rewrite max disjuncts
_query_rewrite_or_error	901, 920	allow query rewrite, if referenced tables are not dataless
_query_rewrite_vop_cleanup	816, 817, 901, 920	prune frocol chain before rewrite after view-merging
_realfree_heap_free_threshold	901, 920	threshold for performing real-free, in Kbytes
_realfree_heap_max_size	901, 920	minimum max total heap size, in Kbytes
_realfree_heap_mode	920	mode flags for real-free heap
_recovery_asserts	920	if TRUE, enable expensive recovery sanity checks (DFS)
_recovery_claim_batch_size	901, 920	number of messages to batch in a recovery claim message (DFS)
_recovery_percentage	901, 920	recovery buffer cache percentage
_release_insert_threshold	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maximum number of unusable blocks to unlink from freelist
_reliable_block_sends	901, 920	if TRUE, block sends across interconnect are reliable
_reuse_index_loop	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	number of blocks being examine for index block reuse
_rollback_segment_count	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	number of undo segments
_rollback_segment_initial	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	starting undo segment number
_row_cache_buffer_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901	size of row cache circular buffer
_row_cache_cursors	815, 816, 817, 901, 920	number of cached cursors for row cache management
_row_cache_instance_locks	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901	number of row cache instance locks
_save_escalates	803, 804, 805, 806, 815
_row_cr	920	enable row cr for all sql
_rowsource_execution_statistics	920	if TRUE, Oracle will collect rowsource level statistics
_scn_scheme	815, 816, 817, 901, 920	SCN scheme
_second_spare_parameter	815, 816, 817, 901, 920	second spare parameter - integer
_send_ast_to_foreground	920	if TRUE, send ast message to foreground
_send_close_with_block	901, 920	if TRUE, send close with block even with direct sends
_send_requests_to_PI	920	if TRUE, try to send CR requests to PI buffers (DFS)
_serial_direct_read	815, 816, 817, 901, 920	enable direct read in serial
_session_idle_bit_latches	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	one latch per session or a latch per group of sessions
_seventh_spare_parameter	901, 920	seventh spare parameter - string list
_shared_pool_reserved_min_alloc	815, 816, 817, 901, 920	minimum allocation size in bytes for reserved area of shared poo
_shared_session_sort_fetch_buffer	723, 732, 733, 734, 803, 804, 805, 806
_shared_pool_reserved_pct	901, 920	percentage memory of the shared pool allocated for the reserved
_shrunk_aggs_disable_threshold	901, 920	percentage of exceptions at which to switch to full length aggs
_shrunk_aggs_enabled	901, 920	enable use of variable sized buffers for non-distinct aggregates
_side_channel_batch_size	901, 920	number of messages to batch in a side channel message (DFS)
_side_channel_batch_timeout	920	timeout before shipping out all the batched side channel message
_single_process	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	run without detached processes
_sixth_spare_parameter	901, 920	sixth spare parameter - string list
_skip_assume_msg	901, 920	if TRUE, skip assume message for consigns at the master
_slave_mapping_enabled	901, 920	enable slave mapping when TRUE
_slave_mapping_group_size	901, 920	force the number of slave group in a slave mapper
_small_table_threshold	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	threshold level of table size for direct reads
_smm_advice_enabled	920	if TRUE, enable v$pga_advice
_smm_advice_log_size	920	overwrites default size of the PGA advice workarea history log
_smm_auto_cost_enabled	901, 920	if TRUE, use the AUTO size policy cost functions
_smm_auto_max_io_size	901, 920	Maximum IO size (in KB) used by sort/hash-join in auto mode
_smm_auto_min_io_size	901, 920	Minimum IO size (in KB) used by sort/hash-join in auto mode
_smm_bound	901, 920	overwrites memory manager automatically computed bound
_smm_control	901, 920	provides controls on the memory manager
_smm_max_size	901, 920	maximum work area size in auto mode (serial)
_smm_min_size	901, 920	minimum work area size in auto mode
_smm_px_max_size	901, 920	maximum work area size in auto mode (global)
_smm_trace	901, 920	Turn on/off tracing for SQL memory manager
_smon_consume_post	920	consume any extra posts after completion of transaction recovery
_smon_internal_errlimit	901, 920	limit of SMON internal errors
_smu_debug_mode	901, 920	<debug-flag> - set debug event for testing SMU operations
_smu_error_simulation_site	901, 920	site ID of error simulation in KTU code
_smu_error_simulation_type	901, 920	error type for error simulation in KTU code
_sort_elimination_cost_ratio	816, 817, 901, 920	cost ratio for sort eimination under first_rows mode
_sort_multiblock_read_count	901, 920	multi-block read count for sort
_sort_space_for_write_buffers	815, 816, 817, 901, 920	tenths of sort_area_size devoted to direct write buffers
_sort_use_os_files_as_temporaries	716, 723, 732
_sortmerge_inequality_join_off	817, 901, 920	turns off sort-merge join on inequality
_spin_count	815, 816, 817, 901, 920	Amount to spin waiting for a latch
_spin_cpu_yield_freq	803, 804, 805, 806
_sql_connect_capability_code	716
_sql_connect_capability_override	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	SQL Connect Capability Table Override
_sql_connect_capability_table	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	SQL Connect Capability Table (testing only)
_sqlexec_progression_cost	816, 817, 901, 920	sql execution progression monitoring cost threshold
_standby_lock_name_space	732, 733, 734
_star_transformation_enabled	733, 734
_subquery_pruning_cost_factor	816, 817, 901, 920	subquery pruning cost factor
_subquery_pruning_enabled	816, 817, 901, 920	enable the use of subquery predicates to perform pruning
_subquery_pruning_mv_enabled	920	enable the use of subquery predicates with MVs to perform prunin
_subquery_pruning_reduction	816, 817, 901, 920	subquery pruning reduction factor
_switch_on_stuck_recovery	716, 723
_system_index_caching	901, 920	optimizer percent system index caching
_system_trig_enabled	815, 816, 817, 901, 920	are system triggers enabled
_table_lookup_prefetch_size	901, 920	table lookup prefetch vector size
_table_lookup_prefetch_thresh	920	table lookup prefetch threshold
_table_scan_cost_plus_one	816, 817, 901, 920	bump estimated full table scan cost by onebump estimated full table scan and index ffs cost by one
_temp_tran_block_threshold	816, 817, 901, 920	number of blocks for a dimension before we temp transform
_temp_tran_cache	816, 817, 901, 920	determines if temp table is created with cache option
_test_ksusigskip	920	test the function ksusigskip
_test_param_1	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	test parmeter 1 - integer
_test_param_2	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	test parameter 2 - string
_test_param_3	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	test parameter 3 - string
_test_param_4	901, 920	test parameter 4 - string list
_test_param_5	901, 920	test parmeter 5 - deprecated integer
_test_param_6	901, 920	test parmeter 6 - size (ub8)
_third_spare_parameter	815, 816, 817, 901, 920	third spare parameter - integer
_tq_dump_period	815, 816, 817, 901, 920	time period for duping of TQ statistics (s)
_trace_archive_dest	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_trace_archive_start	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_trace_block_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_trace_archive	901, 920	start DIAG process
_trace_buffer_flushes	815, 816, 817, 901, 920	trace buffer flushes if otrace cacheIO event is set
_trace_buffer_gets	817, 901, 920	trace kcb buffer gets if otrace cacheIO event is set
_trace_buffers_per_process	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_trace_buffers	901, 920	trace buffer sizes per process. Indicates the number of trace records for a process. Default is 256. Can specifcy different values per process (=<proc-spec>:<size>;)trace buffer sizes per process
_trace_cr_buffer_creates	815, 816, 817, 901, 920	trace cr buffer creates if otrace cacheIO event is set
_trace_enabled	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_trace_events	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	trace events enabled at startup.trace events enabled at startup
_trace_file_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maximum size of trace file (in number of trace records). 64K defaultmaximum size of trace file (in number of trace records)
_trace_files_public	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Create publicly accessible trace files
_trace_flushing	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_trace_flush_processes	901, 920	trace data archived by DIAG for these processes. Can turn the tracing on per process.trace data archived by DIAG for these processes
_trace_instance_termination	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	trace instance termination actions
_trace_multi_block_reads	815, 816, 817, 901, 920	trace multi_block reads if otrace cacheIO event is set
_trace_write_batch_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
_trace_options	901, 920	trace data flush options [binary|text],[multiple|single]trace data flush options
_trace_pin_time	920	trace how long a current pin is held
_trace_processes	901, 920	enable KST tracing in process. Default is ALLenable KST tracing in process
_transaction_recovery_servers	815, 816, 817, 901, 920	max number of parallel recovery slaves that may be used
_tts_allow_nchar_mismatch	816, 817, 901, 920	allow plugging in a tablespace with a different national charact
_two_pass	901, 920	enable two-pass thread recovery
_two_pass_reverse_polish_enabled	920	uses two-pass reverse polish alg. to generate canonical forms
_union_rewrite_for_gs	920	expand queries with GSets into UNIONs for rewrite
_unnest_notexists_sq	920	unnest NOT EXISTS subquery with one or more tables if possible
_unnest_subquery	816, 817, 901, 920	enables unnesting of correlated subqueries
_upconvert_from_ast	803, 804, 805, 806
_use_column_stats_for_function	816, 817, 901, 920	enable the use of column statistics for DDP functions
_use_ism	815, 816, 817, 901, 920	Enable Shared Page Tables - ISM
_use_new_explain_plan	901, 920	if TRUE, use the AUTO size policy cost functions
_use_nosegment_indexes	816, 817, 901, 920	use nosegment indexes in explain plan
_use_realfree_heap	901, 920	use real-free based allocator for PGA memory
_use_seq_process_cache	920	whether to use process local seq cache
_use_vector_post	803, 804, 805, 806, 815, 816, 817, 901, 920	use vector post
_verify_undo_quota	901, 920	TRUE - verify consistency of undo quota statistics
_wait_for_sync	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	wait for sync on commit MUST BE ALWAYS TRUE
_walk_insert_threshold	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maximum number of unusable blocks to walk across freelist
_watchpoint_on	920	is the watchpointing feature turned on?
_write_clones	815, 816, 817, 901, 920	write clones flag
_yield_check_interval	815, 816, 817, 901, 920	interval to check whether actses should yield
active_instance_count	816, 817, 901, 920	number of active instances in the parallel servernumber of active instances in the cluster database
allow_partial_sn_results	803, 804, 805, 806
always_anti_join	732, 733, 734, 803, 804, 805, 806, 815, 816, 817
always_semi_join	815, 816, 817
aq_tm_processes	803, 804, 805, 806, 815, 816, 817, 901, 920	number of AQ Time Managers to start
arch_io_slaves	803, 804, 805, 806
async_read
async_write	716, 723, 732, 733, 734
archive_lag_target	901, 920	Maximum number of seconds of redos the standby could lose
audit_file_dest	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Directory in which auditing files are to reside
audit_sys_operations	920	enable sys auditing
audit_trail	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enable system auditing
auto_mounting
b_tree_bitmap_plans	732, 733, 734, 803, 804, 805, 806
background_core_dump	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Core Size for Background Processes
background_dump_dest	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Detached process dump directory
backup_disk_io_slaves	803, 804, 805, 806
backup_tape_io_slaves	803, 804, 805, 806, 815, 816, 817, 901, 920	BACKUP Tape I/O slaves
bitmap_merge_area_size	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maximum memory allow for BITMAP MERGE
blank_trimming	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	blank trimming semantics parameter
buffer_pool_keep	803, 804, 805, 806, 815, 816, 817, 901, 920	Number of database blocks/latches in keep buffer pool
buffer_pool_recycle	803, 804, 805, 806, 815, 816, 817, 901, 920	Number of database blocks/latches in recycle buffer pool
cache_size_threshold	716, 723, 732, 733, 734, 803, 804, 805, 806
calls_to_get_snapshot_scn_kcmgss
ccf_io_size	716, 723, 732, 733, 734
checkpoint_process	716, 723, 732, 733, 734
cleanup_rollback_entries	716, 723, 732, 733, 734, 803, 804, 805, 806
cleanouts_and_rollbacks_consistent_read_gets
close_cached_open_cursors	716, 723, 732, 733, 734, 803, 804, 805, 806
circuits	901, 920	max number of circuits
cluster_database	920	if TRUE startup in cluster database mode
cluster_database_instances	920	number of instances to use for sizing cluster db SGA structures
cluster_interconnects	901, 920	interconnects for RAC use
commit_point_strength	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Bias this node has toward not preparing in a two-phase commit
compatible	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Database will be completely compatible with this software versio
compatible_no_recovery	716, 723, 732, 733, 734, 803, 804, 805, 806
control_file_record_keep_time	803, 804, 805, 806, 815, 816, 817, 901, 920	control file record keep time in days
control_files	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	control file names list
core_dump_dest	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Core dump directory
cpu_count	723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	initial number of cpu's for this instance
create_bitmap_area_size	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	size of create bitmap buffer for bitmap index
cursor_sharing	816, 817, 901, 920	cursor sharing mode
cursor_space_for_time	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	use more memory in order to get faster execution
db_16k_cache_size	901, 920	Size of cache for 16K buffers
db_2k_cache_size	901, 920	Size of cache for 2K buffers
db_32k_cache_size	901, 920	Size of cache for 32K buffers
db_4k_cache_size	901, 920	Size of cache for 4K buffers
db_8k_cache_size	901, 920	Size of cache for 8K buffers
db_block_buffers	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Number of database blocks cached in memory
db_block_checking	815, 816, 817, 901, 920	data and index block checking
db_block_checkpoint_batch	716, 723, 732, 733, 734, 803, 804, 805, 806
db_block_checksum	723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	store checksum in db blocks and check during reads
db_block_lru_extended_statistics	716, 723, 732, 733, 734, 803, 804, 805, 806
db_block_lru_latches	732, 733, 734, 803, 804, 805, 806, 815, 816, 817
db_block_lru_statistics	716, 723, 732, 733, 734, 803, 804, 805, 806
db_block_max_dirty_target	803, 804, 805, 806, 815, 816, 817
db_block_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Size of database block in bytes
db_cache_advice	901, 920	Buffer cache sizing advisory
db_cache_size	901, 920	Size of DEFAULT buffer pool for standard block size buffers
db_create_file_dest	901, 920	default database location
db_create_online_log_dest_1	901, 920	online log/controlfile destination #1
db_create_online_log_dest_2	901, 920	online log/controlfile destination #2
db_create_online_log_dest_3	901, 920	online log/controlfile destination #3
db_create_online_log_dest_4	901, 920	online log/controlfile destination #4
db_create_online_log_dest_5	901, 920	online log/controlfile destination #5
db_domain	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	directory part of global database name stored with CREATE DATABA
db_file_direct_io_count	803, 804, 805, 806, 815, 816, 817
db_file_multiblock_read_count	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	db block to be read each IO
db_file_name_convert	803, 804, 805, 806, 815, 816, 817, 901, 920	datafile name convert patterns and strings for standby/clone db
db_file_simultaneous_writes	716, 723, 732, 733, 734, 803, 804, 805, 806
db_file_standby_name_convert	732, 733, 734
db_files	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max allowable # db files
db_keep_cache_size	901, 920	Size of KEEP buffer pool for standard block size buffers
db_name	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	database name specified in CREATE DATABASE
db_recycle_cache_size	901, 920	Size of RECYCLE buffer pool for standard block size buffers
db_writer_processes	815, 816, 817, 901, 920	number of background database writer processes to start
db_writers	716, 723, 732, 733, 734
dblink_encrypt_login	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enforce password for distributed login always be encrypted
dbwr_io_slaves	803, 804, 805, 806, 815, 816, 817, 901, 920	DBWR I/O slaves
delayed_logging_block_cleanouts	732, 733, 734, 803, 804, 805, 806
discrete_transactions_enabled	716, 723, 732, 733, 734, 803, 804, 805, 806
dg_broker_config_file1	920	data guard broker configuration file #1
dg_broker_config_file2	920	data guard broker configuration file #2
dg_broker_start	920	start Data Guard broker framework (DMON process)
disk_asynch_io	803, 804, 805, 806, 815, 816, 817, 901, 920	Use asynch I/O for random access devices
dispatchers	920	specifications of dispatchers
distributed_lock_timeout	716, 723, 732, 733, 734, 803, 804, 805, 806, 920	number of seconds a distributed transaction waits for a lock
distributed_recovery_connection_hold_tim	716, 723, 732, 733, 734, 803, 804, 805, 806
dispatchers	901	specifications of dispatchers
distributed_transactions	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901	max. number of concurrent distributed transactions
dml_locks	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	dml locks - one for each table modified in a transaction
drs_start	901, 920	start DR Server framework (DMON process)start DG Broker monitor (DMON process)
enqueue_resources	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	resources for enqueues
ent_domain_name	815
event	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	debug event control - default null string
fal_client	901, 920	FAL client
fal_server	901, 920	FAL server list
fast_start_io_target	816, 817, 901, 920	Upper bound on recovery reads
fast_start_mttr_target	901, 920	MTTR target of forward crash recovery in seconds
fast_start_parallel_rollback	816, 817, 901, 920	max number of parallel recovery slaves that may be used
file_mapping	920	enable file mapping
filesystemio_options	920	IO operations on filesystem files
fixed_date	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	fixed SYSDATE value
freeze_DB_for_fast_instance_recovery	803, 804, 805, 806
gc_db_locks	716, 723, 732, 733, 734
gc_defer_time	803, 804, 805, 806, 815, 816, 817
gc_files_to_locks	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	mapping between file numbers and global cache locks (DFS)
gc_freelist_groups	732, 733, 734
gc_lck_procs	716, 723, 732, 733, 734, 803, 804, 805, 806
gc_releasable_locks	732, 733, 734, 803, 804, 805, 806, 815, 816, 817
gc_rollback_locks	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
gc_rollback_segments	716, 723, 732, 733, 734
gc_save_rollback_locks	716, 723, 732, 733, 734
gc_segments	716, 723, 732, 733, 734
gc_tablespaces	716, 723, 732, 733, 734
global_context_pool_size	901, 920	Global Application Context Pool Size in Bytes
global_names	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enforce that database links have same name as remote database
hash_area_size	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	size of in-memory hash work area
hash_join_enabled	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enable/disable hash join
hash_multiblock_io_count	732, 733, 734, 803, 804, 805, 806, 815, 816, 817
hi_shared_memory_address	815, 816, 817, 901, 920	SGA starting address (high order 32-bits on 64-bit platforms)
hs_autoregister	815, 816, 817, 901, 920	enable automatic server DD updates in HS agent self-registration
ifile	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	include file in init.ora
instance_groups	803, 804, 805, 806, 815, 816, 817, 901, 920	list of instance group names
instance_name	815, 816, 817, 901, 920	instance name supported by the instance
instance_number	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	instance number
ipq_net	733, 734
java_max_sessionspace_size	816, 817, 901, 920	max allowed size in bytes of a Java sessionspace
java_pool_size	815, 816, 817, 901, 920	size in bytes of the Java pool
java_soft_sessionspace_limit	816, 817, 901, 920	warning limit on size in bytes of a Java sessionspace
job_queue_interval	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817
job_queue_keep_connections	716, 723, 732, 733, 734, 803, 804, 805, 806
job_queue_processes	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	number of job queue slave processes
large_pool_min_alloc	803, 804, 805, 806
large_pool_size	803, 804, 805, 806, 815, 816, 817, 901, 920	size in bytes of the large allocation pool
lgwr_io_slaves	803, 804, 805, 806
license_max_sessions	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maximum number of non-system user sessions allowed
license_max_users	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maximum number of named users that can be created in the databas
license_sessions_warning	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	warning level for number of non-system user sessions
lm_locks	803, 804, 805, 806, 815, 816, 817
lm_procs	803, 804, 805, 806, 815
lm_ress	803, 804, 805, 806, 815, 816, 817
local_listener	803, 804, 805, 806, 815, 816, 817, 901, 920	local listener
lock_name_space	803, 804, 805, 806, 815, 816, 817, 901, 920	lock name space used for generating lock names for standby/clone
lock_sga	815, 816, 817, 901, 920	Lock entire SGA in physical memory
log_archive_buffer_size	716, 723, 732, 733, 734, 803, 804, 805, 806
log_archive_buffers	716, 723, 732, 733, 734, 803, 804, 805, 806
log_archive_dest	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	archival destination text string
log_archive_dest_n	815, 816, 817
log_archive_dest_1	815, 816, 817, 901, 920	archival destination #1 text string
log_archive_dest_10	901, 920	archival destination #10 text string
log_archive_dest_2	815, 816, 817, 901, 920	archival destination #2 text string
log_archive_dest_3	815, 816, 817, 901, 920	archival destination #3 text string
log_archive_dest_4	815, 816, 817, 901, 920	archival destination #4 text string
log_archive_dest_5	815, 816, 817, 901, 920	archival destination #5 text string
log_archive_dest_state_n	815, 816, 817
log_archive_dest_6	901, 920	archival destination #6 text string
log_archive_dest_7	901, 920	archival destination #7 text string
log_archive_dest_8	901, 920	archival destination #8 text string
log_archive_dest_9	901, 920	archival destination #9 text string
log_archive_dest_state_1	815, 816, 817, 901, 920	archival destination #1 state text string
log_archive_dest_state_10	901, 920	archival destination #10 state text string
log_archive_dest_state_2	815, 816, 817, 901, 920	archival destination #2 state text string
log_archive_dest_state_3	815, 816, 817, 901, 920	archival destination #3 state text string
log_archive_dest_state_4	815, 816, 817, 901, 920	archival destination #4 state text string
log_archive_dest_state_5	815, 816, 817, 901, 920	archival destination #5 state text string
log_archive_dest_state_6	901, 920	archival destination #6 state text string
log_archive_dest_state_7	901, 920	archival destination #7 state text string
log_archive_dest_state_8	901, 920	archival destination #8 state text string
log_archive_dest_state_9	901, 920	archival destination #9 state text string
log_archive_duplex_dest	803, 804, 805, 806, 815, 816, 817, 901, 920	duplex archival destination text string
log_archive_format	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	archival destination format
log_archive_max_processes	815, 816, 817, 901, 920	maximum number of active ARCH processes
log_archive_min_succeed_dest	803, 804, 805, 806, 815, 816, 817, 901, 920	minimum number of archive destinations that must succeed
log_archive_start	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	start archival process on SGA initialization
log_archive_trace	816, 817, 901, 920	Establish archivelog operation tracing level
log_block_checksum	723, 732, 733, 734, 803, 804, 805, 806
log_buffer	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	redo circular buffer size
log_checkpoint_interval	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	# redo blocks checkpoint threshold
log_checkpoint_timeout	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Maximum time interval between checkpoints in seconds
log_checkpoints_to_alert	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	log checkpoint begin/end to alert file
log_file_name_convert	803, 804, 805, 806, 815, 816, 817, 901, 920	logfile name convert patterns and strings for standby/clone db
log_file_standby_name_convert	732, 733, 734
log_files	716, 723, 732, 733, 734, 803, 804, 805, 806
log_simultaneous_copies	716, 723, 732, 733, 734, 803, 804, 805, 806
log_small_entry_max_size	716, 723, 732, 733, 734, 803, 804, 805, 806
log_parallelism	920	Number of log buffer strands
logmnr_max_persistent_sessions	901, 920	maximum number of threads to mine
max_commit_propagation_delay	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Max age of new snapshot in .01 seconds
max_dispatchers	901, 920	max number of dispatchers
max_dump_file_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Maximum size (blocks) of dump file
max_enabled_roles	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max number of roles a user can have enabled
max_rollback_segments	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max. number of rollback segments in SGA cache
max_shared_servers	901, 920	max number of shared servers
max_transaction_branches	716, 723, 732, 733, 734, 803, 804, 805, 806, 901	max. number of branches per distributed transaction
mts_circuits	816, 817, 901, 920	max number of circuits
mts_dispatchers	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	specifications of dispatchers
mts_listener_address	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	address(es) of network listener
mts_max_dispatchers	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max number of dispatchers
mts_max_servers	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max number of shared servers
mts_multiple_listeners	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Are multiple listeners enabled?
mts_rate_log_size	803, 804, 805, 806
mts_rate_scale	803, 804, 805, 806
mts_servers	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	number of shared servers to start up
mts_service	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	service supported by dispatchers
mts_sessions	816, 817, 901, 920	max number of shared server sessions
nls_calendar	815, 816, 817, 901, 920	NLS calendar system name
nls_comp	815, 816, 817, 901, 920	NLS comparison
nls_currency	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	NLS local currency symbol
nls_date_format	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	NLS Oracle date format
nls_date_language	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	NLS date language name
nls_dual_currency	815, 816, 817, 901, 920	Dual currency symbol
nls_iso_currency	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	NLS ISO currency territory name
nls_language	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	NLS language name
nls_length_semantics	901, 920	create columns using byte or char semantics by default
nls_nchar_conv_excp	901, 920	NLS raise an exception instead of allowing implicit conversion
nls_numeric_characters	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	NLS numeric characters
nls_sort	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	NLS linguistic definition name
nls_territory	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	NLS territory name
nls_time_format	815, 816, 817, 901, 920	time format
nls_time_tz_format	815, 816, 817, 901, 920	time with timezone format
nls_timestamp_format	815, 816, 817, 901, 920	time stamp format
nls_timestamp_tz_format	815, 816, 817, 901, 920	timestampe with timezone format
object_cache_max_size_percent	803, 804, 805, 806, 815, 816, 817, 901, 920	percentage of maximum size over optimal of the user session's ob
object_cache_optimal_size	803, 804, 805, 806, 815, 816, 817, 901, 920	optimal size of the user session's object cache in bytes
olap_page_pool_size	920	size of the olap page pool in bytes
open_cursors	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max # cursors per session
open_links	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max # open links per session
open_links_per_instance	803, 804, 805, 806, 815, 816, 817, 901, 920	max # open links per instance
ops_admin_group	803, 804, 805, 806
ops_interconnects	817
optimizer_comp_weight	716
optimizer_dynamic_sampling	920	optimizer dynamic sampling
optimizer_features_enable	815, 816, 817, 901, 920	optimizer plan compatibility parameter
optimizer_index_caching	815, 816, 817, 901, 920	optimizer percent index caching
optimizer_index_cost_adj	815, 816, 817, 901, 920	optimizer index cost adjustment
optimizer_max_permutations	815, 816, 817, 901, 920	optimizer maximum join permutations per query block
optimizer_mode	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	optimizer mode
optimizer_percent_parallel	732, 733, 734, 803, 804, 805, 806, 815, 816, 817
optimizer_search_limit	733, 734, 803, 804, 805, 806, 815
oracle_trace_collection_name	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Oracle TRACE default collection name
oracle_trace_collection_path	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Oracle TRACE collection path
oracle_trace_collection_size	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Oracle TRACE collection file max. size
oracle_trace_enable	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Oracle Trace enabled/disabled
oracle_trace_facility_name	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Oracle TRACE default facility name
oracle_trace_facility_path	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Oracle TRACE facility path
os_authent_prefix	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	prefix for auto-logon accounts
os_roles	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	retrieve roles from the operating system
parallel_adaptive_multi_user	815, 816, 817, 901, 920	enable adaptive setting of degree for multiple user streams
parallel_automatic_tuning	815, 816, 817, 901, 920	enable intelligent defaults for parallel execution parameters
parallel_broadcast_enabled	815, 816, 817, 901	enable broadcasting of small inputs to hash and sort merge joins
parallel_default_max_instances	716, 723, 732, 733, 734, 803, 804, 805, 806
parallel_default_max_scans	716, 723
parallel_default_scansize	716, 723
parallel_execution_message_size	815, 816, 817, 901, 920	message buffer size for parallel execution
parallel_instance_group	803, 804, 805, 806, 815, 816, 817, 901, 920	instance group to use for all parallel operations
parallel_max_servers	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maximum parallel query servers per instance
parallel_min_message_pool	803, 804, 805, 806
parallel_min_percent	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	minimum percent of threads required for parallel query
parallel_min_servers	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	minimum parallel query servers per instance
parallel_server	803, 804, 805, 806, 815, 816, 817, 901, 920	if TRUE startup in parallel server mode
parallel_server_idle_time	716, 723, 732, 733, 734, 803, 804, 805, 806
parallel_server_instances	815, 816, 817, 901, 920	number of instances to use for sizing OPS SGA structures
parallel_threads_per_cpu	815, 816, 817, 901, 920	number of parallel execution threads per CPU
parallel_transaction_recovery	815
parallel_transaction_resource_timeout	803, 804, 805, 806
partition_view_enabled	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enable/disable partitioned views
plsql_load_without_compile	815
pga_aggregate_target	901, 920	Target size for the aggregate PGA memory consumed by the instanc
plsql_compiler_flags	901, 920	PL/SQL compiler flags
plsql_native_c_compiler	901, 920	plsql native C compiler
plsql_native_library_dir	901, 920	plsql native library dir
plsql_native_library_subdir_count	901, 920	plsql native library number of subdirectories
plsql_native_linker	901, 920	plsql native linker
plsql_native_make_file_name	901, 920	plsql native compilation make file
plsql_native_make_utility	901, 920	plsql native compilation make utility
plsql_v2_compatibility	803, 804, 805, 806, 815, 816, 817, 901, 920	PL/SQL version 2.x compatibility flag
pre_page_sga	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	pre-page sga for process
processes	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	user processes
query_rewrite_enabled	815, 816, 817, 901, 920	allow rewrite of queries using materialized views if enabled
query_rewrite_integrity	815, 816, 817, 901, 920	perform rewrite using materialized views with desired integrity
rdbms_server_dn	815, 816, 817, 901, 920	RDBMS's Distinguished Name
read_only_open_delayed	815, 816, 817, 901, 920	if TRUE delay opening of read only files until first access
recovery_parallelism	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	number of server processes to use for parallel recovery
remote_archive_enable	901, 920	remote archivelog destinations enabledremote archival enable setting
remote_dependencies_mode	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	remote-procedure-call dependencies mode parameter
remote_listener	901, 920	remote listener
remote_login_passwordfile	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	password file usage parameter
remote_os_authent	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	allow non-secure remote clients to use auto-logon accounts
remote_os_roles	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	allow non-secure remote clients to use os roles
replication_dependency_tracking	803, 804, 805, 806, 815, 816, 817, 901, 920	tracking dependency for Replication parallel propagation
resource_limit	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	master switch for resource limit
resource_manager_plan	815, 816, 817, 901, 920	resource mgr top plan
rollback_segments	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	undo segment list
row_cache_cursors	716, 723, 732, 733, 734, 803, 804, 805, 806
row_locking	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	row-locking
sequence_cache_entries	716, 723, 732, 733, 734, 803, 804, 805, 806
sequence_cache_hash_buckets	716, 723, 732, 733, 734, 803, 804, 805, 806
serial_reuse	803, 804, 805, 806, 815, 816, 817, 901, 920	reuse the frame segments
serializable	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	serializable
service_names	815, 816, 817, 901, 920	service names supported by the instance
session_cached_cursors	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	number of cursors to save in the session cursor cache
session_max_open_files	803, 804, 805, 806, 815, 816, 817, 901, 920	maximum number of open files allowed per session
sessions	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	user and system sessions
sga_max_size	901, 920	max total SGA size
shadow_core_dump	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Core Size for Shadow Processes
shared_memory_address	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	SGA starting address (low order 32-bits on 64-bit platforms)
shared_pool_reserved_min_alloc	716, 723, 732, 733, 734, 803, 804, 805, 806
shared_pool_reserved_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	size in bytes of reserved area of shared pool
shared_pool_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	size in bytes of shared pool
single_process	716, 723
snapshot_refresh_interval	716, 723, 732, 733, 734, 803, 804, 805, 806
snapshot_refresh_keep_connections	716, 723, 732, 733, 734, 803, 804, 805, 806
snapshot_refresh_processes	716, 723, 732, 733, 734, 803, 804, 805, 806
shared_server_sessions	901, 920	max number of shared server sessions
shared_servers	901, 920	number of shared servers to start up
sort_area_retained_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	size of in-memory sort work area retained between fetch calls
sort_area_size	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	size of in-memory sort work area
sort_direct_writes	723, 732, 733, 734, 803, 804, 805, 806
sort_mts_buffer_for_fetch_size	716
sort_multiblock_read_count	815, 816, 817
sort_read_fac	716, 723, 732, 733, 734, 803, 804, 805, 806
sort_spacemap_size	716, 723, 732, 733, 734, 803, 804, 805, 806
sort_write_buffer_size	723, 732, 733, 734, 803, 804, 805, 806
sort_write_buffers	723, 732, 733, 734, 803, 804, 805, 806
spin_count	716, 723, 732, 733, 734, 803, 804, 805, 806
spread_extents	803, 804, 805, 806
spfile	901, 920	server parameter file
sql92_security	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	require select privilege for searched update/delete
sql_trace	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	enable SQL trace
sql_version	816, 817, 901, 920	sql language version parameter for compatibility issues
standby_archive_dest	815, 816, 817, 901, 920	standby database archivelog destination text string
standby_file_management	901, 920	if auto then files are created/dropped automatically on standby
standby_preserves_names	901	File names on standby are the same as on the primary.
star_transformation_enabled	803, 804, 805, 806, 815, 816, 817, 901, 920	enable the use of star transformation
statistics_level	920	statistics level
tape_asynch_io	803, 804, 805, 806, 815, 816, 817, 901, 920	Use asynch I/O requests for tape devices
temporary_sort_file_dest	716, 723, 732
temporary_table_locks	716, 723, 732, 733, 734, 803, 804, 805, 806
text_enable	732, 733, 734, 803, 804, 805, 806, 815, 816, 817
thread	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	Redo thread to mount
timed_os_statistics	803, 804, 805, 806, 815, 816, 817, 901, 920	internal os statistic gathering interval in seconds
timed_statistics	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	maintain internal timing statistics
trace_enabled	901, 920	enable KST tracing
tracefile_identifier	817, 901, 920	trace file custom identifier
transaction_auditing	803, 804, 805, 806, 815, 816, 817, 901, 920	transaction auditing records generated in the redo log
transactions	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	max. number of concurrent active transactions
transactions_per_rollback_segment	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	number of active transactions per rollback segment
unlimited_rollback_segments	733, 734
undo_management	901, 920	instance runs in SMU mode if TRUE, else in RBU mode
undo_retention	901, 920	undo retention in seconds
undo_suppress_errors	901, 920	Suppress RBU errors in SMU mode
undo_tablespace	901, 920	use/switch undo tablespace
use_indirect_data_buffers	815, 816, 817, 901, 920	Enable indirect data buffers (very large SGA on 32-bit platforms
use_readv	716, 723, 732, 733, 734
use_sigio	733, 734
user_dump_dest	716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	User process dump directory
utl_file_dir	732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920	utl_file accessible directories list
v733_plans_enabled	732, 733, 734
vlm_sga_base_address	723, 732, 733, 734, 803, 804, 805, 806
workarea_size_policy	901, 920	policy used to size SQL working areas (MANUAL/AUTO)