How To Query And Change The Oracle Hidden Parameters In Oracle 10g

最新推荐文章于 2020-09-25 10:39:58 发布

cnk45946

最新推荐文章于 2020-09-25 10:39:58 发布

阅读量586

点赞数

文章标签：数据库

个人总结
环境
OS
rhel5.4 x86 64

DB

COL PRODUCT FORMAT A55
COL VERSION FORMAT A15
COL STATUS FORMAT A15 
SELECT * FROM PRODUCT_COMPONENT_VERSION;

PRODUCT                       VERSION          STATUS
--------------------------------------------- --------------- ---------------
NLSRTL                          10.2.0.4.0      Production
Oracle Database 10g Enterprise Edition          10.2.0.4.0      64bi
PL/SQL                          10.2.0.4.0      Production
TNS for Linux:                      10.2.0.4.0      Production

如文档中列出的所有隐藏参数

	Parameter	Session Value	Instance Value
1	_trace_files_public	FALSE	FALSE
2	_hang_analysis_num_call_stacks	3	3
3	_ior_serialize_fault	0	0
4	_inject_startup_fault	0	0
5	_latch_recovery_alignment	998	998
6	_spin_count	2000	2000
7	_latch_miss_stat_sid	0	0
8	_max_sleep_holding_latch	4	4
9	_max_exponential_sleep	0	0
10	_other_wait_threshold	0	0
11	_other_wait_event_exclusion
12	_use_vector_post	TRUE	TRUE
13	_latch_class_0
14	_latch_class_1
15	_latch_class_2
16	_latch_class_3
17	_latch_class_4
18	_latch_class_5
19	_latch_class_6
20	_latch_class_7
21	_latch_classes
22	_ultrafast_latch_statistics	TRUE	TRUE
23	_enable_reliable_latch_waits	TRUE	TRUE
24	_session_idle_bit_latches	0	0
25	_ksu_diag_kill_time	5	5
26	_ksuitm_dont_kill_dumper	FALSE	FALSE
27	_disable_image_check	FALSE	FALSE
28	_num_longop_child_latches	8	8
29	_longops_enabled	TRUE	TRUE
30	_test_ksusigskip	5	5
31	_rm_numa_sched_enable	FALSE	FALSE
32	_disable_kcbhxor_osd	FALSE	FALSE
33	_disable_system_state	4294967294	4294967294
34	_session_wait_history	10	10
35	_session_idle_check_interval	60	60
36	_pkt_enable	FALSE	FALSE
37	_pkt_start	FALSE	FALSE
38	_pkt_pmon_interval	50	50
39	_dead_process_scan_interval	10	10
40	_collapse_wait_history	FALSE	FALSE
41	_short_stack_timeout_ms	30000	30000
42	_logout_storm_rate	0	0
43	_logout_storm_timeout	5	5
44	_logout_storm_retrycnt	600	600
45	_single_process	FALSE	FALSE
46	_dbg_proc_startup	FALSE	FALSE
47	_static_backgrounds
48	_enqueue_deadlock_time_sec	5	5
49	_number_cached_attributes	10	10
50	_oradebug_force	FALSE	FALSE
51	_ksdxdocmd_default_timeout_ms	30000	30000
52	_watchpoint_on	FALSE	FALSE
53	_ksdxw_num_sgw	10	10
54	_ksdxw_num_pgw	10	10
55	_ksdxw_stack_depth	4	4
56	_ksdxw_cini_flg	0	0
57	_ksdxw_nbufs	1000	1000
58	_enable_shared_pool_durations	TRUE	TRUE
59	_NUMA_pool_size	Not specified	Not specified
60	_enable_NUMA_optimization	TRUE	TRUE
61	_use_ism	TRUE	TRUE
62	_lock_sga_areas	0	0
63	_NUMA_instance_mapping	Not specified	Not specified
64	_simulator_upper_bound_multiple	2	2
65	_simulator_pin_inval_maxcnt	16	16
66	_simulator_lru_rebalance_thresh	10240	10240
67	_simulator_lru_rebalance_sizthr	2	2
68	_simulator_bucket_mindelta	8192	8192
69	_simulator_lru_scan_count	8	8
70	_simulator_internal_bound	10	10
71	_simulator_reserved_obj_count	1024	1024
72	_simulator_reserved_heap_count	4096	4096
73	_simulator_sampling_factor	2	2
74	_realfree_heap_max_size	32768	32768
75	_realfree_heap_pagesize_hint	65536	65536
76	_realfree_heap_mode	0	0
77	_use_realfree_heap	TRUE	TRUE
78	_pga_large_extent_size	1048576	1048576
79	_uga_cga_large_extent_size	262144	262144
80	_total_large_extent_memory	0	0
81	_use_ism_for_pga	TRUE	TRUE
82	_private_memory_address
83	_mem_annotation_sh_lev	0	0
84	_mem_annotation_pr_lev	0	0
85	_mem_annotation_scale	1	1
86	_mem_annotation_store	FALSE	FALSE
87	_4031_dump_bitvec	67194879	67194879
88	_4031_max_dumps	100	100
89	_4031_dump_interval	300	300
90	_4031_sga_dump_interval	3600	3600
91	_4031_sga_max_dumps	10	10
92	_mem_std_extent_size	4096	4096
93	__shared_pool_size	415236096	415236096
94	__large_pool_size	4194304	4194304
95	__java_pool_size	4194304	4194304
96	__streams_pool_size	0	0
97	_large_pool_min_alloc	65536	65536
98	_shared_pool_reserved_pct	5	5
99	_shared_pool_reserved_min_alloc	4400	4400
100	_kghdsidx_count	1	1
101	_test_param_1	25	25
102	_test_param_2
103	_test_param_3
104	_test_param_4
105	_test_param_5	25	25
106	_test_param_6	0	0
107	_disable_instance_params_check	FALSE	FALSE
108	_parameter_table_block_size	1024	1024
109	_ksb_disable_diagpid	FALSE	FALSE
110	_high_priority_processes	LMS*	LMS*
111	_os_sched_high_priority	1	1
112	_ksb_restart_clean_time	30000	30000
113	_ksb_restart_policy_times
114	_high_priority_process_num_yields_before_sleep	1000	1000
115	_ksd_test_param	999	999
116	_kse_die_timeout	60000	60000
117	_stack_guard_level	0	0
118	_kse_pc_table_size	256	256
119	_messages	300	300
120	_enqueue_locks	3054	3054
121	_enqueue_resources	1792	1792
122	_enqueue_hash	375	375
123	_enqueue_debug_multi_instance	FALSE	FALSE
124	_enqueue_hash_chain_latches	8	8
125	_ksi_trace
126	_trace_processes	ALL	ALL
127	_trace_archive	FALSE	FALSE
128	_trace_events
129	_trace_buffers	ALL:256	ALL:256
130	_trace_flush_processes	ALL	ALL
131	_trace_file_size	65536	65536
132	_trace_options	text,multiple	text,multiple
133	_trace_buffer_wrap_timestamp	TRUE	TRUE
134	_nchar_imp_cnv	TRUE	TRUE
135	_disable_file_locks	FALSE	FALSE
136	_ksfd_verify_write	FALSE	FALSE
137	_disable_odm	FALSE	FALSE
138	_enable_list_io	FALSE	FALSE
139	_omf	enabled	enabled
140	_aiowait_timeouts	100	100
141	_io_shared_pool_size	4194304	4194304
142	_db_file_direct_io_count	1048576	1048576
143	_ioslave_issue_count	500	500
144	_ioslave_batch_count	1	1
145	_io_slaves_disabled	FALSE	FALSE
146	_lgwr_io_slaves	0	0
147	_arch_io_slaves	0	0
148	_backup_disk_io_slaves	0	0
149	_backup_io_pool_size	1048576	1048576
150	_high_server_threshold	0	0
151	_low_server_threshold	0	0
152	_yield_check_interval	100000	100000
153	_resource_manager_always_on	TRUE	TRUE
154	_rm_numa_simulation_pgs	0	0
155	_rm_numa_simulation_cpus	0	0
156	_first_spare_parameter
157	_second_spare_parameter
158	_third_spare_parameter
159	_fourth_spare_parameter
160	_fifth_spare_parameter
161	_sixth_spare_parameter
162	_seventh_spare_parameter
163	_ksxp_send_timeout	300	300
164	_ksxp_diagmode	OFF	OFF
165	_skgxp_reaping	1000	1000
166	_skgxp_udp_hiwat_warn	1000	1000
167	_skgxp_udp_ach_reaping_time	0	0
168	_skgxp_udp_timed_wait_seconds	5	5
169	_skgxp_udp_timed_wait_buffering	1024	1024
170	_skgxp_udp_keep_alive_ping_timer_secs	300	300
171	_disable_duplex_link	TRUE	TRUE
172	_diag_diagnostics	TRUE	TRUE
173	_disable_interface_checking	FALSE	FALSE
174	_skgxp_udp_interface_detection_time_secs	60	60
175	_skgxp_udp_lmp_on	FALSE	FALSE
176	_skgxp_udp_lmp_mtusize	0	0
177	_ksxp_testing	0	0
178	_ksxp_reporting_process	LMD0	LMD0
179	_ksmg_granule_size	4194304	4194304
180	_ksmg_granule_locking_status	1	1
181	_ksmg_lock_check_interval
182	_ksmg_lock_reacquire_count	5	5
183	_filemap_dir
184	_object_statistics	TRUE	TRUE
185	_enable_rlb	TRUE	TRUE
186	_disable_health_check	FALSE	FALSE
187	_accept_versions
188	_hang_detection	0	0
189	_diag_daemon	TRUE	TRUE
190	_dump_system_state_scope	local	local
191	_dump_trace_scope	global	global
192	_dump_interval_limit	120	120
193	_dump_max_limit	5	5
194	_diag_dump_timeout	30	30
195	_trace_navigation_scope	global	global
196	_max_protocol_support	10000	10000
197	_lm_lms	0	0
198	_lm_dynamic_lms	FALSE	FALSE
199	_lm_max_lms	0	0
200	_lm_min_lms	0	0
201	_lm_activate_lms_threshold	100	100
202	_lm_lmd_waittime	8	8
203	_lm_lms_waittime	8	8
204	_lm_procs	320	320
205	_lm_ress	6000	6000
206	_lm_locks	12000	12000
207	_lm_master_weight	1	1
208	_active_standby_fast_reconfiguration	TRUE	TRUE
209	_lm_enq_rcfg	TRUE	TRUE
210	_lm_dynamic_remastering	FALSE	FALSE
211	_lm_xids	352	352
212	_lm_res_part	128	128
213	_lm_drm_window	0	0
214	_lm_drm_max_requests	100	100
215	_lm_drm_xlatch	0	0
216	_lm_contiguous_res_count	128	128
217	_lm_num_pt_buckets	4096	4096
218	_lm_num_pt_latches	128	128
219	_lm_num_pcmhv_latches	0	0
220	_lm_node_join_opt	FALSE	FALSE
221	_lm_non_fault_tolerant	FALSE	FALSE
222	_lm_cache_res_cleanup	25	25
223	_lm_cache_res_type	TMHWDI	TMHWDI
224	_lm_cache_lvl0_cleanup	0	0
225	_lm_send_buffers	10000	10000
226	_lm_rcv_buffer_size	32768	32768
227	_inquiry_retry_interval	3	3
228	_gcs_testing	0	0
229	_ogms_home
230	_lm_sync_timeout
231	_lm_ticket_active_sendback
232	_lm_rcfg_timeout	180000	180000
233	_lm_enq_lock_freelist
234	_lm_enqueue_freelist	3	3
235	_lm_dd_interval	60	60
236	_lm_dd_scan_interval	5	5
237	_lm_dd_search_cnt	3	3
238	_lm_dd_max_search_time	180	180
239	_dlmtrace
240	_lm_tx_delta	16	16
241	_lm_proc_freeze_timeout	300	300
242	_lm_validate_resource_type	FALSE	FALSE
243	_lm_file_affinity
244	_lm_share_lock_opt	FALSE	FALSE
245	_lm_res_hash_bucket	0	0
246	_ges_diagnostics	TRUE	TRUE
247	_fair_remote_cvt	FALSE	FALSE
248	_dlm_send_timeout	30000	30000
249	_lm_rcvr_hang_check_frequency	60	60
250	_lm_rcvr_hang_allow_time	200	200
251	_lm_rcvr_hang_kill	FALSE	FALSE
252	_ges_dd_debug	1	1
253	_lm_global_posts	TRUE	TRUE
254	_rcfg_parallel_replay	TRUE	TRUE
255	_parallel_replay_msg_limit	4000	4000
256	_rcfg_parallel_fixwrite	TRUE	TRUE
257	_parallel_fixwrite_bucket	1000	1000
258	_rcfg_parallel_verify	TRUE	TRUE
259	_rcfg_disable_verify	FALSE	FALSE
260	_dump_rcvr_ipc	TRUE	TRUE
261	_ges_health_check	1	1
262	_kill_enqueue_blocker	3	3
263	_lm_better_ddvictim	TRUE	TRUE
264	_lm_msg_batch_size	0	0
265	_lm_tickets	1000	1000
266	_lm_msg_cache_thresholds
267	_lm_msg_cleanup_interval	3000	3000
268	_lm_send_mode	auto	auto
269	_lm_postevent_buffer_size	256	256
270	_lm_send_queue_length	5000	5000
271	_lm_send_queue_batching	TRUE	TRUE
272	_lm_process_batching	TRUE	TRUE
273	_lm_sq_batch_factor	2	2
274	_lm_sq_batch_type	auto	auto
275	_lm_sq_batch_waittick	3	3
276	_lm_sendproxy_reserve	25	25
277	_lm_checksum_batch_msg	FALSE	FALSE
278	_abort_recovery_on_join	FALSE	FALSE
279	_send_ast_to_foreground	TRUE	TRUE
280	_reliable_block_sends	FALSE	FALSE
281	_blocks_per_cache_server	128	128
282	_object_reuse_bast	2	2
283	_send_close_with_block	TRUE	TRUE
284	_gcs_fast_reconfig	TRUE	TRUE
285	_cr_grant_global_role	TRUE	TRUE
286	_cr_grant_local_role	AUTO	AUTO
287	_skip_assume_msg	TRUE	TRUE
288	_gcs_resources
289	_gcs_latches	0	0
290	_gcs_process_in_recovery	TRUE	TRUE
291	_scatter_gcs_resources	FALSE	FALSE
292	_gcs_shadow_locks
293	_scatter_gcs_shadows	FALSE	FALSE
294	_async_object_flush	TRUE	TRUE
295	_side_channel_batch_size	200	200
296	_side_channel_batch_timeout	6	6
297	_side_channel_batch_timeout_ms	500	500
298	_master_direct_sends	31	31
299	_cgs_send_timeout	300	300
300	_imr_active	TRUE	TRUE
301	_imr_max_reconfig_delay	300	300
302	_imr_splitbrain_res_wait	600	600
303	_imr_disk_voting_interval	3	3
304	_imr_systemload_check	TRUE	TRUE
305	_cluster_library	clss	clss
306	_cgs_reconfig_timeout	120	120
307	_lm_dynamic_load	TRUE	TRUE
308	_notify_crs	FALSE	FALSE
309	_kill_diagnostics_timeout	60	60
310	_shared_pool_max_size	0	0
311	_shared_pool_minsize_on	FALSE	FALSE
312	_streams_pool_max_size	0	0
313	_disable_streams_pool_auto_tuning	FALSE	FALSE
314	_memory_management_tracing	0	0
315	_memory_sanity_check	0	0
316	_init_granule_interval	10	10
317	_memory_broker_stat_interval	30	30
318	_memory_broker_shrink_heaps	15	15
319	_memory_broker_shrink_java_heaps	900	900
320	_memory_broker_shrink_streams_pool	900	900
321	_memory_broker_shrink_timeout	60000000	60000000
322	_memory_broker_log_stat_entries	5	5
323	_memory_broker_marginal_utility_sp	4	4
324	_memory_broker_marginal_utility_bc	10	10
325	_disable_latch_free_SCN_writes_via_32cas	FALSE	FALSE
326	_disable_latch_free_SCN_writes_via_64cas	FALSE	FALSE
327	_controlfile_enqueue_timeout	900	900
328	_controlfile_enqueue_holding_time	120	120
329	_controlfile_update_check	OFF	OFF
330	_controlfile_enqueue_dump	FALSE	FALSE
331	_controlfile_block_size	0	0
332	_controlfile_section_init_size
333	_controlfile_section_max_expand
334	_kill_controlfile_enqueue_blocker	TRUE	TRUE
335	_db_block_buffers	95309	95309
336	_db_block_cache_protect	FALSE	FALSE
337	_db_block_cache_protect_internal	0	0
338	_dbwr_tracing	0	0
339	_disable_multiple_block_sizes	FALSE	FALSE
340	_db_fast_obj_truncate	TRUE	TRUE
341	_db_fast_obj_ckpt	TRUE	TRUE
342	_db_obj_enable_ksr	TRUE	TRUE
343	_small_table_threshold	1906	1906
344	_db_block_cache_num_umap	0	0
345	_dbwr_async_io	TRUE	TRUE
346	_recovery_percentage	50	50
347	_db_lost_write_checking	FALSE	FALSE
348	__db_cache_size	641728512	641728512
349	_db_block_numa	1	1
350	_db_block_lru_latches	32	32
351	_db_percpu_create_cachesize	2	2
352	_db_todefer_cache_create	TRUE	TRUE
353	_db_block_known_clean_pct	2	2
354	_db_block_max_scan_pct	40	40
355	_db_large_dirty_queue	25	25
356	_db_writer_max_writes	0	0
357	_db_writer_chunk_writes	0	0
358	_db_block_med_priority_batch_size	0	0
359	_db_block_hi_priority_batch_size	0	0
360	_db_writer_histogram_statistics	FALSE	FALSE
361	_dbwr_scan_interval	300	300
362	_db_writer_flush_imu	TRUE	TRUE
363	_db_writer_coalesce_write_limit	131072	131072
364	_db_writer_coalesce_area_size	1048576	1048576
365	_selftune_checkpoint_write_pct	3	3
366	_db_writer_verify_writes	FALSE	FALSE
367	_db_block_prefetch_quota	10	10
368	_db_block_prefetch_limit	0	0
369	_db_cache_pre_warm	TRUE	TRUE
370	_db_percent_hot_default	50	50
371	_db_percent_hot_keep	0	0
372	_db_percent_hot_recycle	0	0
373	_db_aging_hot_criteria	2	2
374	_db_aging_stay_count	0	0
375	_db_aging_cool_count	1	1
376	_db_aging_touch_time	3	3
377	_db_aging_freeze_cr	FALSE	FALSE
378	_db_block_hash_buckets	262144	262144
379	_db_block_hash_latches	8192	8192
380	_db_blocks_per_hash_latch
381	_db_handles	750	750
382	_db_handles_cached	5	5
383	_wait_for_sync	TRUE	TRUE
384	_db_block_vlm_check	FALSE	FALSE
385	_db_block_vlm_leak_threshold	3	3
386	_db_block_cache_clone	FALSE	FALSE
387	_db_block_trace_protect	FALSE	FALSE
388	_db_block_max_cr_dba	6	6
389	_trace_buffer_flushes	FALSE	FALSE
390	_trace_multi_block_reads	FALSE	FALSE
391	_trace_cr_buffer_creates	FALSE	FALSE
392	_write_clones	3	3
393	_trace_buffer_gets	FALSE	FALSE
394	_check_block_after_checksum	TRUE	TRUE
395	_trace_pin_time	0	0
396	_db_fast_obj_check	FALSE	FALSE
397	_db_block_temp_redo	FALSE	FALSE
398	_db_block_adjchk_level	0	0
399	_db_block_adjcheck	TRUE	TRUE
400	_db_required_percent_fairshare_usage	10	10
401	_db_block_check_objtyp	TRUE	TRUE
402	_db_block_do_full_mbreads	FALSE	FALSE
403	_trace_buffer_wait_timeouts	0	0
404	_buffer_busy_wait_timeout	100	100
405	_db_cache_crx_check	FALSE	FALSE
406	_db_hot_block_tracking	FALSE	FALSE
407	_db_block_cache_history	0	0
408	_db_block_cache_history_level	2	2
409	_db_block_table_scan_buffer_size	4194304	4194304
410	_db_obj_ckpt_ordered	FALSE	FALSE
411	_db_cache_process_cr_pin_max
412	_db_cache_advice_sample_factor	4	4
413	_db_cache_advice_batch_size	128	128
414	_db_mttr_advice	ON	ON
415	_db_mttr_sim_target
416	_db_mttr_sample_factor	64	64
417	_db_mttr_partitions	0	0
418	_db_mttr_sim_trace_size	256	256
419	_db_mttr_trace_to_alert	FALSE	FALSE
420	_immediate_commit_propagation	TRUE	TRUE
421	_minimum_giga_scn	0	0
422	_redo_compatibility_check	FALSE	FALSE
423	_db_block_check_for_debug	FALSE	FALSE
424	_db_always_check_system_ts	TRUE	TRUE
425	_log_checkpoint_recovery_check	0	0
426	_two_pass	TRUE	TRUE
427	_recovery_verify_writes	FALSE	FALSE
428	_disable_recovery_read_skip	FALSE	FALSE
429	_log_archive_security_enabled	TRUE	TRUE
430	_log_archive_avoid_memcpy	TRUE	TRUE
431	_log_archive_prot_auto_demote	FALSE	FALSE
432	_log_archive_compress_enable	FALSE	FALSE
433	_real_time_apply_arch_delay	0	0
434	_real_time_apply_sim	0	0
435	_log_archive_buffers	10	10
436	_log_archive_buffer_size	2048	2048
437	_log_archive_callout
438	_log_archive_net_timeout	0	0
439	_log_archive_delta_sync_wait	0	0
440	_max_rfs_connections	0	0
441	_lgwr_max_ns_wt	1	1
442	_max_arch_lns_wait	120	120
443	_max_lns_shutdown_archival_time	30	30
444	_ta_lns_wait_for_arch_log	20	20
445	_ns_max_flush_wt	1	1
446	_ns_max_send_delay	15	15
447	_lgwr_ta_sim_err	0	0
448	_lgwr_ns_sim_err	0	0
449	_lgwr_ns_nl_min	500	500
450	_lgwr_ns_nl_max	1000	1000
451	_arch_corrupted_redo_log	0	0
452	_log_archive_network_redo_size	10	10
453	_lgwr_async_io	FALSE	FALSE
454	_lgwr_async_broadcasts	TRUE	TRUE
455	_lgwr_delay_write	FALSE	FALSE
456	_log_io_size	0	0
457	_log_event_queues	0	0
458	_log_switch_timeout	0	0
459	_log_buffers_debug	FALSE	FALSE
460	_log_buffers_corrupt	FALSE	FALSE
461	_log_debug_multi_instance	FALSE	FALSE
462	_log_simultaneous_copies	16	16
463	_log_parallelism	1	1
464	_log_parallelism_max	2	2
465	_log_parallelism_dynamic	TRUE	TRUE
466	_log_private_parallelism	FALSE	FALSE
467	_log_private_parallelism_mul	10	10
468	_log_private_mul	5	5
469	_lightweight_hdrs	TRUE	TRUE
470	_mirror_redo_buffers	FALSE	FALSE
471	_disable_logging	FALSE	FALSE
472	_fg_sync_sleep_usecs	0	0
473	_db_file_exec_read_count	8	8
474	_db_file_optimizer_read_count	8	8
475	_db_file_noncontig_mblock_read_count	11	11
476	_db_recovery_temporal_file_dest
477	_hard_protection	FALSE	FALSE
478	_allow_error_simulation	FALSE	FALSE
479	_db_file_format_io_buffers	4	4
480	_gc_use_cr	TRUE	TRUE
481	_gc_undo_affinity	TRUE	TRUE
482	_gc_affinity_time	10	10
483	_gc_affinity_limit	50	50
484	_gc_affinity_minimum	6000	6000
485	_recovery_asserts	FALSE	FALSE
486	_gc_integrity_checks	1	1
487	_gc_vector_read	TRUE	TRUE
488	_gc_element_percent	103	103
489	_gc_latches	8	8
490	_gc_defer_time	3	3
491	_kcl_debug	TRUE	TRUE
492	_kcl_index_split	TRUE	TRUE
493	_kcl_commit	TRUE	TRUE
494	_fairness_threshold	4	4
495	_interconnect_checksum	TRUE	TRUE
496	_cr_server_log_flush	TRUE	TRUE
497	_ping_level	3	3
498	_async_recovery_reads	TRUE	TRUE
499	_async_recovery_claims	TRUE	TRUE
500	_avoid_prepare	TRUE	TRUE
501	_bwr_for_flushed_pi	TRUE	TRUE
502	_send_requests_to_pi	TRUE	TRUE
503	_kcl_undo_locks	128	128
504	_kcl_undo_grouping	32	32
505	_kcl_conservative_log_flush	FALSE	FALSE
506	_gc_statistics	TRUE	TRUE
507	_gc_check_bscn	TRUE	TRUE
508	_gc_global_lru	AUTO	AUTO
509	_gc_dynamic_affinity_locks	TRUE	TRUE
510	_gc_undo_affinity_locks	TRUE	TRUE
511	_gc_coalesce_recovery_reads	TRUE	TRUE
512	_gc_keep_recovery_buffers	TRUE	TRUE
513	_gc_maximum_bids	0	0
514	_gc_async_memcpy	FALSE	FALSE
515	_gc_dissolve_undo_affinity	FALSE	FALSE
516	_gc_initiate_undo_affinity	TRUE	TRUE
517	_adaptive_direct_read	TRUE	TRUE
518	_db_block_align_direct_read	TRUE	TRUE
519	_disable_incremental_checkpoints	FALSE	FALSE
520	_fast_start_instance_recovery_target	0	0
521	_disable_selftune_checkpointing	FALSE	FALSE
522	_selftune_checkpointing_lag	300	300
523	_target_rba_max_lag_percentage	90	90
524	_no_recovery_through_resetlogs	FALSE	FALSE
525	_log_blocks_during_backup	TRUE	TRUE
526	_allow_resetlogs_corruption	FALSE	FALSE
527	_allow_terminal_recovery_corruption	FALSE	FALSE
528	_allow_read_only_corruption	FALSE	FALSE
529	_recovery_skip_cfseq_check	FALSE	FALSE
530	_serial_recovery	FALSE	FALSE
531	_coord_message_buffer	0	0
532	_multiple_instance_recovery	FALSE	FALSE
533	_backup_kgc_bufsz	0	0
534	_backup_kgc_type	0	0
535	_backup_kgc_niters	0	0
536	_backup_ksfq_bufsz	0	0
537	_backup_ksfq_bufcnt	0	0
538	_backup_max_gap_size	4294967294	4294967294
539	_unused_block_compression	TRUE	TRUE
540	_restore_spfile
541	_dummy_instance	FALSE	FALSE
542	_rman_io_priority	3	3
543	_tts_allow_charset_mismatch	FALSE	FALSE
544	_xtts_allow_pre10	FALSE	FALSE
545	_xtts_set_platform_info	FALSE	FALSE
546	_disable_recoverable_recovery	FALSE	FALSE
547	_recoverable_recovery_batch_percent	50	50
548	_disable_incremental_recovery_ckpt	FALSE	FALSE
549	_incremental_recovery_ckpt_min_batch	30	30
550	_media_recovery_read_batch	128	128
551	_media_recovery_reap_time	3	3
552	_bct_public_dba_buffer_size	0	0
553	_bct_initial_private_dba_buffer_size	0	0
554	_bct_bitmaps_per_file	8	8
555	_bct_file_block_size	0	0
556	_bct_file_extent_size	0	0
557	_bct_chunk_size	0	0
558	_bct_crash_reserve_size	262144	262144
559	_bct_buffer_allocation_size	2097152	2097152
560	_bct_buffer_allocation_max	104857600	104857600
561	_bct_buffer_allocation_min_extents	1	1
562	_bct_fixtab_file
563	_block_change_tracking	TRUE	TRUE
564	_log_deletion_policy	mandatory	mandatory
565	_validate_flashback_database	FALSE	FALSE
566	_flashback_allow_noarchivelog	FALSE	FALSE
567	_verify_flashback_redo	TRUE	TRUE
568	_flashback_verbose_info	FALSE	FALSE
569	_flashback_marker_cache_size	328	328
570	_flashback_marker_cache_enabled	TRUE	TRUE
571	_flashback_logfile_enqueue_timeout	600	600
572	_flashback_barrier_interval	1800	1800
573	_flashback_standby_barrier_interval	1800	1800
574	_flashback_fuzzy_barrier	TRUE	TRUE
575	_disable_flashback_wait_callback	FALSE	FALSE
576	_flashback_log_size	1000	1000
577	_flashback_log_min_size	100	100
578	_flashback_copy_latches	10	10
579	_flashback_n_log_per_thread	128	128
580	_flashback_max_n_log_per_thread	2048	2048
581	_flashback_generation_buffer_size	33554432	33554432
582	_flashback_max_log_size	0	0
583	_flashback_log_io_error_behavior	0	0
584	_flashback_hint_barrier_percent	20	20
585	_percent_flashback_buf_partial_full	50	50
586	_flashback_write_size_qm	4	4
587	_tdb_debug_mode	16	16
588	_row_locking	always	always
589	_serializable	FALSE	FALSE
590	_log_committime_block_cleanout	FALSE	FALSE
591	_ktc_latches	0	0
592	_prescomm	FALSE	FALSE
593	_recursive_imu_transactions	FALSE	FALSE
594	_ktc_debug	0	0
595	_allocate_creation_order	FALSE	FALSE
596	_log_space_errors	TRUE	TRUE
597	_bump_highwater_mark_count	0	0
598	_assm_default	TRUE	TRUE
599	_enable_hwm_sync	TRUE	TRUE
600	_hwm_sync_threshold	10	10
601	_enable_tablespace_alerts	TRUE	TRUE
602	_last_allocation_period	5	5
603	_inst_locking_period	5	5
604	_allocation_update_interval	3	3
605	_minimum_blocks_to_shrink	0	0
606	_minimum_extents_to_shrink	1	1
607	_max_shrink_obj_stats	0	0
608	_check_ts_threshold	0	0
609	_ktu_latches	0	0
610	_rollback_segment_initial	1	1
611	_rollback_segment_count	0	0
612	_offline_rollback_segments
613	_corrupted_rollback_segments
614	_transaction_auditing	TRUE	TRUE
615	_enable_block_level_transaction_recovery	TRUE	TRUE
616	_cleanup_rollback_entries	100	100
617	_smu_error_simulation_site	0	0
618	_smu_error_simulation_type	0	0
619	_collect_undo_stats	TRUE	TRUE
620	_smu_timeouts
621	_smu_debug_mode	0	0
622	_undo_debug_mode	0	0
623	_verify_undo_quota	FALSE	FALSE
624	_discrete_transactions_enabled	FALSE	FALSE
625	_in_memory_undo	TRUE	TRUE
626	_imu_pools	3	3
627	_row_cr	TRUE	TRUE
628	_undo_autotune	TRUE	TRUE
629	_rollback_stopat	0	0
630	_smon_internal_errlimit	100	100
631	_smon_undo_seg_rescan_limit	10	10
632	_transaction_recovery_servers	0	0
633	_parallel_recovery_stopat	32767	32767
634	_disable_txn_alert	0	0
635	_undo_debug_usage	0	0
636	_db_change_notification_enable	TRUE	TRUE
637	_db_row_overlap_checking	TRUE	TRUE
638	_db_index_block_checking	TRUE	TRUE
639	_alternate_iot_leaf_block_split_points	TRUE	TRUE
640	_release_insert_threshold	5	5
641	_walk_insert_threshold	0	0
642	_enable_hash_overflow	FALSE	FALSE
643	_minfree_plus	0	0
644	_use_seq_process_cache	TRUE	TRUE
645	_reuse_index_loop	5	5
646	_kdbl_enable_post_allocation	FALSE	FALSE
647	_ldr_io_size	262144	262144
648	_ignore_desc_in_index	FALSE	FALSE
649	_keep_remote_column_size	FALSE	FALSE
650	_row_cache_cursors	20	20
651	_kgl_multi_instance_lock	TRUE	TRUE
652	_kgl_multi_instance_pin	TRUE	TRUE
653	_kgl_multi_instance_invalidation	TRUE	TRUE
654	_kgl_latch_count	0	0
655	_kgl_heap_size	1024	1024
656	_kgl_fixed_extents	TRUE	TRUE
657	_kgl_session_cached_objects	10	10
658	_kgl_keep_cache_pct	30	30
659	_kgl_keep_cache_retain_pct	20	20
660	_kgl_bucket_count	9	9
661	_library_cache_advice	TRUE	TRUE
662	_kglsim_maxmem_percent	5	5
663	_kgl_hash_collision	FALSE	FALSE
664	_kgl_time_to_wait_for_locks	15	15
665	_kgl_large_heap_warning_threshold	52428800	52428800
666	_synonym_repoint_tracing	FALSE	FALSE
667	_kkdlgon_max_iter	20000	20000
668	_cursor_cache_frame_bind_memory	FALSE	FALSE
669	_cursor_features_enabled	2	2
670	_kgx_latches	512	512
671	_kks_use_mutex_pin	TRUE	TRUE
672	_kgx_spin_count	255	255
673	_cursor_stats_bucket	15	15
674	_cursor_stats_heap	4	4
675	_passwordfile_enqueue_timeout	900	900
676	_dynamic_rls_policies	TRUE	TRUE
677	_app_ctx_vers	FALSE	FALSE
678	_session_context_size	10000	10000
679	_default_encrypt_alg	0	0
680	_ols_cleanup_task	TRUE	TRUE
681	_distributed_recovery_connection_hold_time	200	200
682	__dg_broker_service_names	DRUGSYNC_XPT	DRUGSYNC_XPT
683	_pmon_load_constants	300,192,64,3,10,10,0,0	300,192,64,3,10,10,0,0
684	_dispatcher_rate_ttl
685	_dispatcher_rate_scale
686	_shared_server_spare_param1
687	_shared_server_spare_param2
688	_shared_server_spare_param3
689	_kernel_message_network_driver	FALSE	FALSE
690	_dedicated_server_poll_count	10	10
691	_dedicated_server_post_wait_call	FALSE	FALSE
692	_dedicated_server_post_wait	FALSE	FALSE
693	_session_kept_cursor_pins	0	0
694	_dump_qbc_tree	0	0
695	_plsql_dump_buffer_events
696	_plsql_anon_block_code_type	INTERPRETED	INTERPRETED
697	_inline_sql_in_plsql	FALSE	FALSE
698	_plsql_nvl_optimize	FALSE	FALSE
699	_job_queue_interval	5	5
700	_parallel_default_max_instances	1	1
701	_system_trig_enabled	TRUE	TRUE
702	_kkfi_trace	FALSE	FALSE
703	_adjust_literal_replacement	FALSE	FALSE
704	_kolfuseslf	FALSE	FALSE
705	_session_cached_instantiations	60	60
706	_px_trace	none	none
707	_xt_trace	none	none
708	_xt_coverage	none	none
709	_ku_trace	none	none
710	_optimizer_trace	none	none
711	_parallel_server_idle_time	30000	30000
712	_parallel_server_sleep_time	10	10
713	_px_send_timeout	300	300
714	_dynamic_stats_threshold	30	30
715	_parallel_fake_class_pct	0	0
716	_px_load_publish_interval	200	200
717	_parallel_execution_message_align	FALSE	FALSE
718	_PX_use_large_pool	FALSE	FALSE
719	_parallel_min_message_pool	64440	64440
720	_px_buffer_ttl	30	30
721	_tq_dump_period	0	0
722	_affinity_on	TRUE	TRUE
723	_enable_default_affinity	0	0
724	_dss_cache_flush	FALSE	FALSE
725	_hash_join_enabled	TRUE	TRUE
726	_hash_multiblock_io_count	0	0
727	_cursor_db_buffers_pinned	633	633
728	_old_connect_by_enabled	FALSE	FALSE
729	_table_lookup_prefetch_size	40	40
730	_multi_join_key_table_lookup	TRUE	TRUE
731	_table_lookup_prefetch_thresh	2	2
732	_adaptive_fetch_enabled	TRUE	TRUE
733	_query_execution_cache_max_size	65536	65536
734	_fast_dual_enabled	TRUE	TRUE
735	_newsort_enabled	TRUE	TRUE
736	_newsort_type	0	0
737	_newsort_ordered_pct	63	63
738	_fix_control
739	_oradbg_pathname
740	_vendor_lib_loc
741	_disable_sun_rsm	TRUE	TRUE
742	_ipc_test_failover	0	0
743	_ipc_test_mult_nets	0	0
744	_ipc_fail_network	0	0
745	_no_objects	FALSE	FALSE
746	_domain_index_batch_size	2000	2000
747	_domain_index_dml_batch_size	200	200
748	_nchar_imp_conv	TRUE	TRUE
749	_insert_enable_hwm_brokered	TRUE	TRUE
750	_all_shared_dblinks
751	_close_cached_open_cursors	FALSE	FALSE
752	_disable_savepoint_reset	FALSE	FALSE
753	_init_sql_file	?/rdbms/admin/sql.bsq	?/rdbms/admin/sql.bsq
754	_sort_multiblock_read_count	2	2
755	_shrunk_aggs_enabled	TRUE	TRUE
756	_shrunk_aggs_disable_threshold	60	60
757	_gby_onekey_enabled	TRUE	TRUE
758	_sql_connect_capability_table
759	_optimizer_mode_force	TRUE	TRUE
760	_explain_rewrite_mode	FALSE	FALSE
761	_query_rewrite_or_error	FALSE	FALSE
762	_sort_elimination_cost_ratio	0	0
763	_sql_connect_capability_override	0	0
764	_always_anti_join	CHOOSE	CHOOSE
765	_partition_view_enabled	TRUE	TRUE
766	_always_star_transformation	FALSE	FALSE
767	_b_tree_bitmap_plans	TRUE	TRUE
768	_column_elimination_off	FALSE	FALSE
769	_cpu_to_io	0	0
770	_optimizer_extended_cursor_sharing	UDO	UDO
771	_optimizer_cost_model	CHOOSE	CHOOSE
772	_optimizer_undo_cost_change	10.2.0.4	10.2.0.4
773	_optimizer_system_stats_usage	TRUE	TRUE
774	_optimizer_cache_stats	FALSE	FALSE
775	_new_sort_cost_estimate	TRUE	TRUE
776	_complex_view_merging	TRUE	TRUE
777	_simple_view_merging	TRUE	TRUE
778	_unnest_subquery	TRUE	TRUE
779	_eliminate_common_subexpr	TRUE	TRUE
780	_pred_move_around	TRUE	TRUE
781	_convert_set_to_join	FALSE	FALSE
782	_px_ual_serial_input	TRUE	TRUE
783	_px_bind_peek_sharing	TRUE	TRUE
784	_px_minus_intersect	TRUE	TRUE
785	_remove_aggr_subquery	TRUE	TRUE
786	_distinct_view_unnesting	FALSE	FALSE
787	_optimizer_push_down_distinct	0	0
788	_optimizer_cost_based_transformation	LINEAR	LINEAR
789	_optimizer_squ_bottomup	TRUE	TRUE
790	_optimizer_cbqt_factor	50	50
791	_push_join_predicate	TRUE	TRUE
792	_push_join_union_view	TRUE	TRUE
793	_push_join_union_view2	TRUE	TRUE
794	_fast_full_scan_enabled	TRUE	TRUE
795	_optimizer_skip_scan_enabled	TRUE	TRUE
796	_optimizer_join_sel_sanity_check	TRUE	TRUE
797	_optim_enhance_nnull_detection	TRUE	TRUE
798	_idl_conventional_index_maintenance	TRUE	TRUE
799	_enable_cscn_caching	FALSE	FALSE
800	_parallel_broadcast_enabled	TRUE	TRUE
801	_px_broadcast_fudge_factor	100	100
802	_px_kxib_tracing	0	0
803	_px_granule_size	100000	100000
804	_px_xtgranule_size	10000	10000
805	_xtbuffer_size	0	0
806	_px_async_getgranule	FALSE	FALSE
807	_px_min_granules_per_slave	13	13
808	_px_max_granules_per_slave	100	100
809	_px_no_stealing	FALSE	FALSE
810	_px_no_granule_sort	FALSE	FALSE
811	_px_proc_constrain	TRUE	TRUE
812	_parallel_adaptive_max_users	1	1
813	_parallel_load_balancing	TRUE	TRUE
814	_parallel_load_bal_unit	0	0
815	_parallel_slave_acquisition_wait	1	1
816	_pdml_slaves_diff_part	TRUE	TRUE
817	_pdml_gim_sampling	5000	5000
818	_pdml_gim_staggered	FALSE	FALSE
819	_px_dynamic_opt	TRUE	TRUE
820	_px_dynamic_sample_size	50	50
821	_px_rownum_pd	TRUE	TRUE
822	_predicate_elimination_enabled	TRUE	TRUE
823	_groupby_nopushdown_cut_ratio	3	3
824	_groupby_orderby_combine	5000	5000
825	_temp_tran_block_threshold	100	100
826	_temp_tran_cache	TRUE	TRUE
827	_ordered_semijoin	TRUE	TRUE
828	_always_semi_join	CHOOSE	CHOOSE
829	_ordered_nested_loop	TRUE	TRUE
830	_nested_loop_fudge	100	100
831	_project_view_columns	TRUE	TRUE
832	_no_or_expansion	FALSE	FALSE
833	_optimizer_max_permutations	2000	2000
834	_system_index_caching	0	0
835	_serial_direct_read	FALSE	FALSE
836	_disable_datalayer_sampling	FALSE	FALSE
837	_disable_sample_io_optim	FALSE	FALSE
838	_sample_rows_per_block	4	4
839	_ncmb_readahead_enabled	0	0
840	_ncmb_readahead_tracing	0	0
841	_index_prefetch_factor	100	100
842	_query_cost_rewrite	TRUE	TRUE
843	_query_rewrite_2	TRUE	TRUE
844	_query_rewrite_1	TRUE	TRUE
845	_query_rewrite_fudge	90	90
846	_query_rewrite_expression	TRUE	TRUE
847	_query_rewrite_jgmigrate	TRUE	TRUE
848	_query_rewrite_fpc	TRUE	TRUE
849	_query_rewrite_drj	TRUE	TRUE
850	_query_rewrite_maxdisjunct	257	257
851	_query_rewrite_vop_cleanup	TRUE	TRUE
852	_mmv_query_rewrite_enabled	TRUE	TRUE
853	_bt_mmv_query_rewrite_enabled	TRUE	TRUE
854	_add_stale_mv_to_dependency_list	TRUE	TRUE
855	_full_pwise_join_enabled	TRUE	TRUE
856	_partial_pwise_join_enabled	TRUE	TRUE
857	_slave_mapping_enabled	TRUE	TRUE
858	_slave_mapping_group_size	0	0
859	_local_communication_costing_enabled	TRUE	TRUE
860	_local_communication_ratio	50	50
861	_parallelism_cost_fudge_factor	350	350
862	_left_nested_loops_random	TRUE	TRUE
863	_improved_row_length_enabled	TRUE	TRUE
864	_px_index_sampling	200	200
865	_index_join_enabled	TRUE	TRUE
866	_use_nosegment_indexes	FALSE	FALSE
867	_enable_type_dep_selectivity	TRUE	TRUE
868	_sqlexec_progression_cost	1000	1000
869	_improved_outerjoin_card	TRUE	TRUE
870	_optimizer_adjust_for_nulls	TRUE	TRUE
871	_optimizer_degree	0	0
872	_optimizer_choose_permutation	0	0
873	_use_column_stats_for_function	TRUE	TRUE
874	_subquery_pruning_cost_factor	20	20
875	_subquery_pruning_reduction	50	50
876	_subquery_pruning_enabled	TRUE	TRUE
877	_subquery_pruning_mv_enabled	FALSE	FALSE
878	_parallel_txn_global	FALSE	FALSE
879	_or_expand_nvl_predicate	TRUE	TRUE
880	_like_with_bind_as_equality	FALSE	FALSE
881	_table_scan_cost_plus_one	TRUE	TRUE
882	_cost_equality_semi_join	TRUE	TRUE
883	_default_non_equality_sel_check	TRUE	TRUE
884	_new_initial_join_orders	TRUE	TRUE
885	_oneside_colstat_for_equijoins	TRUE	TRUE
886	_column_tracking_level	1	1
887	_optim_peek_user_binds	TRUE	TRUE
888	_mv_refresh_selections	TRUE	TRUE
889	_cursor_plan_enabled	TRUE	TRUE
890	_minimal_stats_aggregation	TRUE	TRUE
891	_mv_refresh_eut	TRUE	TRUE
892	_mav_refresh_consistent_read	TRUE	TRUE
893	_mav_refresh_opt	0	0
894	_mav_refresh_unionall_tables	3	3
895	_mv_refresh_delta_fraction	10	10
896	_force_temptables_for_gsets	FALSE	FALSE
897	_pga_max_size	209715200	209715200
898	_smm_auto_min_io_size	56	56
899	_smm_auto_max_io_size	248	248
900	_smm_auto_cost_enabled	TRUE	TRUE
901	_smm_control	0	0
902	_smm_trace	0	0
903	_smm_min_size	209	209
904	_smm_max_size	41943	41943
905	_smm_px_max_size	104857	104857
906	_smm_retain_size	0	0
907	_smm_bound	0	0
908	_smm_advice_log_size	0	0
909	_smm_advice_enabled	TRUE	TRUE
910	_gs_anti_semi_join_allowed	TRUE	TRUE
911	_mv_refresh_use_stats	FALSE	FALSE
912	_optim_new_default_join_sel	TRUE	TRUE
913	_optimizer_dyn_smp_blks	32	32
914	_pre_rewrite_push_pred	TRUE	TRUE
915	_optimizer_new_join_card_computation	TRUE	TRUE
916	_mav_refresh_double_count_prevented	FALSE	FALSE
917	_pct_refresh_double_count_prevented	TRUE	TRUE
918	_mv_refresh_new_setup_disabled	FALSE	FALSE
919	_load_without_compile	NONE	NONE
920	_precompute_gid_values	TRUE	TRUE
921	_union_rewrite_for_gs	YES_GSET_MVS	YES_GSET_MVS
922	_nested_mav_fast_oncommit_enabled	TRUE	TRUE
923	_generalized_pruning_enabled	TRUE	TRUE
924	_rowsource_execution_statistics	FALSE	FALSE
925	_rowsource_statistics_sampfreq	128	128
926	_bitmap_or_improvement_enabled	TRUE	TRUE
927	_intrapart_pdml_enabled	TRUE	TRUE
928	_ctas_hwm_brokered_loads	TRUE	TRUE
929	_intrapart_pdml_randomlocal_enabled	TRUE	TRUE
930	_optim_adjust_for_part_skews	TRUE	TRUE
931	_optimizer_compute_index_stats	TRUE	TRUE
932	_optimizer_autostats_job	TRUE	TRUE
933	_optimizer_push_pred_cost_based	TRUE	TRUE
934	_optimizer_filter_pred_pullup	TRUE	TRUE
935	_optimizer_connect_by_cost_based	TRUE	TRUE
936	_optimizer_connect_by_combine_sw	TRUE	TRUE
937	_force_datefold_trunc	FALSE	FALSE
938	_array_update_vector_read_enabled	FALSE	FALSE
939	_two_pass_reverse_polish_enabled	TRUE	TRUE
940	_expand_aggregates	TRUE	TRUE
941	_dump_common_subexpressions	FALSE	FALSE
942	_spr_use_hash_table	FALSE	FALSE
943	_spr_use_AW_AS	TRUE	TRUE
944	_dump_connect_by_loop_data	FALSE	FALSE
945	_column_compression_factor	0	0
946	_dml_monitoring_enabled	TRUE	TRUE
947	_px_slaves_share_cursors	0	0
948	_fic_algorithm_set	automatic	automatic
949	_fic_area_size	131072	131072
950	_fic_max_length	20	20
951	_fic_min_bmsize	1024	1024
952	_dtree_area_size	131072	131072
953	_dtree_pruning_enabled	TRUE	TRUE
954	_dtree_compressbmp_enabled	TRUE	TRUE
955	_dtree_binning_enabled	TRUE	TRUE
956	_dtree_max_surrogates	1	1
957	_dtree_bintest_id	0	0
958	_right_outer_hash_enable	TRUE	TRUE
959	_optimizer_mjc_enabled	TRUE	TRUE
960	_optimizer_sortmerge_join_enabled	TRUE	TRUE
961	_cursor_bind_capture_area_size	400	400
962	_cursor_bind_capture_interval	900	900
963	_dump_cursor_heap_sizes	FALSE	FALSE
964	_projection_pushdown	TRUE	TRUE
965	_projection_pushdown_debug	0	0
966	_px_compilation_debug	0	0
967	_px_compilation_trace	0	0
968	_fic_outofmem_candidates	FALSE	FALSE
969	_print_refresh_schedule	false	false
970	_optimizer_undo_changes	FALSE	FALSE
971	_optimizer_percent_parallel	101	101
972	_optimizer_search_limit	5	5
973	_mv_refresh_costing	rule	rule
974	_mv_refresh_ana	0	0
975	_cache_stats_monitor	FALSE	FALSE
976	_stn_trace	0	0
977	_sta_control	0	0
978	_ds_iocount_iosize	6553664	6553664
979	_mv_refsched_timeincr	300000	300000
980	_spr_push_pred_refspr	TRUE	TRUE
981	_optimizer_block_size	8192	8192
982	_spr_max_rules	10000	10000
983	_idxrb_rowincr	100000000	100000000
984	_hj_bit_filter_threshold	50	50
985	_optimizer_save_stats	TRUE	TRUE
986	_optimizer_cost_filter_pred	FALSE	FALSE
987	_optimizer_correct_sq_selectivity	TRUE	TRUE
988	_allow_commutativity	TRUE	TRUE
989	_mv_refresh_rebuild_percentage	10	10
990	_qa_control	0	0
991	_qa_lrg_type	0	0
992	_mv_refresh_force_parallel_query	0	0
993	_enable_fast_ref_after_mv_tbs	FALSE	FALSE
994	_optim_dict_stats_at_db_cr_upg	TRUE	TRUE
995	_optimizer_dim_subq_join_sel	TRUE	TRUE
996	_optimizer_disable_strans_sanity_checks	0	0
997	_allow_level_without_connect_by	FALSE	FALSE
998	_optimizer_ignore_hints	FALSE	FALSE
999	_optimizer_random_plan	0	0
1000	_optimizer_ceil_cost	TRUE	TRUE
1001	_delay_index_maintain	TRUE	TRUE
1002	_query_rewrite_setopgrw_enable	TRUE	TRUE
1003	_cursor_plan_hash_version	1	1
1004	_disable_function_based_index	FALSE	FALSE
1005	_optimizer_invalidation_period	18000	18000
1006	_px_net_msg_cost	10000	10000
1007	_px_loc_msg_cost	1000	1000
1008	_smm_freeable_retain	5120	5120
1009	_cursor_plan_unparse_enabled	TRUE	TRUE
1010	_kill_java_threads_on_eoc	FALSE	FALSE
1011	_optimizer_join_order_control	3	3
1012	_px_nss_planb	TRUE	TRUE
1013	_bloom_filter_enabled	TRUE	TRUE
1014	_bloom_filter_debug	0	0
1015	_enable_refresh_schedule	TRUE	TRUE
1016	_optimizer_cartesian_enabled	TRUE	TRUE
1017	_optimizer_starplan_enabled	TRUE	TRUE
1018	_optimizer_join_elimination_enabled	TRUE	TRUE
1019	_gby_hash_aggregation_enabled	TRUE	TRUE
1020	_extended_pruning_enabled	TRUE	TRUE
1021	_globalindex_pnum_filter_enabled	TRUE	TRUE
1022	_sql_model_unfold_forloops	RUN_TIME	RUN_TIME
1023	_enable_dml_lock_escalation	TRUE	TRUE
1024	_plsql_cache_enable	TRUE	TRUE
1025	_disable_fast_aggregation	FALSE	FALSE
1026	_disable_adaptive_shrunk_aggregation	FALSE	FALSE
1027	_plsql_minimum_cache_hit_percent	20	20
1028	_plan_outline_data	TRUE	TRUE
1029	_outline_bitmap_tree	TRUE	TRUE
1030	_drop_table_optimization_enabled	TRUE	TRUE
1031	_very_large_partitioned_table	1024	1024
1032	_drop_table_granule	256	256
1033	_xpl_trace	0	0
1034	_dm_max_shared_pool_pct	1	1
1035	_optimizer_multiple_cenv
1036	_kql_subheap_trace	0	0
1037	_optimizer_cost_hjsmj_multimatch	TRUE	TRUE
1038	_optimizer_transitivity_retain	TRUE	TRUE
1039	_px_pwg_enabled	TRUE	TRUE
1040	_sql_hash_debug	0	0
1041	_mv_rolling_inv	FALSE	FALSE
1042	_smm_isort_cap	102400	102400
1043	_optimizer_cbqt_no_size_restriction	TRUE	TRUE
1044	_windowfunc_optimization_settings	0	0
1045	_truncate_optimization_enabled	TRUE	TRUE
1046	_optimizer_enhanced_filter_push	TRUE	TRUE
1047	_compilation_call_heap_extent_size	16384	16384
1048	_xpl_peeked_binds_log_size	8192	8192
1049	_rowsrc_trace_level	0	0
1050	_optimizer_rownum_pred_based_fkr	TRUE	TRUE
1051	_optimizer_better_inlist_costing	ALL	ALL
1052	_optimizer_self_induced_cache_cost	FALSE	FALSE
1053	_optimizer_min_cache_blocks	10	10
1054	_enable_exchange_validation_using_check	TRUE	TRUE
1055	_optimizer_or_expansion	DEPTH	DEPTH
1056	_optimizer_outer_to_anti_enabled	TRUE	TRUE
1057	_optimizer_order_by_elimination_enabled	TRUE	TRUE
1058	_optimizer_star_tran_in_with_clause	TRUE	TRUE
1059	_selfjoin_mv_duplicates	TRUE	TRUE
1060	_dimension_skip_null	TRUE	TRUE
1061	_force_rewrite_enable	FALSE	FALSE
1062	_optimizer_complex_pred_selectivity	TRUE	TRUE
1063	_build_deferred_mv_skipping_mvlog_update	FALSE	FALSE
1064	_row_shipping_threshold	80	80
1065	_row_shipping_explain	FALSE	FALSE
1066	_optimizer_skip_scan_guess	FALSE	FALSE
1067	_enable_row_shipping	FALSE	FALSE
1068	_optimizer_rownum_bind_default	10	10
1069	_first_k_rows_dynamic_proration	TRUE	TRUE
1070	_kks_free_cursor_stat_pct	10	10
1071	_cvw_enable_weak_checking	TRUE	TRUE
1072	_optimizer_native_full_outer_join	off	off
1073	_optimizer_star_trans_min_cost	0	0
1074	_optimizer_star_trans_min_ratio	0	0
1075	_optimizer_fkr_index_cost_bias	10	10
1076	_optimizer_use_subheap	TRUE	TRUE
1077	_optimizer_or_expansion_subheap	TRUE	TRUE
1078	_optimizer_sortmerge_join_inequality	TRUE	TRUE
1079	_optimizer_use_histograms	TRUE	TRUE
1080	_optimizer_enable_density_improvements	FALSE	FALSE
1081	_insert_ctas_dependency	FALSE	FALSE
1082	_tsm_connect_string
1083	_tsm_disable_auto_cleanup	1	1
1084	_enable_nativenet_tcpip	FALSE	FALSE
1085	_aq_tm_scanlimit	0	0
1086	_bufq_stop_flow_control	FALSE	FALSE
1087	_capture_publisher_flow_control_threshold	0	0
1088	_buffered_publisher_flow_control_threshold	0	0
1089	_bufq_flow_control_thrsh	0	0
1090	_bufq_max_msg_sz	0	0
1091	_olapi_history_retention	FALSE	FALSE
1092	_olapi_session_history	300	300
1093	_olapi_session_history_retention	FALSE	FALSE
1094	_olapi_iface_object_history	1000	1000
1095	_olapi_iface_object_history_retention	FALSE	FALSE
1096	_olapi_interface_operation_history	1000	1000
1097	_olapi_iface_operation_history_retention	FALSE	FALSE
1098	_olapi_memory_operation_history	1000	1000
1099	_olapi_memory_operation_history_retention	FALSE	FALSE
1100	_olapi_memory_operation_history_pause_at_seqno	0	0
1101	_olap_continuous_trace_file	FALSE	FALSE
1102	_olap_table_function_statistics	FALSE	FALSE
1103	_olap_parallel_update_threshold	1000	1000
1104	_olap_parallel_update_small_threshold	1000	1000
1105	_olap_parallel_update_small_group	400	400
1106	_olap_aggregate_buffer_size	1048576	1048576
1107	_olap_aggregate_min_buffer_size	1024	1024
1108	_olap_aggregate_work_per_thread	1024	1024
1109	_olap_aggregate_min_thread_status	64	64
1110	_olap_aggregate_statlen_thresh	1024	1024
1111	_olap_aggregate_worklist_max	5000	5000
1112	_olap_aggregate_max_thread_tuples	5000	5000
1113	_olap_aggregate_store_probability	100	100
1114	_olap_aggregate_function_merge_threshold	529	529
1115	_olap_aggregate_function_cache_enabled	TRUE	TRUE
1116	_olap_aggregate_multipath_hier	FALSE	FALSE
1117	_olap_aggregate_flags	0	0
1118	_olap_allocate_errorlog_header	Dim Source Basis %-8d %-8s %-8b Description -------- -------- -------- -----------	Dim Source Basis %-8d %-8s %-8b Description -------- -------- -------- -----------
1119	_olap_allocate_errorlog_format	%8p %8y %8z %e (%n)	%8p %8y %8z %e (%n)
1120	_olap_poutlog_echo_to_eventlog	FALSE	FALSE
1121	_olap_dbgoutfile_echo_to_eventlog	FALSE	FALSE
1122	_olap_eif_export_lob_size	2147483647	2147483647
1123	_olap_sort_buffer_size	262144	262144
1124	_olap_sesscache_enabled	TRUE	TRUE
1125	_olap_object_hash_class	2	2
1126	_olap_dimension_corehash_max	10000	10000
1127	_olap_dimension_corehash_class	1	1
1128	_olap_page_pool_low	262144	262144
1129	_olap_page_pool_hi	50	50
1130	_olap_page_pool_expand_rate	20	20
1131	_olap_page_pool_shrink_rate	50	50
1132	_olap_page_pool_hit_target	100	100
1133	_olap_page_pool_pressure	90	90
1134	_olap_statbool_threshold	8100	8100
1135	_olap_statbool_corebits	20000000	20000000
1136	_olap_lmgen_dim_size	100	100
1137	_olap_lmgen_meas_size	1000	1000
1138	_olap_wrap_errors	FALSE	FALSE
1139	_xsolapi_fetch_type	PARTIAL	PARTIAL
1140	_xsolapi_dimension_group_creation	OVERFETCH	OVERFETCH
1141	_xsolapi_sql_auto_measure_hints	TRUE	TRUE
1142	_xsolapi_sql_auto_dimension_hints	FALSE	FALSE
1143	_xsolapi_sql_hints
1144	_xsolapi_sql_measure_hints
1145	_xsolapi_sql_dimension_hints
1146	_xsolapi_sql_top_measure_hints
1147	_xsolapi_sql_top_dimension_hints
1148	_xsolapi_sql_all_non_base_hints
1149	_xsolapi_sql_all_multi_join_non_base_hints
1150	_xsolapi_densify_cubes	TABULAR	TABULAR
1151	_xsolapi_sql_optimize	TRUE	TRUE
1152	_xsolapi_sql_remove_columns	TRUE	TRUE
1153	_xsolapi_sql_symmetric_predicate	TRUE	TRUE
1154	_xsolapi_sql_use_bind_variables	TRUE	TRUE
1155	_xsolapi_sql_prepare_stmt_cache_size	16	16
1156	_xsolapi_sql_result_set_cache_size	32	32
1157	_xsolapi_sql_minus_threshold	1000	1000
1158	_xsolapi_debug_output
1159	_xsolapi_materialize_sources	TRUE	TRUE
1160	_xsolapi_load_at_process_start	NEVER	NEVER
1161	_xsolapi_auto_materialization_type	PRED_AND_RC	PRED_AND_RC
1162	_xsolapi_auto_materialization_bound	20	20
1163	_xsolapi_materialization_rowcache_min_rows_for_use	1	1
1164	_xsolapi_source_trace	FALSE	FALSE
1165	_xsolapi_metadata_reader_mode	ALL	ALL
1166	_xsolapi_odbo_mode	FALSE	FALSE
1167	_xsolapi_set_nls	TRUE	TRUE
1168	_xsolapi_stringify_order_levels	FALSE	FALSE
1169	_xsolapi_suppression_chunk_size	4000	4000
1170	_xsolapi_suppression_aw_mask_threshold	1000	1000
1171	_xsolapi_share_executors	TRUE	TRUE
1172	_xsolapi_hierarchy_value_type	unique	unique
1173	_xsolapi_use_models	TRUE	TRUE
1174	_xsolapi_use_olap_dml	TRUE	TRUE
1175	_xsolapi_use_olap_dml_for_rank	FALSE	FALSE
1176	_xsolapi_remove_columns_for_materialization	TRUE	TRUE
1177	_xsolapi_precompute_subquery	TRUE	TRUE
1178	_xsolapi_optimize_suppression	TRUE	TRUE
1179	_xsolapi_generate_with_clause	FALSE	FALSE
1180	_xsolapi_sql_enable_aw_join	TRUE	TRUE
1181	_xsolapi_sql_enable_aw_qdr_merge	TRUE	TRUE
1182	_asm_disk_repair_time	14400	14400
1183	_kffmap_hash_size	1024	1024
1184	_kffmop_hash_size	2048	2048
1185	_asm_ausize	1048576	1048576
1186	_asm_blksize	4096	4096
1187	_asm_acd_chunks	1	1
1188	_asm_libraries	ufs	ufs
1189	_asm_maxio	1048576	1048576
1190	_asm_allow_only_raw_disks	TRUE	TRUE
1191	_asmlib_test	0	0
1192	_asm_allow_resilver_corruption	FALSE	FALSE
1193	_asmsid	asm	asm
1194	_asm_wait_time	18	18
1195	_asm_skip_resize_check	FALSE	FALSE
1196	_asm_stripewidth	8	8
1197	_asm_stripesize	131072	131072
1198	_asm_droptimeout	60	60
1199	_asm_emulmax	10000	10000
1200	_asm_emultimeout	0	0
1201	_asm_kfdpevent	0	0
1202	_alert_expiration	604800	604800
1203	_alert_message_cleanup	1	1
1204	_alert_message_purge	1	1
1205	_alert_post_background	1	1
1206	_swrf_test_action	0	0
1207	_sysaux_test_param	1	1
1208	_swrf_mmon_flush	TRUE	TRUE
1209	_awr_corrupt_mode	FALSE	FALSE
1210	_awr_restrict_mode	FALSE	FALSE
1211	_swrf_mmon_metrics	TRUE	TRUE
1212	_swrf_metric_frequent_mode	FALSE	FALSE
1213	_awr_flush_threshold_metrics	FALSE	FALSE
1214	_awr_flush_workload_metrics	FALSE	FALSE
1215	_awr_disabled_flush_tables
1216	_swrf_on_disk_enabled	TRUE	TRUE
1217	_swrf_mmon_dbfus	TRUE	TRUE
1218	_awr_mmon_cpuusage	TRUE	TRUE
1219	_swrf_test_dbfus	FALSE	FALSE
1220	_mwin_schedule	TRUE	TRUE
1221	_awr_sql_child_limit	200	200
1222	_sqltune_category_parsed	DEFAULT	DEFAULT
1223	_ash_sampling_interval	1000	1000
1224	_ash_size	1048618	1048618
1225	_ash_enable	TRUE	TRUE
1226	_ash_disk_write_enable	TRUE	TRUE
1227	_ash_disk_filter_ratio	10	10
1228	_ash_eflush_trigger	66	66
1229	_ash_sample_all	FALSE	FALSE
1230	_ash_dummy_test_param	0	0
1231	_threshold_alerts_enable	1	1
1232	_addm_auto_enable	TRUE	TRUE
1233	_addm_version_check	TRUE	TRUE
1234	_addm_skiprules
1235	_wcr_control	0	0
1236	_capture_buffer_size	65536	65536

暴汗呀,这样多.参数略解都能写几篇了.

How To Query And Change The Oracle Hidden Parameters In Oracle 10g [ID 315631.1]

		Modified 11-OCT-2011 Type HOWTO Status PUBLISHED

In this Document
  Goal
  Solution
  References

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later [Release: 10.1 and later ]
Information in this document applies to any platform.
Reviewed for relevancy on 7-November-2007

Goal

Q1: How to query this hidden initialization parameters in sql ?

Q2: How to change these hidden parameters?

Solution

A1: The hidden parameters start with an "_".They can not be viewed from the output of 'show parameter'
or querying v$parameter unless and until they are set explicitly in init.ora.
However if you want to view all the hidden parameters and their default values the following query
could be of help. Connected as SYSDBA, execute:

SELECT a.ksppinm "Parameter",
       b.ksppstvl "Session Value",
       c.ksppstvl "Instance Value"
FROM   x$ksppi a,
       x$ksppcv b,
       x$ksppsv c
WHERE a.indx = b.indx
AND    a.indx = c.indx
AND    a.ksppinm LIKE '/_%' escape '/'
/

This will list all the hidden parameters with their default values.

A2: Now you can change the desired parameter by setting it explicitly in init.ora or using the alter..session set command for session level.

During startup, the database takes the parameters from spfile by default.
So you have four options to change the parameters:

While starting up the database startup with pfile, e.g.
SQL> startup pfile
Create the spfile from pfile using command "create spfile from pfile" and replace the old spfile with the new one.
For more information see: Note 249664.1 - Pfile vs SPfile
Use
SQL> alter system set "<_parameter-of-choice>" scope=spfile and bounce the database.
Use
SQL> alter..session set command for session level

NOTE:
It is never recommended to modify these hidden parameters without the assistance of Oracle Support.
Changing these parameters may lead to high performance degradation and other problems in the database.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11780477/viewspace-708978/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11780477/viewspace-708978/

cnk45946

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
How To Query And Change The Oracle Hidden Parameters In Oracle 10g

个人总结环境 OSrhel5.4 x86 64DBCOL PRODUCT FORMAT A55COL VERSION FORMAT A15COL STATUS FORMAT A15 SE...
复制链接

扫一扫