Oracle 隐含参数

点击(此处)折叠或打开

set pagesize 9999
set line 9999
col NAME format a40
col KSPPDESC format a50
col KSPPSTVL format a20
SELECT a.INDX,
a.KSPPINM NAME,
a.KSPPDESC,
b.KSPPSTVL
FROM x$ksppi a,
x$ksppcv b
WHERE a.INDX = b.INDX
and lower(a.KSPPINM) like lower('%?meter%');

Oracle系统中还有一类参数称之为隐含参数（Hidden Parameters），在系统中使用，但Oracle官方没有公布的参数，这些参数可能是那些还没有成熟或者是系统开发中使用的参数。这些参数在所有Oracle官方提供的文档中都没有介绍，它们的命名有一个共同特征就是都以“_”作为参数的首字符。下面的查询可以得到当前系统中的所有隐藏参数，需要以SYS用户登陆，查看两个视图：X$KSPPI和X$KSPPCV。下面作者给出具体的SQL语句。
SET PAGESIZE 9999
SET LINE 9999
COL NAME FORMAT A40
COL KSPPDESC FORMAT A50
COL KSPPSTVL FORMAT A20
SELECT A.INDX,
A.KSPPINM NAME,
A.KSPPDESC,
B.KSPPSTVL
FROM X$KSPPI A,
X$KSPPCV B
WHERE A.INDX = B.INDX
AND A.KSPPINM LIKE '/_%' ESCAPE '/'
AND LOWER(A.KSPPINM) LIKE LOWER('%&PARAMETER%');
举个例子，如果需要查询隐含参数“_LM_DD_INTERVAL”的值，那么执行上面的代码后输入“_LM_DD_INTERVAL”就可以看到该隐含参数的值了，如下所示：
SYS@lhrdb> SET PAGESIZE 9999
SYS@lhrdb> SET LINE 9999
SYS@lhrdb> COL NAME FORMAT A40
SYS@lhrdb> COL KSPPDESC FORMAT A50
SYS@lhrdb> COL KSPPSTVL FORMAT A20
SYS@lhrdb> SELECT A.INDX,
2 A.KSPPINM NAME,
3 A.KSPPDESC,
4 B.KSPPSTVL
5 FROM X$KSPPI A,
6 X$KSPPCV B
7 WHERE A.INDX = B.INDX
8 AND A.KSPPINM LIKE '/_%' ESCAPE '/'
9 AND LOWER(A.KSPPINM) LIKE LOWER('%&PARAMETER%');
Enter value for parameter: _lm_dd_interval
old 9: AND LOWER(A.KSPPINM) LIKE LOWER('%&PARAMETER%')
new 9: AND LOWER(A.KSPPINM) LIKE LOWER('%_lm_dd_interval%')
INDX NAME KSPPDESC KSPPSTVL
---------- ---------------------------------------- -------------------------------------------------- --------------------
578 _lm_dd_interval dd time interval in seconds 10

可以看到该隐含参数的值为10。
对于隐含参数而言，修改隐含参数的值的时候需要将隐含参数用双引号括起来。若要清除SPFILE中的隐含参数可以使用RESET命令。
SYS@lhrdb> alter system set _lm_dd_interval=20 scope=spfile;
alter system set _lm_dd_interval=20 scope=spfile
*
ERROR at line 1:
ORA-00911: invalid character

SYS@lhrdb> alter system set "_lm_dd_interval"=20 scope=spfile;

System altered.

SYS@lhrdb> alter system reset "_lm_dd_interval" scope=spfile sid='*';

System altered.

普通用户是不具备查询隐含参数的权限的，可以通过创建视图和同义词的方式来解决这个问题，如下所示：
CREATE OR REPLACE VIEW VW_YH_PARAMETER_LHR AS
SELECT A.INDX, A.KSPPINM NAME, A.KSPPDESC, B.KSPPSTVL
FROM XKSPPIA,XKSPPIA,XKSPPCV B
WHERE A.INDX = B.INDX
AND A.KSPPINM LIKE '/_%' ESCAPE '/' --TRANSLATE (ksppinm, '_', '#') LIKE '#%'
;
GRANT SELECT ON VW_YH_PARAMETER_LHR TO PUBLIC;
CREATE PUBLIC SYNONYM VW_YH_PARAMETER_LHR FOR SYS.VW_YH_PARAMETER_LHR;

INDX	NAME	KSPPDESC	KSPPSTVL
0	_appqos_qt	System Queue time retrieval interval	10
1	_ior_serialize_fault	inject fault in the ior serialize code	0
2	_shutdown_completion_timeout_mins	minutes for shutdown operation to wait for sessions to complete	60
3	_inject_startup_fault	inject fault in the startup code	0
4	_latch_recovery_alignment	align latch recovery structures	65534
5	_spin_count	Amount to spin waiting for a latch	2000
6	_latch_miss_stat_sid	Sid of process for which to collect latch stats	0
7	_max_sleep_holding_latch	max time to sleep while holding a latch	4
8	_max_exponential_sleep	max sleep during exponential backoff	0
9	_other_wait_threshold	threshold wait percentage for event wait class Other	0
10	_other_wait_event_exclusion	exclude event names from _other_wait_threshold calculations
11	_use_vector_post	use vector post	TRUE
12	_latch_class_0	latch class 0
13	_latch_class_1	latch class 1
14	_latch_class_2	latch class 2
15	_latch_class_3	latch class 3
16	_latch_class_4	latch class 4
17	_latch_class_5	latch class 5
18	_latch_class_6	latch class 6
19	_latch_class_7	latch class 7
20	_latch_classes	latch classes override
21	_ultrafast_latch_statistics	maintain fast-path statistics for ultrafast latches	TRUE
22	_enable_reliable_latch_waits	Enable reliable latch waits	TRUE
23	_wait_breakup_time_csecs	Wait breakup time (in centiseconds)	300
24	_wait_breakup_threshold_csecs	Wait breakup threshold (in centiseconds)	600
25	_disable_wait_state	Disable wait state
26	_wait_tracker_num_intervals	Wait Tracker number of intervals	0
27	_wait_tracker_interval_secs	Wait Tracker number of seconds per interval	10
28	_wait_samples_max_time_secs	Wait Samples maximum time in seconds	120
29	_wait_samples_max_sections	Wait Samples maximum sections	40
30	_wait_yield_mode	Wait Yield - Mode	yield
31	_wait_yield_hp_mode	Wait Yield - High Priority Mode	yield
32	_wait_yield_sleep_time_msecs	Wait Yield - Sleep Time (in milliseconds)	1
33	_wait_yield_sleep_freq	Wait Yield - Sleep Frequency	100
34	_wait_yield_yield_freq	Wait Yield - Yield Frequency	20
35	_post_wait_queues_num_per_class	Post Wait Queues - Num Per Class
36	_post_wait_queues_dynamic_queues	Post Wait Queues - Num Dynamic Queues	40
37	lock_name_space	lock name space used for generating lock names for standby/clone database
38	processes	user processes	500
39	sessions	user and system sessions	772
40	timed_statistics	maintain internal timing statistics	TRUE
41	timed_os_statistics	internal os statistic gathering interval in seconds	0
42	resource_limit	master switch for resource limit	FALSE
43	license_max_sessions	maximum number of non-system user sessions allowed	0
44	license_sessions_warning	warning level for number of non-system user sessions	0
45	_session_idle_bit_latches	one latch per session or a latch per group of sessions	0
46	_ksu_diag_kill_time	number of seconds ksuitm waits before killing diag	5
47	_ksuitm_dont_kill_dumper	delay inst. termination to allow processes to dump	FALSE
48	_cleanup_timeout	timeout value for PMON cleanup	150
49	_cleanup_timeout_flags	flags for PMON cleanup timeout	2
50	_disable_image_check	Disable Oracle executable image checking	FALSE
51	_num_longop_child_latches	number of child latches for long op array	2
52	_longops_enabled	longops stats enabled	TRUE
53	_test_ksusigskip	test the function ksusigskip	5
54	_module_action_old_length	Use module and action old length parameter	TRUE
55	_disable_kcbhxor_osd	disable kcbh(c)xor OSD functionality	FALSE
56	_disable_kgghshcrc32_osd	disable kgghshcrc32chk OSD functionality	FALSE
57	_disable_system_state	disable system state dump	4294967294
58	_disable_system_state_wait_samples	Disable system state dump - wait samples	FALSE
59	_session_wait_history	enable session wait history collection	10
60	_pkt_enable	enable progressive kill test	FALSE
61	_pkt_start	start progressive kill test instrumention	FALSE
62	_pkt_pmon_interval	PMON process clean-up interval (cs)	50
63	_collapse_wait_history	collapse wait history	FALSE
64	_short_stack_timeout_ms	short stack timeout in ms	30000
65	_sga_early_trace	sga early trace event	0
66	_kill_session_dump	Process dump on kill session immediate	TRUE
67	_logout_storm_rate	number of processes that can logout in a second	0
68	_logout_storm_timeout	timeout in centi-seconds for time to wait between retries	5
69	_logout_storm_retrycnt	maximum retry count for logouts	600
70	_ksuitm_addon_trccmd	command to execute when dead processes don't go away
71	_timeout_actions_enabled	enables or disables KSU timeout actions	TRUE
72	_idle_session_kill_enabled	enables or disables resource manager session idle limit checks	TRUE
73	_session_allocation_latches	one latch per group of sessions	2
74	_disable_highres_ticks	disable high-res tick counter	FALSE
75	_timer_precision	VKTM timer precision in milli-sec	10
76	_dbrm_quantum	DBRM quantum
77	_highres_drift_allowed_sec	allowed highres timer drift for VKTM	1
78	_lowres_drift_allowed_sec	allowed lowres timer drift for VKTM	5
79	_vktm_assert_thresh	soft assert threshold VKTM timer drift	30
80	_iorm_tout	IORM scheduler timeout value in msec	1000
81	__oracle_base	ORACLE_BASE	/u01/app/oracle
82	_single_process	run without detached processes	FALSE
83	_disable_cpu_check	disable cpu_count check	FALSE
84	_available_core_count	number of cores for this instance	0
85	cpu_count	number of CPUs for this instance	2
86	_dbg_proc_startup	debug process startup	FALSE
87	_static_backgrounds	static backgrounds
88	_enqueue_deadlock_time_sec	requests with timeout <= this will not have deadlock detection	5
89	_number_cached_attributes	maximum number of cached attributes per instance	10
90	instance_groups	list of instance group names
91	_number_cached_group_memberships	maximum number of cached group memberships	32
92	_kss_quiet	if TRUE access violations during kss dumps are not recorded	FALSE
93	_kss_callstack_type	state object callstack trace type
94	event	debug event control - default null string
95	_oradebug_force	force target processes to execute oradebug commands?	FALSE
96	_ksdxdocmd_default_timeout_ms	default timeout for internal oradebug commands	30000
97	_ksdxdocmd_enabled	if TRUE ksdxdocmd* invocations are enabled	TRUE
98	_ksdx_charset_ratio	ratio between the system and oradebug character set	0
99	_oradebug_cmds_at_startup	oradebug commands to execute at instance startup
100	_watchpoint_on	is the watchpointing feature turned on?	FALSE
101	_ksdxw_num_sgw	number of watchpoints to be shared by all processes	10
102	_ksdxw_num_pgw	number of watchpoints on a per-process basis	10
103	_ksdxw_stack_depth	number of PCs to collect in the stack when watchpoint is hit	4
104	_ksdxw_cini_flg	ksdxw context initialization flag	0
105	_ksdxw_nbufs	ksdxw number of buffers in buffered mode	1000
106	sga_max_size	max total SGA size	1275068416
107	_enable_shared_pool_durations	temporary to disable/enable kgh policy	TRUE
108	_NUMA_pool_size	aggregate size in bytes of NUMA pool	Not specified
109	_enable_NUMA_optimization	Enable NUMA specific optimizations	FALSE
110	_enable_NUMA_support	Enable NUMA support and optimizations	FALSE
111	_enable_NUMA_interleave	Enable NUMA interleave mode	TRUE
112	_enable_LGPG_debug	Enable LGPG debug mode	FALSE
113	use_large_pages	Use large pages if available (TRUE/FALSE/ONLY)	TRUE
114	_max_largepage_alloc_time_secs	Maximum number of seconds to spend on largepage allocation	10
115	pre_page_sga	pre-page sga for process	FALSE
116	shared_memory_address	SGA starting address (low order 32-bits on 64-bit platforms)	0
117	hi_shared_memory_address	SGA starting address (high order 32-bits on 64-bit platforms)	0
118	use_indirect_data_buffers	Enable indirect data buffers (very large SGA on 32-bit platforms)	FALSE
119	_use_ism	Enable Shared Page Tables - ISM	TRUE
120	lock_sga	Lock entire SGA in physical memory	FALSE
121	_lock_sga_areas	Lock specified areas of the SGA in physical memory	0
122	_NUMA_instance_mapping	Set of nodes that this instance should run on	Not specified
123	_simulator_upper_bound_multiple	upper bound multiple of pool size	2
124	_simulator_pin_inval_maxcnt	maximum count of invalid chunks on pin list	16
125	_simulator_lru_rebalance_thresh	LRU list rebalance threshold (count)	10240
126	_simulator_lru_rebalance_sizthr	LRU list rebalance threshold (size)	5
127	_simulator_bucket_mindelta	LRU bucket minimum delta	8192
128	_simulator_lru_scan_count	LRU scan count	8
129	_simulator_internal_bound	simulator internal bound percent	10
130	_simulator_reserved_obj_count	simulator reserved object count	1024
131	_simulator_reserved_heap_count	simulator reserved heap count	4096
132	_simulator_sampling_factor	sampling factor for the simulator	2
133	_realfree_heap_max_size	minimum max total heap size, in Kbytes	32768
134	_realfree_heap_pagesize_hint	hint for real-free page size in bytes	65536
135	_realfree_heap_mode	mode flags for real-free heap	0
136	_use_realfree_heap	use real-free based allocator for PGA memory	TRUE
137	_pga_large_extent_size	PGA large extent size	1048576
138	_uga_cga_large_extent_size	UGA/CGA large extent size	262144
139	_total_large_extent_memory	Total memory for allocating large extents	0
140	_use_ism_for_pga	Use ISM for allocating large extents	TRUE
141	_private_memory_address	Start address of large extent memory segment
142	_mem_annotation_sh_lev	shared memory annotation collection level	0
143	_mem_annotation_pr_lev	private memory annotation collection level	0
144	_mem_annotation_scale	memory annotation pre-allocation scaling	1
145	_mem_annotation_store	memory annotation in-memory store	FALSE
146	_4031_dump_bitvec	bitvec to specify dumps prior to 4031 error	67194879
147	_4031_max_dumps	Maximum number of 4031 dumps for this process	100
148	_4031_dump_interval	Dump 4031 error once for each n-second interval	300
149	_4031_sga_dump_interval	Dump 4031 SGA heapdump error once for each n-second interval	3600
150	_4031_sga_max_dumps	Maximum number of SGA heapdumps	10
151	_4030_dump_bitvec	bitvec to specify dumps prior to 4030 error	4095
152	_numa_trace_level	numa trace event	0
153	_mem_std_extent_size	standard extent size for fixed-size-extent heaps	4096
154	_kgsb_threshold_size	threshold size for base allocator	16777216
155	_endprot_chunk_comment	chunk comment for selective overrun protection	chk 10235 dflt
156	_endprot_heap_comment	heap comment for selective overrun protection	hp 10235 dflt
157	_endprot_subheaps	selective overrun protection for subeheaps	TRUE
158	_sga_locking	sga granule locking state	none
159	_ksm_pre_sga_init_notif_delay_secs	seconds to delay instance startup at sga initialization (pre)	0
160	_ksm_post_sga_init_notif_delay_secs	seconds to delay instance startup at sga initialization (post)	0
161	processor_group_name	Name of the processor group that this instance should run in.
162	__shared_pool_size	Actual size in bytes of shared pool	503316480
163	shared_pool_size	size in bytes of shared pool	285212672
164	__large_pool_size	Actual size in bytes of large pool	67108864
165	large_pool_size	size in bytes of large pool	67108864
166	__java_pool_size	Actual size in bytes of java pool	67108864
167	java_pool_size	size in bytes of java pool	67108864
168	__streams_pool_size	Actual size in bytes of streams pool	67108864
169	streams_pool_size	size in bytes of the streams pool	67108864
170	_large_pool_min_alloc	minimum allocation size in bytes for the large allocation pool	65536
171	shared_pool_reserved_size	size in bytes of reserved area of shared pool	25165824
172	_shared_pool_reserved_pct	percentage memory of the shared pool allocated for the reserved area	5
173	_shared_pool_reserved_min_alloc	minimum allocation size in bytes for reserved area of shared pool	4400
174	java_soft_sessionspace_limit	warning limit on size in bytes of a Java sessionspace	0
175	java_max_sessionspace_size	max allowed size in bytes of a Java sessionspace	0
176	_kghdsidx_count	max kghdsidx count	2
177	_test_param_1	test parmeter 1 - integer	25
178	_test_param_2	test parameter 2 - string
179	_test_param_3	test parameter 3 - string
180	_test_param_4	test parameter 4 - string list
181	_test_param_5	test parmeter 5 - deprecated integer	25
182	_test_param_6	test parmeter 6 - size (ub8)	0
183	spfile	server parameter file	/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorclasm.ora
184	instance_type	type of instance to be executed	RDBMS
185	_disable_instance_params_check	disable instance type check for ksp	FALSE
186	_parameter_table_block_size	parameter table block size	2048
187	_high_priority_processes	High Priority Process Name Mask	LMS*\|VKTM
188	_os_sched_high_priority	OS high priority level	1
189	_ksb_restart_clean_time	process uptime for restarts	30000
190	_ksb_restart_policy_times	process restart policy times in seconds	0, 60, 120, 240
191	_ksd_test_param	KSD test parmeter	999
192	_kse_die_timeout	amount of time a dying process is spared by PMON (in centi-secs)	60000
193	_stack_guard_level	stack guard level	0
194	_kse_pc_table_size	kse pc table cache size	256
195	_kse_signature_entries	number of entries in the kse stack signature cache	0
196	_kse_signature_limit	number of stack frames to cache per kse signature	7
197	_kse_snap_ring_size	ring buffer to debug internal error 17090	0
198	_kse_snap_ring_record_stack	should error snap ring entries show a short stack trace	FALSE
199	_kse_trace_int_msg_clear	enables soft assert of KGECLEAERERROR is cleares an interrupt message	FALSE
200	_system_api_interception_debug	enable debug tracing for system api interception	FALSE
201	_messages	message queue resources - dependent on # processes & # buffers	1000
202	_enqueue_locks	locks for managed enqueues	9100
203	_enqueue_resources	resources for enqueues	3616
204	_enqueue_hash	enqueue hash table length	1579
205	_enqueue_debug_multi_instance	debug enqueue multi instance	FALSE
206	_enqueue_hash_chain_latches	enqueue hash chain latches	2
207	_enqueue_deadlock_scan_secs	deadlock scan interval	0
208	_enqueue_paranoia_mode_enabled	enable enqueue layer advanced debugging checks	FALSE
209	_ksi_trace	KSI trace string of lock type(s)
210	_ksi_trace_bucket	memory tracing: use ksi-private or rdbms-shared bucket	PRIVATE
211	_ksi_trace_bucket_size	size of the KSI trace bucket	8192
212	_ksi_clientlocks_enabled	if TRUE, DLM-clients can provide the lock memory	TRUE
213	_trace_processes	enable KST tracing in process	ALL
214	_trace_events	trace events enabled at startup
215	_trace_buffers	trace buffer sizes per process	ALL:256
216	_trace_dump_static_only	if TRUE filter trace dumps to always loaded dlls	FALSE
217	_trace_dump_all_procs	if TRUE on error buckets of all processes will be dumped to the current trace file	FALSE
218	_trace_dump_cur_proc_only	if TRUE on error just dump our process bucket	FALSE
219	_trace_dump_client_buckets	if TRUE dump client (ie. non-kst) buckets	TRUE
220	_cdmp_diagnostic_level	cdmp directory diagnostic level	2
221	nls_language	NLS language name	AMERICAN
222	nls_territory	NLS territory name	AMERICA
223	nls_sort	NLS linguistic definition name	BINARY
224	nls_date_language	NLS date language name	AMERICAN
225	nls_date_format	NLS Oracle date format	YYYY-MM-DD HH24:MI:SS
226	nls_currency	NLS local currency symbol	$
227	nls_numeric_characters	NLS numeric characters	.,
228	nls_iso_currency	NLS ISO currency territory name	AMERICA
229	nls_calendar	NLS calendar system name	GREGORIAN
230	nls_time_format	time format	HH.MI.SSXFF AM
231	nls_timestamp_format	time stamp format	DD-MON-RR HH.MI.SSXFF AM
232	nls_time_tz_format	time with timezone format	HH.MI.SSXFF AM TZR
233	nls_timestamp_tz_format	timestamp with timezone format	DD-MON-RR HH.MI.SSXFF AM TZR
234	nls_dual_currency	Dual currency symbol	$
235	nls_comp	NLS comparison	BINARY
236	nls_length_semantics	create columns using byte or char semantics by default	BYTE
237	nls_nchar_conv_excp	NLS raise an exception instead of allowing implicit conversion	FALSE
238	_nchar_imp_cnv	NLS allow Implicit Conversion between CHAR and NCHAR	TRUE
239	_nls_parameter_sync_enabled	enables or disables updates to v$parameter whenever an alter session statement modifies various nls parameters	TRUE
240	_disable_file_locks	disable file locks for control, data, redo log files	FALSE
241	_ksfd_verify_write	verify asynchronous writes issued through ksfd	FALSE
242	_disable_odm	disable odm feature	FALSE
243	fileio_network_adapters	Network Adapters for File I/O
244	_enable_list_io	Enable List I/O	FALSE
245	filesystemio_options	IO operations on filesystem files	none
246	_omf	enable/disable OMF	enabled
247	_aiowait_timeouts	Number of aiowait timeouts before error is reported	100
248	_io_shared_pool_size	Size of I/O buffer pool from SGA	4194304
249	_max_io_size	Maximum I/O size in bytes for sequential file accesses	1048576
250	_io_statistics	if TRUE, ksfd I/O statistics are collected	TRUE
251	_disk_sector_size_override	if TRUE, OSD sector size could be overridden	FALSE
252	_simulate_disk_sectorsize	Enables skgfr to report simulated disk sector size	0
253	_enable_asyncvio	enable asynch vectored I/O	FALSE
254	_iocalibrate_max_ios	iocalibrate max I/Os per process	0
255	_iocalibrate_init_ios	iocalibrate init I/Os per process	2
256	clonedb	clone database	FALSE
257	_db_file_direct_io_count	Sequential I/O buf size	1048576
258	_cell_fast_file_create	Allow optimized file creation path for Cells	TRUE
259	_cell_fast_file_restore	Allow optimized rman restore for Cells	TRUE
260	_file_size_increase_increment	Amount of file size increase increment, in bytes	67108864
261	_ioslave_issue_count	IOs issued before completion check	500
262	_ioslave_batch_count	Per attempt IOs picked	1
263	disk_asynch_io	Use asynch I/O for random access devices	TRUE
264	tape_asynch_io	Use asynch I/O requests for tape devices	TRUE
265	_io_slaves_disabled	Do not use I/O slaves	FALSE
266	dbwr_io_slaves	DBWR I/O slaves	0
267	_lgwr_io_slaves	LGWR I/O slaves	0
268	_arch_io_slaves	ARCH I/O slaves	0
269	_backup_disk_io_slaves	BACKUP Disk I/O slaves	0
270	backup_tape_io_slaves	BACKUP Tape I/O slaves	FALSE
271	_fg_iorm_slaves	ForeGround I/O slaves for IORM	1
272	_backup_io_pool_size	memory to reserve from the large pool	1048576
273	_reset_maxcap_history	reset maxcap history time	10
274	_high_server_threshold	high server thresholds	0
275	_low_server_threshold	low server thresholds	0
276	_active_session_idle_limit	active session idle limit	5
277	_active_session_legacy_behavior	active session legacy behavior	FALSE
278	resource_manager_cpu_allocation	Resource Manager CPU allocation	2
279	_resource_manager_plan	resource mgr top plan for internal use
280	resource_manager_plan	resource mgr top plan
281	_vkrm_schedule_interval	VKRM scheduling interval	10
282	_dbrm_dynamic_threshold	DBRM dynamic threshold setting	16843752
283	_resource_manager_always_off	disable the resource manager always	FALSE
284	_resource_manager_always_on	enable the resource manager always	TRUE
285	_io_resource_manager_always_on	io resource manager always on	FALSE
286	_max_small_io	IORM:max number of small I/O's to issue	0
287	_max_large_io	IORM:max number of large I/O's to issue	0
288	_auto_assign_cg_for_sessions	auto assign CGs for sessions	FALSE
289	_rm_numa_simulation_pgs	number of PGs for numa simulation in resource manager	0
290	_rm_numa_simulation_cpus	number of cpus for each pg for numa simulation in resource manager	0
291	_rm_numa_sched_enable	Is Resource Manager (RM) related NUMA scheduled policy enabled	FALSE
292	_dbrm_runchk	Resource Manager Diagnostic Running Thread Check	0
293	_dbrm_short_wait_us	Resource Manager short wait length	300
294	_dbrm_num_runnable_list	Resource Manager number of runnable list per NUMA node	0
295	_db_check_cell_hints		FALSE
296	_pqq_enabled	Enable Resource Manager based Parallel Statement Queuing	TRUE
297	_pqq_debug_txn_act	pq queuing transaction active	FALSE
298	_ksr_unit_test_processes	number of ksr unit test processes	0
299	_ksv_spawn_control_all	control all spawning of background slaves	FALSE
300	_ksv_max_spawn_fail_limit	bg slave spawn failure limit	5
301	_ksv_pool_wait_timeout	bg slave pool wait limit	600
302	_ksv_pool_hang_kill_to	bg slave pool terminate timeout	0
303	_ksvppktmode	ksv internal pkt test	0
304	_ksv_static_flags1	ksv static flags 1 - override default behavior	0
305	_ksv_dynamic_flags1	ksv dynamic flags 1 - override default behavior	0
306	_first_spare_parameter	first spare parameter - integer
307	_second_spare_parameter	second spare parameter - integer
308	_third_spare_parameter	third spare parameter - integer
309	_fourth_spare_parameter	fourth spare parameter - integer
310	_fifth_spare_parameter	fifth spare parameter - integer
311	_sixth_spare_parameter	sixth spare parameter - integer
312	_seventh_spare_parameter	seventh spare parameter - integer
313	_eighth_spare_parameter	eighth spare parameter - integer
314	_ninth_spare_parameter	ninth spare parameter - integer
315	_tenth_spare_parameter	tenth spare parameter - integer
316	_eleventh_spare_parameter	eleventh spare parameter - string
317	_twelfth_spare_parameter	twelfth spare parameter - string
318	_thirteenth_spare_parameter	thirteenth spare parameter - string
319	_fourteenth_spare_parameter	fourteenth spare parameter - string
320	_fifteenth_spare_parameter	fifteenth spare parameter - string
321	_sixteenth_spare_parameter	sixteenth spare parameter - string list
322	_seventeenth_spare_parameter	seventeenth spare parameter - string list
323	_eighteenth_spare_parameter	eighteenth spare parameter - string list
324	_nineteenth_spare_parameter	nineteenth spare parameter - string list
325	_twentieth_spare_parameter	twentieth spare parameter - string list
326	_ksxp_ping_enable	disable dynamic loadin of lib skgxp	TRUE
327	_ksxp_ping_polling_time	max. arrays for ipc statistics	0
328	_ksxp_disable_dynamic_loading	disable dynamic loadin of lib skgxp	FALSE
329	_ksxp_disable_rolling_migration	disable possibility of starting rolling migration	FALSE
330	_skgxp_udp_use_tcb	disable use of high speek timer	TRUE
331	_ksxp_skgxp_library_path	over-ride default location of lib skgxp
332	_ksxp_skgxp_compat_library_path	over-ride default location of lib skgxp compat
333	_ksxp_disable_ipc_stats	disable ipc statistics	FALSE
334	_ksxp_max_stats_bkts	max. arrays for ipc statistics	0
335	_ksxp_init_stats_bkts	initial number arrays for ipc statistics	0
336	_ksxp_stats_mem_lmt	limit ipc statistics memory. this parameter is a percentage value	0
337	cluster_interconnects	interconnects for RAC use
338	_rm_cluster_interconnects	interconnects for RAC use (RM)
339	_ksxp_disable_clss	disable CLSS interconnects	0
340	_ksxp_send_timeout	set timeout for sends queued with the inter-instance IPC	300
341	_ksxp_dump_timeout	set timeout for kjzddmp request	20
342	_ksxp_diagmode	set to OFF to disable automatic slowsend diagnostics	OFF
343	_skgxp_reaping	tune skgxp OSD reaping limit	1000
344	_ksxp_reaping	tune ksxp layer reaping limit	20
345	_ksxp_wait_flags	tune ksxpwait	0
346	_ksxp_control_flags	modify ksxp behavior	0
347	_skgxp_udp_hiwat_warn	ach hiwat mark warning interval	1000
348	_skgxp_udp_ach_reaping_time	time in minutes before idle ach's are reaped	120
349	_skgxp_udp_timed_wait_seconds	time in seconds before timed wait is invoked	5
350	_skgxp_udp_timed_wait_buffering	diagnostic log buffering space (in bytes) for timed wait (0 means unbufferd	1024
351	_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	300
352	_disable_duplex_link	Turn off connection duplexing	TRUE
353	_diag_diagnostics	Turn off diag diagnostics	TRUE
354	_disable_interface_checking	disable interface checking at startup	FALSE
355	_skgxp_udp_interface_detection_time_secs	time in seconds between interface detection checks	60
356	_skgxp_udp_lmp_on	enable UDP long message protection	FALSE
357	_skgxp_udp_lmp_mtusize	MTU size for UDP LMP testing	0
358	_skgxp_udp_enable_dynamic_credit_mgmt	Enables dynamic credit management	0
359	_skgxp_udp_ack_delay	Enables delayed acks	0
360	_skgxp_gen_ant_ping_misscount	ANT protocol ping miss count	3
361	_skgxp_gen_rpc_no_path_check_in_sec	ANT ping protocol miss count	5
362	_skgxp_gen_rpc_timeout_in_sec	VRPC request timeout when ANT enabled	300
363	_skgxp_gen_ant_off_rpc_timeout_in_sec	VRPC request timeout when ANT disabled	30
364	_skgxp_min_zcpy_len	IPC threshold for zcpy operation (default = 0 - disabled)	0
365	_skgxp_min_rpc_rcv_zcpy_len	IPC threshold for rpc rcv zcpy operation (default = 0 - disabled)	0
366	_skgxp_zcpy_flags	IPC zcpy options flags	0
367	_skgxp_ctx_flags1	IPC debug options flags (oss)	0
368	_skgxp_ctx_flags1mask	IPC debug options flags mask (oss)	0
369	_skgxp_dynamic_protocol	IPC protocol override (!0/-1=*,2=UDP,3=RDS,0x1000=ipc_X)	0
370	_skgxp_inets	limit SKGXP networks
371	_skgxp_rgn_ports	region socket limits (0xFFFFNNXX): F=flags, N=min, X=max	0
372	_ksxp_skgxp_ctx_flags1	IPC debug options flags (RAC)	0
373	_ksxp_skgxp_ctx_flags1mask	IPC debug options flags mask (RAC)	0
374	_ksxp_skgxp_dynamic_protocol	IPC protocol override (RAC) (0/-1=*,2=UDP,3=RDS,!0x1000=ipc_X)	4096
375	_ksxp_skgxp_rgn_ports	region socket limits (0xFFFFNNXX): F=flags, N=min, X=max	0
376	_ksxp_dynamic_skgxp_param	dynamic skgxp parameters
377	_ksxp_if_config	ksxp if config flags	0
378	_ksxp_compat_flags	ksxp compat flags	0
379	_skgxp_spare_param1	ipc oss spare parameter 1
380	_ksxp_skgxp_spare_param1	ipc ksxp spare parameter 1
381	_skgxp_spare_param2	ipc oss spare parameter 2
382	_ksxp_skgxp_spare_param2	ipc ksxp spare parameter 2
383	_skgxp_spare_param3	ipc oss spare parameter 3
384	_ksxp_skgxp_spare_param3	ipc ksxp spare parameter 3
385	_skgxp_spare_param4	ipc oss spare parameter 4
386	_ksxp_skgxp_spare_param4	ipc ksxp spare parameter 4
387	_skgxp_spare_param5	ipc oss spare parameter 5
388	_ksxp_skgxp_spare_param5	ipc ksxp spare parameter 5
389	_skgxpg_last_parameter	last defined skgxpg parameter - oss	26
390	_ksxp_skgxpg_last_parameter	last defined skgxpg parameter - ksxp	26
391	_ksxp_testing	KSXP test parameter	0
392	_ksxp_reporting_process	reporting process for KSXP	LMD0
393	_ksxp_unit_test_byte_transformation	enable byte transformation unit test	FALSE
394	_ksxp_lwipc_enabled	enable lwipc for KSXP	FALSE
395	_ksmd_protect_mode	KSMD protect mode for catching stale access	off
396	_ksmg_granule_size	granule size in bytes	16777216
397	_ksmg_granule_locking_status	granule locking status	1
398	_ksmg_lock_check_interval	timeout action interval in minutes
399	_ksmg_lock_reacquire_count	repeat count for acquisition of locks	5
400	file_mapping	enable file mapping	FALSE
401	_filemap_dir	FILEMAP directory
402	_object_statistics	enable the object level statistics collection	TRUE
403	_object_stats_max_entries	Maximum number of entries to be tracked per stat	3072
404	_enable_rlb	enable RLB metrics processing	TRUE
405	_enable_midtier_affinity	enable midtier affinity metrics processing	TRUE
406	_midtier_affinity_clusterwait_threshold	cluster wait threshold to enter affinity	100
407	_midtier_affinity_goodness_threshold	goodness gradient threshold to dissolve affinity	2000
408	_service_cleanup_timeout	timeout to peform service cleanup	30
409	_max_services	maximum number of database services	150
410	_disable_health_check	Disable Health Check	FALSE
411	_mpmt_enabled	MPMT mode enabled	FALSE
412	_spawn_diag_thresh_secs	thread spawn diagnostic minimal threshold in seconds	30
413	_spawn_diag_opts	thread spawn diagnostic options	0
414	_sched_delay_sample_interval_ms	scheduling delay sampling interval in ms	1000
415	_sched_delay_max_samples	scheduling delay maximum number of samples	4
416	_sched_delay_sample_collection_thresh_ms	scheduling delay sample collection duration threshold ms	200
417	_sched_delay_measurement_sleep_us	scheduling delay mesurement sleep us	1000
418	_sched_delay_os_tick_granularity_us	os tick granularity used by scheduling delay calculations	16000
419	_accept_versions	List of parameters for rolling operation
420	_hang_analysis_num_call_stacks	hang analysis num call stacks	3
421	_local_hang_analysis_interval_secs	the interval at which local hang analysis is run	3
422	_deadlock_resolution_level	automatic deadlock resolution level	1
423	_deadlock_resolution_incidents_enabled	create incidents during deadlock resolution	TRUE
424	_deadlock_resolution_incidents_always	create incidents when resolving any deadlock?	FALSE
425	_deadlock_resolution_min_wait_timeout_secs	the minimum wait timeout required for deadlock resolution	60
426	_deadlock_resolution_signal_process_thresh_secs	the amount of time given to process a deadlock resolution signal	60
427	_heur_deadlock_resolution_secs	the heuristic wait time per node for deadlock resolution	0
428	_deadlock_diagnostic_level	automatic deadlock resolution diagnostics level	2
429	_blocking_sess_graph_cache_size	blocking session graph cache size in bytes
430	_diag_proc_enabled	enable hung process diagnostic API	TRUE
431	_diag_proc_stack_capture_type	hung process diagnostic API stack capture type	1
432	_diag_proc_max_time_ms	hung process diagnostic API max wait time in milliseconds	30000
433	_hang_msg_checksum_enabled	enable hang graph message checksum	TRUE
434	_kspol_tac_timeout	timeouts for TAC registerd by kspol	5
435	_disable_12751	disable policy timeout error (ORA-12751)	FALSE
436	_diskmon_pipe_name	DiSKMon skgznp pipe name
437	_dskm_health_check_cnt	DiSKMon health check counter	20
438	_ksmb_debug	ksmb debug flags	0
439	_pmon_enable_dead_blkrs	look for dead blockers during PMON cleanup	TRUE
440	_pmon_dead_blkrs_scan_rate_secs	rate to scan for dead blockers during cleanup (in seconds)	3
441	_pmon_dead_blkrs_alive_chk_rate_secs	rate to check blockers are alive during cleanup (in seconds)	3
442	_pmon_dead_blkrs_max_cleanup_attempts	max attempts per blocker while checking dead blockers	5
443	_pmon_dead_blkrs_max_blkrs	max blockers to check during cleanup	200
444	_pmon_max_consec_posts	PMON max consecutive posts in main loop	5
445	_dead_process_scan_interval	PMON dead process scan interval (in seconds)	60
446	_main_dead_process_scan_interval	PMON main dead process scan interval (in seconds)	0
447	_use_platform_compression_lib	Enable platform optimized compression implementation	FALSE
448	_use_platform_encryption_lib	Enable platform optimized encryption implementation	TRUE
449	_use_hybrid_encryption_mode	Enable platform optimized encryption in hybrid mode	FALSE
450	_xengem_diagmode	set to OFF to disable VM GEM support and functionalities	OFF
451	_xengem_devname	override default VM GEM device name used by skgvm	DEFAULT
452	_xengem_enabled	Enable OVM GEM support	TRUE
453	_diag_daemon	start DIAG daemon	TRUE
454	_dump_system_state_scope	scope of sysstate dump during instance termination	local
455	_dump_trace_scope	scope of trace dump during a process crash	global
456	_dump_interval_limit	trace dump time interval limit (in seconds)	120
457	_dump_max_limit	max number of dump within dump interval	5
458	_diag_dump_timeout	timeout parameter for SYNC dump	30
459	_diag_dump_request_debug_level	DIAG dump request debug level (0-2)	1
460	_diag_crashdump_level	parameter for systemstate dump level, used by DIAG during crash	10
461	_hang_detection_enabled	Hang Management detection	TRUE
462	_hang_detection_interval	Hang Management detection interval in seconds	32
463	_hang_resolution_scope	Hang Management hang resolution scope	PROCESS
464	_hang_resolution_policy	Hang Management hang resolution policy	HIGH
465	_hang_resolution_confidence_promotion	Hang Management hang resolution confidence promotion	FALSE
466	_hang_resolution_global_hang_confidence_promotion	Hang Management hang resolution global hang confidence promotion	FALSE
467	_hang_resolution_promote_process_termination	Hang Management hang resolution promote process termination	FALSE
468	_hang_output_suspected_hangs	Hang Management enabled output of suspected hangs	FALSE
469	_hang_signature_list_match_output_frequency	Hang Signature List matched output frequency	10
470	_hm_analysis_output_disk	if TRUE the hang manager outputs hang analysis results to disk	FALSE
471	_hm_analysis_oradebug_node_dump_level	the oradebug node dump level for hang manager hang analysis	0
472	_hm_analysis_oradebug_sys_dump_level	the oradebug system state level for hang manager hang analysis	0
473	_global_hang_analysis_interval_secs	the interval at which global hang analysis is run	10
474	_hang_verification_interval	Hang Management verification interval in seconds	46
475	_hang_ignored_hangs_interval	Time in seconds ignored hangs must persist after verification	300
476	_hang_ignored_hang_count	Hang Management ignored hang count	1
477	_hang_hiload_promoted_ignored_hang_count	Hang Management high load or promoted ignored hang count	2
478	_hang_log_incidents	Hang Manager incident logging	FALSE
479	_hang_long_wait_time_threshold	Long session wait time threshold in seconds	0
480	_hang_lws_file_count	Number of trace files for long waiting sessions	5
481	_hang_lws_file_time_limit	Timespan in seconds for current long waiting session trace file	3600
482	_hang_hiprior_session_attribute_list	Hang Management high priority session attribute list
483	_ipddb_enable	Enable IPD/DB data collection	FALSE
484	_trace_navigation_scope	enabling trace navigation linking	global
485	_max_protocol_support	Max occurrence protocols supported in a process	10000
486	_lm_lms	number of background gcs server processes to start	0
487	gcs_server_processes	number of background gcs server processes to start	0
488	_lm_dynamic_lms	dynamic lms invocation	FALSE
489	_lm_max_lms	max. number of background global cache server processes	0
490	_lm_activate_lms_threshold	threshold value to activate an additional lms	100
491	_lm_lmd_waittime	default wait time for lmd in centiseconds	8
492	_lm_lms_waittime	default wait time for lms in centiseconds	3
493	_lm_procs	number of client processes configured for cluster database	320
494	_lm_lms_priority_dynamic	enable lms priority modification	TRUE
495	_lm_lms_rt_threshold	maximum number of real time lms processes on machine
496	_lm_ress	number of resources configured for cluster database	6000
497	_lm_locks	number of enqueues configured for cluster database	12000
498	_lm_master_weight	master resource weight for this instance	1
499	active_instance_count	number of active instances in the cluster database
500	_active_instance_count	number of active instances in the cluster database
501	_active_standby_fast_reconfiguration	if TRUE optimize dlm reconfiguration for active/standby OPS	TRUE
502	_lm_enq_rcfg	if TRUE enables enqueue reconfiguration	TRUE
503	_lm_asm_enq_hashing	if TRUE makes ASM use enqueue master hashing for fusion locks	TRUE
504	_lm_xids	number of transaction IDs configured for cluster database	352
505	_lm_res_part	number of resource partition configured for gcs	128
506	_lm_drm_window	dynamic remastering bucket window size	0
507	_lm_drm_max_requests	dynamic remastering maximum affinity requests processed together	100
508	_lm_drm_xlatch	dynamic remastering forced exclusive latches	0
509	_lm_drm_disable	disable drm in different level	0
510	_lm_contiguous_res_count	number of contiguous blocks that will hash to the same HV bucket	128
511	_lm_num_pt_buckets	number of buckets in the object affinity hash table	8192
512	_lm_num_pt_latches	number of latches in the object affinity hash table	128
513	_lm_node_join_opt	cluster database node join optimization in reconfig	FALSE
514	_lm_no_sync	skip reconfiguration/drm syncr/synca messaging	TRUE
515	_lm_non_fault_tolerant	disable cluster database fault-tolerance mode	FALSE
516	_lm_cache_res_cleanup	percentage of cached resources should be cleanup	25
517	_lm_cache_allocated_res_ratio	ratio of cached over allocated resources	50
518	_lm_cache_res_skip_cleanup	multiple of iniital res cache below which cleanup is skipped	20
519	_lm_cache_res_cleanup_tries	max number of batches of cached resources to free per cleanup	10
520	_lm_cache_res_type	cache resource: string of lock types(s)	TMHWHVDI
521	_lm_cache_lvl0_cleanup	how often to cleanup level 0 cache res (in sec)	0
522	_lm_cache_res_options	ges resource cache options	0
523	_ogms_home	GMS home directory
524	_lm_sync_timeout	Synchronization timeout for DLM reconfiguration steps	163
525	_lm_ticket_active_sendback	Flow control ticket active sendback threshold
526	_lm_rcfg_timeout	dlm reconfiguration timeout	489
527	_lm_enq_lock_freelist	Number of ges enqueue element freelist
528	_lm_enqueue_freelist	Number of enqueue freelist	3
529	_lm_dd_interval	dd time interval in seconds	10
530	_lm_dd_scan_interval	dd scan interval in seconds	5
531	_lm_dd_search_cnt	number of dd search per token get	3
532	_lm_dd_max_search_time	max dd search time per token	180
533	_lm_dd_maxdump	max number of locks to be dumped during dd validation	50
534	_lm_dd_ignore_nodd	if TRUE nodeadlockwait/nodeadlockblock options are ignored	FALSE
535	_lm_enqueue_blocker_dump_timeout	enqueue blocker dump timeout	120
536	_lm_enqueue_blocker_kill_timeout	enqueue blocker kill timeout	0
537	_dlmtrace	Trace string of global enqueue type(s)
538	_lm_tx_delta	TX lock localization delta	16
539	_lm_proc_freeze_timeout	reconfiguration: process freeze timeout	70
540	_lm_deferred_msg_timeout	deferred message timeout	163
541	_lm_use_new_defmsgtmo_action	use new defered msg queue timeout action	TRUE
542	_lm_dump_null_lock	dump null lock in state dump	FALSE
543	_lm_validate_resource_type	if TRUE enables resource name validation	FALSE
544	_lm_file_affinity	mapping between file id and master instance number
545	_lm_file_read_mostly	mapping between read-mostly file id and master instance number
546	_lm_enable_aff_benefit_stats	enables affinity benefit computations if TRUE	FALSE
547	_lm_share_lock_opt	if TRUE enables share lock optimization	FALSE
548	_lm_res_hash_bucket	number of resource hash buckets	0
549	_ges_diagnostics	if TRUE enables GES diagnostics	TRUE
550	_fair_remote_cvt	if TRUE enables fair remote convert	FALSE
551	_lm_rcvr_hang_check_frequency	receiver hang check frequency in seconds	20
552	_lm_rcvr_hang_allow_time	receiver hang allow time in seconds	70
553	_lm_rcvr_hang_kill	to kill receiver hang	TRUE
554	_lm_rcvr_hang_check_system_load	examine system load when check receiver health	TRUE
555	_lm_rcvr_hang_systemstate_dump_level	systemstate dump level upon receiver hang	0
556	_lm_rcvr_hang_cfio_kill	to kill receiver hang at control file IO	FALSE
557	_lm_lmon_nowait_latch	if TRUE makes lmon get nowait latches with timeout loop	TRUE
558	_ges_dd_debug	if 1 or higher enables GES deadlock detection debug diagnostics	1
559	_lm_global_posts	if TRUE deliver global posts to remote nodes	TRUE
560	_rcfg_parallel_replay	if TRUE enables parallel replay and cleanup at reconfiguration	TRUE
561	_parallel_replay_msg_limit	Number of messages for each round of parallel replay	4000
562	_rcfg_parallel_fixwrite	if TRUE enables parallel fixwrite at reconfiguration	TRUE
563	_parallel_fixwrite_bucket	Number of buckets for each round of fix write	1000
564	_rcfg_parallel_verify	if TRUE enables parallel verify at reconfiguration	TRUE
565	_rcfg_disable_verify	if TRUE disables verify at reconfiguration	TRUE
566	_drm_parallel_freeze	if TRUE enables parallel drm freeze	TRUE
567	_dump_rcvr_ipc	if TRUE enables IPC dump at instance eviction time	TRUE
568	_ges_health_check	if greater than 0 enables GES system health check	0
569	_kill_enqueue_blocker	if greater than 0 enables killing enqueue blocker	2
570	_lm_psrcfg	enable pseudo reconfiguration	TRUE
571	_lm_single_inst_affinity_lock	enable single instance affinity lock optimization	TRUE
572	_lm_preregister_css_restype	enqueue type that requires pre-registration to css	CF
573	_inquiry_retry_interval	if greater than 0 enables inquiry retry after specified interval	3
574	_lm_drm_object_scan	enable/disable object scan to force full table scan always	TRUE
575	_lm_spare_threads	number of spare threads to be created by the GPnP master	0
576	_lm_spare_undo	number of spare undo tablespaces to be created by GPnP master	0
577	_lm_rcvinst	designated instance to do instance recovery	TRUE
578	_lm_use_gcr	use GCR module if TRUE	TRUE
579	_lm_use_tx_tsn	use undo tsn affinity master as TX enqueue master	TRUE
580	_lm_local_hp_enq	use static file affinity for HP enqueue mastership	TRUE
581	_lm_broadcast_res	Enable broadcast of highest held mode of resource.	disable
582	_lm_broadcast_resname	Trace string of resource type(s)	AD
583	_gcs_testing	GCS testing parameter	0
584	_gcs_pkey_history	number of pkey remastering history	4000
585	_ges_designated_master	designated master for GES and GCS resources	FALSE
586	_lm_lms_spin	make lms not sleep	FALSE
587	_lm_freeze_kill_time	timeout for killing unfrozen processes in rcfg/drm freeze step	30
588	_lm_no_lh_check	skip load and health check at decision points	FALSE
589	_lm_lhupd_interval	load and health update interval	5
590	_lm_high_load_threshold	high load threshold parameter	5
591	_lm_high_load_sysload_percentage	high watermark system load percentage	90
592	_lm_low_load_percentage	low watermark percentage for load threshold	75
593	_lm_drm_hiload_percentage	drm high load threshold percentage	200
594	_lm_drm_lowload_percentage	drm low load threshold percentage	200
595	_lm_drm_min_interval	minimum interval in secs between two consecutive drms	300
596	_lm_drm_batch_time	time in seconds to wait to batch drm requests	10
597	_lm_enqueue_timeout	enqueue suggested min timeout in seconds	360
598	_lm_better_ddvictim	GES better deadlock victim	TRUE
599	_lm_msg_batch_size	GES batch message size	0
600	_lm_tickets	GES messaging tickets	1000
601	_lm_msg_cleanup_interval	GES message buffer cleanup interval time	3000
602	_lm_idle_connection_check	GES idle connection check	TRUE
603	_lm_idle_connection_check_interval	GES idle connection check interval time	140
604	_lm_idle_connection_kill	GES idle connection kill	TRUE
605	_lm_idle_connection_instance_check_callout	GES idle connection instance check callout	FALSE
606	_lm_send_mode	GES send mode	auto
607	_lm_postevent_buffer_size	postevent buffer size	256
608	_lm_kill_fg_on_timeout	GES kill fg on IPC timeout	TRUE
609	_lm_send_queue_length	GES send queue maximum length	5000
610	_lm_send_queue_batching	GES send queue message batching	TRUE
611	_lm_process_batching	GES implicit process batching for IPC messages	TRUE
612	_lm_sq_batch_factor	GES send queue minimum batching factor	2
613	_lm_sq_batch_type	GES send queue batching mechanism	auto
614	_lm_sq_batch_waittick	GES send queue batching waittime in tick	3
615	_lm_sendproxy_reserve	GES percentage of send proxy reserve of send tickets	25
616	_lm_checksum_batch_msg	GES checksum batch messages	0
617	_lm_batch_compression_threshold	GES threshold to start compression on batch messages	0
618	_lm_compression_scheme	GES compression scheme	zlib
619	_lm_validate_pbatch	GES process batch validation	FALSE
620	_lm_watchpoint_maximum	GES number of watchpoints	3
621	_lm_watchpoint_timeout	GES maximum time in seconds to keep watchpoint	3600
622	_lm_free_queue_threshold	GES free queue threshold	0
623	_abort_recovery_on_join	if TRUE, abort recovery on join reconfigurations	FALSE
624	_send_ast_to_foreground	if TRUE, send ast message to foreground	AUTO
625	_reliable_block_sends	if TRUE, no side channel on reliable interconnect	TRUE
626	_blocks_per_cache_server	number of consecutive blocks per global cache server	32
627	_object_reuse_bast	if 1 or higher, handle object reuse	2
628	_delta_push_share_blockers	enable delta push if greater than the # of share blockers	0
629	_send_close_with_block	if TRUE, send close with block even with direct sends	TRUE
630	_gcs_fast_reconfig	if TRUE, enable fast reconfiguration for gcs locks	TRUE
631	_cr_grant_global_role	if TRUE, grant lock for CR requests when block is in global role	TRUE
632	_cr_grant_local_role	turn 3-way CR grants off, make it automatic, or turn it on	AUTO
633	_cr_grant_only	if TRUE, grant locks when possible and do not send the block	FALSE
634	_skip_assume_msg	if TRUE, skip assume message for consigns at the master	TRUE
635	_gcs_resources	number of gcs resources to be allocated
636	_gcs_latches	number of gcs resource hash latches to be allocated per LMS process	0
637	_gcs_process_in_recovery	if TRUE, process gcs requests during instance recovery	TRUE
638	_scatter_gcs_resources	if TRUE, gcs resources are scattered uniformly across sub pools	FALSE
639	_gcs_res_per_bucket	number of gcs resource per hash bucket	4
640	_gcs_shadow_locks	number of pcm shadow locks to be allocated
641	_scatter_gcs_shadows	if TRUE, gcs shadows are scattered uniformly across sub pools	FALSE
642	_gcs_disable_remote_handles	disable remote client/shadow handles	FALSE
643	_gcs_disable_skip_close_remastering	if TRUE, disable skip close optimization in remastering	FALSE
644	_side_channel_batch_size	number of messages to batch in a side channel message (DFS)	200
645	_side_channel_batch_timeout	timeout before shipping out the batched side channelmessages in seconds	6
646	_side_channel_batch_timeout_ms	timeout before shipping out the batched side channelmessages in milliseconds	500
647	_broadcast_scn_wait_timeout	broadcast-on-commit scn wait timeout in centiseconds	10
648	_hb_redo_msg_interval	BOC HB redo message interval in ms	100
649	_master_direct_sends	direct sends for messages from master (DFS)	31
650	_cgs_send_timeout	CGS send timeout value	300
651	_imr_active	Activate Instance Membership Recovery feature	TRUE
652	_imr_max_reconfig_delay	Maximum Reconfiguration delay (seconds)	75
653	_imr_splitbrain_res_wait	Maximum wait for split-brain resolution (seconds)	0
654	_imr_disk_voting_interval	Maximum wait for IMR disk voting (seconds)	3
655	_imr_systemload_check	Perform the system load check during IMR	TRUE
656	_imr_device_type	Type of device to be used by IMR	controlfile
657	_imr_highload_threshold	IMR system highload threshold
658	_imr_evicted_member_kill	IMR issue evicted member kill after a wait	TRUE
659	_imr_evicted_member_kill_wait	IMR evicted member kill wait time in seconds	20
660	_imr_avoid_double_voting	Avoid device voting for CSS reconfig during IMR	TRUE
661	_imr_diskvote_implementation	IMR disk voting implementation method	auto
662	_imr_extra_reconfig_wait	Extra reconfiguration wait in seconds	10
663	_imr_controlfile_access_wait_time	IMR controlfile access wait time in seconds	10
664	_cluster_library	cluster library selection	clss
665	_cgs_reconfig_timeout	CGS reconfiguration timeout interval	0
666	_cgs_node_kill_escalation	CGS node kill escalation to CSS	TRUE
667	_cgs_node_kill_escalation_wait	CGS wait time to escalate node kill to CSS in seconds	0
668	_cgs_zombie_member_kill_wait	CGS zombie member kill wait time in seconds	20
669	_cgs_reconfig_extra_wait	CGS reconfiguration extra wait time for CSS in seconds	3
670	_cgs_health_check_in_reconfig	CGS health check during reconfiguration	TRUE
671	_cgs_tickets	CGS messaging tickets	1000
672	_cgs_dball_group_registration	CGS DBALL group registration type	local
673	_cgs_dbgroup_poll_time	CGS DB group polling interval in milli-seconds	600
674	_cgs_allgroup_poll_time	CGS DBALL group polling interval in milli-seconds	20000
675	_lm_dynamic_load	dynamic load adjustment	TRUE
676	_notify_crs	notify cluster ready services of startup and shutdown	TRUE
677	_kill_diagnostics_timeout	timeout delay in seconds before killing enqueue blocker	60
678	_ges_diagnostics_asm_dump_level	systemstate level on global enqueue diagnostics blocked by ASM	11
679	_ges_num_blockers_to_kill	number of blockers to be killed for hang resolution	1
680	_lm_hb_callstack_collect_time	hb diagnostic call stack collection time in seconds	5
681	_lm_hb_disable_check_list	list of process names to be disabled in heartbeat check	none
682	_hang_statistics_collection_interval	Hang Management statistics collection interval in seconds	15
683	_hang_statistics_collection_ma_alpha	Hang Management statistics collection moving average alpha	30
684	_hang_statistics_high_io_percentage_threshold	Hang Management statistics high IO percentage threshold	45
685	_gcr_enable_high_cpu_kill	if TRUE, GCR may kill foregrounds under high load	FALSE
686	_gcr_enable_high_cpu_rm	if TRUE, GCR may enable a RM plan under high load	FALSE
687	_gcr_enable_high_cpu_rt	if TRUE, GCR may boost bg priority under high load	FALSE
688	_gcr_high_cpu_threshold	minimum amount of CPU process must consume to be kill target	10
689	_gcr_use_css	if FALSE, GCR wont register with CSS nor use any CSS feature	TRUE
690	_lm_rac_spare_p1	rac parameter p1	0
691	_lm_rac_spare_p2	rac parameter p2	0
692	_lm_rac_spare_p3	rac parameter p3	0
693	_lm_rac_spare_p4	rac parameter p4	0
694	_lm_rac_spare_p5	rac parameter p5	0
695	_lm_rac_spare_p6	rac parameter p6
696	_lm_rac_spare_p7	rac parameter p7
697	_lm_rac_spare_p8	rac parameter p8
698	_lm_rac_spare_p9	rac parameter p9
699	_lm_rac_spare_p10	rac parameter p10
700	_lm_rac_spare_dp1	rac parameter dp1	0
701	_lm_rac_spare_dp2	rac parameter dp2	0
702	_lm_rac_spare_dp3	rac parameter dp3	0
703	_lm_rac_spare_dp4	rac parameter dp4	0
704	_lm_rac_spare_dp5	rac parameter dp5	0
705	_lm_rac_spare_dp6	rac parameter dp6
706	_lm_rac_spare_dp7	rac parameter dp7
707	_lm_rac_spare_dp8	rac parameter dp8
708	_lm_rac_spare_dp9	rac parameter dp9
709	_lm_rac_spare_dp10	rac parameter dp10
710	sga_target	Target size of SGA	1073741824
711	__sga_target	Actual size of SGA	1073741824
712	memory_target	Target size of Oracle SGA and PGA memory	0
713	memory_max_target	Max size for Memory Target	0
714	_disable_streams_pool_auto_tuning	disable streams pool auto tuning	FALSE
715	_memory_management_tracing	trace memory management activity	0
716	_memory_mgmt_immreq_timeout	time in seconds to time out immediate mode request	150
717	_memory_checkinuse_timeintv	check inuse time interval	30
718	_memory_mgmt_fail_immreq	always fail immediate mode request	FALSE
719	_memory_sanity_check	partial granule sanity check	0
720	_init_granule_interval	number of granules to process for deferred cache	10
721	_shared_pool_max_size	shared pool maximum size when auto SGA enabled	0
722	_shared_pool_minsize_on	shared pool minimum size when auto SGA enabled	FALSE
723	_streams_pool_max_size	streams pool maximum size when auto SGA enabled	0
724	_simulate_mem_transfer	simulate auto memory sga/pga transfers	FALSE
725	_memory_nocancel_defsgareq	do not cancel deferred sga reqs with auto-memory	FALSE
726	_memory_imm_mode_without_autosga	Allow immediate mode without sga/memory target	TRUE
727	_memory_broker_stat_interval	memory broker statistics gathering interval for auto sga	30
728	_automemory_broker_interval	memory broker statistics gathering interval for auto memory	3
729	_memory_broker_shrink_heaps	memory broker allow policy to shrink shared pool	15
730	_memory_broker_shrink_java_heaps	memory broker allow policy to shrink java pool	900
731	_memory_broker_shrink_streams_pool	memory broker allow policy to shrink streams pool	900
732	_memory_broker_shrink_timeout	memory broker policy to timeout shrink shared/java pool	60000000
733	_memory_broker_log_stat_entries	memory broker num stat entries	5
734	_memory_initial_sga_split_perc	Initial default sga target percentage with memory target	60
735	_memory_broker_marginal_utility_sp	Marginal Utility threshold pct for sp	7
736	_memory_broker_marginal_utility_bc	Marginal Utility threshold pct for bc	12
737	_disable_latch_free_SCN_writes_via_32cas	disable latch-free SCN writes using 32-bit compare & swap	FALSE
738	_disable_latch_free_SCN_writes_via_64cas	disable latch-free SCN writes using 64-bit compare & swap	FALSE
739	control_files	control file names list	+DATA/orclasm/controlfile/current.256.929201173, +FRA/orclasm/controlfile/current.256.850260253
740	_controlfile_enqueue_timeout	control file enqueue timeout in seconds	900
741	_controlfile_enqueue_holding_time	control file enqueue max holding time in seconds	120
742	_controlfile_enqueue_holding_time_tracking_size	control file enqueue holding time tracking size	10
743	_controlfile_update_check	controlfile update sanity check	OFF
744	_controlfile_enqueue_dump	dump the system states after controlfile enqueue timeout	FALSE
745	_controlfile_block_size	control file block size in bytes	0
746	_controlfile_section_init_size	control file initial section size
747	_controlfile_section_max_expand	control file max expansion rate
748	db_file_name_convert	datafile name convert patterns and strings for standby/clone db
749	log_file_name_convert	logfile name convert patterns and strings for standby/clone db
750	control_file_record_keep_time	control file record keep time in days	14
751	_kill_controlfile_enqueue_blocker	enable killing controlfile enqueue blocker on timeout	TRUE
752	_controlfile_backup_copy_check	enable check of the copied blocks during controlfile backup copy	TRUE
753	db_block_buffers	Number of database blocks cached in memory	0
754	_db_block_buffers	Number of database blocks cached in memory: hidden parameter	41391
755	_db_block_cache_protect	protect database blocks (true only when debugging)	FALSE
756	_db_block_cache_protect_internal	protect database blocks (for strictly internal use only)	0
757	db_block_checksum	store checksum in db blocks and check during reads	TRUE
758	db_ultra_safe	Sets defaults for other parameters that control protection levels	OFF
759	db_block_size	Size of database block in bytes	8192
760	_dbwr_tracing	Enable dbwriter tracing	0
761	_tsenc_tracing	Enable TS encryption tracing	0
762	_disable_multiple_block_sizes	disable multiple block size support (for debugging)	FALSE
763	_db_fast_obj_truncate	enable fast object truncate	TRUE
764	_db_fast_obj_ckpt	enable fast object checkpoint	TRUE
765	_enable_obj_queues	enable object queues	TRUE
766	_db_obj_enable_ksr	enable ksr in object checkpoint/reuse	TRUE
767	_small_table_threshold	lower threshold level of table size for direct reads	827
768	_very_large_object_threshold	upper threshold level of object size for direct reads	500
769	_db_block_cache_num_umap	number of unmapped buffers (for tracking swap calls on blocks)	0
770	_dbwr_async_io	Enable dbwriter asynchronous writes	TRUE
771	_recovery_percentage	recovery buffer cache percentage	50
772	_db_lost_write_checking	Enable scn based lost write detection mechanism	2
773	_db_lost_write_tracing	Enable _db_lost_write_checking tracing	FALSE
774	__db_cache_size	Actual size of DEFAULT buffer pool for standard block size buffers	352321536
775	db_cache_size	Size of DEFAULT buffer pool for standard block size buffers	301989888
776	_db_block_numa	Number of NUMA nodes	1
777	db_2k_cache_size	Size of cache for 2K buffers	0
778	db_4k_cache_size	Size of cache for 4K buffers	0
779	db_8k_cache_size	Size of cache for 8K buffers	0
780	db_16k_cache_size	Size of cache for 16K buffers	0
781	db_32k_cache_size	Size of cache for 32K buffers	0
782	db_keep_cache_size	Size of KEEP buffer pool for standard block size buffers	0
783	db_recycle_cache_size	Size of RECYCLE buffer pool for standard block size buffers	0
784	__shared_io_pool_size	Actual size of shared IO pool	0
785	_shared_io_pool_size	Size of shared IO pool	0
786	_db_hot_block_tracking	track hot blocks for hash latch contention	FALSE
787	_sga_clear_dump	Allow dumping encrypted blocks in clear for debugging	FALSE
788	_clear_buffer_before_reuse	Always zero-out buffer before reuse for security	FALSE
789	_db_block_bad_write_check	enable bad write checks	FALSE
790	_db_block_lru_latches	number of lru latches	16
791	_db_percpu_create_cachesize	size of cache created per cpu in deferred cache create	2
792	_db_initial_cachesize_create_mb	size of cache created at startup	256
793	_db_num_evict_waitevents	number of evict wait events	64
794	_db_todefer_cache_create	buffer cache deferred create	TRUE
795	db_writer_processes	number of background database writer processes to start	1
796	_db_block_known_clean_pct	Initial Percentage of buffers to maintain known clean	2
797	_db_block_max_scan_pct	Percentage of buffers to inspect when looking for free	40
798	_db_large_dirty_queue	Number of buffers which force dirty queue to be written	25
799	_db_writer_max_writes	Max number of outstanding DB Writer IOs	0
800	_db_writer_chunk_writes	Number of writes DBWR should wait for	0
801	_db_block_med_priority_batch_size	Fraction of writes for medium priority reasons	0
802	_db_block_hi_priority_batch_size	Fraction of writes for high priority reasons	0
803	_db_writer_histogram_statistics	maintain dbwr histogram statistics in x$kcbbhs	FALSE
804	_dbwr_scan_interval	dbwriter scan interval	300
805	_db_writer_flush_imu	If FALSE, DBWR will not downgrade IMU txns for AGING	TRUE
806	_db_writer_coalesce_write_limit	Limit on size of coalesced write	131072
807	_db_writer_coalesce_area_size	Size of memory allocated to dbwriter for coalescing writes	3522560
808	_db_writer_nomemcopy_coalesce	Enable DBWR no-memcopy coalescing	FALSE
809	_selftune_checkpoint_write_pct	Percentage of total physical i/os for self-tune ckpt	3
810	_db_writer_verify_writes	Enable lost write detection mechanism	FALSE
811	_db_block_prefetch_quota	Prefetch quota as a percent of cache size	10
812	_db_block_prefetch_limit	Prefetch limit in blocks	0
813	_db_block_prefetch_override	Prefetch force override in blocks	0
814	_rbr_ckpt_tracing	Enable reuse block range checkpoint tracing	0
815	_db_cache_pre_warm	Buffer Cache Pre-Warm Enabled : hidden parameter	TRUE
816	buffer_pool_keep	Number of database blocks/latches in keep buffer pool
817	buffer_pool_recycle	Number of database blocks/latches in recycle buffer pool
818	_db_percent_hot_default	Percent of default buffer pool considered hot	50
819	_db_percent_hot_keep	Percent of keep buffer pool considered hot	0
820	_db_percent_hot_recycle	Percent of recycle buffer pool considered hot	0
821	_db_aging_hot_criteria	Touch count which sends a buffer to head of replacement list	2
822	_db_aging_stay_count	Touch count set when buffer moved to head of replacement list	0
823	_db_aging_cool_count	Touch count set when buffer cooled	1
824	_db_aging_touch_time	Touch count which sends a buffer to head of replacement list	3
825	_db_aging_freeze_cr	Make CR buffers always be too cold to keep in cache	FALSE
826	_db_block_hash_buckets	Number of database block hash buckets	131072
827	_db_block_hash_latches	Number of database block hash latches	4096
828	_db_blocks_per_hash_latch	Number of blocks per hash latch
829	_db_handles_cached	Buffer handles cached each process	8
830	_db_handles	System-wide simultaneous buffer operations	4000
831	_wait_for_sync	wait for sync on commit MUST BE ALWAYS TRUE	TRUE
832	_db_block_vlm_check	check of rvlm mapping leaks (for debugging)	FALSE
833	_db_block_vlm_leak_threshold	Threshold for allowable vlm leaks	3
834	_db_block_cache_clone	Always clone data blocks on get (for debugging)	FALSE
835	_db_block_trace_protect	trace buffer protect calls	FALSE
836	_db_cache_miss_check_les	check LEs after cache miss	FALSE
837	_db_block_max_cr_dba	Maximum Allowed Number of CR buffers per dba	6
838	_write_clones	write clones flag	3
839	_check_block_after_checksum	perform block check after checksum if both are turned on	TRUE
840	_trace_pin_time	trace how long a current pin is held	0
841	_db_fast_obj_check	enable fast object drop sanity check	FALSE
842	_db_block_temp_redo	generate redo for temp blocks	FALSE
843	_db_block_adjchk_level	adjacent cache buffer check level	7
844	_db_block_adjcheck	adjacent cache buffer checks - low blkchk overwrite parameter	TRUE
845	_db_required_percent_fairshare_usage	percent of fairshare a processor group should always use	10
846	_db_block_check_objtyp	check objd and typ on cache disk read	TRUE
847	_db_block_do_full_mbreads	do full block read even if some blocks are in cache	FALSE
848	_shared_iop_max_size	maximum shared io pool size	536870912
849	_shared_io_pool_buf_size	Shared IO pool buffer size	1048576
850	_siop_flashback_scandepth	Shared IO pool flashback io completion scan depth	20
851	_shared_io_pool_debug_trc	trace kcbi debug info to tracefile	0
852	_shared_io_set_value	shared io pool size set internal value - overwrite zero user size	FALSE
853	_trace_buffer_wait_timeouts	trace buffer busy wait timeouts	0
854	_buffer_busy_wait_timeout	buffer busy wait time in centiseconds	100
855	_db_cache_crx_check	check for costly crx examination functions	FALSE
856	_db_cache_mman_latch_check	check for wait latch get under MMAN ops in kcb	FALSE
857	_db_block_cache_history	buffer header tracing (non-zero only when debugging)	0
858	_db_block_cache_history_level	buffer header tracing level	2
859	_db_block_header_guard_level	number of extra buffer headers to use as guard pages	0
860	_db_block_table_scan_buffer_size	Size of shared table scan read buffer	4194304
861	_db_cache_process_cr_pin_max	maximum number of cr pins a process may have
862	_db_block_corruption_recovery_threshold	threshold number of block recovery attempts	5
863	_db_block_chunkify_ncmbr	chunkify noncontig multi block reads	FALSE
864	_db_cache_wait_debug	trace new kslwaits	0
865	_fastpin_enable	enable reference count based fast pins	229847041
866	_db_prefetch_histogram_statistics	maintain prefetch histogram statistics in x$kcbprfhs	FALSE
867	_flush_undo_after_tx_recovery	if TRUE, flush undo buffers after TX recovery	TRUE
868	_spare_test_parameter	Spare test parameter	0
869	db_flash_cache_file	flash cache file for default block size
870	db_flash_cache_size	flash cache size for db_flash_cache_file	0
871	_db_2k_flash_cache_file	flash cache file for 2k block size
872	_db_2k_flash_cache_size	flash cache size for _db_2k_flash_cache_file	0
873	_db_4k_flash_cache_file	flash cache file for 4k block size
874	_db_4k_flash_cache_size	flash cache size for _db_4k_flash_cache_file	0
875	_db_8k_flash_cache_file	flash cache file for 8k block size
876	_db_8k_flash_cache_size	flash cache size for _db_8k_flash_cache_file	0
877	_db_16k_flash_cache_file	flash cache file for 16k block size
878	_db_16k_flash_cache_size	flash cache size for _db_16k_flash_cache_file	0
879	_db_32k_flash_cache_file	flash cache file for 32k block size
880	_db_32k_flash_cache_size	flash cache size for _db_32k_flash_cache_file	0
881	_db_flash_cache_keep_limit	Flash cache keep buffer upper limit in percentage	229771856
882	_db_flash_cache_write_limit	Flash cache write buffer upper limit in percentage	1
883	_db_flash_cache_force_replenish_limit	Flash cache force replenish lower limit in buffers	8
884	_db_l2_tracing	flash cache debug tracing	0
885	_db_dump_from_disk_noefc	dump reading buffer contents	0
886	_numa_buffer_cache_stats	Configure NUMA buffer cache stats	0
887	_db_cache_block_read_stack_trace	dump short call stack for block reads	0
888	db_cache_advice	Buffer cache sizing advisory	ON
889	_db_cache_advice_sample_factor	cache advisory sampling factor	4
890	_db_cache_advice_max_size_factor	cache advisory maximum multiple of current size to similate	2
891	_db_cache_advice_sanity_check	cache simulation sanity check	FALSE
892	_db_mttr_advice	MTTR advisory	ON
893	_db_mttr_sim_target	MTTR simulation targets
894	_db_mttr_sample_factor	MTTR simulation sampling factor	64
895	_db_mttr_partitions	number of partitions for MTTR advisory	0
896	_db_mttr_sim_trace_size	MTTR simulation trace size	256
897	_db_mttr_trace_to_alert	dump trace entries to alert file	FALSE
898	_obj_ckpt_tracing	Enable object checkpoint tracing	0
899	_immediate_commit_propagation	if TRUE, propagate commit SCN immediately	TRUE
900	_minimum_giga_scn	Minimum SCN to start with in 2^30 units	0
901	_max_reasonable_scn_rate	Max reasonable SCN rate	32768
902	_reasonable_scn_offset_seconds	Reasonable SCN offset seconds	0
903	compatible	Database will be completely compatible with this software version	11.2.0.3.0
904	_redo_compatibility_check	general and redo/undo compatibility sanity check	FALSE
905	_db_block_check_for_debug	Check more and dump block before image for debugging	FALSE
906	_db_always_check_system_ts	Always perform block check and checksum for System tablespace	TRUE
907	_log_checkpoint_recovery_check	# redo blocks to verify after checkpoint	0
908	_two_pass	enable two-pass thread recovery	TRUE
909	_recovery_verify_writes	enable thread recovery write verify	FALSE
910	_disable_recovery_read_skip	Disable the read optimization during media recovery	FALSE
911	_redo_transport_stream_writes	Stream network writes?	TRUE
912	_redo_transport_stream_test	test stream connection?	TRUE
913	_redo_transport_vio_size_req	VIO size requirement	4294967294
914	log_archive_dest_1	archival destination #1 text string
915	log_archive_dest_2	archival destination #2 text string
916	log_archive_dest_3	archival destination #3 text string
917	log_archive_dest_4	archival destination #4 text string
918	log_archive_dest_5	archival destination #5 text string
919	log_archive_dest_6	archival destination #6 text string
920	log_archive_dest_7	archival destination #7 text string
921	log_archive_dest_8	archival destination #8 text string
922	log_archive_dest_9	archival destination #9 text string
923	log_archive_dest_10	archival destination #10 text string
924	log_archive_dest_11	archival destination #11 text string
925	log_archive_dest_12	archival destination #12 text string
926	log_archive_dest_13	archival destination #13 text string
927	log_archive_dest_14	archival destination #14 text string
928	log_archive_dest_15	archival destination #15 text string
929	log_archive_dest_16	archival destination #16 text string
930	log_archive_dest_17	archival destination #17 text string
931	log_archive_dest_18	archival destination #18 text string
932	log_archive_dest_19	archival destination #19 text string
933	log_archive_dest_20	archival destination #20 text string
934	log_archive_dest_21	archival destination #21 text string
935	log_archive_dest_22	archival destination #22 text string
936	log_archive_dest_23	archival destination #23 text string
937	log_archive_dest_24	archival destination #24 text string
938	log_archive_dest_25	archival destination #25 text string
939	log_archive_dest_26	archival destination #26 text string
940	log_archive_dest_27	archival destination #27 text string
941	log_archive_dest_28	archival destination #28 text string
942	log_archive_dest_29	archival destination #29 text string
943	log_archive_dest_30	archival destination #30 text string
944	log_archive_dest_31	archival destination #31 text string
945	log_archive_dest_state_1	archival destination #1 state text string	enable
946	log_archive_dest_state_2	archival destination #2 state text string	enable
947	log_archive_dest_state_3	archival destination #3 state text string	enable
948	log_archive_dest_state_4	archival destination #4 state text string	enable
949	log_archive_dest_state_5	archival destination #5 state text string	enable
950	log_archive_dest_state_6	archival destination #6 state text string	enable
951	log_archive_dest_state_7	archival destination #7 state text string	enable
952	log_archive_dest_state_8	archival destination #8 state text string	enable
953	log_archive_dest_state_9	archival destination #9 state text string	enable
954	log_archive_dest_state_10	archival destination #10 state text string	enable
955	log_archive_dest_state_11	archival destination #11 state text string	enable
956	log_archive_dest_state_12	archival destination #12 state text string	enable
957	log_archive_dest_state_13	archival destination #13 state text string	enable
958	log_archive_dest_state_14	archival destination #14 state text string	enable
959	log_archive_dest_state_15	archival destination #15 state text string	enable
960	log_archive_dest_state_16	archival destination #16 state text string	enable
961	log_archive_dest_state_17	archival destination #17 state text string	enable
962	log_archive_dest_state_18	archival destination #18 state text string	enable
963	log_archive_dest_state_19	archival destination #19 state text string	enable
964	log_archive_dest_state_20	archival destination #20 state text string	enable
965	log_archive_dest_state_21	archival destination #21 state text string	enable
966	log_archive_dest_state_22	archival destination #22 state text string	enable
967	log_archive_dest_state_23	archival destination #23 state text string	enable
968	log_archive_dest_state_24	archival destination #24 state text string	enable
969	log_archive_dest_state_25	archival destination #25 state text string	enable
970	log_archive_dest_state_26	archival destination #26 state text string	enable
971	log_archive_dest_state_27	archival destination #27 state text string	enable
972	log_archive_dest_state_28	archival destination #28 state text string	enable
973	log_archive_dest_state_29	archival destination #29 state text string	enable
974	log_archive_dest_state_30	archival destination #30 state text string	enable
975	log_archive_dest_state_31	archival destination #31 state text string	enable
976	log_archive_start	start archival process on SGA initialization	FALSE
977	log_archive_dest	archival destination text string
978	log_archive_duplex_dest	duplex archival destination text string
979	log_archive_min_succeed_dest	minimum number of archive destinations that must succeed	1
980	standby_archive_dest	standby database archivelog destination text string	?/dbs/arch
981	_arch_sim_mode	Change behavior of local archiving	0
982	_dg_corrupt_redo_log	Corrupt redo log validation during archivals	0
983	_local_arc_assert_on_wait	Assert whenever local ORL arch waits for space	FALSE
984	_defer_eor_orl_arch_for_so	defer EOR ORL archival for switchover	FALSE
985	fal_client	FAL client
986	fal_server	FAL server list
987	_enable_ffw	FAL FORWARDING	TRUE
988	_force_rcv_info_ping	Force recovery info ping to stdby	0
989	log_archive_trace	Establish archivelog operation tracing level	0
990	_log_archive_trace_pids	log archive trace pids parameter
991	_flush_redo_to_standby	Flush redo to standby test event parameter	0
992	_redo_transport_sanity_check	redo transport sanity check bit mask	0
993	_dg_cf_check_timer	Data Guard controlfile check timer	15
994	_bypass_srl_for_so_eor	bypass SRL for S/O EOR logs	FALSE
995	_rta_sync_wait_timeout	RTA sync wait timeout	10
996	_log_archive_prot_auto_demote	log archive protection auto demotion	FALSE
997	_serialize_lgwr_sync_io	Serialize LGWR SYNC local and remote io	FALSE
998	_mgd_rcv_handle_orphan_datafiles	Managed recovery handle orphan datafile situation	FALSE
999	_real_time_apply_sim	Simulation value with real time apply	0
1000	_defer_rcv_during_sw_to_sby	Defer recovery during switchover to standby	FALSE
1001	_skip_trstamp_check	Skip terminal recovery stamp check	FALSE
1002	_set_mgd_recovery_state	set mgd recovery state to new value	0
1003	_show_mgd_recovery_state	Show internal managed recovery state	FALSE
1004	_log_archive_security_enabled	log archive security enabled	TRUE
1005	log_archive_config	log archive config parameter
1006	_enable_sb_detection	Split Brain Detection	TRUE
1007	_log_archive_buffers	Number of buffers to allocate for archiving	10
1008	_redo_transport_compress_all	Is ASYNC LNS compression allowed?	TRUE
1009	_log_archive_callout	archival callout
1010	log_archive_local_first	Establish EXPEDITE attribute default value	TRUE
1011	_rtc_infeasible_threshold	Redo Transport Compression infeasible threshold	25
1012	log_archive_format	archival destination format	%t_%s_%r.dbf
1013	_disable_thread_snapshot	Thread snapshot	TRUE
1014	_log_archive_avoid_memcpy	log archive avoid memcpy	TRUE
1015	_log_archive_strong_auth	log archive security strong auth	TRUE
1016	redo_transport_user	Data Guard transport user when using password file
1017	_lgwr_ns_nl_min	Variable to simulate network latency or buffer threshold	500
1018	_lgwr_ns_nl_max	Variable to simulate network latency or buffer threshold	1000
1019	_redo_transport_stall_time	I/O stall time before terminating redo transport process	360
1020	_redo_transport_stall_time_long	long I/O stall time before terminating redo transport process	3600
1021	log_archive_max_processes	maximum number of active ARCH processes	4
1022	_max_lns_shutdown_archival_time	Maximum time spent by LNS to archive last log during shutdown	30
1023	_ta_lns_wait_for_arch_log	LNS Wait time for arhcived version of online log	20
1024	_lgwr_max_ns_wt	Maximum wait time for lgwr to allow NetServer to progress	1
1025	_ns_max_flush_wt	Flush wait time for NetServer to flush oustanding writes	1
1026	_ns_max_send_delay	Data Loss Time Bound for NetServer	15
1027	_lgwr_ta_sim_err	Variable to simulate errors lgwr true async	0
1028	_lgwr_ns_sim_err	Variable to simulate errors lgwrns	0
1029	_log_archive_network_redo_size	Log archive network redo buffer size used by ARCH	10
1030	_switchover_to_standby_switch_log	Switchover to standby switches log for open redo threads	TRUE
1031	_max_async_wait_for_catch_up	Switchover wait time for async LNS to catch up in seconds	20
1032	_lgwr_delay_write	LGWR write delay for debugging	FALSE
1033	_enable_redo_global_post	LGWR post globally on write	FALSE
1034	log_buffer	redo circular buffer size	8478720
1035	_log_io_size	automatically initiate log write if this many redo blocks in buffer	0
1036	_log_event_queues	number of the log writer event queues	0
1037	log_checkpoint_interval	# redo blocks checkpoint threshold	0
1038	log_checkpoint_timeout	Maximum time interval between checkpoints in seconds	1800
1039	_log_switch_timeout	Maximum number of seconds redos in the current log could span	0
1040	archive_lag_target	Maximum number of seconds of redos the standby could lose	0
1041	_log_buffers_debug	debug redo buffers (slows things down)	FALSE
1042	_log_buffers_corrupt	corrupt redo buffers before write	FALSE
1043	_log_simultaneous_copies	number of simultaneous copies into redo buffer(# of copy latches)	4
1044	_log_parallelism_max	Maximum number of log buffer strands	2
1045	_log_parallelism_dynamic	Enable dynamic strands	TRUE
1046	_log_private_parallelism_mul	Active sessions multiplier to deduce number of private strands	10
1047	_log_private_mul	Private strand multiplier for log space preallocation	5
1048	_lightweight_hdrs	Lightweight headers for redo	TRUE
1049	_redo_read_from_memory	Enable reading redo from in-memory log buffer	TRUE
1050	_desired_readmem_rate	The desired percentage of redo reading from memory	90
1051	_log_read_buffer_size	buffer size for reading log files	8
1052	_validate_readmem_redo	validate redo blocks read from in-memory log buffer	OFF
1053	_mirror_redo_buffers	Save buffers for debugging redo corruptions	FALSE
1054	_fg_log_checksum	Checksum redo in foreground process	TRUE
1055	_verify_fg_log_checksum	LGWR verifies redo checksums generated by foreground processes	FALSE
1056	_disable_logging	Disable logging	FALSE
1057	_log_buffer_coalesce	Coalescing log buffers for log writes	FALSE
1058	_fg_sync_sleep_usecs	Log file sync via usleep	0
1059	_log_file_sync_timeout	Log file sync timeout (centiseconds)	10
1060	_use_adaptive_log_file_sync	Adaptively switch between post/wait and polling	TRUE
1061	_adaptive_log_file_sync_use_polling_threshold	Ratio of redo synch time to expected poll time as a percentage	200
1062	_adaptive_log_file_sync_use_postwait_threshold	Percentage of foreground load from when post/wait was last used	50
1063	_adaptive_log_file_sync_sched_delay_window	Window (in seconds) for measuring average scheduling delay	60
1064	_adaptive_log_file_sync_poll_aggressiveness	Polling interval selection bias (conservative=0, aggressive=100)	0
1065	_adaptive_log_file_sync_high_switch_freq_threshold	Threshold for frequent log file sync mode switches (per minute)	3
1066	_max_pending_scn_bcasts	maximum number of pending SCN broadcasts	8
1067	_lgwr_posts_for_pending_bcasts	LGWR posts commit waiters for pending broadcasts	FALSE
1068	_long_log_write_warning_threshold	threshold for long log write warning messages in ms	500
1069	_long_bcast_ack_warning_threshold	threshold for long bcast ack warning messages in ms	500
1070	_enable_flash_logging	Enable Exadata Smart Flash Logging	TRUE
1071	db_files	max allowable # db files	200
1072	db_file_multiblock_read_count	db block to be read each IO	53
1073	_db_file_exec_read_count	multiblock read count for regular clients	53
1074	_db_file_optimizer_read_count	multiblock read count for regular clients	8
1075	_db_file_noncontig_mblock_read_count	number of noncontiguous db blocks to be prefetched	11
1076	read_only_open_delayed	if TRUE delay opening of read only files until first access	FALSE
1077	cluster_database	if TRUE startup in cluster database mode	FALSE
1078	parallel_server	if TRUE startup in parallel server mode	FALSE
1079	parallel_server_instances	number of instances to use for sizing OPS SGA structures	1
1080	cluster_database_instances	number of instances to use for sizing cluster db SGA structures	1
1081	db_create_file_dest	default database location	+DATA
1082	db_create_online_log_dest_1	online log/controlfile destination #1
1083	db_create_online_log_dest_2	online log/controlfile destination #2
1084	db_create_online_log_dest_3	online log/controlfile destination #3
1085	db_create_online_log_dest_4	online log/controlfile destination #4
1086	db_create_online_log_dest_5	online log/controlfile destination #5
1087	db_recovery_file_dest	default database recovery file location	+FRA
1088	db_recovery_file_dest_size	database recovery files size limit	8589934592
1089	_db_recovery_temporal_file_dest	default database recovery temporal file location
1090	standby_file_management	if auto then files are created/dropped automatically on standby	MANUAL
1091	_standby_switchover_timeout	Number of secords for standby switchover enqueue timeout	120
1092	_hard_protection	if TRUE enable H.A.R.D specific format changes	FALSE
1093	_datafile_cow	Use copy on write snapshot for the renamed file	FALSE
1094	_max_filestat_tries	maximum number of file stat tries	10
1095	_allow_error_simulation	Allow error simulation for testing	FALSE
1096	_db_file_format_io_buffers	Block formatting I/O buf count	4
1097	_disable_read_only_open_dict_check	Disable read-only open dictionary check	FALSE
1098	_standby_flush_mode	standby flush mode	SLFLUSH
1099	_causal_standby_wait_timeout	Causal standby wait timeout	20
1100	_gc_use_cr	if TRUE, allow CR pins on PI and WRITING buffers	TRUE
1101	_gc_undo_affinity	if TRUE, enable dynamic undo affinity	TRUE
1102	_gc_disable_s_lock_brr_ping_check	if TRUE, disable S lock BRR ping check for lost write protect	TRUE
1103	_gc_policy_time	how often to make object policy decisions in minutes	10
1104	_gc_policy_minimum	dynamic object policy minimum activity per minute	1500
1105	_gc_affinity_ratio	dynamic object affinity ratio	50
1106	_gc_transfer_ratio	dynamic object read-mostly transfer ratio	2
1107	_recovery_asserts	if TRUE, enable expensive integrity checks	FALSE
1108	_gc_integrity_checks	set the integrity check level	1
1109	_gc_vector_read	if TRUE, vector read current buffers	TRUE
1110	_gc_element_percent	global cache element percent	110
1111	_gc_latches	number of latches per LMS process	8
1112	_gc_statistics	if TRUE, kcl statistics are maintained	TRUE
1113	_gc_keep_recovery_buffers	if TRUE, make single instance crash recovery buffers current	TRUE
1114	_recovery_read_limit	number of recovery reads which can be outstanding	1024
1115	_gc_defer_time	how long to defer pings for hot buffers in milliseconds	1
1116	_gc_defer_ping_index_only	if TRUE, restrict deferred ping to index blocks only	TRUE
1117	_kcl_debug	if TRUE, record le history	TRUE
1118	_kcl_index_split	if TRUE, reject pings on blocks in middle of a split	TRUE
1119	_kcl_commit	if TRUE, call kjbcommit	TRUE
1120	_fairness_threshold	number of times to CR serve before downgrading lock	2
1121	_interconnect_checksum	if TRUE, checksum interconnect blocks	TRUE
1122	_cr_server_log_flush	if TRUE, flush redo log before serving a CR buffer	TRUE
1123	_gc_log_flush	if TRUE, flush redo log before a current block transfer	TRUE
1124	_async_recovery_reads	if TRUE, issue recovery reads asynchronously	TRUE
1125	_async_recovery_claims	if TRUE, issue recovery claims asynchronously	TRUE
1126	_avoid_prepare	if TRUE, do not prepare a buffer when the master is local	TRUE
1127	_bwr_for_flushed_pi	if TRUE, generate a BWR for a flushed PI	TRUE
1128	_send_requests_to_pi	if TRUE, try to send CR requests to PI buffers	TRUE
1129	_kcl_conservative_log_flush	if TRUE, conservatively log flush before CR serving	FALSE
1130	_gc_check_bscn	if TRUE, check for stale blocks	TRUE
1131	_gc_global_cpu	global cpu checks	TRUE
1132	_gc_global_lru	turn global lru off, make it automatic, or turn it on	AUTO
1133	_gc_global_lru_touch_count	global lru touch count	5
1134	_gc_global_lru_touch_time	global lru touch time in seconds	60
1135	_gc_coalesce_recovery_reads	if TRUE, coalesce recovery reads	TRUE
1136	_gc_maximum_bids	maximum number of bids which can be prepared	0
1137	_gc_async_memcpy	if TRUE, use async memcpy	FALSE
1138	_gc_global_checkpoint_scn	if TRUE, enable global checkpoint scn	TRUE
1139	_gc_undo_block_disk_reads	if TRUE, enable undo block disk reads	TRUE
1140	_gc_long_query_threshold	threshold for long running query	0
1141	_gc_affinity_locking	if TRUE, enable object affinity	TRUE
1142	_gc_affinity_locks	if TRUE, get affinity locks	TRUE
1143	_gc_read_mostly_locking	if TRUE, enable read-mostly locking	TRUE
1144	_gc_persistent_read_mostly	if TRUE, enable persistent read-mostly locking	TRUE
1145	_gc_bypass_readers	if TRUE, modifications bypass readers	TRUE
1146	_gc_max_downcvt	maximum downconverts to process at one time	256
1147	_gc_tsn_undo_affinity	if TRUE, use TSN undo affinity	TRUE
1148	_gc_fusion_compression	compress fusion blocks if there is free space	1024
1149	_gc_down_convert_after_keep	if TRUE, down-convert lock after recovery	TRUE
1150	_gc_delta_push_objects	objects which use delta push	0
1151	_gc_delta_push_max_level	max delta level for delta push	100
1152	_gc_delta_push_compression	if delta >= K bytes, compress before push	3072
1153	_gc_flush_during_affinity	if TRUE, flush during affinity	TRUE
1154	_gc_cr_server_read_wait	if TRUE, cr server waits for a read to complete	TRUE
1155	_gc_read_mostly_flush_check	if TRUE, optimize flushes for read mostly objects	FALSE
1156	_gc_override_force_cr	if TRUE, try to override force-cr requests	TRUE
1157	_gc_escalate_bid	if TRUE, escalates create a bid	TRUE
1158	_gc_cpu_time	if TRUE, record the gc cpu time	FALSE
1159	_gc_fg_merge	if TRUE, merge pi buffers in the foreground	TRUE
1160	_gc_no_fairness_for_clones	if TRUE, no fairness if we serve a clone	TRUE
1161	_gc_serve_high_pi_as_current	if TRUE, use a higher clone scn when serving a pi	TRUE
1162	_gc_sanity_check_cr_buffers	if TRUE, sanity check CR buffers	FALSE
1163	_adaptive_direct_read	Adaptive Direct Read	TRUE
1164	_adaptive_direct_write	Adaptive Direct Write	TRUE
1165	_db_block_align_direct_read	Align Direct Reads	TRUE
1166	_db_noarch_disble_optim	Image redo logging (NOARCHIVEMODE)	FALSE
1167	_db_disable_temp_encryption	Disable Temp Encryption for Spills	FALSE
1168	db_unrecoverable_scn_tracking	Track nologging SCN in controlfile	TRUE
1169	_direct_io_slots	number of slots for direct path I/O	0
1170	_direct_io_skip_cur_slot_on_error	Skip current slot on error	TRUE
1171	_direct_io_wslots	number of write slots for direct path I/O	0
1172	thread	Redo thread to mount	0
1173	_disable_incremental_checkpoints	Disable incremental checkpoints for thread recovery	FALSE
1174	_disable_thread_internal_disable	Disable thread internal disable feature	FALSE
1175	_disable_selftune_checkpointing	Disable self-tune checkpointing	FALSE
1176	_selftune_checkpointing_lag	Self-tune checkpointing lag the tail of the redo log	300
1177	_target_rba_max_lag_percentage	target rba max log lag percentage	81
1178	_no_recovery_through_resetlogs	no recovery through this resetlogs operation	FALSE
1179	fast_start_io_target	Upper bound on recovery reads	0
1180	fast_start_mttr_target	MTTR target in seconds	0
1181	_log_blocks_during_backup	log block images when changed during backup	TRUE
1182	_allow_resetlogs_corruption	allow resetlogs even if it will cause corruption	FALSE
1183	_allow_terminal_recovery_corruption	Finish terminal recovery even if it may cause corruption	FALSE
1184	_allow_read_only_corruption	allow read-only open even if database is corrupt	FALSE
1185	_recovery_skip_cfseq_check	allow media recovery even if controlfile seq check fails	FALSE
1186	log_checkpoints_to_alert	log checkpoint begin/end to alert file	FALSE
1187	db_lost_write_protect	enable lost write detection	NONE
1188	_switchover_to_standby_option	option for graceful switchover to standby	OPEN_ONE
1189	recovery_parallelism	number of server processes to use for parallel recovery	0
1190	_serial_recovery	force serial recovery or parallel recovery	FALSE
1191	_coord_message_buffer	parallel recovery coordinator side extra message buffer size	0
1192	_multiple_instance_recovery	use multiple instances for media recovery	FALSE
1193	_backup_kgc_scheme	specifies compression scheme	ZLIB
1194	_backup_kgc_bufsz	specifies buffer size to be used by BASIC compression	0
1195	_backup_kgc_type	specifies compression type used by kgc BASIC compression	0
1196	_backup_kgc_niters	specifies number of iterations done by BASIC compression	0
1197	_backup_lzo_size	specifies buffer size for LOW compression	262144
1198	_backup_kgc_perflevel	specifies compression (performance) level for MEDIUM compression	1
1199	_backup_kgc_windowbits	specifies window size for MEDIUM compression	15
1200	_backup_kgc_memlevel	specifies memory level for MEDIUM compression	8
1201	_backup_kgc_blksiz	specifies buffer size to be used by HIGH compression	9
1202	_backup_ksfq_bufcnt_max	maximum number of buffers used for backup/restore	64
1203	_backup_ksfq_bufsz	size of buffers used for backup/restore	0
1204	_backup_ksfq_bufcnt	number of buffers used for backup/restore	0
1205	_backup_disk_bufsz	size of buffers used for DISK channels	0
1206	_backup_disk_bufcnt	number of buffers used for DISK channels	0
1207	_backup_seq_bufsz	size of buffers used for non-DISK channels	0
1208	_backup_seq_bufcnt	number of buffers used for non-DISK channels	0
1209	_backup_file_bufsz	size of buffers used for file access	0
1210	_backup_file_bufcnt	number of buffers used for file access	0
1211	_restore_maxopenfiles	restore assumption for maxopenfiles	8
1212	_backup_max_gap_size	largest gap in an incremental/optimized backup buffer, in bytes	4294967294
1213	_unused_block_compression	enable unused block compression	TRUE
1214	_restore_spfile	restore spfile to this location
1215	_dummy_instance	dummy instance started by RMAN	FALSE
1216	_rman_io_priority	priority at which rman backup i/o's are done	3
1217	_rman_restore_through_link	RMAN restore through link	FALSE
1218	_backup_encrypt_opt_mode	specifies encryption block optimization mode	4294967294
1219	_disable_initial_block_compression	disable initial block compression	FALSE
1220	_undo_block_compression	enable undo block compression	TRUE
1221	_update_datafile_headers_with_space_information	user requested update of datafile headers of locally managed datafiles with space information	FALSE
1222	_disable_cell_optimized_backups	disable cell optimized backups	FALSE
1223	_backup_align_write_io	align backup write I/Os	TRUE
1224	_backup_dynamic_buffers	dynamically compute backup/restore buffer sizes	TRUE
1225	_backup_automatic_retry	automatic retry on backup write errors	10
1226	_controlfile_autobackup_delay	time delay (in seconds) for performing controlfile autobackups	300
1227	_deferred_log_dest_is_valid	consider deferred log dest as valid for log deletion (TRUE/FALSE)	TRUE
1228	_log_deletion_policy	archivelog deletion policy for mandatory/all destination	mandatory
1229	_auto_bmr	enable/disable Auto BMR	enabled
1230	_auto_bmr_req_timeout	Auto BMR Requester Timeout	60
1231	_auto_bmr_sess_threshold	Auto BMR Request Session Threshold	30
1232	_auto_bmr_pub_timeout	Auto BMR Publish Timeout	10
1233	_auto_bmr_fc_time	Auto BMR Flood Control Time	60
1234	_auto_bmr_bg_time	Auto BMR Process Run Time	3600
1235	_auto_bmr_sys_threshold	Auto BMR Request System Threshold	100
1236	_bmr_prefered_standby	standby db_unique_name prefered for standby BMR
1237	_tts_allow_charset_mismatch	allow plugging in a tablespace with an incompatible character set	FALSE
1238	_xtts_allow_pre10	allow cross platform for pre10 compatible tablespace	FALSE
1239	_xtts_set_platform_info	set cross platform info during file header read	FALSE
1240	_bypass_xplatform_error	bypass datafile header cross-platform-compliance errors	FALSE
1241	_query_on_physical	query on physical	TRUE
1242	_recoverable_recovery_batch_percent	Recoverable recovery batch size (percentage of buffer cache)	50
1243	_disable_incremental_recovery_ckpt	Disable incremental recovery checkpoint mechanism	FALSE
1244	_incremental_recovery_ckpt_min_batch	minimum number of writes for incremental recovery ckpt every second	500
1245	_multi_instance_pmr	force multi instance or single instance parallel recovery	TRUE
1246	_disable_active_influx_move	disable active influx move during parallel media recovery	FALSE
1247	_defer_log_boundary_ckpt	defer media recovery checkpoint at log boundary	TRUE
1248	_defer_log_count	Number of log boundaries media recovery checkpoint lags behind	2
1249	_transient_logical_clear_hold_mrp_bit	clear KCCDI2HMRP flag during standby recovery	FALSE
1250	_log_max_optimize_threads	maximum number of threads to which log scan optimization is applied	128
1251	_reduce_sby_log_scan	enable standby log scan optimization	TRUE
1252	_sync_primary_wait_time	wait time for alter session sync with primary	5
1253	_standby_implicit_rcv_timeout	minutes to wait for redo during standby implicit recovery	1
1254	_readable_standby_sync_timeout	readable standby query scn sync timeout	10
1255	_read_only_violation_max_count	read-only violation array max count	500
1256	_read_only_violation_max_count_per_module	read-only violation array per module max count	100
1257	_read_only_violation_dump_to_trace	read-only violation dump to trace files	FALSE
1258	_media_recovery_read_batch	media recovery block read batch	32
1259	_standby_causal_heartbeat_timeout	readable standby causal heartbeat timeout	2
1260	_bct_public_dba_buffer_size	total size of all public change tracking dba buffers, in bytes	0
1261	_bct_initial_private_dba_buffer_size	initial number of entries in the private change tracking dba buffers	0
1262	_bct_bitmaps_per_file	number of bitmaps to store for each datafile	8
1263	_bct_file_block_size	block size of change tracking file, in bytes	0
1264	_bct_file_extent_size	extent size of change tracking file, in bytes	0
1265	_bct_chunk_size	change tracking datafile chunk size, in bytes	0
1266	_bct_crash_reserve_size	change tracking reserved crash recovery SGA space, in bytes	262144
1267	_bct_buffer_allocation_size	size of one change tracking buffer allocation, in bytes	2097152
1268	_bct_buffer_allocation_max	maximum size of all change tracking buffer allocations, in bytes	104857600
1269	_bct_buffer_allocation_min_extents	mininum number of extents to allocate per buffer allocation	1
1270	_bct_fixtab_file	change tracking file for fixed tables
1271	_disable_primary_bitmap_switch	disable primary bitmap switch	FALSE
1272	_bct_health_check_interval	CTWR health check interval (seconds), zero to disable	60
1273	db_flashback_retention_target	Maximum Flashback Database log retention time in minutes.	1440
1274	_validate_flashback_database	Scan database to validate result of flashback database	FALSE
1275	_flashback_allow_noarchivelog	Allow enabling flashback on noarchivelog database	FALSE
1276	_verify_flashback_redo	Verify that the redo logs needed for flashback are available	TRUE
1277	_flashback_verbose_info	Print verbose information about flashback database	FALSE
1278	_flashback_dynamic_enable_failure	Simulate failures during dynamic enable	0
1279	_flashback_dynamic_enable	enable flashback enable code path	TRUE
1280	_allow_drop_snapshot_standby_grsp	Allow dropping snapshot standby guaranteed restore point	FALSE
1281	_flashback_marker_cache_size	Size of flashback database marker cache	328
1282	_flashback_marker_cache_enabled	Enable flashback database marker cache	TRUE
1283	_flashback_database_test_only	Run Flashback Database in test mode	FALSE
1284	_allow_drop_ts_with_grp	Allow drop Tablespace with guaranteed restore points	FALSE
1285	_flashback_logfile_enqueue_timeout	flashback logfile enqueue timeout for opens	600
1286	_flashback_barrier_interval	Flashback barrier interval in seconds	1800
1287	_flashback_standby_barrier_interval	Flashback standby barrier interval in seconds	1
1288	_flashback_max_standby_sync_span	Maximum time span between standby recovery sync for flashback	300
1289	_flashback_fuzzy_barrier	Use flashback fuzzy barrier	TRUE
1290	_disable_kcb_flashback_blocknew_opt	Disable KCB flashback block new optimization	FALSE
1291	_disable_kcbl_flashback_blocknew_opt	Disable KCBL flashback block new optimization	FALSE
1292	_disable_flashback_wait_callback	Disable flashback wait callback	FALSE
1293	_check_block_new_invariant_for_flashback	check block new invariant for flashback	FALSE
1294	_allow_compatibility_adv_w_grp	allow advancing DB compatibility with guaranteed restore points	FALSE
1295	_minimum_db_flashback_retention	Minimum flashback retention	60
1296	_flashback_delete_chunk_MB	Amount of flashback log (in MB) to delete in one attempt	128
1297	_flashback_11.1_block_new_opt	use 11.1 flashback block new optimization scheme	FALSE
1298	_flashback_log_size	Flashback log size	1000
1299	_flashback_log_min_size	Minimum flashback log size	100
1300	_db_flashback_log_min_size	Minimum flashback database log size in bytes	16777216
1301	_db_flashback_log_min_total_space	Minimum flashback database log total space in bytes	0
1302	_flashback_copy_latches	Number of flashback copy latches	10
1303	_flashback_n_log_per_thread	Desired number of flashback logs per flashback thread	128
1304	_flashback_max_n_log_per_thread	Maximum number of flashback logs per flashback thread	2048
1305	_flashback_generation_buffer_size	flashback generation buffer size	8388608
1306	_flashback_max_log_size	Maximum flashback log size in bytes (OS limit)	0
1307	_flashback_log_io_error_behavior	Specify Flashback log I/O error behavior	0
1308	_flashback_prepare_log	Prepare Flashback logs in the background	TRUE
1309	_flashback_size_based_on_redo	Size new flashback logs based on average redo log size	TRUE
1310	_flashback_validate_controlfile	validate flashback pointers in controlfile for 11.2.0.2 database	FALSE
1311	_flashback_format_chunk_mb	Chunk mega-bytes for formatting flashback logs using sync write	4
1312	_flashback_format_chunk_mb_dwrite	Chunk mega-bytes for formatting flashback logs using delayed write	16
1313	_flashback_log_rac_balance_factor	flashback log rac balance factor	10
1314	_flashback_write_max_loop_limit	Flashback writer loop limit before it returns	10
1315	_flashback_hint_barrier_percent	Flashback hint barrier percent	20
1316	_drop_flashback_logical_operations_enq	Drop logical operations enqueue immediately during flashback marker generation	FALSE
1317	_percent_flashback_buf_partial_full	Percent of flashback buffer filled to be considered partial full	50
1318	_tdb_debug_mode	set debug mode for testing transportable database	16
1319	_log_read_buffers	Number of log read buffers for media recovery	8
1320	_change_vector_buffers	Number of change vector buffers for media recovery	1
1321	_kcfis_trace_level	sets kcfis tracing level	0
1322	_kcfis_spawn_debugger	Decides whether to spawn the debugger at kcfis initialize	FALSE
1323	_kcfis_trace_bucket_size	KCFIS tracing bucket size in bytes	131072
1324	_kcfis_fault_control	Fault Injection Control	0
1325	_kcfis_caching_enabled	enable kcfis intra-scan session caching	TRUE
1326	_kcfis_large_payload_enabled	enable large payload to be passed to cellsrv	FALSE
1327	_kcfis_cell_passthru_enabled	Do not perform smart IO filtering on the cell	FALSE
1328	_kcfis_dump_corrupt_block	Dump any corrupt blocks found during smart IO	TRUE
1329	_kcfis_kept_in_cellfc_enabled	Enable usage of cellsrv flash cache for kept objects	TRUE
1330	_kcfis_nonkept_in_cellfc_enabled	Enable use of cellsrv flash cache for non-kept objects	FALSE
1331	_kcfis_rdbms_blockio_enabled	Use block IO instead of smart IO in the smart IO module on RDBMS	FALSE
1332	_kcfis_fast_response_enabled	Enable smart scan optimization for fast response (first rows)	TRUE
1333	_kcfis_fast_response_threshold	Fast response - the number of IOs after which smartIO is used	1048576
1334	_kcfis_fast_response_initiosize	Fast response - The size of the first IO in logical blocks	2
1335	_kcfis_fast_response_iosizemult	Fast response - (next IO size = current IO size * this parameter)	4
1336	_kcfis_max_out_translations	Sets the maximum number of outstanding translations in kcfis	5000
1337	_kcfis_max_cached_sessions	Sets the maximum number of kcfis sessions cached	10
1338	_kcfis_storageidx_disabled	Don't use storage index optimization on the storage cell	FALSE
1339	_kcfis_disable_platform_decryption	Don't use platform-specific decryption on the storage cell	FALSE
1340	_kcfis_storageidx_diag_mode	Debug mode for storage index on the cell	0
1341	_kcfis_test_control1	kcfis tst control1	0
1342	_kcfis_stats_level	sets kcfis stats level	0
1343	_kcfis_io_prefetch_size	Smart IO prefetch size for a cell	8
1344	_kcfis_block_dump_level	Smart IO block dump level	0
1345	_kcfis_ioreqs_throttle_enabled	Enable Smart IO requests throttling	TRUE
1346	_kcfis_work_set_appliances	Working Set of appliances in a KCFIS session	2
1347	_kcfis_control1	Kcfis control1	0
1348	_kcfis_control2	Kcfis control2	0
1349	_kcfis_control3	Kcfis control3	0
1350	_kcfis_control4	Kcfis control4	0
1351	_kcfis_control5	Kcfis control5	0
1352	_kcfis_control6	Kcfis control6	0
1353	_kcfis_oss_io_size	KCFIS OSS I/O size	0
1354	_kcfis_read_buffer_limit	KCFIS Read Buffer (per session) memory limit in bytes	0
1355	_cell_file_format_chunk_size	Cell file format chunk size in MB	0
1356	_cell_offload_capabilities_enabled	specifies capability table to load	1
1357	_kcfis_cell_passthru_fromcpu_enabled	Enable automatic passthru mode when cell CPU util is too high	TRUE
1358	_db_block_prefetch_skip_reading_enabled	Batched IO enable skip reading buffers	TRUE
1359	_db_block_prefetch_fast_longjumps_enabled	Batched IO enable fast longjumps	TRUE
1360	_db_block_prefetch_private_cache_enabled	Batched IO enable private cache	TRUE
1361	_datafile_write_errors_crash_instance	datafile write errors crash instance	TRUE
1362	_siop_perc_of_bc_x100	percentange * 100 of cache to transfer to shared io pool	2500
1363	_db_flashback_iobuf_size	Flashback IO Buffer Size	1
1364	_db_flashback_num_iobuf	Flashback Number of IO buffers	32
1365	_flashback_enable_ra	Flashback enable read ahead	TRUE
1366	dml_locks	dml locks - one for each table modified in a transaction	3396
1367	_row_locking	row-locking	always
1368	_serializable	serializable	FALSE
1369	_scn_wait_interface_max_timeout_secs	max timeout for scn wait interface in kta	2147483647
1370	_scn_wait_interface_max_backoff_time_secs	max exponential backoff time for scn wait interface in kta	600
1371	replication_dependency_tracking	tracking dependency for Replication parallel propagation	TRUE
1372	_ktb_debug_flags	ktb-layer debug flags	0
1373	_log_committime_block_cleanout	Log commit-time block cleanout	FALSE
1374	_ktc_latches	number of ktc latches	0
1375	_prescomm	presume commit of IMU transactions	FALSE
1376	_recursive_imu_transactions	recursive transactions may be IMU	FALSE
1377	_ktc_debug	for ktc debug	0
1378	_enable_minscn_cr	enable/disable minscn optimization for CR	TRUE
1379	transactions	max. number of concurrent active transactions	849
1380	transactions_per_rollback_segment	number of active transactions per rollback segment	5
1381	_ktu_latches	number of KTU latches	0
1382	rollback_segments	undo segment list
1383	_rollback_segment_initial	starting undo segment number	1
1384	_rollback_segment_count	number of undo segments	0
1385	_offline_rollback_segments	offline undo segment list
1386	_corrupted_rollback_segments	corrupted undo segment list
1387	_transaction_auditing	transaction auditing records generated in the redo log	TRUE
1388	_enable_block_level_transaction_recovery	enable block level recovery	TRUE
1389	_cleanup_rollback_entries	no. of undo entries to apply per transaction cleanup	100
1390	undo_management	instance runs in SMU mode if TRUE, else in RBU mode	AUTO
1391	undo_tablespace	use/switch undo tablespace	UNDOTBS1
1392	_smu_error_simulation_site	site ID of error simulation in KTU code	0
1393	_smu_error_simulation_type	error type for error simulation in KTU code	0
1394	_collect_undo_stats	Collect Statistics v$undostat	TRUE
1395	_smu_timeouts	comma-separated AND double-quoted list of AUM timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl
1396	_smu_debug_mode	<debug-flag> - set debug event for testing SMU operations	0
1397	_undo_debug_mode	debug flag for undo related operations	0
1398	_verify_undo_quota	TRUE - verify consistency of undo quota statistics	FALSE
1399	_tablespaces_per_transaction	estimated number of tablespaces manipulated by each transaction	10
1400	_in_memory_tbs_search	FALSE - disable fast path for alter tablespace read only	TRUE
1401	_discrete_transactions_enabled	enable OLTP mode	FALSE
1402	_in_memory_undo	Make in memory undo for top level transactions	TRUE
1403	_imu_pools	in memory undo pools	3
1404	_row_cr	enable row cr for all sql	TRUE
1405	_undo_autotune	enable auto tuning of undo_retention	FALSE
1406	_highthreshold_undoretention	high threshold undo_retention in seconds	4294967294
1407	_branch_tagging	enable branch tagging for distributed transaction	TRUE
1408	undo_retention	undo retention in seconds	60
1409	_rollback_stopat	stop at -position to step rollback	0
1410	_transaction_recovery_servers	max number of parallel recovery slaves that may be used	0
1411	fast_start_parallel_rollback	max number of parallel recovery slaves that may be used	LOW
1412	_parallel_recovery_stopat	stop at -position- to step through SMON	32767
1413	resumable_timeout	set resumable_timeout	0
1414	_max_cr_rollbacks	Maximum number of CR rollbacks per block (LMS)	0
1415	_cr_trc_buf_size	size of cr trace buffer	8192
1416	_disable_txn_alert	disable txn layer alert	0
1417	_undo_debug_usage	invoke undo usage functions for testing	0
1418	_db_change_notification_enable	enable db change notification	TRUE
1419	_disable_flashback_archiver	disable flashback archiver	0
1420	_disable_fba_qrw	disable flashback archiver query rewrite	0
1421	_disable_fba_wpr	disable flashback archiver wait for prepared transactions	0
1422	_flashback_archiver_partition_size	flashback archiver table partition size	0
1423	_fbda_busy_percentage	flashback archiver busy percentage	0
1424	_fbda_inline_percentage	flashback archiver inline percentage	0
1425	_fbda_debug_mode	flashback archiver debug event for testing	0
1426	_fbda_debug_assert	flashback archiver debug assert for testing	0
1427	_fbda_global_bscn_lag	flashback archiver global barrier scn lag	0
1428	_fbda_rac_inactive_limit	flashback archiver rac inactive limit	0
1429	_partition_large_extents	Enables large extent allocation for partitioned tables	TRUE
1430	_index_partition_large_extents	Enables large extent allocation for partitioned indices	FALSE
1431	instance_number	instance number	0
1432	_allocate_creation_order	should files be examined in creation order during allocation	FALSE
1433	_log_space_errors	should we report space errors to alert log	TRUE
1434	_assm_low_gsp_threshold	Number of blocks rejected before collecting stats	10000
1435	_assm_high_gsp_threshold	Number of blocks rejected before growing segment	11024
1436	_simulate_io_wait	Simulate I/O wait to test segment advisor	0
1437	_bump_highwater_mark_count	how many blocks should we allocate per free list on advancing HWM	0
1438	_assm_default	ASSM default	TRUE
1439	_enable_hwm_sync	enable HWM synchronization	TRUE
1440	_hwm_sync_threshold	HWM synchronization threshold in percentage	10
1441	_enable_check_truncate	enable checking of corruption caused by canceled truncate	TRUE
1442	_enable_tablespace_alerts	enable tablespace alerts	TRUE
1443	_disable_temp_tablespace_alerts	disable tablespace alerts for TEMPORARY tablespaces	FALSE
1444	_disable_undo_tablespace_alerts	disable tablespace alerts for UNDO tablespaces	FALSE
1445	_last_allocation_period	period over which an instance can retain an active level1 bitmap	5
1446	_securefiles_forceflush	securefiles force flush before allocation	FALSE
1447	_securefiles_concurrency_estimate	securefiles concurrency estimate	12
1448	_securefiles_memory_percentofSGA	securefiles memory as percent of SGA	20
1449	_inst_locking_period	period an instance can retain a newly acquired level1 bitmap	5
1450	_allocation_update_interval	interval at which successful search in L1 should be updated	3
1451	_minimum_blocks_to_shrink	minimum number freeable blocks for shrink to be present	0
1452	_minimum_extents_to_shrink	minimum number freeable extents for shrink to be present	1
1453	_use_best_fit	use best fit to allocate space	FALSE
1454	_step_down_limit_in_pct	step down limit in percentage	1
1455	_enable_space_preallocation	enable space pre-allocation	3
1456	_ktspsrch_maxsc	maximum segments supported by space search cache	1024
1457	_ktspsrch_maxskip	space search cache rejection skip upper limit	5
1458	_assm_force_fetchmeta	enable metadata block fetching in ASSM segment scan	FALSE
1459	_max_fsu_segments	Maximum segments to track for fast space usage	4096
1460	_max_fsu_stale_time	Allowed space usage staleness in seconds	600
1461	_max_shrink_obj_stats	number of segments for which shrink stats will be maintained	0
1462	_check_ts_threshold	check tablespace thresholds	0
1463	_async_ts_threshold	check tablespace thresholds asynchronously	1
1464	_kttext_warning	tablespace pre-extension warning threshold in percentage	5
1465	_smon_internal_errlimit	limit of SMON internal errors	100
1466	_smon_undo_seg_rescan_limit	limit of SMON continous undo segments re-scan	10
1467	_space_align_size	space align size	1048576
1468	_enable_spacebg	enable space management background task	TRUE
1469	_max_spacebg_slaves	maximum space management background slaves	10
1470	_max_spacebg_tasks	maximum space management background tasks	1000
1471	_max_spacebg_msgs_percentage	maximum space management interrupt message throttling	50
1472	_ktslj_segext_warning	segment pre-extension warning threshold in percentage	10
1473	_ktslj_segext_warning_mb	segment pre-extension warning threshold in MB	0
1474	_ktslj_segext_max_mb	segment pre-extension max size in MB (0: unlimited)	0
1475	_ktslj_segext_retry	segment pre-extension retry	5
1476	_securefiles_fg_retry	segment retry before foreground waits	100
1477	_securefiles_bulkinsert	securefiles segment insert only optization	FALSE
1478	_db_row_overlap_checking	row overlap checking override parameter for data/index blocks	TRUE
1479	_db_index_block_checking	index block checking override parameter	TRUE
1480	_kdi_avoid_block_checking	avoid index block checking on sensitive opcodes	FALSE
1481	db_block_checking	header checking and data and index block checking	TRUE
1482	_disable_block_checking	disable block checking at the session level	FALSE
1483	_kd_symtab_chk	enable or disable symbol table integrity block check	TRUE
1484	recyclebin	recyclebin processing	on
1485	_compression_compatibility	Compression compatability	11.2.0.3.0
1486	_check_column_length	check column length	TRUE
1487	_oltp_compression	oltp compression enabled	TRUE
1488	_inplace_update_retry	inplace update retry for ora1551	TRUE
1489	_limit_itls	limit the number of ITLs in OLTP Compressed Tables	20
1490	_force_hsc_compress	compress all newly created tables	FALSE
1491	_force_oltp_compress	OLTP Compress all newly created compressed tables	FALSE
1492	_force_oltp_update_opt	OLTP Compressed row optimization on update	TRUE
1493	_force_arch_compress	Archive Compress all newly created compressed tables	0
1494	_compression_advisor	Compression advisor	0
1495	_compression_chain	percentage of chained rows allowed for Compression	90
1496	_compression_above_cache	number of recompression above cache for sanity check	0
1497	_oltp_compression_gain	oltp compression gain	10
1498	_arch_compression	archive compression enabled	TRUE
1499	_arch_comp_dbg_scan	archive compression scan debug	0
1500	_arch_comp_dec_block_check_dump	decompress archive compression blocks for checking and dumping	1
1501	_lmn_compression	suppl logging for compression enabled	TRUE
1502	_alternate_iot_leaf_block_split_points	enable alternate index-organized table leaf-block split-points	TRUE
1503	_kdu_array_depth	array update retry recursion depth limits	16
1504	_cell_offload_hybridcolumnar	Query offloading of hybrid columnar compressed tables to exadata	TRUE
1505	_disable_implicit_row_movement	disable implicit row movement	FALSE
1506	_release_insert_threshold	maximum number of unusable blocks to unlink from freelist	5
1507	_walk_insert_threshold	maximum number of unusable blocks to walk across freelist	0
1508	_enable_hash_overflow	TRUE - enable hash cluster overflow based on SIZE	FALSE
1509	_kdtgsp_retries	max number of retries in kdtgsp if space returns same block	1024
1510	_minfree_plus	max percentage of block space + minfree before we mark block full	0
1511	_use_seq_process_cache	whether to use process local seq cache	TRUE
1512	_disable_index_block_prefetching	disable index block prefetching	FALSE
1513	_index_scan_check_skip_corrupt	check and skip corrupt blocks during index scans	FALSE
1514	_index_scan_check_stopkey	check stopkey during index range scans	FALSE
1515	_reuse_index_loop	number of blocks being examine for index block reuse	5
1516	_kdis_reject_limit	#block rejections in space reclamation before segment extension	5
1517	_kdis_reject_level	b+tree level to enable rejection limit	24
1518	_kdis_reject_ops	enable rejection heuristic for branch splits	FALSE
1519	_kdbl_enable_post_allocation	allocate dbas after populating data buffers	FALSE
1520	_ldr_io_size	size of write IOs used during a load operation	262144
1521	_ldr_io_size2	size of write IOs used during a load operation of EHCC with HWMB	1048576
1522	_ldr_pga_lim	pga limit, beyond which new partition loads are delayed	0
1523	_ignore_desc_in_index	ignore DESC in indexes, sort those columns ascending anyhow	FALSE
1524	_kdic_segarr_sz	size threshold for segmented arrays for seg_info_kdicctx	0
1525	_keep_remote_column_size	remote column size does not get modified	FALSE
1526	_ignore_edition_enabled_for_EV_creation	ignore schema's edition-enabled status during EV creation	FALSE
1527	_kdli_trace	inode trace level	0
1528	_kdli_sort_dbas	sort dbas during chunkification	FALSE
1529	_kdli_safe_callbacks	invoke inode read/write callbacks safely	TRUE
1530	_kdli_inode_preference	inline inode evolution preference (data, headless, lhb)	data
1531	_kdli_reshape	reshape an inode to inline or headless on length truncation	FALSE
1532	_kdli_cache_inode	cache inode state across calls	TRUE
1533	_kdli_cache_verify	verify cached inode via deserialization	FALSE
1534	_kdli_cache_size	maximum #entries in inode cache	8
1535	_kdli_memory_protect	trace accesses to inode memory outside kdli API functions	FALSE
1536	_kdli_rci_lobmap_entries	#entries in RCI lobmap before migration to lhb	255
1537	_kdli_readahead_strategy	shared/cached IO readahead strategy	contig
1538	_kdli_readahead_limit	shared/cached IO readahead limit	0
1539	_kdli_sio_on	enable shared IO pool operations	TRUE
1540	_kdli_sio_min_read	shared IO pool read threshold	0
1541	_kdli_sio_min_write	shared IO pool write threshold	0
1542	_kdli_sio_async	asynchronous shared IO	TRUE
1543	_kdli_sio_fgio	reap asynchronous IO in the foreground	TRUE
1544	_kdli_sio_nbufs	maximum #IO buffers to allocate per session	8
1545	_kdli_sio_niods	maximum #IO descriptors to allocate per session	8
1546	_kdli_sio_strategy	shared IO strategy: block vs. extent	extent
1547	_kdli_sio_fileopen	shared IO fileopen mode: datasync vs nodatasync vs async	none
1548	_kdli_sio_flush	enable shared IO pool operations	FALSE
1549	_kdli_sio_bps	maximum blocks per IO slot	0
1550	_kdli_sio_pga	use PGA allocations for direct IO	FALSE
1551	_kdli_sio_pga_top	PGA allocations come from toplevel PGA heap	FALSE
1552	_kdli_sio_dop	degree-of-parallelism in the SIO keep pool	2
1553	_kdli_sio_free	free IO buffers when not in active use	TRUE
1554	_kdli_sio_backoff	use exponential backoff when attempting SIOP allocations	FALSE
1555	_kdli_inline_xfm	allow inline transformed lobs	TRUE
1556	_kdli_timer_trc	trace inode timers to uts/tracefile	FALSE
1557	_kdli_timer_dmp	dump inode timers on session termination	FALSE
1558	_kdli_cacheable_length	minimum lob length for inode cacheability	0
1559	_kdli_small_cache_limit	size limit of small inode cache	32
1560	_kdli_inject_assert	inject asserts into the inode	0
1561	_kdli_inject_crash	inject crashes into the inode	0
1562	_kdli_space_cache_limit	maximum size of the space cache in #blocks	2048
1563	_kdli_force_cr	force CR when reading data blocks of direct-write lobs	TRUE
1564	_kdli_force_cr_meta	force CR when reading metadata blocks of direct-write lobs	TRUE
1565	_kdli_recent_scn	use recent (not dependent) scns for block format/allocation	FALSE
1566	_kdli_itree_entries	#entries in lhb/itree blocks (for testing only)	0
1567	_kdli_cache_read_threshold	minimum lob size for cache->nocache read (0 disables heuristic)	0
1568	_kdli_cache_write_threshold	minimum lob size for cache->nocache write (0 disables heuristic)	0
1569	_kdli_full_readahead_threshold	maximum lob size for full readahead	0
1570	_kdli_force_storage	force storage settings for all lobs	none
1571	_kdli_allow_corrupt	allow corrupt filesystem_logging data blocks during read/write	TRUE
1572	_kdli_squeeze	compact lobmap extents with contiguous dbas	TRUE
1573	_kdli_buffer_inject	use buffer injection for CACHE [NO]LOGGING lobs	TRUE
1574	_kdli_inject_batch	buffer injection batch size [1, KCBNEWMAX]	0
1575	_kdli_flush_injections	flush injected buffers of CACHE NOLOGGING lobs before commit	TRUE
1576	_kdli_flush_cache_reads	flush cache-reads data blocks after load	FALSE
1577	_kdli_checkpoint_flush	do not invalidate cache buffers after write	FALSE
1578	_kdli_delay_flushes	delay flushing cache writes to direct-write lobs	TRUE
1579	_kdli_dbc	override db_block_checking setting for securefiles	none
1580	_kdli_preallocation_pct	percentage preallocation [0 .. inf) for lob growth	0
1581	_kdli_preallocation_mode	preallocation mode for lob growth	length
1582	_kdli_inplace_overwrite	maximum inplace overwrite size (> chunksize)	0
1583	_kdli_sio_write_pct	percentage of buffer used for direct writes	100
1584	_kdli_sio_fbwrite_pct	percentage of buffer used for direct writes in flashback-db	35
1585	_kdli_vll_direct	use skip-navigation and direct-positioning in vll-domain	TRUE
1586	_kdli_oneblk	allocate chunks as single blocks	FALSE
1587	_kdli_STOP_tsn	undocumented parameter for internal use only	0
1588	_kdli_STOP_dba	undocumented parameter for internal use only	0
1589	_kdli_STOP_fsz	undocumented parameter for internal use only	0
1590	_kdli_STOP_bsz	undocumented parameter for internal use only	0
1591	_kdli_STOP_nio	undocumented parameter for internal use only	0
1592	_kdlw_enable_write_gathering	enable lob write gathering for sql txns	TRUE
1593	_kdlw_enable_ksi_locking	enable ksi locking for lobs	FALSE
1594	_kdlwp_flush_threshold	WGC flush threshold in bytes	4194304
1595	_kdlxp_cmp_subunit_size	size of compression sub-unit in bytes	262144
1596	_kdlxp_minxfm_size	minimum transformation size in bytes	32768
1597	_kdlxp_lobcompress	enable lob compression - only on SecureFiles	FALSE
1598	_kdlxp_lobcmplevel	Default securefile compression	2
1599	_kdlxp_lobcmprciver	Default securefile compression map version	1
1600	_kdlxp_lobencrypt	enable lob encryption - only on SecureFiles	FALSE
1601	_kdlxp_xfmcache	enable xfm cache - only on SecureFiles	TRUE
1602	_kdlxp_lobcmpadp	enable adaptive compression - only on SecureFiles	FALSE
1603	_kdlxp_uncmp	lob data uncompressed - only on SecureFiles	FALSE
1604	_kdlxp_mincmplen	minimum loblen to compress - only on SecureFiles	200
1605	_kdlxp_mincmp	minimum comp ratio in pct - only on SecureFiles	20
1606	db_securefile	permit securefile storage during lob creation	PERMITTED
1607	_kdlxp_lobdeduplicate	enable lob deduplication - only on SecureFiles	FALSE
1608	_kdlxp_lobdedupvalidate	enable deduplicate validate - only on SecureFiles	TRUE
1609	_kdlxp_dedup_hash_algo	secure hash algorithm for deduplication - only on SecureFiles	SHA1
1610	_kdlxp_dedup_flush_threshold	deduplication flush threshold in bytes	8388608
1611	_kdlxp_dedup_prefix_threshold	deduplication prefix hash threshold in bytes	1048576
1612	_kdlxp_dedup_inl_pctfree	deduplication pct size increase by which inlining avoided	5
1613	_kdlxp_dedup_wapp_len	deduplication length to allow write-append	0
1614	_kdlxp_spare1	deduplication spare 1	0
1615	_securefile_timers	collect kdlu timers and accumulate per layers	FALSE
1616	_kdlu_trace_session	UTS session dump	0
1617	_kdlu_trace_system	UTS system dump	0
1618	_kdlu_trace_layer	UTS kdlu per-layer trace level	0
1619	_kdlu_max_bucket_size	UTS kdlu bucket size	4194304
1620	_kdlu_max_bucket_size_mts	UTS kdlu bucket size for mts	131072
1621	_kdz_hcc_track_upd_rids	Enable rowid tracking during updates	TRUE
1622	_kdz_hcc_flags	Miscellaneous HCC flags	0
1623	_row_cache_cursors	number of cached cursors for row cache management	20
1624	_kgl_cluster_lock	Library cache support for cluster lock	TRUE
1625	_kgl_cluster_pin	Library cache support for cluster pins	TRUE
1626	_kgl_cluster_lock_read_mostly	Library cache support for cluster lock read mostly optimization	FALSE
1627	_kgl_latch_count	number of library cache latches	0
1628	_kgl_heap_size	extent size for library cache heap 0	4096
1629	_kgl_fixed_extents	fixed extent size for library cache memory allocations	TRUE
1630	_kgl_bucket_count	Library cache hash table bucket count (2^_kgl_bucket_count * 256)	9
1631	_library_cache_advice	whether KGL advice should be turned on	TRUE
1632	_kglsim_maxmem_percent	max percentage of shared pool size to be used for KGL advice	5
1633	_kgl_hash_collision	Library cache name hash collision possible	FALSE
1634	_kgl_time_to_wait_for_locks	time to wait for locks and pins before timing out	15
1635	_kgl_large_heap_warning_threshold	maximum heap size before KGL writes warnings to the alert log	52428800
1636	_synonym_repoint_tracing	whether to trace metadata comparisons for synonym repointing	FALSE
1637	_ignore_fg_deps	ignore fine-grain dependencies during invalidation
1638	_trace_kqlidp	trace kqlidp0 operation	FALSE
1639	_disable_fast_validate	disable PL/SQL fast validation	FALSE
1640	_kgl_message_locks	RAC message lock count	64
1641	_kgl_debug	Library cache debugging
1642	_mutex_wait_time	Mutex wait time	1
1643	_mutex_spin_count	Mutex spin count	255
1644	_mutex_wait_scheme	Mutex wait scheme	2
1645	_kgl_min_cached_so_count	Minimum cached SO count. If > 1 can help find SO corruptions	1
1646	_kgl_hot_object_copies	Number of copies for the hot object	0
1647	_kgl_kqr_cap_so_stacks	capture stacks for library and row cache state objects	FALSE
1648	_enable_kqf_purge	Enable KQF fixed runtime table purge	TRUE
1649	create_stored_outlines	create stored outlines for DML statements
1650	_object_number_cache_size	Object number cache size	5
1651	_enable_Front_End_View_Optimization	enable front end view optimization	1
1652	serial_reuse	reuse the frame segments	disable
1653	_cursor_features_enabled	Shared cursor features enabled bits.	2
1654	_session_page_extent	Session Page Extent Size	2048
1655	_cursor_runtimeheap_memlimit	Shared cursor runtime heap memory limit	5242880
1656	_kks_cached_parse_errors	KKS cached parse errors	0
1657	_kgx_latches	# of mutex latches if CAS is not supported.	1024
1658	_cursor_stats_enabled	Enable cursor stats	TRUE
1659	_enable_editions_for_users	enable editions for all users	FALSE
1660	ldap_directory_access	RDBMS's LDAP access option	NONE
1661	ldap_directory_sysauth	OID usage parameter	no
1662	os_roles	retrieve roles from the operating system	FALSE
1663	rdbms_server_dn	RDBMS's Distinguished Name
1664	max_enabled_roles	max number of roles a user can have enabled	150
1665	remote_os_authent	allow non-secure remote clients to use auto-logon accounts	FALSE
1666	remote_os_roles	allow non-secure remote clients to use os roles	FALSE
1667	_case_sensitive_logon	case sensitive logon enabled	TRUE
1668	sec_case_sensitive_logon	case sensitive password enabled for logon	TRUE
1669	O7_DICTIONARY_ACCESSIBILITY	Version 7 Dictionary Accessibility Support	TRUE
1670	_passwordfile_enqueue_timeout	password file enqueue timeout in seconds	900
1671	remote_login_passwordfile	password file usage parameter	EXCLUSIVE
1672	license_max_users	maximum number of named users that can be created in the database	0
1673	_dynamic_rls_policies	rls policies are dynamic	TRUE
1674	_app_ctx_vers	enable app ctx versioning	FALSE
1675	_session_context_size	session app context size	10000
1676	audit_sys_operations	enable sys auditing	FALSE
1677	_default_encrypt_alg	default encryption algorithm	0
1678	_ols_cleanup_task	Clean up unnecessary entries in OLS sessinfo table	TRUE
1679	global_context_pool_size	Global Application Context Pool Size in Bytes
1680	_select_any_dictionary_security_enabled	Exclude user$ from SELECT ANY DICTIONARY system privilege	FALSE
1681	_fusion_security	Fusion Security	FALSE
1682	db_domain	directory part of global database name stored with CREATE DATABASE	lhr.com
1683	global_names	enforce that database links have same name as remote database	FALSE
1684	distributed_lock_timeout	number of seconds a distributed transaction waits for a lock	60
1685	_distributed_recovery_connection_hold_time	number of seconds RECO holds outbound connections open	200
1686	commit_point_strength	Bias this node has toward not preparing in a two-phase commit	1
1687	_k2q_latches	number of k2q latches	0
1688	_clusterwide_global_transactions	enable/disable clusterwide global transactions	TRUE
1689	global_txn_processes	number of background global transaction processes to start	1
1690	_autotune_gtx_threshold	auto-tune threshold for degree of global transaction concurrency	60
1691	_forwarded_2pc_threshold	auto-tune threshold for two-phase commit rate across RAC instances	10
1692	_disable_autotune_gtx	disable autotune global transaction background processes	FALSE
1693	_autotune_gtx_interval	interval to autotune global transaction background processes	5
1694	_autotune_gtx_idle_time	idle time to trigger auto-shutdown a gtx background process	600
1695	_enable_separable_transactions	enable/disable separable transactions	FALSE
1696	instance_name	instance name supported by the instance	ORCLASM
1697	service_names	service names supported by the instance	orclasm.lhr.com, orclasm
1698	__dg_broker_service_names	service names for broker use
1699	dispatchers	specifications of dispatchers	(PROTOCOL=TCP) (SERVICE=orclasmXDB)
1700	shared_servers	number of shared servers to start up	1
1701	max_shared_servers	max number of shared servers
1702	max_dispatchers	max number of dispatchers
1703	circuits	max number of circuits
1704	shared_server_sessions	max number of shared server sessions
1705	local_listener	local listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))))
1706	remote_listener	remote listener
1707	listener_networks	listener registration networks
1708	_pmon_load_constants	server load balancing constants (S,P,D,I,L,C,M)	300,192,64,3,10,10,0,0
1709	_dispatcher_rate_ttl	time-to-live for rate statistic (100ths of a second)
1710	_dispatcher_rate_scale	scale to display rate statistic (100ths of a second)
1711	_enable_shared_server_vector_io	Enable shared server vector I/O	FALSE
1712	_shared_server_load_balance	shared server load balance	0
1713	_shared_server_num_queues	number of shared server common queues	2
1714	_kernel_message_network_driver	kernel message network driver	FALSE
1715	_dedicated_server_poll_count	dedicated server poll count	10
1716	_dedicated_server_post_wait_call	dedicated server post/wait call	FALSE
1717	_dedicated_server_post_wait	dedicated server post/wait	FALSE
1718	_cp_num_hash_latches	connection pool number of hash latches	1
1719	_connection_broker_host	connection broker host for listen address
1720	_fast_cursor_reexecute	use more memory in order to get faster execution	FALSE
1721	cursor_space_for_time	use more memory in order to get faster execution	FALSE
1722	session_cached_cursors	Number of cursors to cache in a session.	50
1723	_cursor_obsolete_threshold	Number of cursors per parent before obsoletion.	100
1724	_disable_cursor_sharing	disable cursor sharing	FALSE
1725	_dump_qbc_tree	dump top level query parse tree to trace	0
1726	remote_dependencies_mode	remote-procedure-call dependencies mode parameter	TIMESTAMP
1727	utl_file_dir	utl_file accessible directories list	/home/oracle/
1728	smtp_out_server	utl_smtp server and port configuration parameter
1729	_plsql_dump_buffer_events	conditions upon which the PL/SQL circular buffer is dumped
1730	plsql_v2_compatibility	PL/SQL version 2.x compatibility flag	FALSE
1731	_ncomp_shared_objects_dir	native compilation shared objects dir
1732	plsql_warnings	PL/SQL compiler warnings settings	DISABLE:ALL
1733	plsql_code_type	PL/SQL code-type	INTERPRETED
1734	_plsql_anon_block_code_type	PL/SQL anonymous block code-type	INTERPRETED
1735	plsql_debug	PL/SQL debug	FALSE
1736	plsql_optimize_level	PL/SQL optimize level	1
1737	plsql_ccflags	PL/SQL ccflags
1738	_inline_sql_in_plsql	inline SQL in PL/SQL	FALSE
1739	plscope_settings	plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data	identifiers:none
1740	_plsql_native_frame_threshold	Allocate PL/SQL native frames on the heap if size exceeds this value	4294967294
1741	_plsql_nvl_optimize	PL/SQL NVL optimize	FALSE
1742	_plsql_max_stack_size	PL/SQL maximum stack size	0
1743	permit_92_wrap_format	allow 9.2 or older wrap format in PL/SQL	TRUE
1744	java_jit_enabled	Java VM JIT enabled	TRUE
1745	job_queue_processes	maximum number of job queue slave processes	500
1746	_job_queue_interval	Wakeup interval in seconds for job queue co-ordinator	5
1747	_dbms_sql_security_level	Security level in DBMS_SQL	1
1748	parallel_min_percent	minimum percent of threads required for parallel query	0
1749	_parallel_default_max_instances	default maximum number of instances for parallel query	1
1750	_system_trig_enabled	are system triggers enabled	TRUE
1751	create_bitmap_area_size	size of create bitmap buffer for bitmap index	8388608
1752	bitmap_merge_area_size	maximum memory allow for BITMAP MERGE	1048576
1753	_kkfi_trace	trace expression substitution	FALSE
1754	cursor_sharing	cursor sharing mode	EXACT
1755	_adjust_literal_replacement	If TRUE, we will adjust the SQL/PLUS output	FALSE
1756	_kolfuseslf	allow kolf to use slffopen	FALSE
1757	result_cache_mode	result cache operator usage mode	MANUAL
1758	_result_cache_auto_size_threshold	result cache auto max size allowed	100
1759	_result_cache_auto_time_threshold	result cache auto time threshold	1000
1760	_result_cache_auto_execution_threshold	result cache auto execution threshold	1
1761	_session_cached_instantiations	Number of pl/sql instantiations to cache in a session.	60
1762	_protect_frame_heaps	Protect cursor frame heaps	FALSE
1763	_frame_cache_time	number of seconds a cached frame page stay in cache.	0
1764	_cursor_cache_time	number of seconds a session cached cursor stay in cache.	900
1765	_aged_out_cursor_cache_time	number of seconds an aged out session cached cursor stay in cache	300
1766	_px_trace	px trace parameter	none
1767	_xt_trace	external tables trace parameter	none
1768	_xt_coverage	external tables code coverage parameter	none
1769	_ku_trace	datapump trace parameter	none
1770	_optimizer_trace	optimizer trace parameter	none
1771	parallel_min_servers	minimum parallel query servers per instance	0
1772	parallel_max_servers	maximum parallel query servers per instance	80
1773	_parallel_server_idle_time	idle time before parallel query server dies (in 1/100 sec)	30000
1774	_parallel_server_sleep_time	sleep time between dequeue timeouts (in 1/100ths)	10
1775	_px_send_timeout	IPC message send timeout value in seconds	300
1776	_dynamic_stats_threshold	delay threshold (in seconds) between sending statistics messages	30
1777	parallel_instance_group	instance group to use for all parallel operations
1778	_px_execution_services_enabled	enable service-based constraint of px slave allocation	TRUE
1779	_parallel_fake_class_pct	fake db-scheduler percent used for testing	0
1780	_px_load_publish_interval	interval at which LMON will check whether to publish PX load	200
1781	parallel_execution_message_size	message buffer size for parallel execution	16384
1782	_parallel_execution_message_align	Alignment of PX buffers to OS page boundary	FALSE
1783	_PX_use_large_pool	Use Large Pool as source of PX buffers	FALSE
1784	_parallel_min_message_pool	minimum size of shared pool memory to reserve for pq servers	491520
1785	_px_buffer_ttl	ttl for px mesg buffers in seconds	30
1786	_tq_dump_period	time period for duping of TQ statistics (s)	0
1787	_affinity_on	enable/disable affinity at run time	TRUE
1788	_enable_default_affinity	enable default implementation of hard affinity osds	0
1789	_px_max_map_val	Maximum value of rehash mapping for PX	32
1790	_dss_cache_flush	enable full cache flush for parallel execution	FALSE
1791	_hash_join_enabled	enable/disable hash join	TRUE
1792	hash_area_size	size of in-memory hash work area	131072
1793	_hash_multiblock_io_count	number of blocks hash join will read/write at once	0
1794	_cursor_db_buffers_pinned	additional number of buffers a cursor can pin at once	80
1795	_old_connect_by_enabled	enable/disable old connect by	FALSE
1796	_table_lookup_prefetch_size	table lookup prefetch vector size	40
1797	_multi_join_key_table_lookup	TRUE iff multi-join-key table lookup prefetch is enabled	TRUE
1798	_table_lookup_prefetch_thresh	table lookup prefetch threshold	2
1799	_adaptive_fetch_enabled	enable/disable adaptive fetch in parallel group by	TRUE
1800	_query_execution_cache_max_size	max size of query execution cache	131072
1801	_fast_dual_enabled	enable/disable fast dual	TRUE
1802	_newsort_enabled	controls whether new sorts can be used as system sort	TRUE
1803	_newsort_type	specifies options for the new sort algorithm	0
1804	_newsort_ordered_pct	controls when new sort avoids sorting ordered input	63
1805	_recursive_with_max_recursion_level	check for maximum level of recursion instead of checking for cycles	0
1806	_sort_spill_threshold	force sort to spill to disk each time this many rows are received	0
1807	_queue_buffer_max_dump_len	max number of bytes to dump to trace file for queue buffer dump	65536
1808	_force_hash_join_spill	force hash join to spill to disk	FALSE
1809	_nlj_batching_ae_flag	FAE flag type set after restoring to IO batching buffer	2
1810	_fix_control	bug fix control parameter
1811	_sdiag_crash	sql diag crash	NONE
1812	result_cache_max_size	maximum amount of memory to be used by the cache	2883584
1813	result_cache_max_result	maximum result size as percent of cache size	5
1814	result_cache_remote_expiration	maximum life time (min) for any result using a remote object	0
1815	_result_cache_block_size	result cache block size	1024
1816	_result_cache_copy_block_count	blocks to copy instead of pinning the result	1
1817	_result_cache_global	Are results available globally across RAC?	TRUE
1818	_result_cache_timeout	maximum time (sec) a session waits for a result	10
1819	_result_cache_auto_time_distance	result cache auto time distance	300
1820	_result_cache_auto_dml_monitoring_slots	result cache auto dml monitoring slot	4
1821	_result_cache_auto_dml_monitoring_duration	result cache auto dml monitoring duration	15
1822	_result_cache_auto_dml_threshold	result cache auto dml threshold	16
1823	_result_cache_auto_dml_trend_threshold	result cache auto dml trend threshold	20
1824	_parallel_queuing_max_waitingtime	parallel statement queuing: max waiting time in queue
1825	_oss_skgxp_udp_dynamic_credit_mgmt	OSSLIB enable[!0]/disable[0] dynamic credit mgmt for SKGXP-UDP	1
1826	shadow_core_dump	Core Size for Shadow Processes	PARTIAL
1827	background_core_dump	Core Size for Background Processes	partial
1828	background_dump_dest	Detached process dump directory	/u01/app/oracle/diag/rdbms/orclasm/orclasm/trace
1829	user_dump_dest	User process dump directory	/u01/app/oracle/diag/rdbms/orclasm/orclasm/trace
1830	core_dump_dest	Core dump directory	/u01/app/oracle/diag/rdbms/orclasm/orclasm/cdump
1831	_oradbg_pathname	path of oradbg script
1832	_shmprotect	allow mprotect use for shared memory	0
1833	_online_patch_disable_stack_check	disable check for function on stack for online patches	FALSE
1834	_vendor_lib_loc	Vendor library search root directory
1835	_disable_sun_rsm	Disable IPC OSD support for Sun RSMAPI	TRUE
1836	_ipc_test_failover	Test transparent cluster network failover	0
1837	_ipc_test_mult_nets	simulate multiple cluster networks	0
1838	_ipc_fail_network	Simulate cluster network failer	0
1839	audit_file_dest	Directory in which auditing files are to reside	/u01/app/oracle/admin/orclasm/adump
1840	audit_syslog_level	Syslog facility and level
1841	_sem_per_semid	the exact number of semaphores per semaphore set to allocate
1842	_ops_per_semop	the exact number of operations per semop system call
1843	_linux_prepage_large_pages	prepage large pages during allocation on Linux	FALSE
1844	_disable_streams_diagnostics	streams diagnostics	0
1845	_max_aq_persistent_queue_memory	max aq persistent queue memory	10
1846	object_cache_optimal_size	optimal size of the user session's object cache in bytes	102400
1847	object_cache_max_size_percent	percentage of maximum size over optimal of the user session's object cache	10
1848	_no_objects	no object features are used	FALSE
1849	_kokli_cache_size	Size limit of ADT Table Lookup Cache	128
1850	_kokln_current_read	Make all LOB reads for this session 'current' reads	FALSE
1851	session_max_open_files	maximum number of open files allowed per session	10
1852	_domain_index_batch_size	maximum number of rows from one call to domain index fetch routine	2000
1853	_domain_index_dml_batch_size	maximum number of rows for one call to domain index dml routines	200
1854	_nchar_imp_conv	should implicit conversion bewteen clob and nclob be allowed	TRUE
1855	_insert_enable_hwm_brokered	during parallel inserts high water marks are brokered	TRUE
1856	_pgactx_cap_stacks	capture stacks for setting pgactx	FALSE
1857	open_links	max # open links per session	4
1858	open_links_per_instance	max # open links per instance	4
1859	_all_shared_dblinks	treat all dblinks as shared
1860	_close_cached_open_cursors	close cursors cached by PL/SQL at each commit	FALSE
1861	_disable_savepoint_reset	disable the fix for bug 1402161	FALSE
1862	commit_write	transaction commit log write behaviour
1863	commit_wait	transaction commit log wait behaviour
1864	commit_logging	transaction commit log write behaviour
1865	_init_sql_file	File containing SQL statements to execute upon database creation	?/rdbms/admin/sql.bsq
1866	optimizer_features_enable	optimizer plan compatibility parameter	11.2.0.3
1867	fixed_date	fixed SYSDATE value
1868	audit_trail	enable system auditing	DB
1869	sort_area_size	size of in-memory sort work area	65536
1870	sort_area_retained_size	size of in-memory sort work area retained between fetch calls	0
1871	_sort_multiblock_read_count	multi-block read count for sort	2
1872	_shrunk_aggs_enabled	enable use of variable sized buffers for non-distinct aggregates	TRUE
1873	_sql_ncg_mode	Optimization mode for SQL NCG	OFF
1874	_cell_storidx_mode	Cell Storage Index mode	EVA
1875	_deferred_constant_folding_mode	Deferred constant folding mode	DEFAULT
1876	_rdbms_internal_fplib_raise_errors	enable reraising of any exceptions in CELL FPLIB	FALSE
1877	_rdbms_internal_fplib_enabled	enable CELL FPLIB filtering within rdbms	FALSE
1878	_cell_index_scan_enabled	enable CELL processing of index FFS	TRUE
1879	_cell_range_scan_enabled	enable CELL processing of index range scans	TRUE
1880	_cell_offload_virtual_columns	enable offload of predicates on virtual columns to cells	TRUE
1881	_cell_offload_predicate_reordering_enabled	enable out-of-order SQL processing offload to cells	FALSE
1882	_cell_offload_timezone	enable timezone related SQL processing offload to cells	TRUE
1883	_direct_read_decision_statistics_driven	enable direct read decision based on optimizer statistics	TRUE
1884	cell_offload_processing	enable SQL processing offload to cells	TRUE
1885	cell_offload_decryption	enable SQL processing offload of encrypted data to cells	TRUE
1886	cell_offload_parameters	Additional cell offload parameters
1887	cell_offload_compaction	Cell packet compaction strategy	ADAPTIVE
1888	cell_offload_plan_display	Cell offload explain plan display	AUTO
1889	_shrunk_aggs_disable_threshold	percentage of exceptions at which to switch to full length aggs	60
1890	_gby_onekey_enabled	enable use of one comparison of all group by keys	TRUE
1891	db_name	database name specified in CREATE DATABASE	orclasm
1892	db_unique_name	Database Unique Name	orclasm
1893	open_cursors	max # cursors per session	65535
1894	ifile	include file in init.ora
1895	sql_trace	enable SQL trace	FALSE
1896	os_authent_prefix	prefix for auto-logon accounts	ops$
1897	_sql_connect_capability_table	SQL Connect Capability Table (testing only)
1898	optimizer_mode	optimizer mode	ALL_ROWS
1899	_optimizer_mode_force	force setting of optimizer mode for user recursive SQL also	TRUE
1900	_explain_rewrite_mode	allow additional messages to be generated during explain rewrite	FALSE
1901	_query_rewrite_or_error	allow query rewrite, if referenced tables are not dataless	FALSE
1902	_sort_elimination_cost_ratio	cost ratio for sort eimination under first_rows mode	0
1903	sql92_security	require select privilege for searched update/delete	FALSE
1904	_sql_connect_capability_override	SQL Connect Capability Table Override	0
1905	blank_trimming	blank trimming semantics parameter	FALSE
1906	_always_anti_join	always use this method for anti-join when possible	CHOOSE
1907	_optimizer_null_aware_antijoin	null-aware antijoin parameter	TRUE
1908	_partition_view_enabled	enable/disable partitioned views	TRUE
1909	_always_star_transformation	always favor use of star transformation	FALSE
1910	_b_tree_bitmap_plans	enable the use of bitmap plans for tables w. only B-tree indexes	TRUE
1911	star_transformation_enabled	enable the use of star transformation	FALSE
1912	_column_elimination_off	turn off predicate-only column elimination	FALSE
1913	_cpu_to_io	divisor for converting CPU cost to I/O cost	0
1914	_optimizer_extended_cursor_sharing	optimizer extended cursor sharing	UDO
1915	_optimizer_extended_cursor_sharing_rel	optimizer extended cursor sharing for relational operators	SIMPLE
1916	_optimizer_adaptive_cursor_sharing	optimizer adaptive cursor sharing	TRUE
1917	_optimizer_cost_model	optimizer cost model	CHOOSE
1918	_optimizer_undo_cost_change	optimizer undo cost change	11.2.0.3
1919	_optimizer_system_stats_usage	system statistics usage	TRUE
1920	_optimizer_cache_stats	cost with cache statistics	FALSE
1921	_new_sort_cost_estimate	enables the use of new cost estimate for sort	TRUE
1922	_complex_view_merging	enable complex view merging	TRUE
1923	_simple_view_merging	control simple view merging performed by the optimizer	TRUE
1924	_unnest_subquery	enables unnesting of complex subqueries	TRUE
1925	_optimizer_unnest_all_subqueries	enables unnesting of every type of subquery	TRUE
1926	_eliminate_common_subexpr	enables elimination of common sub-expressions	TRUE
1927	_pred_move_around	enables predicate move-around	TRUE
1928	_convert_set_to_join	enables conversion of set operator to join	FALSE
1929	_px_bind_peek_sharing	enables sharing of px cursors that were built using bind peeking	TRUE
1930	_px_ual_serial_input	enables new pq for UNION operators	TRUE
1931	_px_minus_intersect	enables pq for minus/interect operators	TRUE
1932	_remove_aggr_subquery	enables removal of subsumed aggregated subquery	TRUE
1933	_distinct_view_unnesting	enables unnesting of in subquery into distinct view	FALSE
1934	_optimizer_push_down_distinct	push down distinct from query block to table	0
1935	_optimizer_cost_based_transformation	enables cost-based query transformation	LINEAR
1936	_optimizer_squ_bottomup	enables unnesting of subquery in a bottom-up manner	TRUE
1937	_optimizer_cbqt_factor	cost factor for cost-based query transformation	50
1938	_push_join_predicate	enable pushing join predicate inside a view	TRUE
1939	_push_join_union_view	enable pushing join predicate inside a union all view	TRUE
1940	_push_join_union_view2	enable pushing join predicate inside a union view	TRUE
1941	_fast_full_scan_enabled	enable/disable index fast full scan	TRUE
1942	_optimizer_skip_scan_enabled	enable/disable index skip scan	TRUE
1943	_optimizer_join_sel_sanity_check	enable/disable sanity check for multi-column join selectivity	TRUE
1944	_optim_enhance_nnull_detection	TRUE to enable index [fast] full scan more often	TRUE
1945	_idl_conventional_index_maintenance	enable conventional index maintenance for insert direct load	TRUE
1946	_enable_cscn_caching	enable commit SCN caching for all transactions	FALSE
1947	_parallel_broadcast_enabled	enable broadcasting of small inputs to hash and sort merge joins	TRUE
1948	_px_broadcast_fudge_factor	set the tq broadcasting fudge factor percentage	100
1949	_px_kxib_tracing	turn on kxib tracing	0
1950	_px_granule_size	default size of a rowid range granule (in KB)	1000000
1951	_px_xtgranule_size	default size of a external table granule (in KB)	10000
1952	_xtbuffer_size	buffer size in KB needed for populate/query operation	0
1953	parallel_degree_policy	policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)	MANUAL
1954	_px_async_getgranule	asynchronous get granule in the slave	FALSE
1955	_px_min_granules_per_slave	minimum number of rowid range granules to generate per slave	13
1956	_px_max_granules_per_slave	maximum number of rowid range granules to generate per slave	100
1957	_px_no_stealing	prevent parallel granule stealing in shared nothing environment	FALSE
1958	_px_no_granule_sort	prevent parallel partition granules to be sorted on size	FALSE
1959	_px_proc_constrain	reduce parallel_max_servers if greater than (processes - fudge)	TRUE
1960	_px_freelist_latch_divisor	Divide the computed number of freelists by this power of 2	2
1961	parallel_adaptive_multi_user	enable adaptive setting of degree for multiple user streams	TRUE
1962	parallel_threads_per_cpu	number of parallel execution threads per CPU	2
1963	parallel_automatic_tuning	enable intelligent defaults for parallel execution parameters	FALSE
1964	_parallel_adaptive_max_users	maximum number of users running with default DOP	4
1965	_parallel_cluster_cache_policy	policy used for parallel execution on cluster(ADAPTIVE/CACHED)	ADAPTIVE
1966	_parallel_load_balancing	parallel execution load balanced slave allocation	TRUE
1967	_parallel_load_bal_unit	number of threads to allocate per instance	0
1968	_parallel_slave_acquisition_wait	time(in seconds) to wait before retrying slave acquisition	1
1969	parallel_io_cap_enabled	enable capping DOP by IO bandwidth	FALSE
1970	_px_io_system_bandwidth	total IO system bandwidth in MB/sec for computing DOP	0
1971	_px_io_process_bandwidth	IO process bandwidth in MB/sec for computing DOP	200
1972	_pdml_slaves_diff_part	slaves start on different partition when doing index maint	TRUE
1973	_pdml_gim_sampling	control separation of global index maintenance for PDML	5000
1974	_pdml_gim_staggered	slaves start on different index when doing index maint	FALSE
1975	_px_dynamic_opt	turn off/on restartable qerpx dynamic optimization	TRUE
1976	_px_dynamic_sample_size	num of samples for restartable qerpx dynamic optimization	50
1977	_px_rownum_pd	turn off/on parallel rownum pushdown optimization	TRUE
1978	_predicate_elimination_enabled	allow predicate elimination if set to TRUE	TRUE
1979	_groupby_nopushdown_cut_ratio	groupby nopushdown cut ratio	3
1980	_groupby_orderby_combine	groupby/orderby don't combine threshold	5000
1981	_temp_tran_block_threshold	number of blocks for a dimension before we temp transform	100
1982	_temp_tran_cache	determines if temp table is created with cache option	TRUE
1983	_ordered_semijoin	enable ordered semi-join subquery	TRUE
1984	_always_semi_join	always use this method for semi-join when possible	CHOOSE
1985	_ordered_nested_loop	enable ordered nested loop costing	TRUE
1986	_nested_loop_fudge	nested loop fudge	100
1987	_project_view_columns	enable projecting out unreferenced columns of a view	TRUE
1988	_no_or_expansion	OR expansion during optimization disabled	FALSE
1989	_optimizer_max_permutations	optimizer maximum join permutations per query block	2000
1990	optimizer_index_cost_adj	optimizer index cost adjustment	100
1991	optimizer_index_caching	optimizer percent index caching	0
1992	_system_index_caching	optimizer percent system index caching	0
1993	_serial_direct_read	enable direct read in serial	auto
1994	_disable_datalayer_sampling	disable datalayer sampling	FALSE
1995	_disable_sample_io_optim	disable row sampling IO optimization	FALSE
1996	_sample_rows_per_block	number of rows per block used for sampling IO optimization	4
1997	_ncmb_readahead_enabled	enable multi-block readahead for an index scan	0
1998	_ncmb_readahead_tracing	turn on multi-block readahead tracing	0
1999	_nlj_batching_enabled	enable batching of the RHS IO in NLJ	1
2000	_nlj_batching_misses_enabled	enable exceptions for buffer cache misses	1
2001	_ioq_fanin_multiplier	IOQ miss count before a miss exception	2
2002	_index_prefetch_factor	index prefetching factor	100
2003	query_rewrite_enabled	allow rewrite of queries using materialized views if enabled	TRUE
2004	query_rewrite_integrity	perform rewrite using materialized views with desired integrity	enforced
2005	_query_cost_rewrite	perform the cost based rewrite with materialized views	TRUE
2006	_query_rewrite_2	perform query rewrite before&after or only after view merging	TRUE
2007	_query_rewrite_1	perform query rewrite before&after or only before view merging	TRUE
2008	_query_rewrite_fudge	cost based query rewrite with MVs fudge factor	90
2009	_query_rewrite_expression	rewrite with cannonical form for expressions	TRUE
2010	_query_rewrite_jgmigrate	mv rewrite with jg migration	TRUE
2011	_query_rewrite_fpc	mv rewrite fresh partition containment	TRUE
2012	_query_rewrite_drj	mv rewrite and drop redundant joins	TRUE
2013	_query_rewrite_maxdisjunct	query rewrite max disjuncts	257
2014	_query_rewrite_vop_cleanup	prune frocol chain before rewrite after view-merging	TRUE
2015	_mmv_query_rewrite_enabled	allow rewrites with multiple MVs and/or base tables	TRUE
2016	_bt_mmv_query_rewrite_enabled	allow rewrites with multiple MVs and base tables	TRUE
2017	_add_stale_mv_to_dependency_list	add stale mv to dependency list	TRUE
2018	_max_rwgs_groupings	maximum no of groupings on materialized views	8192
2019	_full_pwise_join_enabled	enable full partition-wise join when TRUE	TRUE
2020	_partial_pwise_join_enabled	enable partial partition-wise join when TRUE	TRUE
2021	_slave_mapping_enabled	enable slave mapping when TRUE	TRUE
2022	_slave_mapping_group_size	force the number of slave group in a slave mapper	0
2023	_local_communication_costing_enabled	enable local communication costing when TRUE	TRUE
2024	_local_communication_ratio	set the ratio between global and local communication (0..100)	50
2025	_parallelism_cost_fudge_factor	set the parallelism cost fudge factor	350
2026	_left_nested_loops_random	enable random distribution method for left of nestedloops	TRUE
2027	_improved_row_length_enabled	enable the improvements for computing the average row length	TRUE
2028	_px_index_sampling	parallel query sampling for index create (100000 = 100%)	200
2029	_index_join_enabled	enable the use of index joins	TRUE
2030	_use_nosegment_indexes	use nosegment indexes in explain plan	FALSE
2031	_enable_type_dep_selectivity	enable type dependent selectivity estimates	TRUE
2032	_sqlexec_progression_cost	sql execution progression monitoring cost threshold	1000
2033	_improved_outerjoin_card	improved outer-join cardinality calculation	TRUE
2034	_optimizer_adjust_for_nulls	adjust selectivity for null values	TRUE
2035	_optimizer_degree	force the optimizer to use the same degree of parallelism	0
2036	_use_column_stats_for_function	enable the use of column statistics for DDP functions	TRUE
2037	_subquery_pruning_cost_factor	subquery pruning cost factor	20
2038	_subquery_pruning_reduction	subquery pruning reduction factor	50
2039	_subquery_pruning_enabled	enable the use of subquery predicates to perform pruning	TRUE
2040	_subquery_pruning_mv_enabled	enable the use of subquery predicates with MVs to perform pruning	FALSE
2041	_parallel_txn_global	enable parallel_txn hint with updates and deletes	FALSE
2042	_or_expand_nvl_predicate	enable OR expanded plan for NVL/DECODE predicate	TRUE
2043	_like_with_bind_as_equality	treat LIKE predicate with bind as an equality predicate	FALSE
2044	_table_scan_cost_plus_one	bump estimated full table scan and index ffs cost by one	TRUE
2045	_cost_equality_semi_join	enables costing of equality semi-join	TRUE
2046	_default_non_equality_sel_check	sanity check on default selectivity for like/range predicate	TRUE
2047	_new_initial_join_orders	enable initial join orders based on new ordering heuristics	TRUE
2048	_oneside_colstat_for_equijoins	sanity check on default selectivity for like/range predicate	TRUE
2049	_column_tracking_level	column usage tracking	1
2050	_optim_peek_user_binds	enable peeking of user binds	TRUE
2051	_mv_refresh_selections	create materialized views with selections and fast refresh	TRUE
2052	_cursor_plan_enabled	enable collection and display of cursor plans	TRUE
2053	_minimal_stats_aggregation	prohibit stats aggregation at compile/partition maintenance time	TRUE
2054	_mv_refresh_eut	refresh materialized views using EUT(partition)-based algorithm	TRUE
2055	_mav_refresh_consistent_read	refresh materialized views using consistent read snapshot	TRUE
2056	_mav_refresh_opt	optimizations during refresh of materialized views	0
2057	_mav_refresh_unionall_tables	# tables for union all expansion during materialized view refresh	3
2058	_mv_refresh_delta_fraction	delta mv as fractional percentage of size of mv	10
2059	_force_temptables_for_gsets	executes concatenation of rollups using temp tables	FALSE
2060	pga_aggregate_target	Target size for the aggregate PGA memory consumed by the instance	134217728
2061	__pga_aggregate_target	Current target size for the aggregate PGA memory consumed	134217728
2062	_pga_max_size	Maximum size of the PGA memory for one process	209715200
2063	workarea_size_policy	policy used to size SQL working areas (MANUAL/AUTO)	AUTO
2064	_smm_auto_min_io_size	Minimum IO size (in KB) used by sort/hash-join in auto mode	56
2065	_smm_auto_max_io_size	Maximum IO size (in KB) used by sort/hash-join in auto mode	248
2066	_smm_auto_cost_enabled	if TRUE, use the AUTO size policy cost functions	TRUE
2067	_smm_control	provides controls on the memory manager	0
2068	_smm_trace	Turn on/off tracing for SQL memory manager	0
2069	_smm_min_size	minimum work area size in auto mode	131
2070	_smm_max_size	maximum work area size in auto mode (serial)	26214
2071	_smm_px_max_size	maximum work area size in auto mode (global)	65536
2072	_smm_retain_size	work area retain size in SGA for shared server sessions (0 for AUTO)	0
2073	_smm_bound	overwrites memory manager automatically computed bound	0
2074	_smm_advice_log_size	overwrites default size of the PGA advice workarea history log	0
2075	_smm_advice_enabled	if TRUE, enable v$pga_advice	TRUE
2076	_gs_anti_semi_join_allowed	enable anti/semi join for the GS query	TRUE
2077	_mv_refresh_use_stats	pass cardinality hints to refresh queries	FALSE
2078	_mv_refresh_use_no_merge	use no_merge hint in queries	TRUE
2079	_mv_refresh_use_hash_sj	use hash_sj hint in queries	TRUE
2080	_mv_refresh_no_idx_rebuild	avoid index rebuild as part of the MV refresh	FALSE
2081	_optim_new_default_join_sel	improves the way default equijoin selectivity are computed	TRUE
2082	_optimizer_dyn_smp_blks	number of blocks for optimizer dynamic sampling	32
2083	optimizer_dynamic_sampling	optimizer dynamic sampling	2
2084	_pre_rewrite_push_pred	push predicates into views before rewrite	TRUE
2085	_optimizer_new_join_card_computation	compute join cardinality using non-rounded input values	TRUE
2086	_mav_refresh_double_count_prevented	materialized view MAV refreshes avoid double counting	FALSE
2087	_pct_refresh_double_count_prevented	materialized view PCT refreshes avoid double counting	TRUE
2088	_mv_refresh_new_setup_disabled	materialized view MV refresh new setup disabling	FALSE
2089	_load_without_compile	Load PL/SQL or Database objects without compilation	NONE
2090	_precompute_gid_values	precompute gid values and copy them before returning a row	TRUE
2091	_union_rewrite_for_gs	expand queries with GSets into UNIONs for rewrite	YES_GSET_MVS
2092	_nested_mv_fast_oncommit_enabled	nested MV refresh fast on commit allowed	TRUE
2093	_generalized_pruning_enabled	controls extensions to partition pruning for general predicates	TRUE
2094	_rowsource_execution_statistics	if TRUE, Oracle will collect rowsource statistics	FALSE
2095	_rowsource_profiling_statistics	if TRUE, Oracle will capture active row sources in v$active_session_history	TRUE
2096	_rowsource_statistics_sampfreq	frequency of rowsource statistic sampling (must be a power of 2)	128
2097	_bitmap_or_improvement_enabled	controls extensions to partition pruning for general predicates	TRUE
2098	_intrapart_pdml_enabled	Enable intra-partition updates/deletes	TRUE
2099	_force_tmp_segment_loads	Force tmp segment loads	FALSE
2100	_force_slave_mapping_intra_part_loads	Force slave mapping for intra partition loads	FALSE
2101	_intrapart_pdml_randomlocal_enabled	Enable intra-partition updates/deletes with random local dist	TRUE
2102	_optim_adjust_for_part_skews	adjust stats for skews across partitions	TRUE
2103	_optimizer_compute_index_stats	force index stats collection on index creation/rebuild	TRUE
2104	_optimizer_autostats_job	enable/disable auto stats collection job	TRUE
2105	_optimizer_push_pred_cost_based	use cost-based query transformation for push pred optimization	TRUE
2106	_optimizer_extend_jppd_view_types	join pred pushdown on group-by, distinct, semi-/anti-joined view	TRUE
2107	_optimizer_filter_pred_pullup	use cost-based flter predicate pull up transformation	TRUE
2108	_optimizer_connect_by_cost_based	use cost-based transformation for connect by	TRUE
2109	_optimizer_connect_by_combine_sw	combine no filtering connect by and start with	TRUE
2110	_optimizer_connect_by_elim_dups	allow connect by to eliminate duplicates from input	TRUE
2111	_connect_by_use_union_all	use union all for connect by	TRUE
2112	_force_datefold_trunc	force use of trunc for datefolding rewrite	FALSE
2113	statistics_level	statistics level	TYPICAL
2114	_array_update_vector_read_enabled	Enable array update vector read	FALSE
2115	_two_pass_reverse_polish_enabled	uses two-pass reverse polish alg. to generate canonical forms	TRUE
2116	_expand_aggregates	expand aggregates	TRUE
2117	_dump_common_subexpressions	dump common subexpressions	FALSE
2118	_spr_use_hash_table	use hash table for spreadsheet	FALSE
2119	_spr_use_AW_AS	enable AW for hash table in spreadsheet	TRUE
2120	_dump_connect_by_loop_data	dump connect by loop error message into trc file	FALSE
2121	_column_compression_factor	Column compression ratio	0
2122	_dml_monitoring_enabled	enable modification monitoring	TRUE
2123	_px_slaves_share_cursors	slaves share cursors with QC	0
2124	_fic_algorithm_set	Set Frequent Itemset Counting Algorithm	automatic
2125	_fic_area_size	size of Frequent Itemset Counting work area	131072
2126	_fic_max_length	Frequent Itemset Counting Maximum Itemset Length	20
2127	_fic_min_bmsize	Frequent Itemset Counting Minimum BITMAP Size	1024
2128	_dtree_area_size	size of Decision Tree Classification work area	131072
2129	_dtree_pruning_enabled	Decision Tree Pruning Enabled	TRUE
2130	_dtree_compressbmp_enabled	Decision Tree Using Compressed Bitmaps Enabled	TRUE
2131	_dtree_binning_enabled	Decision Tree Binning Enabled	TRUE
2132	_dtree_max_surrogates	maximum number of surrogates	1
2133	_dtree_bintest_id	Decision Tree Binning Test ID	0
2134	_right_outer_hash_enable	Right Outer/Semi/Anti Hash Enabled	TRUE
2135	_optimizer_mjc_enabled	enable merge join cartesian	TRUE
2136	_optimizer_sortmerge_join_enabled	enable/disable sort-merge join method	TRUE
2137	_cursor_bind_capture_area_size	maximum size of the cursor bind capture area	400
2138	cursor_bind_capture_destination	Allowed destination for captured bind variables	memory+disk
2139	_flush_plan_in_awr_sql	Plan is being flushed from an AWR flush SQL	0
2140	_cursor_bind_capture_interval	interval (in seconds) between two bind capture for a cursor	900
2141	_dump_cursor_heap_sizes	dump comp/exec heap sizes to tryace file	FALSE
2142	_projection_pushdown	projection pushdown	TRUE
2143	_projection_pushdown_debug	level for projection pushdown debugging	0
2144	_px_compilation_debug	debug level for parallel compilation	0
2145	_px_compilation_trace	tracing level for parallel compilation	0
2146	_trace_virtual_columns	trace virtual columns exprs	FALSE
2147	_replace_virtual_columns	replace expressions with virtual columns	TRUE
2148	_virtual_column_overload_allowed	overload virtual columns expression	TRUE
2149	_kdt_buffering	control kdt buffering for conventional inserts	TRUE
2150	_disable_parallel_conventional_load	Disable parallel conventional loads	FALSE
2151	_ltc_trace	tracing level for load table conventional	0
2152	_fic_outofmem_candidates	Frequent Itemset Counting Out Of Memory Candidates Generation	FALSE
2153	_print_refresh_schedule	enable dbms_output of materialized view refresh schedule	false
2154	_optimizer_undo_changes	undo changes to query optimizer	FALSE
2155	_optimizer_percent_parallel	optimizer percent parallel	101
2156	_optimizer_search_limit	optimizer search limit	5
2157	skip_unusable_indexes	skip unusable indexes if set to TRUE	TRUE
2158	_mv_refresh_costing	refresh decision based on cost or on rules	rule
2159	_mv_refresh_ana	what percent to analyze after complete/PCT refresh	0
2160	_cache_stats_monitor	if TRUE, enable cache stats monitoring	FALSE
2161	_sta_control	SQL Tuning Advisory control parameter	0
2162	_enable_automatic_sqltune	Automatic SQL Tuning Advisory enabled parameter	TRUE
2163	_sql_analyze_enable_auto_txn	SQL Analyze Autonomous Transaction control parameter	FALSE
2164	_ds_enable_auto_txn	Dynamic Sampling Service Autonomous Transaction control parameter	FALSE
2165	_sql_analyze_parse_model	SQL Analyze Parse Model control parameter	2
2166	_ds_parse_model	Dynamic Sampling Service Parse Model control parameter	2
2167	_kes_parse_model	SQL Tune/SPA KES Layer Parse Model control parameter	2
2168	_ds_iocount_iosize	Dynamic Sampling Service defaults: #IOs and IO Size	6553664
2169	_mv_refsched_timeincr	proportionality constant for dop vs. time in MV refresh	300000
2170	_spr_push_pred_refspr	push predicates through reference spreadsheet	TRUE
2171	_optimizer_block_size	standard block size used by optimizer	8192
2172	_spr_max_rules	maximum number of rules in sql spreadsheet	10000
2173	_idxrb_rowincr	proportionality constant for dop vs. rows in index rebuild	100000000
2174	_hj_bit_filter_threshold	hash-join bit filtering threshold (0 always enabled)	50
2175	_optimizer_save_stats	enable/disable saving old versions of optimizer stats	TRUE
2176	_optimizer_cost_filter_pred	enables costing of filter predicates in IO cost model	FALSE
2177	_optimizer_correct_sq_selectivity	force correct computation of subquery selectivity	TRUE
2178	_allow_commutativity	allow for commutativity of +, * when comparing expressions	TRUE
2179	_mv_refresh_rebuild_percentage	minimum percentage change required in MV to force an indexrebuild	10
2180	_qa_control	Oracle internal parameter to control QA	0
2181	_qa_lrg_type	Oracle internal parameter to specify QA lrg type	0
2182	_mv_refresh_force_parallel_query	force materialized view refreshes to use parallel query	0
2183	_enable_fast_ref_after_mv_tbs	enable fast refresh after move tablespace	FALSE
2184	_optim_dict_stats_at_db_cr_upg	enable/disable dictionary stats gathering at db create/upgrade	TRUE
2185	_optimizer_dim_subq_join_sel	use join selectivity in choosing star transformation dimensions	TRUE
2186	_optimizer_disable_strans_sanity_checks	disable star transformation sanity checks	0
2187	_allow_level_without_connect_by	allow level without connect by	FALSE
2188	_optimizer_ignore_hints	enables the embedded hints to be ignored	FALSE
2189	_optimizer_random_plan	optimizer seed value for random plans	0
2190	_optimizer_ceil_cost	CEIL cost in CBO	TRUE
2191	_delay_index_maintain	delays index maintenance until after MV is refreshed	TRUE
2192	_query_rewrite_setopgrw_enable	perform general rewrite using set operator summaries	TRUE
2193	_cursor_plan_hash_version	version of cursor plan hash value	1
2194	_disable_function_based_index	disable function-based index matching	FALSE
2195	_optimizer_invalidation_period	time window for invalidation of cursors of analyzed objects	18000
2196	_px_net_msg_cost	CPU cost to send a PX message over the internconnect	10000
2197	_px_loc_msg_cost	CPU cost to send a PX message via shared memory	1000
2198	_smm_freeable_retain	value in KB of the instance freeable PGA memory to retain	5120
2199	_cursor_plan_unparse_enabled	enables/disables using unparse to build projection/predicates	TRUE
2200	_kill_java_threads_on_eoc	Kill Java threads and do sessionspace migration at end of call	FALSE
2201	_optimizer_join_order_control	controls the optimizer join order search algorithm	3
2202	_px_nss_planb	enables or disables NSS Plan B reparse with outline	TRUE
2203	_bloom_filter_enabled	enables or disables bloom filter	TRUE
2204	_bloom_filter_debug	debug level for bloom filtering	0
2205	_bloom_vector_elements	number of elements in a bloom filter vector	0
2206	_bloom_predicate_enabled	enables or disables bloom filter predicate pushdown	TRUE
2207	_bloom_predicate_pushdown_to_storage	enables or disables bloom filter predicate pushdown to storage	TRUE
2208	_bloom_folding_enabled	Enable folding of bloom filter	TRUE
2209	_bloom_folding_density	bloom filter folding density lower bound	16
2210	_bloom_folding_min	bloom filter folding size lower bound	131072
2211	_bloom_pushing_max	bloom filter pushing size upper bound	512
2212	_bloom_max_size	bloom filter maximum size in bytes	268435456
2213	_enable_refresh_schedule	enable or disable MV refresh scheduling (revert to 9.2 behavior)	TRUE
2214	_optimizer_cartesian_enabled	optimizer cartesian join enabled	TRUE
2215	_optimizer_starplan_enabled	optimizer star plan enabled	TRUE
2216	_optimizer_join_elimination_enabled	optimizer join elimination enabled	TRUE
2217	_gby_hash_aggregation_enabled	enable group-by and aggregation using hash scheme	TRUE
2218	_extended_pruning_enabled	do runtime pruning in iterator if set to TRUE	TRUE
2219	_globalindex_pnum_filter_enabled	enables filter for global index with partition extended syntax	TRUE
2220	_sql_model_unfold_forloops	specifies compile-time unfolding of sql model forloops	RUN_TIME
2221	_enable_dml_lock_escalation	enable dml lock escalation against partitioned tables if TRUE	TRUE
2222	_plsql_cache_enable	PL/SQL Function Cache Enabled	TRUE
2223	_disable_fast_aggregation	fast aggregation	FALSE
2224	_disable_adaptive_shrunk_aggregation	adaptive shrunk aggregation	FALSE
2225	_plsql_minimum_cache_hit_percent	plsql minimum cache hit percentage required to keep caching active	20
2226	_plan_outline_data	explain plan outline data enabled	TRUE
2227	_outline_bitmap_tree	BITMAP_TREE hint enabled in outline	TRUE
2228	_drop_table_optimization_enabled	reduce SGA memory use during drop of a partitioned table	TRUE
2229	_very_large_partitioned_table	very_large_partitioned_table	1024
2230	_drop_table_granule	drop_table_granule	256
2231	_xpl_trace	Explain Plan tracing parameter	0
2232	_dm_max_shared_pool_pct	max percentage of the shared pool to use for a mining model	1
2233	_optimizer_multiple_cenv	generate and run plans using several compilation environments
2234	_kql_subheap_trace	tracing level for library cache subheap level pins	0
2235	_optimizer_cost_hjsmj_multimatch	add cost of generating result set when #rows per key > 1	TRUE
2236	_optimizer_transitivity_retain	retain equi-join pred upon transitive equality pred generation	TRUE
2237	optimizer_secure_view_merging	optimizer secure view merging and predicate pushdown/movearound	TRUE
2238	_px_pwg_enabled	parallel partition wise group by enabled	TRUE
2239	_sql_hash_debug	Hash value of the SQL statement to debug	0
2240	_mv_rolling_inv	create/alter mv uses rolling cursor invalidation instead of immediate	FALSE
2241	_smm_isort_cap	maximum work area for insertion sort(v1)	102400
2242	_optimizer_cbqt_no_size_restriction	disable cost based transformation query size restriction	TRUE
2243	_windowfunc_optimization_settings	settings for window function optimizations	0
2244	_truncate_optimization_enabled	do truncate optimization if set to TRUE	TRUE
2245	_optimizer_enhanced_filter_push	push filters before trying cost-based query transformation	TRUE
2246	_compilation_call_heap_extent_size	Size of the compilation call heaps extents	16384
2247	_xpl_peeked_binds_log_size	maximum bytes for logging peeked bind values for V$SQL_PLAN (0 = OFF)	8192
2248	_rowsrc_trace_level	Row source tree tracing level	0
2249	_optimizer_rownum_pred_based_fkr	enable the use of first K rows due to rownum predicate	TRUE
2250	_optimizer_better_inlist_costing	enable improved costing of index access using in-list(s)	ALL
2251	_optimizer_self_induced_cache_cost	account for self-induced caching	FALSE
2252	_optimizer_min_cache_blocks	set minimum cached blocks	10
2253	_enable_exchange_validation_using_check	use check constraints on the table for validation	TRUE
2254	_optimizer_or_expansion	control or expansion approach used	DEPTH
2255	_optimizer_outer_to_anti_enabled	Enable transformation of outer-join to anti-join if possible	TRUE
2256	_optimizer_order_by_elimination_enabled	Eliminates order bys from views before query transformation	TRUE
2257	_optimizer_star_tran_in_with_clause	enable/disable star transformation in with clause queries	TRUE
2258	_optimizer_sortmerge_join_inequality	enable/disable sort-merge join using inequality predicates	TRUE
2259	_selfjoin_mv_duplicates	control rewrite self-join algorithm	TRUE
2260	_dimension_skip_null	control dimension skip when null feature	TRUE
2261	_force_rewrite_enable	control new query rewrite features	FALSE
2262	_optimizer_complex_pred_selectivity	enable selectivity estimation for builtin functions	TRUE
2263	_build_deferred_mv_skipping_mvlog_update	DEFERRED MV creation skipping MV log setup update	TRUE
2264	_bloom_pruning_enabled	Enable partition pruning using bloom filtering	TRUE
2265	_query_mmvrewrite_maxpreds	query mmv rewrite maximum number of predicates per disjunct	10
2266	_query_mmvrewrite_maxintervals	query mmv rewrite maximum number of intervals per disjunct	5
2267	_query_mmvrewrite_maxinlists	query mmv rewrite maximum number of in-lists per disjunct	5
2268	_query_mmvrewrite_maxdmaps	query mmv rewrite maximum number of dmaps per query disjunct	10
2269	_query_mmvrewrite_maxcmaps	query mmv rewrite maximum number of cmaps per dmap in query disjunct	20
2270	_query_mmvrewrite_maxregperm	query mmv rewrite maximum number of region permutations	512
2271	_row_shipping_threshold	row shipping column selection threshold	80
2272	_row_shipping_explain	enable row shipping explain plan support	FALSE
2273	_query_mmvrewrite_maxqryinlistvals	query mmv rewrite maximum number of query in-list values	500
2274	_first_k_rows_dynamic_proration	enable the use of dynamic proration of join cardinalities	TRUE
2275	_optimizer_aw_stats_enabled	Enables statistcs on AW olap_table table function	TRUE
2276	_enable_row_shipping	use the row shipping optimization for wide table selects	TRUE
2277	_optimizer_skip_scan_guess	consider index skip scan for predicates with guessed selectivity	FALSE
2278	_optimizer_distinct_elimination	Eliminates redundant SELECT DISTNCT's	TRUE
2279	_add_col_optim_enabled	Allows new add column optimization	TRUE
2280	_optimizer_multi_level_push_pred	consider join-predicate pushdown that requires multi-level pushdown to base table	TRUE
2281	ddl_lock_timeout	timeout to restrict the time that ddls wait for dml lock	0
2282	_enable_ddl_wait_lock	use this to turn off ddls with wait semantics	TRUE
2283	deferred_segment_creation	defer segment creation to first insert	TRUE
2284	_optimizer_group_by_placement	consider group-by placement optimization	TRUE
2285	_optimizer_distinct_placement	consider distinct placement optimization	TRUE
2286	_optimizer_coalesce_subqueries	consider coalescing of subqueries optimization	TRUE
2287	_optimizer_enable_density_improvements	use improved density computation for selectivity estimation	TRUE
2288	_optimizer_rownum_bind_default	Default value to use for rownum bind	10
2289	_enable_query_rewrite_on_remote_objs	mv rewrite on remote table/view	TRUE
2290	_enable_scn_wait_interface	use this to turn off scn wait interface in kta	TRUE
2291	optimizer_use_pending_statistics	Control whether to use optimizer pending statistics	FALSE
2292	_optimizer_improve_selectivity	improve table and partial overlap join selectivity computation	TRUE
2293	_optimizer_aw_join_push_enabled	Enables AW Join Push optimization	TRUE
2294	_kks_free_cursor_stat_pct	percentage of cursor stats buckets to scan on each load, in 1/10th of a percent	10
2295	_cvw_enable_weak_checking	enable weak view checking	TRUE
2296	optimizer_capture_sql_plan_baselines	automatic capture of SQL plan baselines for repeatable statements	FALSE
2297	optimizer_use_sql_plan_baselines	use of SQL plan baselines for captured sql statements	FALSE
2298	_enable_online_index_without_s_locking	Allow online index creation algorithm without S DML lock	TRUE
2299	_sqlmon_threshold	CPU/IO time threshold before a statement is monitored. 0 is disabled	5
2300	_sqlmon_max_plan	Maximum number of plans entry that can be monitored. Defaults to 20 per CPU	40
2301	_sqlmon_max_planlines	Number of plan lines beyond which a plan cannot be monitored	300
2302	_sqlmon_recycle_time	Minimum time (in s) to wait before a plan entry can be recycled	60
2303	_sqlmon_binds_xml_format	format of column binds_xml in [G]V$SQL_MONITOR	default
2304	_optimizer_native_full_outer_join	execute full outer join using native implementaion	FORCE
2305	_optimizer_enable_extended_stats	use extended statistics for selectivity estimation	TRUE
2306	_direct_path_insert_features	disable direct path insert features	0
2307	_optimizer_free_transformation_heap	free transformation subheap after each transformation	TRUE
2308	_pivot_implementation_method	pivot implementation method	CHOOSE
2309	_optimizer_use_subheap	Enables physical optimizer subheap	TRUE
2310	_optimizer_or_expansion_subheap	Use subheap for optimizer or-expansion	TRUE
2311	_optimizer_star_trans_min_cost	optimizer star transformation minimum cost	0
2312	_optimizer_star_trans_min_ratio	optimizer star transformation minimum ratio	0
2313	_with_subquery	WITH subquery transformation	OPTIMIZER
2314	_optimizer_reuse_cost_annotations	reuse cost annotations during cost-based query transformation	TRUE
2315	_optimizer_interleave_jppd	interleave join predicate pushdown during CBQT	TRUE
2316	_optimizer_fkr_index_cost_bias	Optimizer index bias over FTS/IFFS under first K rows mode	10
2317	_px_dump_12805_source	enables or disables tracing of 12805 signal source	TRUE
2318	parallel_min_time_threshold	threshold above which a plan is a candidate for parallelization (in seconds)	AUTO
2319	_parallel_time_unit	unit of work used to derive the degree of parallelism (in seconds)	10
2320	parallel_degree_limit	limit placed on degree of parallelism	CPU
2321	parallel_force_local	force single instance execution	FALSE
2322	_parallel_scalability	Parallel scalability criterion for parallel execution	50
2323	_parallel_syspls_obey_force	TRUE to obey force parallel query/dml/ddl under System PL/SQL	TRUE
2324	_optimizer_nested_rollup_for_gset	number of groups above which we use nested rollup exec for gset	100
2325	_plan_verify_local_time_limit	Local time limit to use for an individual plan verification	0
2326	_plan_verify_improvement_margin	Performance improvement criterion for evolving plan baselines	150
2327	_evolve_plan_baseline_report_level	Level of detail to show in plan verification/evolution report	typical
2328	_statistics_based_srf_enabled	enable/disable the use of statistics for storage reduction factor	TRUE
2329	_selectivity_for_srf_enabled	enable/disable selectivity for storage reduction factor	FALSE
2330	optimizer_use_invisible_indexes	Usage of invisible indexes (TRUE/FALSE)	FALSE
2331	_optimizer_extended_stats_usage_control	controls the optimizer usage of extended stats	192
2332	_sql_plan_management_control	controls various internal SQL Plan Management algorithms	0
2333	_optimizer_fast_pred_transitivity	use fast algorithm to generate transitive predicates	TRUE
2334	_optimizer_fast_access_pred_analysis	use fast algorithm to traverse predicates for physical optimizer	TRUE
2335	_optimizer_multiple_cenv_report	control what to report in trace file when run in multi-plan mode	result
2336	_optimizer_multiple_cenv_stmt	control the types of statements that are run in multi-plan mode	query
2337	_parallel_cluster_cache_pct	max percentage of the global buffer cache to use for affinity	80
2338	_px_granule_batch_size	default size of a batch of granules	10
2339	_optimizer_instance_count	force the optimizer to use the specified number of instances	0
2340	_block_sample_readahead_prob_threshold	controls readahead value during block sampling	10
2341	_mv_generalized_oj_refresh_opt	enable/disable new algorithm for MJV with generalized outer joins	TRUE
2342	_parallel_optimization_phase_for_local	parallel optimization phase when all slaves are local	FALSE
2343	_enable_schema_synonyms	enable DDL operations (e.g. creation) involving schema synonyms	FALSE
2344	_enable_rename_user	enable RENAME-clause using ALTER USER statement	FALSE
2345	_mv_refresh_enhanced_dml_detection	enable enhanced detection of DML types from MV log	ON_RC
2346	_mv_refresh_pkfk_relationship_opt	control MV refresh based on the use of PK-FK relationships	TRUE
2347	_mv_refresh_pkfk_data_units_opt	control MV refresh based on the assumption of PK-FK data units	auto
2348	_optimizer_unnest_disjunctive_subq	Unnesting of disjunctive subqueries (TRUE/FALSE)	TRUE
2349	_optimizer_unnest_corr_set_subq	Unnesting of correlated set subqueries (TRUE/FALSE)	TRUE
2350	_optimizer_distinct_agg_transform	Transforms Distinct Aggregates to non-distinct aggregates	TRUE
2351	_aggregation_optimization_settings	settings for aggregation optimizations	0
2352	_arch_compress_checksums	enable/disable row checksums for archive compressed blocks	FALSE
2353	_optimizer_eliminate_filtering_join	optimizer filtering join elimination enabled	TRUE
2354	dst_upgrade_insert_conv	Enables/Disables internal conversions during DST upgrade	TRUE
2355	_create_table_in_any_cluster	allow creation of table in a cluster not owned by the user	FALSE
2356	_dsc_feature_level	controls the feature level for deferred segment creation	0
2357	_parallel_statement_queuing	parallel statement queuing enabled	FALSE
2358	_parallel_conservative_queuing	conservative parallel statement queuing	FALSE
2359	parallel_servers_target	instance target in terms of number of parallel servers	32
2360	_px_load_factor	weighted autodop load factor	300
2361	_dml_frequency_tracking	Control DML frequency tracking	FALSE
2362	_dml_frequency_tracking_advance	Control automatic advance and broadcast of DML frequencies	TRUE
2363	_dml_frequency_tracking_slots	Number of slots to use for DML frequency tracking	4
2364	_dml_frequency_tracking_slot_time	Time length of each slot for DML frequency tracking	15
2365	_px_gim_factor	weighted autodop global index maintenance factor	100
2366	_add_trim_for_nlssort	add trimming for fixed char semantics	TRUE
2367	_optimizer_connect_by_cb_whr_only	use cost-based transformation for whr clause in connect by	FALSE
2368	_optimizer_join_factorization	use join factorization transformation	TRUE
2369	_optimizer_force_CBQT	force CBQT transformation regardless of cost
2370	_optimizer_use_cbqt_star_transformation	use rewritten star transformation using cbqt framework	TRUE
2371	_rep_base_path	base path for EM reports in database
2372	_optimizer_table_expansion	consider table expansion transformation	TRUE
2373	_and_pruning_enabled	allow partition pruning based on multiple mechanisms	TRUE
2374	_dml_batch_error_limit	number or error handles allocated for DML in batch mode	0
2375	_noseg_for_unusable_index_enabled	no segments for unusable indexes if set to TRUE	TRUE
2376	_slave_mapping_skew_ratio	maximum skew before slave mapping is disabled	2
2377	_px_index_sampling_objsize	parallel query sampling for index create based on object size	TRUE
2378	_sql_compatibility	sql compatability bit vector	0
2379	_optimizer_use_feedback	optimizer use feedback	TRUE
2380	_optimizer_feedback_control	controls the optimizer feedback framework
2381	_optimizer_try_st_before_jppd	try Star Transformation before Join Predicate Push Down	TRUE
2382	_parallel_blackbox_size	parallel execution blackbox bucket size	16384
2383	_parallel_blackbox_enabled	parallel execution blackbox enabled	TRUE
2384	_parallel_load_publish_threshold	diffrence in percentage controlling px load propagation	10
2385	_px_partition_scan_enabled	enables or disables parallel partition-based scan	TRUE
2386	_px_partition_scan_threshold	least number of partitions per slave to start partition-based scan	64
2387	_parallel_heartbeat_snapshot_interval	interval of snapshot to track px msging between instances	2
2388	_parallel_heartbeat_snapshot_max	maximum number of historical snapshots archived	128
2389	_bloom_pushing_total_max	bloom filter combined pushing size (DOP x filter size) upper bound	262144
2390	_optimizer_false_filter_pred_pullup	optimizer false predicate pull up transformation	TRUE
2391	_px_granule_randomize	enables or disables randomization of parallel scans rowid granules	TRUE
2392	_optimizer_purge_stats_iteration_row_count	number of rows to be deleted at each iteration of the stats purging process	10000
2393	_mv_refresh_update_analysis	materialized view refresh using update analysis	TRUE
2394	_ptn_cache_threshold	flags and threshold to control partition metadata caching	0
2395	_bloom_minmax_enabled	enable or disable bloom min max filtering	TRUE
2396	_optimizer_enable_table_lookup_by_nl	consider table lookup by nl transformation	TRUE
2397	_px_max_message_pool_pct	percentage of shared pool for px msg buffers range [5,60]	40
2398	_px_chunklist_count_ratio	ratio of the number of chunk lists to the default DOP per instance	8
2399	_px_hold_time	hold px at execution time (unit: second)	0
2400	_cdc_subscription_owner	Change Data Capture subscription_owner
2401	_optimizer_filter_pushdown	enable/disable filter predicate pushdown	TRUE
2402	_px_round_robin_rowcnt	round robin row count to enq to next slave	1000
2403	_optimizer_outer_join_to_inner	enable/disable outer to inner join conversion	TRUE
2404	_optimizer_full_outer_join_to_outer	enable/disable full outer to left outer join conversion	TRUE
2405	_px_numa_support_enabled	enable/disable PQ NUMA support	TRUE
2406	_px_numa_stealing_enabled	enable/disable PQ granule stealing across NUMA nodes	TRUE
2407	_px_adaptive_offload_threshold	threshold (GB/s) for PQ adaptive offloading of granules	10
2408	_px_adaptive_offload_pecentage	percentage for PQ adaptive offloading of granules	0
2409	sec_protocol_error_trace_action	TTC protocol error action	TRACE
2410	sec_protocol_error_further_action	TTC protocol error continue action	CONTINUE
2411	sec_max_failed_login_attempts	maximum number of failed login attempts on a connection	10
2412	sec_return_server_release_banner	whether the server retruns the complete version information	FALSE
2413	_sec_enable_test_rpcs	Whether to enable the test RPCs	FALSE
2414	_use_zero_copy_io	Should network vector IO interface be used for data transfer	TRUE
2415	enable_ddl_logging	enable ddl logging	FALSE
2416	_tstz_localtime_bypass	Should TTC not convert to LocalTime to preserve Timestamp with Timezone values	FALSE
2417	_client_tstz_error_check	Should Client give error for suspect Timestamp with Timezone operations	TRUE
2418	client_result_cache_size	client result cache max size in bytes	0
2419	client_result_cache_lag	client result cache maximum lag in milliseconds	3000
2420	_client_result_cache_bypass	bypass the client result cache	FALSE
2421	_emon_regular_ntfn_slaves	number of EMON slaves doing regular database notifications	4
2422	_emon_outbound_connect_timeout	timeout for completing connection set up to clients	30000
2423	_emon_max_active_connections	maximum open connections to clients per emon	256
2424	_client_ntfn_pingtimeout	timeout to connect to unreachable notification clients	30000
2425	_client_ntfn_pinginterval	time between pings to unreachable notification clients	75
2426	_client_ntfn_pingretries	number of times to ping unreachable notification clients	6
2427	_client_ntfn_cleanup_interval	interval after which dead client registration cleanup task repeats	2400
2428	_srvntfn_q_msgcount	srvntfn q msg count for job exit	50
2429	_srvntfn_q_msgcount_inc	srvntfn q msg count increase for job submit	100
2430	_srvntfn_jobsubmit_interval	srvntfn job submit interval	3
2431	_srvntfn_max_concurrent_jobs	srvntfn max concurrent jobs	20
2432	_srvntfn_job_deq_timeout	srvntfn job deq timeout	60
2433	_tsm_connect_string	TSM test connect string
2434	_sscr_dir	Session State Capture and Restore DIRectory object
2435	_sscr_osdir	Session State Capture and Restore OS DIRectory
2436	_tsm_disable_auto_cleanup	Disable TSM auto cleanup actions	1
2437	_enable_nativenet_tcpip	Enable skgxp driver usage for native net	FALSE
2438	_close_deq_by_cond_curs	Close Dequeue By Condition Cursors	FALSE
2439	_deq_maxwait_time	Change wait times between dequeue calls	0
2440	_deq_max_fetch_count	deq max fetch count	10
2441	_deq_execute_reset_time	deq execute reset time	30
2442	aq_tm_processes	number of AQ Time Managers to start	1
2443	_aq_tm_statistics_duration	statistics collection window duration	0
2444	_orph_cln_interval	qmon periodic interval for removed subscriber messages cleanup	1200
2445	_aq_max_scan_delay	Maximum allowable scan delay for AQ indexes and IOTs	1500
2446	_aq_tm_scanlimit	scan limit for Time Managers to clean up IOT	0
2447	_aq_tm_deqcountinterval	dequeue count interval for Time Managers to cleanup DEQ IOT BLOCKS	0
2448	_disable_gvaq_cache	Disable cache	FALSE
2449	_prop_old_enabled	Shift to pre 11g propagation behaviour	FALSE
2450	_bufq_stop_flow_control	Stop enforcing flow control for buffered queues	FALSE
2451	_capture_publisher_flow_control_threshold	Flow control threshold for capture publishers	0
2452	_buffered_publisher_flow_control_threshold	Flow control threshold for buffered publishers except capture	0
2453	_buffered_message_spill_age	Buffered message spill age	300
2454	_deq_log_array_size	deq log array size	10000
2455	_deq_ht_max_elements	deq ht max elements	100000
2456	_deq_ht_child_latches	deq ht child latches	8
2457	_deq_large_txn_size	deq large txn size	25000
2458	hs_autoregister	enable automatic server DD updates in HS agent self-registration	TRUE
2459	xml_db_events	are XML DB events enabled	enable
2460	dg_broker_start	start Data Guard broker (DMON process)	FALSE
2461	dg_broker_config_file1	data guard broker configuration file #1	/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1orclasm.dat
2462	dg_broker_config_file2	data guard broker configuration file #2	/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2orclasm.dat
2463	_dg_broker_trace_level	data guard broker trace level
2464	_olapi_history_retention	enable olapi history retention	FALSE
2465	_olapi_session_history	enable olapi session history collection	300
2466	_olapi_session_history_retention	enable olapi session history retention	FALSE
2467	_olapi_iface_object_history	enable olapi interface object history collection	1000
2468	_olapi_iface_object_history_retention	enable olapi interface object history retention	FALSE
2469	_olapi_interface_operation_history	enable olapi interface operation history collection	1000
2470	_olapi_iface_operation_history_retention	enable olapi interface operation history retention	FALSE
2471	_olapi_memory_operation_history	enable olapi memory alloc/free history collection	1000
2472	_olapi_memory_operation_history_retention	enable olapi memory operation history retention	FALSE
2473	_olapi_memory_operation_history_pause_at_seqno	enable olapi memory alloc/free history collection pausing	0
2474	olap_page_pool_size	size of the olap page pool in bytes	0
2475	_olap_continuous_trace_file	OLAP logging definition	false
2476	_olap_table_function_statistics	Specify TRUE to output OLAP table function timed statistics trace	FALSE
2477	_olap_parallel_update_threshold	OLAP parallel update threshold in pages	1000
2478	_olap_parallel_update_small_threshold	OLAP parallel update threshold for number of small pagespaces	1000
2479	_olap_parallel_update_server_num	OLAP parallel update server count	0
2480	_olap_aggregate_buffer_size	OLAP Aggregate max buffer size	1048576
2481	_olap_aggregate_min_buffer_size	OLAP Aggregate min buffer size	1024
2482	_olap_aggregate_work_per_thread	OLAP Aggregate max work parents	1024
2483	_olap_aggregate_min_thread_status	OLAP Aggregate minimum cardinality of dimensions for thread	64
2484	_olap_aggregate_statlen_thresh	OLAP Aggregate status array usage threshold	1024
2485	_olap_aggregate_worklist_max	OLAP Aggregate max worklists generated at once	5000
2486	_olap_aggregate_max_thread_tuples	OLAP Aggregate max thread tuples creation	5000
2487	_olap_aggregate_function_cache_enabled	OLAP Aggregate function cache enabler	TRUE
2488	_olap_aggregate_multipath_hier	OLAP Aggregate Multi-path Hierarhies enabled	FALSE
2489	_olap_aggregate_flags	OLAP Aggregate debug flags	0
2490	_olap_allocate_errorlog_header	OLAP Allocate Errorlog Header format	Dim Source Basis %-8d %-8s %-8b Description -------- -------- -------- -----------
2491	_olap_allocate_errorlog_format	OLAP Allocate Errorlog Format	%8p %8y %8z %e (%n)
2492	_olap_dbgoutfile_echo_to_eventlog	OLAP DbgOutfile copy output to event log (tracefile)	FALSE
2493	_olap_eif_export_lob_size	OLAP EIF Export BLOB size	2147483647
2494	_olap_sort_buffer_size	OLAP Sort Buffer Size	262144
2495	_olap_sort_buffer_pct	OLAP Sort Buffer Size Percentage	10
2496	_olap_sesscache_enabled	OLAP Session Cache knob	TRUE
2497	_olap_object_hash_class	OLAP Object Hash Table Class	3
2498	_olap_dimension_corehash_size	OLAP Dimension In-Core Hash Table Maximum Memory Use	30
2499	_olap_dimension_corehash_pressure	OLAP Dimension In-Core Hash Table Pressure Threshold	90
2500	_olap_dimension_corehash_large	OLAP Dimension In-Core Hash Table Large Threshold	50000
2501	_olap_dimension_corehash_force	OLAP Dimension In-Core Hash Table Force	FALSE
2502	_olap_page_pool_low	OLAP Page Pool Low Watermark	262144
2503	_olap_page_pool_hi	OLAP Page Pool High Watermark	50
2504	_olap_page_pool_expand_rate	OLAP Page Pool Expand Rate	20
2505	_olap_page_pool_shrink_rate	OLAP Page Pool Shrink Rate	50
2506	_olap_page_pool_hit_target	OLAP Page Pool Hit Target	100
2507	_olap_page_pool_pressure	OLAP Page Pool Pressure Threshold	90
2508	_olap_statbool_threshold	OLAP Status Boolean CBM threshold	8100
2509	_olap_statbool_corebits	OLAP Status Boolean max incore bits	20000000
2510	_olap_lmgen_dim_size	Limitmap generator dimension column size	100
2511	_olap_lmgen_meas_size	Limitmap generator measure column size	1000
2512	_olap_wrap_errors	Wrap error messages to OLAP outfile	FALSE
2513	_olap_analyze_max	OLAP DML ANALYZE command max cells to analyze	10000
2514	_olap_adv_comp_stats_max_rows	do additional predicate stats analysis for AW rowsource	100000
2515	_olap_adv_comp_stats_cc_precomp	do additional predicate stats analysis for AW rowsource	20
2516	_xsolapi_fetch_type	OLAP API fetch type	PARTIAL
2517	_xsolapi_dimension_group_creation	OLAP API symmetric overfetch	OVERFETCH
2518	_xsolapi_sql_auto_measure_hints	OLAP API enable automatic measure hints	TRUE
2519	_xsolapi_sql_auto_dimension_hints	OLAP API enable automatic dimension hints	FALSE
2520	_xsolapi_sql_hints	OLAP API generic hints
2521	_xsolapi_sql_measure_hints	OLAP API measure hints
2522	_xsolapi_sql_dimension_hints	OLAP API dimension hints
2523	_xsolapi_sql_top_measure_hints	OLAP API top measure hints
2524	_xsolapi_sql_top_dimension_hints	OLAP API top dimension hints
2525	_xsolapi_sql_all_non_base_hints	OLAP API non-base hints
2526	_xsolapi_sql_all_multi_join_non_base_hints	OLAP API multi-join non-base hints
2527	_xsolapi_densify_cubes	OLAP API cube densification	TABULAR
2528	_xsolapi_sql_optimize	OLAP API enable optimization	TRUE
2529	_xsolapi_sql_remove_columns	OLAP API enable remove unused columns optimizations	TRUE
2530	_xsolapi_sql_symmetric_predicate	OLAP API enable symmetric predicate for dimension groups	TRUE
2531	_xsolapi_sql_use_bind_variables	OLAP API enable bind variables optimization	TRUE
2532	_xsolapi_sql_prepare_stmt_cache_size	OLAP API prepare statement cache size	16
2533	_xsolapi_sql_result_set_cache_size	OLAP API result set cache size	32
2534	_xsolapi_sql_minus_threshold	OLAP API SQL MINUS threshold	1000
2535	_xsolapi_debug_output	OLAP API debug output disposition	SUPPRESS
2536	_xsolapi_materialize_sources	OLAP API Enable source materialization	TRUE
2537	_xsolapi_load_at_process_start	When to load OLAP API library at server process start	NEVER
2538	_xsolapi_fix_vptrs	OLAP API Enable vptr fixing logic in shared server mode	TRUE
2539	_xsolapi_auto_materialization_type	OLAP API behavior for auto materialization	PRED_AND_RC
2540	_xsolapi_auto_materialization_bound	OLAP API lower bound for auto materialization.	20
2541	_xsolapi_materialization_rowcache_min_rows_for_use	OLAP API min number of rows required to use rowcache in query materialization	1
2542	_xsolapi_source_trace	OLAP API output Source definitions to trace file	FALSE
2543	_xsolapi_dml_trace	OLAP API output dml commands and expressions to trace file
2544	_xsolapi_build_trace	OLAP API output build info to trace file	FALSE
2545	_xsolapi_metadata_reader_mode	OLAP API metadata reader mode	DEFAULT
2546	_xsolapi_odbo_mode	OLAP API uses ODBO mode?	FALSE
2547	_xsolapi_set_nls	OLAP API sets NLS?	TRUE
2548	_xsolapi_stringify_order_levels	OLAP API stringifies order levels?	FALSE
2549	_xsolapi_suppression_chunk_size	OLAP API suppression chunk size	4000
2550	_xsolapi_suppression_aw_mask_threshold	OLAP API suppression AW mask threshold	1000
2551	_xsolapi_share_executors	OLAP API share executors?	TRUE
2552	_xsolapi_hierarchy_value_type	OLAP API hierarchy value type	unique
2553	_xsolapi_use_models	OLAP API uses models?	TRUE
2554	_xsolapi_use_olap_dml	OLAP API uses OLAP DML?	TRUE
2555	_xsolapi_use_olap_dml_for_rank	OLAP API uses OLAP DML for rank?	TRUE
2556	_xsolapi_remove_columns_for_materialization	OLAP API removes columns for materialization?	TRUE
2557	_xsolapi_precompute_subquery	OLAP API precomputes subqueries?	TRUE
2558	_xsolapi_optimize_suppression	OLAP API optimizes suppressions?	TRUE
2559	_xsolapi_generate_with_clause	OLAP API generates WITH clause?	FALSE
2560	_xsolapi_sql_enable_aw_join	OLAP API enables AW join?	TRUE
2561	_xsolapi_sql_enable_aw_qdr_merge	OLAP API enables AW QDR merge?	TRUE
2562	_xsolapi_opt_aw_position	OLAP API enables AW position and count optimization?	TRUE
2563	_xsolapi_support_mtm	OLAP API MTM mapping classes supported?	FALSE
2564	_asm_runtime_capability_volume_support	runtime capability for volume support returns supported	FALSE
2565	_asm_disable_multiple_instance_check	Disable checking for multiple ASM instances on a given node	FALSE
2566	_asm_disable_amdu_dump	Disable AMDU dump	FALSE
2567	_asmsid	ASM instance id	asm
2568	_asm_allow_system_alias_rename	if system alias renaming is allowed	FALSE
2569	_asm_instlock_quota	ASM Instance Lock Quota	0
2570	asm_diskstring	disk set locations for discovery
2571	_asm_disk_repair_time	seconds to wait before dropping a failing disk	14400
2572	asm_preferred_read_failure_groups	preferred read failure groups
2573	_asm_disable_profilediscovery	disable profile query for discovery	FALSE
2574	_asm_imbalance_tolerance	hundredths of a percentage of inter-disk imbalance to tolerate	3
2575	_asm_shadow_cycle	Inverse shadow cycle requirement	3
2576	_asm_primary_load_cycles	True if primary load is in cycles, false if extent counts	TRUE
2577	_asm_primary_load	Number of cycles/extents to load for non-mirrored files	1
2578	_asm_secondary_load_cycles	True if secondary load is in cycles, false if extent counts	FALSE
2579	_asm_secondary_load	Number of cycles/extents to load for mirrored files	10000
2580	_kffmap_hash_size	size of kffmap_hash table	1024
2581	_kffmop_hash_size	size of kffmop_hash table	2048
2582	asm_diskgroups	disk groups to mount automatically
2583	asm_power_limit	number of parallel relocations for disk rebalancing	1
2584	_disable_rebalance_space_check	disable space usage checks for storage reconfiguration	FALSE
2585	_disable_rebalance_compact	disable space usage checks for storage reconfiguration	FALSE
2586	_asm_log_scale_rebalance	Rebalance power uses logarithmic scale	FALSE
2587	_asm_sync_rebalance	Rebalance uses sync I/O	FALSE
2588	_diag_arb_before_kill	dump diagnostics before killing unresponsive ARBs	FALSE
2589	_asm_ausize	allocation unit size	1048576
2590	_asm_blksize	metadata block size	4096
2591	_asm_acd_chunks	initial ACD chunks created	1
2592	_asm_partner_target_disk_part	target maximum number of disk partners for repartnering	8
2593	_asm_partner_target_fg_rel	target maximum number of failure group relationships for repartnering	4
2594	_asm_automatic_rezone	automatically rebalance free space across zones	TRUE
2595	_asm_rebalance_plan_size	maximum rebalance work unit	120
2596	_asm_rebalance_space_errors	number of out of space errors allowed before aborting rebalance	4
2597	_asm_libraries	library search order for discovery	ufs
2598	_asm_maxio	Maximum size of individual I/O request	1048576
2599	_asm_allow_only_raw_disks	Discovery only raw devices	TRUE
2600	_asm_fob_tac_frequency	Timeout frequency for FOB cleanup	9
2601	_asm_emulate_nfs_disk	Emulate NFS disk test event	FALSE
2602	_asmlib_test	Osmlib test event	0
2603	_asm_allow_lvm_resilvering	Enable disk resilvering for external redundancy	TRUE
2604	_asm_lsod_bucket_size	ASM lsod bucket size	13
2605	_asm_iostat_latch_count	ASM I/O statistics latch count	31
2606	_kfm_disable_set_fence	disable set fence calls and revert to default (process fence)	FALSE
2607	_asm_disable_smr_creation	Do Not create smr	FALSE
2608	_asm_wait_time	Max/imum time to wait before asmb exits	18
2609	_asm_skip_resize_check	skip the checking of the clients for s/w compatibility for resize	FALSE
2610	_asm_skip_rename_check	skip the checking of the clients for s/w compatibility for rename	FALSE
2611	_asm_direct_con_expire_time	Expire time for idle direct connection to ASM instance	120
2612	_asm_check_for_misbehaving_cf_clients	check for misbehaving CF-holding clients	FALSE
2613	_asm_diag_dead_clients	diagnostics for dead clients	FALSE
2614	_asm_reserve_slaves	reserve ASM slaves for CF txns	TRUE
2615	_asm_kill_unresponsive_clients	kill unresponsive ASM clients	TRUE
2616	_asm_disable_async_msgs	disable async intra-instance messaging	FALSE
2617	_asm_stripewidth	ASM file stripe width	8
2618	_asm_stripesize	ASM file stripe size	131072
2619	_disable_fastopen	Do Not Use Fastopen	FALSE
2620	_asm_random_zone	Random zones for new files	FALSE
2621	_asm_serialize_volume_rebalance	Serialize volume rebalance	FALSE
2622	_asm_force_quiesce	Force diskgroup quiescing	FALSE
2623	_asm_dba_threshold	ASM Disk Based Allocation Threshold	0
2624	_asm_dba_batch	ASM Disk Based Allocation Max Batch Size	500000
2625	_asm_usd_batch	ASM USD Update Max Batch Size	64
2626	_asm_fail_random_rx	Randomly fail some RX enqueue gets	FALSE
2627	_relocation_commit_batch_size	ASM relocation commit batch size	8
2628	_asm_max_redo_buffer_size	asm maximum redo buffer size	2097152
2629	_asm_max_cod_strides	maximum number of COD strides	5
2630	_asm_kfioevent	KFIO event	0
2631	_asm_evenread	ASM Even Read level	0
2632	_asm_evenread_alpha	ASM Even Read Alpha	0
2633	_asm_evenread_alpha2	ASM Even Read Second Alpha	0
2634	_asm_evenread_faststart	ASM Even Read Fast Start Threshold	0
2635	_asm_dbmsdg_nohdrchk	dbms_diskgroup.checkfile does not check block headers	FALSE
2636	_asm_root_directory	ASM default root directory	ASM
2637	_asm_hbeatiowait	number of secs to wait for PST Async Hbeat IO return	15
2638	_asm_hbeatwaitquantum	quantum used to compute time-to-wait for a PST Hbeat check	2
2639	_asm_repairquantum	quantum (in 3s) used to compute elapsed time for disk drop	60
2640	_asm_emulmax	max number of concurrent disks to emulate I/O errors	10000
2641	_asm_emultimeout	timeout before emulation begins (in 3s ticks)	0
2642	_asm_kfdpevent	KFDP event	0
2643	_asm_storagemaysplit	PST Split Possible	FALSE
2644	_asm_avoid_pst_scans	Avoid PST Scans	TRUE
2645	_disable_storage_type	Disable storage type checks	TRUE
2646	_asm_compatibility	default ASM compatibility level	10.1
2647	_rdbms_compatibility	default RDBMS compatibility level	10.1
2648	_allow_cell_smart_scan_attr	Allow checking smart_scan_capable Attr	TRUE
2649	_asm_admin_with_sysdba	Does the sysdba role have administrative privileges on ASM?	FALSE
2650	_asm_allow_appliance_dropdisk_noforce	Allow DROP DISK/FAILUREGROUP NOFORCE on ASM Appliances	FALSE
2651	_disable_appliance_check	Disable checking for appliance bread crumbs	FALSE
2652	_asm_appliance_config_file	Appliance configuration file name
2653	_disable_appliance_partnering	Disable partnering mode for appliance	FALSE
2654	control_management_pack_access	declares which manageability packs are enabled	DIAGNOSTIC+TUNING
2655	_alert_expiration	seconds before an alert message is moved to exception queue	604800
2656	_alert_message_cleanup	Enable Alert Message Cleanup	1
2657	_alert_message_purge	Enable Alert Message Purge	1
2658	_alert_post_background	Enable Background Alert Posting	1
2659	_swrf_test_action	test action parameter for SWRF	0
2660	_sysaux_test_param	test parameter for SYSAUX	1
2661	_swrf_mmon_flush	Enable/disable SWRF MMON FLushing	TRUE
2662	_awr_corrupt_mode	AWR Corrupt Mode	FALSE
2663	_awr_restrict_mode	AWR Restrict Mode	FALSE
2664	_swrf_mmon_metrics	Enable/disable SWRF MMON Metrics Collection	TRUE
2665	_swrf_metric_frequent_mode	Enable/disable SWRF Metric Frequent Mode Collection	FALSE
2666	_awr_flush_threshold_metrics	Enable/Disable Flushing AWR Threshold Metrics	TRUE
2667	_awr_flush_workload_metrics	Enable/Disable Flushing AWR Workload Metrics	FALSE
2668	_awr_disabled_flush_tables	Disable flushing of specified AWR tables
2669	_swrf_on_disk_enabled	Parameter to enable/disable SWRF	TRUE
2670	_swrf_mmon_dbfus	Enable/disable SWRF MMON DB Feature Usage	TRUE
2671	_awr_mmon_cpuusage	Enable/disable AWR MMON CPU Usage Tracking	TRUE
2672	_swrf_test_dbfus	Enable/disable DB Feature Usage Testing	FALSE
2673	_adr_migrate_runonce	Enable/disable ADR Migrate Runonce action	TRUE
2674	_mwin_schedule	Enable/disable Maintenance Window Schedules	TRUE
2675	_awr_sql_child_limit	Setting for AWR SQL Child Limit	200
2676	awr_snapshot_time_offset	Setting for AWR Snapshot Time Offset	0
2677	_awr_mmon_deep_purge_interval	Set interval for deep purge of AWR contents	7
2678	_awr_mmon_deep_purge_extent	Set extent of rows to check each deep purge run	7
2679	_awr_mmon_deep_purge_numrows	Set max number of rows per table to delete each deep purge run	5000
2680	sqltune_category	Category qualifier for applying hintsets	DEFAULT
2681	_sqltune_category_parsed	Parsed category qualifier for applying hintsets	DEFAULT
2682	_ash_sampling_interval	Time interval between two successive Active Session samples in millisecs	1000
2683	_ash_size	To set the size of the in-memory Active Session History buffers	1048618
2684	_ash_enable	To enable or disable Active Session sampling and flushing	TRUE
2685	_ash_disk_write_enable	To enable or disable Active Session History flushing	TRUE
2686	_ash_disk_filter_ratio	Ratio of the number of in-memory samples to the number of samples actually written to disk	10
2687	_ash_eflush_trigger	The percentage above which if the in-memory ASH is full the emergency flusher will be triggered	66
2688	_ash_sample_all	To enable or disable sampling every connected session including ones waiting for idle waits	FALSE
2689	_ash_dummy_test_param	Oracle internal dummy ASH parameter used ONLY for testing!	0
2690	_ash_min_mmnl_dump	Minimum Time interval passed to consider MMNL Dump	90
2691	_ash_compression_enable	To enable or disable string compression in ASH	TRUE
2692	_kebm_nstrikes	kebm # strikes to auto suspend an action	3
2693	_kebm_suspension_time	kebm auto suspension time in seconds	82800
2694	_timemodel_collection	enable timemodel collection	TRUE
2695	_disable_metrics_group	Disable Metrics Group (or all Metrics Groups)	0
2696	_threshold_alerts_enable	if 1, issue threshold-based alerts	1
2697	_enable_default_undo_threshold	Enable Default Tablespace Utilization Threshold for TEMPORARY Tablespaces	TRUE
2698	_enable_default_temp_threshold	Enable Default Tablespace Utilization Threshold for UNDO Tablespaces	TRUE
2699	_addm_auto_enable	governs whether ADDM gets run automatically after every AWR snapshot	TRUE
2700	_addm_version_check	governs whether ADDM checks the input AWR snapshot version	TRUE
2701	_addm_skiprules	comma-separated list of ADDM nodes to skip
2702	_automatic_maintenance_test	Enable AUTOTASK Test Mode	0
2703	_autotask_min_window	Minimum Maintenance Window Length in minutes	15
2704	_autotask_max_window	Maximum Logical Maintenance Window Length in minutes	480
2705	_enable_automatic_maintenance	if 1, Automated Maintenance Is Enabled	1
2706	_bsln_adaptive_thresholds_enabled	Adaptive Thresholds Enabled	TRUE
2707	_wcr_control	Oracle internal test WCR parameter used ONLY for testing!	0
2708	_capture_buffer_size	To set the size of the PGA I/O recording buffers	65536
2709	_diag_verbose_error_on_init	Allow verbose error tracing on diag init	0
2710	_diag_hm_rc_enabled	Parameter to enable/disable Diag HM Reactive Checks	TRUE
2711	_diag_hm_tc_enabled	Parameter to enable/disable Diag HM Test(dummy) Checks	FALSE
2712	diagnostic_dest	diagnostic base directory	/u01/app/oracle
2713	_diag_adr_enabled	Parameter to enable/disable Diag ADR	TRUE
2714	_diag_adr_auto_purge	Enable/disable ADR MMON Auto Purging	TRUE
2715	_diag_backward_compat	Backward Compatibility for Diagnosability	TRUE
2716	_diag_adr_test_param	Test parameter for Diagnosability	0
2717	_dra_enable_offline_dictionary	Enable the periodic creation of the offline dictionary for DRA	FALSE
2718	_dra_bmr_number_threshold	Maximum number of BMRs that can be done to a file	1000
2719	_dra_bmr_percent_threshold	Maximum percentage of blocks in a file that can be BMR-ed	10
2720	_diag_conf_cap_enabled	Parameter to enable/disable Diag Configuration Capture	TRUE
2721	_dde_flood_control_init	Initialize Flood Control at database open	TRUE
2722	_diag_dde_fc_enabled	Parameter to enable/disable Diag Flood Control	TRUE
2723	_diag_dde_fc_implicit_time	Override Implicit Error Flood Control time parameter	0
2724	_diag_dde_fc_macro_time	Override Macro Error Flood Control time parameter	0
2725	_diag_cc_enabled	Parameter to enable/disable Diag Call Context	TRUE
2726	_diag_dde_inc_proc_delay	The minimum delay between two MMON incident sweeps (minutes)	1
2727	_diag_dde_async_msgs	diag dde async actions: number of preallocated message buffers	50
2728	_diag_dde_async_msg_capacity	diag dde async actions: message buffer capacity	1024
2729	_diag_dde_async_slaves	diag dde async actions: max number of concurrent slave processes	5
2730	_diag_dde_async_mode	diag dde async actions: dispatch mode	1
2731	_diag_dde_async_age_limit	diag dde async actions: message age limit (in seconds)	300
2732	_diag_dde_async_process_rate	diag dde async actions: message processing rate - per loop	5
2733	_diag_dde_async_runtime_limit	diag dde async actions: action runtime limit (in seconds)	900
2734	_diag_dde_async_cputime_limit	diag dde async actions: action cputime limit (in seconds)	300
2735	_diag_dde_enabled	enable DDE handling of critical errors	TRUE
2736	tracefile_identifier	trace file custom identifier
2737	_trace_files_public	Create publicly accessible trace files	FALSE
2738	max_dump_file_size	Maximum size (in bytes) of dump file	unlimited
2739	_diag_uts_control	UTS control parameter	0
2740	_trace_pool_size	trace pool size in bytes
2741	trace_enabled	enable in memory tracing	TRUE
2742	_evt_system_event_propagation	disable system event propagation	TRUE
2743	_diag_enable_startup_events	enable events in instance startup notifiers	FALSE
2744	_auto_manage_exadata_disks	Automate Exadata disk management	TRUE
2745	_auto_manage_ioctl_bufsz	oss_ioctl buffer size, to read and respond to cell notifications	8192
2746	_auto_manage_num_tries	Num. tries before giving up on a automation operation	2
2747	_auto_manage_enable_offline_check	perodically check for OFFLINE disks and attempt to ONLINE	TRUE
2748	_auto_manage_max_online_tries	Max. attempts to auto ONLINE an ASM disk	3
2749	_auto_manage_online_tries_expire_time	Allow Max. attempts to auto ONLINE an ASM disk after lapsing this time (unit in seconds)	86400
2750	_auto_manage_num_pipe_msgs	Max. number of out-standing msgs in the KXDAM pipe	1000
2751	_auto_manage_infreq_tout	TEST: Set infrequent timeout action to run at this interval, unit is seconds	0

About Me

...............................................................................................................................

● 本文作者：小麦苗，只专注于数据库的技术，更注重技术的运用

● 本文在itpub（http://blog.itpub.net/26736162）、博客园（http://www.cnblogs.com/lhrbest）和个人微信公众号（xiaomaimiaolhr）上有同步更新

● 本文itpub地址：http://blog.itpub.net/26736162/abstract/1/

● 本文博客园地址：http://www.cnblogs.com/lhrbest

● 本文pdf版及小麦苗云盘地址：http://blog.itpub.net/26736162/viewspace-1624453/

● 数据库笔试面试题库及解答：http://blog.itpub.net/26736162/viewspace-2134706/

● QQ群：230161599 微信群：私聊

● 联系我请加QQ好友(646634621)，注明添加缘由

● 于 2017-06-02 09:00 ~ 2017-06-30 22:00 在魔都完成

● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解

● 版权所有，欢迎分享本文，转载请保留出处

...............................................................................................................................

拿起手机使用微信客户端扫描下边的左边图片来关注小麦苗的微信公众号：xiaomaimiaolhr，扫描右边的二维码加入小麦苗的QQ群，学习最实用的数据库技术。

阅读(821) | 评论(0) | 转发(1) |

上一篇：Oracle中的游标、硬解析、软解析、软软解析、解析失败

下一篇：Oracle绑定变量分级（Bind Graduation）

Oracle 隐含参数

Oracle 隐含参数

热门文章

最新文章

相关电子书

推荐镜像

探索云世界

热门

云计算

大数据

云原生

人工智能

数据库

开发与运维

活动广场

任务中心

训练营

直播

乘风者计划

下载

镜像站

技术资料

Oracle 隐含参数

Oracle 隐含参数

热门文章

最新文章

相关电子书

推荐镜像