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©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	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	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	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	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)

Parameters (by xsoft) [2009.10.21]

Hidden Parameters 조회방법

목차(10.2.0.3 기준)

\_db_block_buffers