Oracle 隐含参数

0    49    1

👉 本文共约141641个字,系统预计阅读时间或需533分钟。

简介

Oracle系统中还有一类参数称之为隐含参数(Hidden Parameters),在系统中使用,但Oracle官方没有公布的参数,这些参数可能是那些还没有成熟或者是系统开发中使用的参数。这些参数在所有Oracle官方提供的文档中都没有介绍,它们的命名有一个共同特征就是都以“_”作为参数的首字符。下面的查询可以得到当前系统中的所有隐藏参数,需要以SYS用户登陆,查看两个视图:X$KSPPI和X$KSPPCV。下面作者给出具体的SQL语句。

举个例子,如果需要查询隐含参数“_LM_DD_INTERVAL”的值,那么执行上面的代码后输入“_LM_DD_INTERVAL”就可以看到该隐含参数的值了,如下所示:

可以看到该隐含参数的值为10。
对于隐含参数而言,修改隐含参数的值的时候需要将隐含参数用双引号括起来。若要清除SPFILE中的隐含参数可以使用RESET命令。

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

普通用户是不具备查询隐含参数的权限的,可以通过创建视图和同义词的方式来解决这个问题,如下所示:



所有隐含参数

INDXNAMEKSPPDESCKSPPSTVL
0_appqos_qtSystem Queue time retrieval interval10
1_ior_serialize_faultinject fault in the ior serialize code0
2_shutdown_completion_timeout_minsminutes for shutdown operation to wait for sessions to complete60
3_inject_startup_faultinject fault in the startup code0
4_latch_recovery_alignmentalign latch recovery structures65534
5_spin_countAmount to spin waiting for a latch2000
6_latch_miss_stat_sidSid of process for which to collect latch stats0
7_max_sleep_holding_latchmax time to sleep while holding a latch4
8_max_exponential_sleepmax sleep during exponential backoff0
9_other_wait_thresholdthreshold wait percentage for event wait class Other0
10_other_wait_event_exclusionexclude event names from _other_wait_threshold calculations
11_use_vector_postuse vector postTRUE
12_latch_class_0latch class 0
13_latch_class_1latch class 1
14_latch_class_2latch class 2
15_latch_class_3latch class 3
16_latch_class_4latch class 4
17_latch_class_5latch class 5
18_latch_class_6latch class 6
19_latch_class_7latch class 7
20_latch_classeslatch classes override
21_ultrafast_latch_statisticsmaintain fast-path statistics for ultrafast latchesTRUE
22_enable_reliable_latch_waitsEnable reliable latch waitsTRUE
23_wait_breakup_time_csecsWait breakup time (in centiseconds)300
24_wait_breakup_threshold_csecsWait breakup threshold (in centiseconds)600
25_disable_wait_stateDisable wait state
26_wait_tracker_num_intervalsWait Tracker number of intervals0
27_wait_tracker_interval_secsWait Tracker number of seconds per interval10
28_wait_samples_max_time_secsWait Samples maximum time in seconds120
29_wait_samples_max_sectionsWait Samples maximum sections40
30_wait_yield_modeWait Yield - Modeyield
31_wait_yield_hp_modeWait Yield - High Priority Modeyield
32_wait_yield_sleep_time_msecsWait Yield - Sleep Time (in milliseconds)1
33_wait_yield_sleep_freqWait Yield - Sleep Frequency100
34_wait_yield_yield_freqWait Yield - Yield Frequency20
35_post_wait_queues_num_per_classPost Wait Queues - Num Per Class
36_post_wait_queues_dynamic_queuesPost Wait Queues - Num Dynamic Queues40
37lock_name_spacelock name space used for generating lock names for standby/clone database
38processesuser processes500
39sessionsuser and system sessions772
40timed_statisticsmaintain internal timing statisticsTRUE
41timed_os_statisticsinternal os statistic gathering interval in seconds0
42resource_limitmaster switch for resource limitFALSE
43license_max_sessionsmaximum number of non-system user sessions allowed0
44license_sessions_warningwarning level for number of non-system user sessions0
45_session_idle_bit_latchesone latch per session or a latch per group of sessions0
46_ksu_diag_kill_timenumber of seconds ksuitm waits before killing diag5
47_ksuitm_dont_kill_dumperdelay inst. termination to allow processes to dumpFALSE
48_cleanup_timeouttimeout value for PMON cleanup150
49_cleanup_timeout_flagsflags for PMON cleanup timeout2
50_disable_image_checkDisable Oracle executable image checkingFALSE
51_num_longop_child_latchesnumber of child latches for long op array2
52_longops_enabledlongops stats enabledTRUE
53_test_ksusigskiptest the function ksusigskip5
54_module_action_old_lengthUse module and action old length parameterTRUE
55_disable_kcbhxor_osddisable kcbh(c)xor OSD functionalityFALSE
56_disable_kgghshcrc32_osddisable kgghshcrc32chk OSD functionalityFALSE
57_disable_system_statedisable system state dump4294967294
58_disable_system_state_wait_samplesDisable system state dump - wait samplesFALSE
59_session_wait_historyenable session wait history collection10
60_pkt_enableenable progressive kill testFALSE
61_pkt_startstart progressive kill test instrumentionFALSE
62_pkt_pmon_intervalPMON process clean-up interval (cs)50
63_collapse_wait_historycollapse wait historyFALSE
64_short_stack_timeout_msshort stack timeout in ms30000
65_sga_early_tracesga early trace event0
66_kill_session_dumpProcess dump on kill session immediateTRUE
67_logout_storm_ratenumber of processes that can logout in a second0
68_logout_storm_timeouttimeout in centi-seconds for time to wait between retries5
69_logout_storm_retrycntmaximum retry count for logouts600
70_ksuitm_addon_trccmdcommand to execute when dead processes don't go away
71_timeout_actions_enabledenables or disables KSU timeout actionsTRUE
72_idle_session_kill_enabledenables or disables resource manager session idle limit checksTRUE
73_session_allocation_latchesone latch per group of sessions2
74_disable_highres_ticksdisable high-res tick counterFALSE
75_timer_precisionVKTM timer precision in milli-sec10
76_dbrm_quantumDBRM quantum
77_highres_drift_allowed_secallowed highres timer drift for VKTM1
78_lowres_drift_allowed_secallowed lowres timer drift for VKTM5
79_vktm_assert_threshsoft assert threshold VKTM timer drift30
80_iorm_toutIORM scheduler timeout value in msec1000
81__oracle_baseORACLE_BASE/u01/app/oracle
82_single_processrun without detached processesFALSE
83_disable_cpu_checkdisable cpu_count checkFALSE
84_available_core_countnumber of cores for this instance0
85cpu_countnumber of CPUs for this instance2
86_dbg_proc_startupdebug process startupFALSE
87_static_backgroundsstatic backgrounds
88_enqueue_deadlock_time_secrequests with timeout <= this will not have deadlock detection5
89_number_cached_attributesmaximum number of cached attributes per instance10
90instance_groupslist of instance group names
91_number_cached_group_membershipsmaximum number of cached group memberships32
92_kss_quietif TRUE access violations during kss dumps are not recordedFALSE
93_kss_callstack_typestate object callstack trace type
94eventdebug event control - default null string
95_oradebug_forceforce target processes to execute oradebug commands?FALSE
96_ksdxdocmd_default_timeout_msdefault timeout for internal oradebug commands30000
97_ksdxdocmd_enabledif TRUE ksdxdocmd* invocations are enabledTRUE
98_ksdx_charset_ratioratio between the system and oradebug character set0
99_oradebug_cmds_at_startuporadebug commands to execute at instance startup
100_watchpoint_onis the watchpointing feature turned on?FALSE
101_ksdxw_num_sgwnumber of watchpoints to be shared by all processes10
102_ksdxw_num_pgwnumber of watchpoints on a per-process basis10
103_ksdxw_stack_depthnumber of PCs to collect in the stack when watchpoint is hit4
104_ksdxw_cini_flgksdxw context initialization flag0
105_ksdxw_nbufsksdxw number of buffers in buffered mode1000
106sga_max_sizemax total SGA size1275068416
107_enable_shared_pool_durationstemporary to disable/enable kgh policyTRUE
108_NUMA_pool_sizeaggregate size in bytes of NUMA poolNot specified
109_enable_NUMA_optimizationEnable NUMA specific optimizationsFALSE
110_enable_NUMA_supportEnable NUMA support and optimizationsFALSE
111_enable_NUMA_interleaveEnable NUMA interleave modeTRUE
112_enable_LGPG_debugEnable LGPG debug modeFALSE
113use_large_pagesUse large pages if available (TRUE/FALSE/ONLY)TRUE
114_max_largepage_alloc_time_secsMaximum number of seconds to spend on largepage allocation10
115pre_page_sgapre-page sga for processFALSE
116shared_memory_addressSGA starting address (low order 32-bits on 64-bit platforms)0
117hi_shared_memory_addressSGA starting address (high order 32-bits on 64-bit platforms)0
118use_indirect_data_buffersEnable indirect data buffers (very large SGA on 32-bit platforms)FALSE
119_use_ismEnable Shared Page Tables - ISMTRUE
120lock_sgaLock entire SGA in physical memoryFALSE
121_lock_sga_areasLock specified areas of the SGA in physical memory0
122_NUMA_instance_mappingSet of nodes that this instance should run onNot specified
123_simulator_upper_bound_multipleupper bound multiple of pool size2
124_simulator_pin_inval_maxcntmaximum count of invalid chunks on pin list16
125_simulator_lru_rebalance_threshLRU list rebalance threshold (count)10240
126_simulator_lru_rebalance_sizthrLRU list rebalance threshold (size)5
127_simulator_bucket_mindeltaLRU bucket minimum delta8192
128_simulator_lru_scan_countLRU scan count8
129_simulator_internal_boundsimulator internal bound percent10
130_simulator_reserved_obj_countsimulator reserved object count1024
131_simulator_reserved_heap_countsimulator reserved heap count4096
132_simulator_sampling_factorsampling factor for the simulator2
133_realfree_heap_max_sizeminimum max total heap size, in Kbytes32768
134_realfree_heap_pagesize_hinthint for real-free page size in bytes65536
135_realfree_heap_modemode flags for real-free heap0
136_use_realfree_heapuse real-free based allocator for PGA memoryTRUE
137_pga_large_extent_sizePGA large extent size1048576
138_uga_cga_large_extent_sizeUGA/CGA large extent size262144
139_total_large_extent_memoryTotal memory for allocating large extents0
140_use_ism_for_pgaUse ISM for allocating large extentsTRUE
141_private_memory_addressStart address of large extent memory segment
142_mem_annotation_sh_levshared memory annotation collection level0
143_mem_annotation_pr_levprivate memory annotation collection level0
144_mem_annotation_scalememory annotation pre-allocation scaling1
145_mem_annotation_storememory annotation in-memory storeFALSE
146_4031_dump_bitvecbitvec to specify dumps prior to 4031 error67194879
147_4031_max_dumpsMaximum number of 4031 dumps for this process100
148_4031_dump_intervalDump 4031 error once for each n-second interval300
149_4031_sga_dump_intervalDump 4031 SGA heapdump error once for each n-second interval3600
150_4031_sga_max_dumpsMaximum number of SGA heapdumps10
151_4030_dump_bitvecbitvec to specify dumps prior to 4030 error4095
152_numa_trace_levelnuma trace event0
153_mem_std_extent_sizestandard extent size for fixed-size-extent heaps4096
154_kgsb_threshold_sizethreshold size for base allocator16777216
155_endprot_chunk_commentchunk comment for selective overrun protectionchk 10235 dflt
156_endprot_heap_commentheap comment for selective overrun protectionhp 10235 dflt
157_endprot_subheapsselective overrun protection for subeheapsTRUE
158_sga_lockingsga granule locking statenone
159_ksm_pre_sga_init_notif_delay_secsseconds to delay instance startup at sga initialization (pre)0
160_ksm_post_sga_init_notif_delay_secsseconds to delay instance startup at sga initialization (post)0
161processor_group_nameName of the processor group that this instance should run in.
162__shared_pool_sizeActual size in bytes of shared pool503316480
163shared_pool_sizesize in bytes of shared pool285212672
164__large_pool_sizeActual size in bytes of large pool67108864
165large_pool_sizesize in bytes of large pool67108864
166__java_pool_sizeActual size in bytes of java pool67108864
167java_pool_sizesize in bytes of java pool67108864
168__streams_pool_sizeActual size in bytes of streams pool67108864
169streams_pool_sizesize in bytes of the streams pool67108864
170_large_pool_min_allocminimum allocation size in bytes for the large allocation pool65536
171shared_pool_reserved_sizesize in bytes of reserved area of shared pool25165824
172_shared_pool_reserved_pctpercentage memory of the shared pool allocated for the reserved area5
173_shared_pool_reserved_min_allocminimum allocation size in bytes for reserved area of shared pool4400
174java_soft_sessionspace_limitwarning limit on size in bytes of a Java sessionspace0
175java_max_sessionspace_sizemax allowed size in bytes of a Java sessionspace0
176_kghdsidx_countmax kghdsidx count2
177_test_param_1test parmeter 1 - integer25
178_test_param_2test parameter 2 - string
179_test_param_3test parameter 3 - string
180_test_param_4test parameter 4 - string list
181_test_param_5test parmeter 5 - deprecated integer25
182_test_param_6test parmeter 6 - size (ub8)0
183spfileserver parameter file/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorclasm.ora
184instance_typetype of instance to be executedRDBMS
185_disable_instance_params_checkdisable instance type check for kspFALSE
186_parameter_table_block_sizeparameter table block size2048
187_high_priority_processesHigh Priority Process Name MaskLMS*|VKTM
188_os_sched_high_priorityOS high priority level1
189_ksb_restart_clean_timeprocess uptime for restarts30000
190_ksb_restart_policy_timesprocess restart policy times in seconds0, 60, 120, 240
191_ksd_test_paramKSD test parmeter999
192_kse_die_timeoutamount of time a dying process is spared by PMON (in centi-secs)60000
193_stack_guard_levelstack guard level0
194_kse_pc_table_sizekse pc table cache size256
195_kse_signature_entriesnumber of entries in the kse stack signature cache0
196_kse_signature_limitnumber of stack frames to cache per kse signature7
197_kse_snap_ring_sizering buffer to debug internal error 170900
198_kse_snap_ring_record_stackshould error snap ring entries show a short stack traceFALSE
199_kse_trace_int_msg_clearenables soft assert of KGECLEAERERROR is cleares an interrupt messageFALSE
200_system_api_interception_debugenable debug tracing for system api interceptionFALSE
201_messagesmessage queue resources - dependent on # processes & # buffers1000
202_enqueue_lockslocks for managed enqueues9100
203_enqueue_resourcesresources for enqueues3616
204_enqueue_hashenqueue hash table length1579
205_enqueue_debug_multi_instancedebug enqueue multi instanceFALSE
206_enqueue_hash_chain_latchesenqueue hash chain latches2
207_enqueue_deadlock_scan_secsdeadlock scan interval0
208_enqueue_paranoia_mode_enabledenable enqueue layer advanced debugging checksFALSE
209_ksi_traceKSI trace string of lock type(s)
210_ksi_trace_bucketmemory tracing: use ksi-private or rdbms-shared bucketPRIVATE
211_ksi_trace_bucket_sizesize of the KSI trace bucket8192
212_ksi_clientlocks_enabledif TRUE, DLM-clients can provide the lock memoryTRUE
213_trace_processesenable KST tracing in processALL
214_trace_eventstrace events enabled at startup
215_trace_bufferstrace buffer sizes per processALL:256
216_trace_dump_static_onlyif TRUE filter trace dumps to always loaded dllsFALSE
217_trace_dump_all_procsif TRUE on error buckets of all processes will be dumped to the current trace fileFALSE
218_trace_dump_cur_proc_onlyif TRUE on error just dump our process bucketFALSE
219_trace_dump_client_bucketsif TRUE dump client (ie. non-kst) bucketsTRUE
220_cdmp_diagnostic_levelcdmp directory diagnostic level2
221nls_languageNLS language nameAMERICAN
222nls_territoryNLS territory nameAMERICA
223nls_sortNLS linguistic definition nameBINARY
224nls_date_languageNLS date language nameAMERICAN
225nls_date_formatNLS Oracle date formatYYYY-MM-DD HH24:MI:SS
226nls_currencyNLS local currency symbol$
227nls_numeric_charactersNLS numeric characters.,
228nls_iso_currencyNLS ISO currency territory nameAMERICA
229nls_calendarNLS calendar system nameGREGORIAN
230nls_time_formattime formatHH.MI.SSXFF AM
231nls_timestamp_formattime stamp formatDD-MON-RR HH.MI.SSXFF AM
232nls_time_tz_formattime with timezone formatHH.MI.SSXFF AM TZR
233nls_timestamp_tz_formattimestamp with timezone formatDD-MON-RR HH.MI.SSXFF AM TZR
234nls_dual_currencyDual currency symbol$
235nls_compNLS comparisonBINARY
236nls_length_semanticscreate columns using byte or char semantics by defaultBYTE
237nls_nchar_conv_excpNLS raise an exception instead of allowing implicit conversionFALSE
238_nchar_imp_cnvNLS allow Implicit Conversion between CHAR and NCHARTRUE
239_nls_parameter_sync_enabledenables or disables updates to v$parameter whenever an alter session statement modifies various nls parametersTRUE
240_disable_file_locksdisable file locks for control, data, redo log filesFALSE
241_ksfd_verify_writeverify asynchronous writes issued through ksfdFALSE
242_disable_odmdisable odm featureFALSE
243fileio_network_adaptersNetwork Adapters for File I/O
244_enable_list_ioEnable List I/OFALSE
245filesystemio_optionsIO operations on filesystem filesnone
246_omfenable/disable OMFenabled
247_aiowait_timeoutsNumber of aiowait timeouts before error is reported100
248_io_shared_pool_sizeSize of I/O buffer pool from SGA4194304
249_max_io_sizeMaximum I/O size in bytes for sequential file accesses1048576
250_io_statisticsif TRUE, ksfd I/O statistics are collectedTRUE
251_disk_sector_size_overrideif TRUE, OSD sector size could be overriddenFALSE
252_simulate_disk_sectorsizeEnables skgfr to report simulated disk sector size0
253_enable_asyncvioenable asynch vectored I/OFALSE
254_iocalibrate_max_iosiocalibrate max I/Os per process0
255_iocalibrate_init_iosiocalibrate init I/Os per process2
256clonedbclone databaseFALSE
257_db_file_direct_io_countSequential I/O buf size1048576
258_cell_fast_file_createAllow optimized file creation path for CellsTRUE
259_cell_fast_file_restoreAllow optimized rman restore for CellsTRUE
260_file_size_increase_incrementAmount of file size increase increment, in bytes67108864
261_ioslave_issue_countIOs issued before completion check500
262_ioslave_batch_countPer attempt IOs picked1
263disk_asynch_ioUse asynch I/O for random access devicesTRUE
264tape_asynch_ioUse asynch I/O requests for tape devicesTRUE
265_io_slaves_disabledDo not use I/O slavesFALSE
266dbwr_io_slavesDBWR I/O slaves0
267_lgwr_io_slavesLGWR I/O slaves0
268_arch_io_slavesARCH I/O slaves0
269_backup_disk_io_slavesBACKUP Disk I/O slaves0
270backup_tape_io_slavesBACKUP Tape I/O slavesFALSE
271_fg_iorm_slavesForeGround I/O slaves for IORM1
272_backup_io_pool_sizememory to reserve from the large pool1048576
273_reset_maxcap_historyreset maxcap history time10
274_high_server_thresholdhigh server thresholds0
275_low_server_thresholdlow server thresholds0
276_active_session_idle_limitactive session idle limit5
277_active_session_legacy_behavioractive session legacy behaviorFALSE
278resource_manager_cpu_allocationResource Manager CPU allocation2
279_resource_manager_planresource mgr top plan for internal use
280resource_manager_planresource mgr top plan
281_vkrm_schedule_intervalVKRM scheduling interval10
282_dbrm_dynamic_thresholdDBRM dynamic threshold setting16843752
283_resource_manager_always_offdisable the resource manager alwaysFALSE
284_resource_manager_always_onenable the resource manager alwaysTRUE
285_io_resource_manager_always_onio resource manager always onFALSE
286_max_small_ioIORM:max number of small I/O's to issue0
287_max_large_ioIORM:max number of large I/O's to issue0
288_auto_assign_cg_for_sessionsauto assign CGs for sessionsFALSE
289_rm_numa_simulation_pgsnumber of PGs for numa simulation in resource manager0
290_rm_numa_simulation_cpusnumber of cpus for each pg for numa simulation in resource manager0
291_rm_numa_sched_enableIs Resource Manager (RM) related NUMA scheduled policy enabledFALSE
292_dbrm_runchkResource Manager Diagnostic Running Thread Check0
293_dbrm_short_wait_usResource Manager short wait length300
294_dbrm_num_runnable_listResource Manager number of runnable list per NUMA node0
295_db_check_cell_hintsFALSE
296_pqq_enabledEnable Resource Manager based Parallel Statement QueuingTRUE
297_pqq_debug_txn_actpq queuing transaction activeFALSE
298_ksr_unit_test_processesnumber of ksr unit test processes0
299_ksv_spawn_control_allcontrol all spawning of background slavesFALSE
300_ksv_max_spawn_fail_limitbg slave spawn failure limit5
301_ksv_pool_wait_timeoutbg slave pool wait limit600
302_ksv_pool_hang_kill_tobg slave pool terminate timeout0
303_ksvppktmodeksv internal pkt test0
304_ksv_static_flags1ksv static flags 1 - override default behavior0
305_ksv_dynamic_flags1ksv dynamic flags 1 - override default behavior0
306_first_spare_parameterfirst spare parameter - integer
307_second_spare_parametersecond spare parameter - integer
308_third_spare_parameterthird spare parameter - integer
309_fourth_spare_parameterfourth spare parameter - integer
310_fifth_spare_parameterfifth spare parameter - integer
311_sixth_spare_parametersixth spare parameter - integer
312_seventh_spare_parameterseventh spare parameter - integer
313_eighth_spare_parametereighth spare parameter - integer
314_ninth_spare_parameterninth spare parameter - integer
315_tenth_spare_parametertenth spare parameter - integer
316_eleventh_spare_parametereleventh spare parameter - string
317_twelfth_spare_parametertwelfth spare parameter - string
318_thirteenth_spare_parameterthirteenth spare parameter - string
319_fourteenth_spare_parameterfourteenth spare parameter - string
320_fifteenth_spare_parameterfifteenth spare parameter - string
321_sixteenth_spare_parametersixteenth spare parameter - string list
322_seventeenth_spare_parameterseventeenth spare parameter - string list
323_eighteenth_spare_parametereighteenth spare parameter - string list
324_nineteenth_spare_parameternineteenth spare parameter - string list
325_twentieth_spare_parametertwentieth spare parameter - string list
326_ksxp_ping_enabledisable dynamic loadin of lib skgxpTRUE
327_ksxp_ping_polling_timemax. arrays for ipc statistics0
328_ksxp_disable_dynamic_loadingdisable dynamic loadin of lib skgxpFALSE
329_ksxp_disable_rolling_migrationdisable possibility of starting rolling migrationFALSE
330_skgxp_udp_use_tcbdisable use of high speek timerTRUE
331_ksxp_skgxp_library_pathover-ride default location of lib skgxp
332_ksxp_skgxp_compat_library_pathover-ride default location of lib skgxp compat
333_ksxp_disable_ipc_statsdisable ipc statisticsFALSE
334_ksxp_max_stats_bktsmax. arrays for ipc statistics0
335_ksxp_init_stats_bktsinitial number arrays for ipc statistics0
336_ksxp_stats_mem_lmtlimit ipc statistics memory. this parameter is a percentage value0
337cluster_interconnectsinterconnects for RAC use
338_rm_cluster_interconnectsinterconnects for RAC use (RM)
339_ksxp_disable_clssdisable CLSS interconnects0
340_ksxp_send_timeoutset timeout for sends queued with the inter-instance IPC300
341_ksxp_dump_timeoutset timeout for kjzddmp request20
342_ksxp_diagmodeset to OFF to disable automatic slowsend diagnosticsOFF
343_skgxp_reapingtune skgxp OSD reaping limit1000
344_ksxp_reapingtune ksxp layer reaping limit20
345_ksxp_wait_flagstune ksxpwait0
346_ksxp_control_flagsmodify ksxp behavior0
347_skgxp_udp_hiwat_warnach hiwat mark warning interval1000
348_skgxp_udp_ach_reaping_timetime in minutes before idle ach's are reaped120
349_skgxp_udp_timed_wait_secondstime in seconds before timed wait is invoked5
350_skgxp_udp_timed_wait_bufferingdiagnostic log buffering space (in bytes) for timed wait (0 means unbufferd1024
351_skgxp_udp_keep_alive_ping_timer_secsconnection idle time in seconds before keep alive is initiated. min: 30 sec max: 1800 sec default: 300 sec300
352_disable_duplex_linkTurn off connection duplexingTRUE
353_diag_diagnosticsTurn off diag diagnosticsTRUE
354_disable_interface_checkingdisable interface checking at startupFALSE
355_skgxp_udp_interface_detection_time_secstime in seconds between interface detection checks60
356_skgxp_udp_lmp_onenable UDP long message protectionFALSE
357_skgxp_udp_lmp_mtusizeMTU size for UDP LMP testing0
358_skgxp_udp_enable_dynamic_credit_mgmtEnables dynamic credit management0
359_skgxp_udp_ack_delayEnables delayed acks0
360_skgxp_gen_ant_ping_misscountANT protocol ping miss count3
361_skgxp_gen_rpc_no_path_check_in_secANT ping protocol miss count5
362_skgxp_gen_rpc_timeout_in_secVRPC request timeout when ANT enabled300
363_skgxp_gen_ant_off_rpc_timeout_in_secVRPC request timeout when ANT disabled30
364_skgxp_min_zcpy_lenIPC threshold for zcpy operation (default = 0 - disabled)0
365_skgxp_min_rpc_rcv_zcpy_lenIPC threshold for rpc rcv zcpy operation (default = 0 - disabled)0
366_skgxp_zcpy_flagsIPC zcpy options flags0
367_skgxp_ctx_flags1IPC debug options flags (oss)0
368_skgxp_ctx_flags1maskIPC debug options flags mask (oss)0
369_skgxp_dynamic_protocolIPC protocol override (!0/-1=*,2=UDP,3=RDS,0x1000=ipc_X)0
370_skgxp_inetslimit SKGXP networks
371_skgxp_rgn_portsregion socket limits (0xFFFFNNXX): F=flags, N=min, X=max0
372_ksxp_skgxp_ctx_flags1IPC debug options flags (RAC)0
373_ksxp_skgxp_ctx_flags1maskIPC debug options flags mask (RAC)0
374_ksxp_skgxp_dynamic_protocolIPC protocol override (RAC) (0/-1=*,2=UDP,3=RDS,!0x1000=ipc_X)4096
375_ksxp_skgxp_rgn_portsregion socket limits (0xFFFFNNXX): F=flags, N=min, X=max0
376_ksxp_dynamic_skgxp_paramdynamic skgxp parameters
377_ksxp_if_configksxp if config flags0
378_ksxp_compat_flagsksxp compat flags0
379_skgxp_spare_param1ipc oss spare parameter 1
380_ksxp_skgxp_spare_param1ipc ksxp spare parameter 1
381_skgxp_spare_param2ipc oss spare parameter 2
382_ksxp_skgxp_spare_param2ipc ksxp spare parameter 2
383_skgxp_spare_param3ipc oss spare parameter 3
384_ksxp_skgxp_spare_param3ipc ksxp spare parameter 3
385_skgxp_spare_param4ipc oss spare parameter 4
386_ksxp_skgxp_spare_param4ipc ksxp spare parameter 4
387_skgxp_spare_param5ipc oss spare parameter 5
388_ksxp_skgxp_spare_param5ipc ksxp spare parameter 5
389_skgxpg_last_parameterlast defined skgxpg parameter - oss26
390_ksxp_skgxpg_last_parameterlast defined skgxpg parameter - ksxp26
391_ksxp_testingKSXP test parameter0
392_ksxp_reporting_processreporting process for KSXPLMD0
393_ksxp_unit_test_byte_transformationenable byte transformation unit testFALSE
394_ksxp_lwipc_enabledenable lwipc for KSXPFALSE
395_ksmd_protect_modeKSMD protect mode for catching stale accessoff
396_ksmg_granule_sizegranule size in bytes16777216
397_ksmg_granule_locking_statusgranule locking status1
398_ksmg_lock_check_intervaltimeout action interval in minutes
399_ksmg_lock_reacquire_countrepeat count for acquisition of locks5
400file_mappingenable file mappingFALSE
401_filemap_dirFILEMAP directory
402_object_statisticsenable the object level statistics collectionTRUE
403_object_stats_max_entriesMaximum number of entries to be tracked per stat3072
404_enable_rlbenable RLB metrics processingTRUE
405_enable_midtier_affinityenable midtier affinity metrics processingTRUE
406_midtier_affinity_clusterwait_thresholdcluster wait threshold to enter affinity100
407_midtier_affinity_goodness_thresholdgoodness gradient threshold to dissolve affinity2000
408_service_cleanup_timeouttimeout to peform service cleanup30
409_max_servicesmaximum number of database services150
410_disable_health_checkDisable Health CheckFALSE
411_mpmt_enabledMPMT mode enabledFALSE
412_spawn_diag_thresh_secsthread spawn diagnostic minimal threshold in seconds30
413_spawn_diag_optsthread spawn diagnostic options0
414_sched_delay_sample_interval_msscheduling delay sampling interval in ms1000
415_sched_delay_max_samplesscheduling delay maximum number of samples4
416_sched_delay_sample_collection_thresh_msscheduling delay sample collection duration threshold ms200
417_sched_delay_measurement_sleep_usscheduling delay mesurement sleep us1000
418_sched_delay_os_tick_granularity_usos tick granularity used by scheduling delay calculations16000
419_accept_versionsList of parameters for rolling operation
420_hang_analysis_num_call_stackshang analysis num call stacks3
421_local_hang_analysis_interval_secsthe interval at which local hang analysis is run3
422_deadlock_resolution_levelautomatic deadlock resolution level1
423_deadlock_resolution_incidents_enabledcreate incidents during deadlock resolutionTRUE
424_deadlock_resolution_incidents_alwayscreate incidents when resolving any deadlock?FALSE
425_deadlock_resolution_min_wait_timeout_secsthe minimum wait timeout required for deadlock resolution60
426_deadlock_resolution_signal_process_thresh_secsthe amount of time given to process a deadlock resolution signal60
427_heur_deadlock_resolution_secsthe heuristic wait time per node for deadlock resolution0
428_deadlock_diagnostic_levelautomatic deadlock resolution diagnostics level2
429_blocking_sess_graph_cache_sizeblocking session graph cache size in bytes
430_diag_proc_enabledenable hung process diagnostic APITRUE
431_diag_proc_stack_capture_typehung process diagnostic API stack capture type1
432_diag_proc_max_time_mshung process diagnostic API max wait time in milliseconds30000
433_hang_msg_checksum_enabledenable hang graph message checksumTRUE
434_kspol_tac_timeouttimeouts for TAC registerd by kspol5
435_disable_12751disable policy timeout error (ORA-12751)FALSE
436_diskmon_pipe_nameDiSKMon skgznp pipe name
437_dskm_health_check_cntDiSKMon health check counter20
438_ksmb_debugksmb debug flags0
439_pmon_enable_dead_blkrslook for dead blockers during PMON cleanupTRUE
440_pmon_dead_blkrs_scan_rate_secsrate to scan for dead blockers during cleanup (in seconds)3
441_pmon_dead_blkrs_alive_chk_rate_secsrate to check blockers are alive during cleanup (in seconds)3
442_pmon_dead_blkrs_max_cleanup_attemptsmax attempts per blocker while checking dead blockers5
443_pmon_dead_blkrs_max_blkrsmax blockers to check during cleanup200
444_pmon_max_consec_postsPMON max consecutive posts in main loop5
445_dead_process_scan_intervalPMON dead process scan interval (in seconds)60
446_main_dead_process_scan_intervalPMON main dead process scan interval (in seconds)0
447_use_platform_compression_libEnable platform optimized compression implementationFALSE
448_use_platform_encryption_libEnable platform optimized encryption implementationTRUE
449_use_hybrid_encryption_modeEnable platform optimized encryption in hybrid modeFALSE
450_xengem_diagmodeset to OFF to disable VM GEM support and functionalitiesOFF
451_xengem_devnameoverride default VM GEM device name used by skgvmDEFAULT
452_xengem_enabledEnable OVM GEM supportTRUE
453_diag_daemonstart DIAG daemonTRUE
454_dump_system_state_scopescope of sysstate dump during instance terminationlocal
455_dump_trace_scopescope of trace dump during a process crashglobal
456_dump_interval_limittrace dump time interval limit (in seconds)120
457_dump_max_limitmax number of dump within dump interval5
458_diag_dump_timeouttimeout parameter for SYNC dump30
459_diag_dump_request_debug_levelDIAG dump request debug level (0-2)1
460_diag_crashdump_levelparameter for systemstate dump level, used by DIAG during crash10
461_hang_detection_enabledHang Management detectionTRUE
462_hang_detection_intervalHang Management detection interval in seconds32
463_hang_resolution_scopeHang Management hang resolution scopePROCESS
464_hang_resolution_policyHang Management hang resolution policyHIGH
465_hang_resolution_confidence_promotionHang Management hang resolution confidence promotionFALSE
466_hang_resolution_global_hang_confidence_promotionHang Management hang resolution global hang confidence promotionFALSE
467_hang_resolution_promote_process_terminationHang Management hang resolution promote process terminationFALSE
468_hang_output_suspected_hangsHang Management enabled output of suspected hangsFALSE
469_hang_signature_list_match_output_frequencyHang Signature List matched output frequency10
470_hm_analysis_output_diskif TRUE the hang manager outputs hang analysis results to diskFALSE
471_hm_analysis_oradebug_node_dump_levelthe oradebug node dump level for hang manager hang analysis0
472_hm_analysis_oradebug_sys_dump_levelthe oradebug system state level for hang manager hang analysis0
473_global_hang_analysis_interval_secsthe interval at which global hang analysis is run10
474_hang_verification_intervalHang Management verification interval in seconds46
475_hang_ignored_hangs_intervalTime in seconds ignored hangs must persist after verification300
476_hang_ignored_hang_countHang Management ignored hang count1
477_hang_hiload_promoted_ignored_hang_countHang Management high load or promoted ignored hang count2
478_hang_log_incidentsHang Manager incident loggingFALSE
479_hang_long_wait_time_thresholdLong session wait time threshold in seconds0
480_hang_lws_file_countNumber of trace files for long waiting sessions5
481_hang_lws_file_time_limitTimespan in seconds for current long waiting session trace file3600
482_hang_hiprior_session_attribute_listHang Management high priority session attribute list
483_ipddb_enableEnable IPD/DB data collectionFALSE
484_trace_navigation_scopeenabling trace navigation linkingglobal
485_max_protocol_supportMax occurrence protocols supported in a process10000
486_lm_lmsnumber of background gcs server processes to start0
487gcs_server_processesnumber of background gcs server processes to start0
488_lm_dynamic_lmsdynamic lms invocationFALSE
489_lm_max_lmsmax. number of background global cache server processes0
490_lm_activate_lms_thresholdthreshold value to activate an additional lms100
491_lm_lmd_waittimedefault wait time for lmd in centiseconds8
492_lm_lms_waittimedefault wait time for lms in centiseconds3
493_lm_procsnumber of client processes configured for cluster database320
494_lm_lms_priority_dynamicenable lms priority modificationTRUE
495_lm_lms_rt_thresholdmaximum number of real time lms processes on machine
496_lm_ressnumber of resources configured for cluster database6000
497_lm_locksnumber of enqueues configured for cluster database12000
498_lm_master_weightmaster resource weight for this instance1
499active_instance_countnumber of active instances in the cluster database
500_active_instance_countnumber of active instances in the cluster database
501_active_standby_fast_reconfigurationif TRUE optimize dlm reconfiguration for active/standby OPSTRUE
502_lm_enq_rcfgif TRUE enables enqueue reconfigurationTRUE
503_lm_asm_enq_hashingif TRUE makes ASM use enqueue master hashing for fusion locksTRUE
504_lm_xidsnumber of transaction IDs configured for cluster database352
505_lm_res_partnumber of resource partition configured for gcs128
506_lm_drm_windowdynamic remastering bucket window size0
507_lm_drm_max_requestsdynamic remastering maximum affinity requests processed together100
508_lm_drm_xlatchdynamic remastering forced exclusive latches0
509_lm_drm_disabledisable drm in different level0
510_lm_contiguous_res_countnumber of contiguous blocks that will hash to the same HV bucket128
511_lm_num_pt_bucketsnumber of buckets in the object affinity hash table8192
512_lm_num_pt_latchesnumber of latches in the object affinity hash table128
513_lm_node_join_optcluster database node join optimization in reconfigFALSE
514_lm_no_syncskip reconfiguration/drm syncr/synca messagingTRUE
515_lm_non_fault_tolerantdisable cluster database fault-tolerance modeFALSE
516_lm_cache_res_cleanuppercentage of cached resources should be cleanup25
517_lm_cache_allocated_res_ratioratio of cached over allocated resources50
518_lm_cache_res_skip_cleanupmultiple of iniital res cache below which cleanup is skipped20
519_lm_cache_res_cleanup_triesmax number of batches of cached resources to free per cleanup10
520_lm_cache_res_typecache resource: string of lock types(s)TMHWHVDI
521_lm_cache_lvl0_cleanuphow often to cleanup level 0 cache res (in sec)0
522_lm_cache_res_optionsges resource cache options0
523_ogms_homeGMS home directory
524_lm_sync_timeoutSynchronization timeout for DLM reconfiguration steps163
525_lm_ticket_active_sendbackFlow control ticket active sendback threshold
526_lm_rcfg_timeoutdlm reconfiguration timeout489
527_lm_enq_lock_freelistNumber of ges enqueue element freelist
528_lm_enqueue_freelistNumber of enqueue freelist3
529_lm_dd_intervaldd time interval in seconds10
530_lm_dd_scan_intervaldd scan interval in seconds5
531_lm_dd_search_cntnumber of dd search per token get3
532_lm_dd_max_search_timemax dd search time per token180
533_lm_dd_maxdumpmax number of locks to be dumped during dd validation50
534_lm_dd_ignore_noddif TRUE nodeadlockwait/nodeadlockblock options are ignoredFALSE
535_lm_enqueue_blocker_dump_timeoutenqueue blocker dump timeout120
536_lm_enqueue_blocker_kill_timeoutenqueue blocker kill timeout0
537_dlmtraceTrace string of global enqueue type(s)
538_lm_tx_deltaTX lock localization delta16
539_lm_proc_freeze_timeoutreconfiguration: process freeze timeout70
540_lm_deferred_msg_timeoutdeferred message timeout163
541_lm_use_new_defmsgtmo_actionuse new defered msg queue timeout actionTRUE
542_lm_dump_null_lockdump null lock in state dumpFALSE
543_lm_validate_resource_typeif TRUE enables resource name validationFALSE
544_lm_file_affinitymapping between file id and master instance number
545_lm_file_read_mostlymapping between read-mostly file id and master instance number
546_lm_enable_aff_benefit_statsenables affinity benefit computations if TRUEFALSE
547_lm_share_lock_optif TRUE enables share lock optimizationFALSE
548_lm_res_hash_bucketnumber of resource hash buckets0
549_ges_diagnosticsif TRUE enables GES diagnosticsTRUE
550_fair_remote_cvtif TRUE enables fair remote convertFALSE
551_lm_rcvr_hang_check_frequencyreceiver hang check frequency in seconds20
552_lm_rcvr_hang_allow_timereceiver hang allow time in seconds70
553_lm_rcvr_hang_killto kill receiver hangTRUE
554_lm_rcvr_hang_check_system_loadexamine system load when check receiver healthTRUE
555_lm_rcvr_hang_systemstate_dump_levelsystemstate dump level upon receiver hang0
556_lm_rcvr_hang_cfio_killto kill receiver hang at control file IOFALSE
557_lm_lmon_nowait_latchif TRUE makes lmon get nowait latches with timeout loopTRUE
558_ges_dd_debugif 1 or higher enables GES deadlock detection debug diagnostics1
559_lm_global_postsif TRUE deliver global posts to remote nodesTRUE
560_rcfg_parallel_replayif TRUE enables parallel replay and cleanup at reconfigurationTRUE
561_parallel_replay_msg_limitNumber of messages for each round of parallel replay4000
562_rcfg_parallel_fixwriteif TRUE enables parallel fixwrite at reconfigurationTRUE
563_parallel_fixwrite_bucketNumber of buckets for each round of fix write1000
564_rcfg_parallel_verifyif TRUE enables parallel verify at reconfigurationTRUE
565_rcfg_disable_verifyif TRUE disables verify at reconfigurationTRUE
566_drm_parallel_freezeif TRUE enables parallel drm freezeTRUE
567_dump_rcvr_ipcif TRUE enables IPC dump at instance eviction timeTRUE
568_ges_health_checkif greater than 0 enables GES system health check0
569_kill_enqueue_blockerif greater than 0 enables killing enqueue blocker2
570_lm_psrcfgenable pseudo reconfigurationTRUE
571_lm_single_inst_affinity_lockenable single instance affinity lock optimizationTRUE
572_lm_preregister_css_restypeenqueue type that requires pre-registration to cssCF
573_inquiry_retry_intervalif greater than 0 enables inquiry retry after specified interval3
574_lm_drm_object_scanenable/disable object scan to force full table scan alwaysTRUE
575_lm_spare_threadsnumber of spare threads to be created by the GPnP master0
576_lm_spare_undonumber of spare undo tablespaces to be created by GPnP master0
577_lm_rcvinstdesignated instance to do instance recoveryTRUE
578_lm_use_gcruse GCR module if TRUETRUE
579_lm_use_tx_tsnuse undo tsn affinity master as TX enqueue masterTRUE
580_lm_local_hp_enquse static file affinity for HP enqueue mastershipTRUE
581_lm_broadcast_resEnable broadcast of highest held mode of resource.disable
582_lm_broadcast_resnameTrace string of resource type(s)AD
583_gcs_testingGCS testing parameter0
584_gcs_pkey_historynumber of pkey remastering history4000
585_ges_designated_masterdesignated master for GES and GCS resourcesFALSE
586_lm_lms_spinmake lms not sleepFALSE
587_lm_freeze_kill_timetimeout for killing unfrozen processes in rcfg/drm freeze step30
588_lm_no_lh_checkskip load and health check at decision pointsFALSE
589_lm_lhupd_intervalload and health update interval5
590_lm_high_load_thresholdhigh load threshold parameter5
591_lm_high_load_sysload_percentagehigh watermark system load percentage90
592_lm_low_load_percentagelow watermark percentage for load threshold75
593_lm_drm_hiload_percentagedrm high load threshold percentage200
594_lm_drm_lowload_percentagedrm low load threshold percentage200
595_lm_drm_min_intervalminimum interval in secs between two consecutive drms300
596_lm_drm_batch_timetime in seconds to wait to batch drm requests10
597_lm_enqueue_timeoutenqueue suggested min timeout in seconds360
598_lm_better_ddvictimGES better deadlock victimTRUE
599_lm_msg_batch_sizeGES batch message size0
600_lm_ticketsGES messaging tickets1000
601_lm_msg_cleanup_intervalGES message buffer cleanup interval time3000
602_lm_idle_connection_checkGES idle connection checkTRUE
603_lm_idle_connection_check_intervalGES idle connection check interval time140
604_lm_idle_connection_killGES idle connection killTRUE
605_lm_idle_connection_instance_check_calloutGES idle connection instance check calloutFALSE
606_lm_send_modeGES send modeauto
607_lm_postevent_buffer_sizepostevent buffer size256
608_lm_kill_fg_on_timeoutGES kill fg on IPC timeoutTRUE
609_lm_send_queue_lengthGES send queue maximum length5000
610_lm_send_queue_batchingGES send queue message batchingTRUE
611_lm_process_batchingGES implicit process batching for IPC messagesTRUE
612_lm_sq_batch_factorGES send queue minimum batching factor2
613_lm_sq_batch_typeGES send queue batching mechanismauto
614_lm_sq_batch_waittickGES send queue batching waittime in tick3
615_lm_sendproxy_reserveGES percentage of send proxy reserve of send tickets25
616_lm_checksum_batch_msgGES checksum batch messages0
617_lm_batch_compression_thresholdGES threshold to start compression on batch messages0
618_lm_compression_schemeGES compression schemezlib
619_lm_validate_pbatchGES process batch validationFALSE
620_lm_watchpoint_maximumGES number of watchpoints3
621_lm_watchpoint_timeoutGES maximum time in seconds to keep watchpoint3600
622_lm_free_queue_thresholdGES free queue threshold0
623_abort_recovery_on_joinif TRUE, abort recovery on join reconfigurationsFALSE
624_send_ast_to_foregroundif TRUE, send ast message to foregroundAUTO
625_reliable_block_sendsif TRUE, no side channel on reliable interconnectTRUE
626_blocks_per_cache_servernumber of consecutive blocks per global cache server32
627_object_reuse_bastif 1 or higher, handle object reuse2
628_delta_push_share_blockersenable delta push if greater than the # of share blockers0
629_send_close_with_blockif TRUE, send close with block even with direct sendsTRUE
630_gcs_fast_reconfigif TRUE, enable fast reconfiguration for gcs locksTRUE
631_cr_grant_global_roleif TRUE, grant lock for CR requests when block is in global roleTRUE
632_cr_grant_local_roleturn 3-way CR grants off, make it automatic, or turn it onAUTO
633_cr_grant_onlyif TRUE, grant locks when possible and do not send the blockFALSE
634_skip_assume_msgif TRUE, skip assume message for consigns at the masterTRUE
635_gcs_resourcesnumber of gcs resources to be allocated
636_gcs_latchesnumber of gcs resource hash latches to be allocated per LMS process0
637_gcs_process_in_recoveryif TRUE, process gcs requests during instance recoveryTRUE
638_scatter_gcs_resourcesif TRUE, gcs resources are scattered uniformly across sub poolsFALSE
639_gcs_res_per_bucketnumber of gcs resource per hash bucket4
640_gcs_shadow_locksnumber of pcm shadow locks to be allocated
641_scatter_gcs_shadowsif TRUE, gcs shadows are scattered uniformly across sub poolsFALSE
642_gcs_disable_remote_handlesdisable remote client/shadow handlesFALSE
643_gcs_disable_skip_close_remasteringif TRUE, disable skip close optimization in remasteringFALSE
644_side_channel_batch_sizenumber of messages to batch in a side channel message (DFS)200
645_side_channel_batch_timeouttimeout before shipping out the batched side channelmessages in seconds6
646_side_channel_batch_timeout_mstimeout before shipping out the batched side channelmessages in milliseconds500
647_broadcast_scn_wait_timeoutbroadcast-on-commit scn wait timeout in centiseconds10
648_hb_redo_msg_intervalBOC HB redo message interval in ms100
649_master_direct_sendsdirect sends for messages from master (DFS)31
650_cgs_send_timeoutCGS send timeout value300
651_imr_activeActivate Instance Membership Recovery featureTRUE
652_imr_max_reconfig_delayMaximum Reconfiguration delay (seconds)75
653_imr_splitbrain_res_waitMaximum wait for split-brain resolution (seconds)0
654_imr_disk_voting_intervalMaximum wait for IMR disk voting (seconds)3
655_imr_systemload_checkPerform the system load check during IMRTRUE
656_imr_device_typeType of device to be used by IMRcontrolfile
657_imr_highload_thresholdIMR system highload threshold
658_imr_evicted_member_killIMR issue evicted member kill after a waitTRUE
659_imr_evicted_member_kill_waitIMR evicted member kill wait time in seconds20
660_imr_avoid_double_votingAvoid device voting for CSS reconfig during IMRTRUE
661_imr_diskvote_implementationIMR disk voting implementation methodauto
662_imr_extra_reconfig_waitExtra reconfiguration wait in seconds10
663_imr_controlfile_access_wait_timeIMR controlfile access wait time in seconds10
664_cluster_librarycluster library selectionclss
665_cgs_reconfig_timeoutCGS reconfiguration timeout interval0
666_cgs_node_kill_escalationCGS node kill escalation to CSSTRUE
667_cgs_node_kill_escalation_waitCGS wait time to escalate node kill to CSS in seconds0
668_cgs_zombie_member_kill_waitCGS zombie member kill wait time in seconds20
669_cgs_reconfig_extra_waitCGS reconfiguration extra wait time for CSS in seconds3
670_cgs_health_check_in_reconfigCGS health check during reconfigurationTRUE
671_cgs_ticketsCGS messaging tickets1000
672_cgs_dball_group_registrationCGS DBALL group registration typelocal
673_cgs_dbgroup_poll_timeCGS DB group polling interval in milli-seconds600
674_cgs_allgroup_poll_timeCGS DBALL group polling interval in milli-seconds20000
675_lm_dynamic_loaddynamic load adjustmentTRUE
676_notify_crsnotify cluster ready services of startup and shutdownTRUE
677_kill_diagnostics_timeouttimeout delay in seconds before killing enqueue blocker60
678_ges_diagnostics_asm_dump_levelsystemstate level on global enqueue diagnostics blocked by ASM11
679_ges_num_blockers_to_killnumber of blockers to be killed for hang resolution1
680_lm_hb_callstack_collect_timehb diagnostic call stack collection time in seconds5
681_lm_hb_disable_check_listlist of process names to be disabled in heartbeat checknone
682_hang_statistics_collection_intervalHang Management statistics collection interval in seconds15
683_hang_statistics_collection_ma_alphaHang Management statistics collection moving average alpha30
684_hang_statistics_high_io_percentage_thresholdHang Management statistics high IO percentage threshold45
685_gcr_enable_high_cpu_killif TRUE, GCR may kill foregrounds under high loadFALSE
686_gcr_enable_high_cpu_rmif TRUE, GCR may enable a RM plan under high loadFALSE
687_gcr_enable_high_cpu_rtif TRUE, GCR may boost bg priority under high loadFALSE
688_gcr_high_cpu_thresholdminimum amount of CPU process must consume to be kill target10
689_gcr_use_cssif FALSE, GCR wont register with CSS nor use any CSS featureTRUE
690_lm_rac_spare_p1rac parameter p10
691_lm_rac_spare_p2rac parameter p20
692_lm_rac_spare_p3rac parameter p30
693_lm_rac_spare_p4rac parameter p40
694_lm_rac_spare_p5rac parameter p50
695_lm_rac_spare_p6rac parameter p6
696_lm_rac_spare_p7rac parameter p7
697_lm_rac_spare_p8rac parameter p8
698_lm_rac_spare_p9rac parameter p9
699_lm_rac_spare_p10rac parameter p10
700_lm_rac_spare_dp1rac parameter dp10
701_lm_rac_spare_dp2rac parameter dp20
702_lm_rac_spare_dp3rac parameter dp30
703_lm_rac_spare_dp4rac parameter dp40
704_lm_rac_spare_dp5rac parameter dp50
705_lm_rac_spare_dp6rac parameter dp6
706_lm_rac_spare_dp7rac parameter dp7
707_lm_rac_spare_dp8rac parameter dp8
708_lm_rac_spare_dp9rac parameter dp9
709_lm_rac_spare_dp10rac parameter dp10
710sga_targetTarget size of SGA1073741824
711__sga_targetActual size of SGA1073741824
712memory_targetTarget size of Oracle SGA and PGA memory0
713memory_max_targetMax size for Memory Target0
714_disable_streams_pool_auto_tuningdisable streams pool auto tuningFALSE
715_memory_management_tracingtrace memory management activity0
716_memory_mgmt_immreq_timeouttime in seconds to time out immediate mode request150
717_memory_checkinuse_timeintvcheck inuse time interval30
718_memory_mgmt_fail_immreqalways fail immediate mode requestFALSE
719_memory_sanity_checkpartial granule sanity check0
720_init_granule_intervalnumber of granules to process for deferred cache10
721_shared_pool_max_sizeshared pool maximum size when auto SGA enabled0
722_shared_pool_minsize_onshared pool minimum size when auto SGA enabledFALSE
723_streams_pool_max_sizestreams pool maximum size when auto SGA enabled0
724_simulate_mem_transfersimulate auto memory sga/pga transfersFALSE
725_memory_nocancel_defsgareqdo not cancel deferred sga reqs with auto-memoryFALSE
726_memory_imm_mode_without_autosgaAllow immediate mode without sga/memory targetTRUE
727_memory_broker_stat_intervalmemory broker statistics gathering interval for auto sga30
728_automemory_broker_intervalmemory broker statistics gathering interval for auto memory3
729_memory_broker_shrink_heapsmemory broker allow policy to shrink shared pool15
730_memory_broker_shrink_java_heapsmemory broker allow policy to shrink java pool900
731_memory_broker_shrink_streams_poolmemory broker allow policy to shrink streams pool900
732_memory_broker_shrink_timeoutmemory broker policy to timeout shrink shared/java pool60000000
733_memory_broker_log_stat_entriesmemory broker num stat entries5
734_memory_initial_sga_split_percInitial default sga target percentage with memory target60
735_memory_broker_marginal_utility_spMarginal Utility threshold pct for sp7
736_memory_broker_marginal_utility_bcMarginal Utility threshold pct for bc12
737_disable_latch_free_SCN_writes_via_32casdisable latch-free SCN writes using 32-bit compare & swapFALSE
738_disable_latch_free_SCN_writes_via_64casdisable latch-free SCN writes using 64-bit compare & swapFALSE
739control_filescontrol file names list+DATA/orclasm/controlfile/current.256.929201173, +FRA/orclasm/controlfile/current.256.850260253
740_controlfile_enqueue_timeoutcontrol file enqueue timeout in seconds900
741_controlfile_enqueue_holding_timecontrol file enqueue max holding time in seconds120
742_controlfile_enqueue_holding_time_tracking_sizecontrol file enqueue holding time tracking size10
743_controlfile_update_checkcontrolfile update sanity checkOFF
744_controlfile_enqueue_dumpdump the system states after controlfile enqueue timeoutFALSE
745_controlfile_block_sizecontrol file block size in bytes0
746_controlfile_section_init_sizecontrol file initial section size
747_controlfile_section_max_expandcontrol file max expansion rate
748db_file_name_convertdatafile name convert patterns and strings for standby/clone db
749log_file_name_convertlogfile name convert patterns and strings for standby/clone db
750control_file_record_keep_timecontrol file record keep time in days14
751_kill_controlfile_enqueue_blockerenable killing controlfile enqueue blocker on timeoutTRUE
752_controlfile_backup_copy_checkenable check of the copied blocks during controlfile backup copyTRUE
753db_block_buffersNumber of database blocks cached in memory0
754_db_block_buffersNumber of database blocks cached in memory: hidden parameter41391
755_db_block_cache_protectprotect database blocks (true only when debugging)FALSE
756_db_block_cache_protect_internalprotect database blocks (for strictly internal use only)0
757db_block_checksumstore checksum in db blocks and check during readsTRUE
758db_ultra_safeSets defaults for other parameters that control protection levelsOFF
759db_block_sizeSize of database block in bytes8192
760_dbwr_tracingEnable dbwriter tracing0
761_tsenc_tracingEnable TS encryption tracing0
762_disable_multiple_block_sizesdisable multiple block size support (for debugging)FALSE
763_db_fast_obj_truncateenable fast object truncateTRUE
764_db_fast_obj_ckptenable fast object checkpointTRUE
765_enable_obj_queuesenable object queuesTRUE
766_db_obj_enable_ksrenable ksr in object checkpoint/reuseTRUE
767_small_table_thresholdlower threshold level of table size for direct reads827
768_very_large_object_thresholdupper threshold level of object size for direct reads500
769_db_block_cache_num_umapnumber of unmapped buffers (for tracking swap calls on blocks)0
770_dbwr_async_ioEnable dbwriter asynchronous writesTRUE
771_recovery_percentagerecovery buffer cache percentage50
772_db_lost_write_checkingEnable scn based lost write detection mechanism2
773_db_lost_write_tracingEnable _db_lost_write_checking tracingFALSE
774__db_cache_sizeActual size of DEFAULT buffer pool for standard block size buffers352321536
775db_cache_sizeSize of DEFAULT buffer pool for standard block size buffers301989888
776_db_block_numaNumber of NUMA nodes1
777db_2k_cache_sizeSize of cache for 2K buffers0
778db_4k_cache_sizeSize of cache for 4K buffers0
779db_8k_cache_sizeSize of cache for 8K buffers0
780db_16k_cache_sizeSize of cache for 16K buffers0
781db_32k_cache_sizeSize of cache for 32K buffers0
782db_keep_cache_sizeSize of KEEP buffer pool for standard block size buffers0
783db_recycle_cache_sizeSize of RECYCLE buffer pool for standard block size buffers0
784__shared_io_pool_sizeActual size of shared IO pool0
785_shared_io_pool_sizeSize of shared IO pool0
786_db_hot_block_trackingtrack hot blocks for hash latch contentionFALSE
787_sga_clear_dumpAllow dumping encrypted blocks in clear for debuggingFALSE
788_clear_buffer_before_reuseAlways zero-out buffer before reuse for securityFALSE
789_db_block_bad_write_checkenable bad write checksFALSE
790_db_block_lru_latchesnumber of lru latches16
791_db_percpu_create_cachesizesize of cache created per cpu in deferred cache create2
792_db_initial_cachesize_create_mbsize of cache created at startup256
793_db_num_evict_waiteventsnumber of evict wait events64
794_db_todefer_cache_createbuffer cache deferred createTRUE
795db_writer_processesnumber of background database writer processes to start1
796_db_block_known_clean_pctInitial Percentage of buffers to maintain known clean2
797_db_block_max_scan_pctPercentage of buffers to inspect when looking for free40
798_db_large_dirty_queueNumber of buffers which force dirty queue to be written25
799_db_writer_max_writesMax number of outstanding DB Writer IOs0
800_db_writer_chunk_writesNumber of writes DBWR should wait for0
801_db_block_med_priority_batch_sizeFraction of writes for medium priority reasons0
802_db_block_hi_priority_batch_sizeFraction of writes for high priority reasons0
803_db_writer_histogram_statisticsmaintain dbwr histogram statistics in x$kcbbhsFALSE
804_dbwr_scan_intervaldbwriter scan interval300
805_db_writer_flush_imuIf FALSE, DBWR will not downgrade IMU txns for AGINGTRUE
806_db_writer_coalesce_write_limitLimit on size of coalesced write131072
807_db_writer_coalesce_area_sizeSize of memory allocated to dbwriter for coalescing writes3522560
808_db_writer_nomemcopy_coalesceEnable DBWR no-memcopy coalescingFALSE
809_selftune_checkpoint_write_pctPercentage of total physical i/os for self-tune ckpt3
810_db_writer_verify_writesEnable lost write detection mechanismFALSE
811_db_block_prefetch_quotaPrefetch quota as a percent of cache size10
812_db_block_prefetch_limitPrefetch limit in blocks0
813_db_block_prefetch_overridePrefetch force override in blocks0
814_rbr_ckpt_tracingEnable reuse block range checkpoint tracing0
815_db_cache_pre_warmBuffer Cache Pre-Warm Enabled : hidden parameterTRUE
816buffer_pool_keepNumber of database blocks/latches in keep buffer pool
817buffer_pool_recycleNumber of database blocks/latches in recycle buffer pool
818_db_percent_hot_defaultPercent of default buffer pool considered hot50
819_db_percent_hot_keepPercent of keep buffer pool considered hot0
820_db_percent_hot_recyclePercent of recycle buffer pool considered hot0
821_db_aging_hot_criteriaTouch count which sends a buffer to head of replacement list2
822_db_aging_stay_countTouch count set when buffer moved to head of replacement list0
823_db_aging_cool_countTouch count set when buffer cooled1
824_db_aging_touch_timeTouch count which sends a buffer to head of replacement list3
825_db_aging_freeze_crMake CR buffers always be too cold to keep in cacheFALSE
826_db_block_hash_bucketsNumber of database block hash buckets131072
827_db_block_hash_latchesNumber of database block hash latches4096
828_db_blocks_per_hash_latchNumber of blocks per hash latch
829_db_handles_cachedBuffer handles cached each process8
830_db_handlesSystem-wide simultaneous buffer operations4000
831_wait_for_syncwait for sync on commit MUST BE ALWAYS TRUETRUE
832_db_block_vlm_checkcheck of rvlm mapping leaks (for debugging)FALSE
833_db_block_vlm_leak_thresholdThreshold for allowable vlm leaks3
834_db_block_cache_cloneAlways clone data blocks on get (for debugging)FALSE
835_db_block_trace_protecttrace buffer protect callsFALSE
836_db_cache_miss_check_lescheck LEs after cache missFALSE
837_db_block_max_cr_dbaMaximum Allowed Number of CR buffers per dba6
838_write_cloneswrite clones flag3
839_check_block_after_checksumperform block check after checksum if both are turned onTRUE
840_trace_pin_timetrace how long a current pin is held0
841_db_fast_obj_checkenable fast object drop sanity checkFALSE
842_db_block_temp_redogenerate redo for temp blocksFALSE
843_db_block_adjchk_leveladjacent cache buffer check level7
844_db_block_adjcheckadjacent cache buffer checks - low blkchk overwrite parameterTRUE
845_db_required_percent_fairshare_usagepercent of fairshare a processor group should always use10
846_db_block_check_objtypcheck objd and typ on cache disk readTRUE
847_db_block_do_full_mbreadsdo full block read even if some blocks are in cacheFALSE
848_shared_iop_max_sizemaximum shared io pool size536870912
849_shared_io_pool_buf_sizeShared IO pool buffer size1048576
850_siop_flashback_scandepthShared IO pool flashback io completion scan depth20
851_shared_io_pool_debug_trctrace kcbi debug info to tracefile0
852_shared_io_set_valueshared io pool size set internal value - overwrite zero user sizeFALSE
853_trace_buffer_wait_timeoutstrace buffer busy wait timeouts0
854_buffer_busy_wait_timeoutbuffer busy wait time in centiseconds100
855_db_cache_crx_checkcheck for costly crx examination functionsFALSE
856_db_cache_mman_latch_checkcheck for wait latch get under MMAN ops in kcbFALSE
857_db_block_cache_historybuffer header tracing (non-zero only when debugging)0
858_db_block_cache_history_levelbuffer header tracing level2
859_db_block_header_guard_levelnumber of extra buffer headers to use as guard pages0
860_db_block_table_scan_buffer_sizeSize of shared table scan read buffer4194304
861_db_cache_process_cr_pin_maxmaximum number of cr pins a process may have
862_db_block_corruption_recovery_thresholdthreshold number of block recovery attempts5
863_db_block_chunkify_ncmbrchunkify noncontig multi block readsFALSE
864_db_cache_wait_debugtrace new kslwaits0
865_fastpin_enableenable reference count based fast pins229847041
866_db_prefetch_histogram_statisticsmaintain prefetch histogram statistics in x$kcbprfhsFALSE
867_flush_undo_after_tx_recoveryif TRUE, flush undo buffers after TX recoveryTRUE
868_spare_test_parameterSpare test parameter0
869db_flash_cache_fileflash cache file for default block size
870db_flash_cache_sizeflash cache size for db_flash_cache_file0
871_db_2k_flash_cache_fileflash cache file for 2k block size
872_db_2k_flash_cache_sizeflash cache size for _db_2k_flash_cache_file0
873_db_4k_flash_cache_fileflash cache file for 4k block size
874_db_4k_flash_cache_sizeflash cache size for _db_4k_flash_cache_file0
875_db_8k_flash_cache_fileflash cache file for 8k block size
876_db_8k_flash_cache_sizeflash cache size for _db_8k_flash_cache_file0
877_db_16k_flash_cache_fileflash cache file for 16k block size
878_db_16k_flash_cache_sizeflash cache size for _db_16k_flash_cache_file0
879_db_32k_flash_cache_fileflash cache file for 32k block size
880_db_32k_flash_cache_sizeflash cache size for _db_32k_flash_cache_file0
881_db_flash_cache_keep_limitFlash cache keep buffer upper limit in percentage229771856
882_db_flash_cache_write_limitFlash cache write buffer upper limit in percentage1
883_db_flash_cache_force_replenish_limitFlash cache force replenish lower limit in buffers8
884_db_l2_tracingflash cache debug tracing0
885_db_dump_from_disk_noefcdump reading buffer contents0
886_numa_buffer_cache_statsConfigure NUMA buffer cache stats0
887_db_cache_block_read_stack_tracedump short call stack for block reads0
888db_cache_adviceBuffer cache sizing advisoryON
889_db_cache_advice_sample_factorcache advisory sampling factor4
890_db_cache_advice_max_size_factorcache advisory maximum multiple of current size to similate2
891_db_cache_advice_sanity_checkcache simulation sanity checkFALSE
892_db_mttr_adviceMTTR advisoryON
893_db_mttr_sim_targetMTTR simulation targets
894_db_mttr_sample_factorMTTR simulation sampling factor64
895_db_mttr_partitionsnumber of partitions for MTTR advisory0
896_db_mttr_sim_trace_sizeMTTR simulation trace size256
897_db_mttr_trace_to_alertdump trace entries to alert fileFALSE
898_obj_ckpt_tracingEnable object checkpoint tracing0
899_immediate_commit_propagationif TRUE, propagate commit SCN immediatelyTRUE
900_minimum_giga_scnMinimum SCN to start with in 2^30 units0
901_max_reasonable_scn_rateMax reasonable SCN rate32768
902_reasonable_scn_offset_secondsReasonable SCN offset seconds0
903compatibleDatabase will be completely compatible with this software version11.2.0.3.0
904_redo_compatibility_checkgeneral and redo/undo compatibility sanity checkFALSE
905_db_block_check_for_debugCheck more and dump block before image for debuggingFALSE
906_db_always_check_system_tsAlways perform block check and checksum for System tablespaceTRUE
907_log_checkpoint_recovery_check# redo blocks to verify after checkpoint0
908_two_passenable two-pass thread recoveryTRUE
909_recovery_verify_writesenable thread recovery write verifyFALSE
910_disable_recovery_read_skipDisable the read optimization during media recoveryFALSE
911_redo_transport_stream_writesStream network writes?TRUE
912_redo_transport_stream_testtest stream connection?TRUE
913_redo_transport_vio_size_reqVIO size requirement4294967294
914log_archive_dest_1archival destination #1 text string
915log_archive_dest_2archival destination #2 text string
916log_archive_dest_3archival destination #3 text string
917log_archive_dest_4archival destination #4 text string
918log_archive_dest_5archival destination #5 text string
919log_archive_dest_6archival destination #6 text string
920log_archive_dest_7archival destination #7 text string
921log_archive_dest_8archival destination #8 text string
922log_archive_dest_9archival destination #9 text string
923log_archive_dest_10archival destination #10 text string
924log_archive_dest_11archival destination #11 text string
925log_archive_dest_12archival destination #12 text string
926log_archive_dest_13archival destination #13 text string
927log_archive_dest_14archival destination #14 text string
928log_archive_dest_15archival destination #15 text string
929log_archive_dest_16archival destination #16 text string
930log_archive_dest_17archival destination #17 text string
931log_archive_dest_18archival destination #18 text string
932log_archive_dest_19archival destination #19 text string
933log_archive_dest_20archival destination #20 text string
934log_archive_dest_21archival destination #21 text string
935log_archive_dest_22archival destination #22 text string
936log_archive_dest_23archival destination #23 text string
937log_archive_dest_24archival destination #24 text string
938log_archive_dest_25archival destination #25 text string
939log_archive_dest_26archival destination #26 text string
940log_archive_dest_27archival destination #27 text string
941log_archive_dest_28archival destination #28 text string
942log_archive_dest_29archival destination #29 text string
943log_archive_dest_30archival destination #30 text string
944log_archive_dest_31archival destination #31 text string
945log_archive_dest_state_1archival destination #1 state text stringenable
946log_archive_dest_state_2archival destination #2 state text stringenable
947log_archive_dest_state_3archival destination #3 state text stringenable
948log_archive_dest_state_4archival destination #4 state text stringenable
949log_archive_dest_state_5archival destination #5 state text stringenable
950log_archive_dest_state_6archival destination #6 state text stringenable
951log_archive_dest_state_7archival destination #7 state text stringenable
952log_archive_dest_state_8archival destination #8 state text stringenable
953log_archive_dest_state_9archival destination #9 state text stringenable
954log_archive_dest_state_10archival destination #10 state text stringenable
955log_archive_dest_state_11archival destination #11 state text stringenable
956log_archive_dest_state_12archival destination #12 state text stringenable
957log_archive_dest_state_13archival destination #13 state text stringenable
958log_archive_dest_state_14archival destination #14 state text stringenable
959log_archive_dest_state_15archival destination #15 state text stringenable
960log_archive_dest_state_16archival destination #16 state text stringenable
961log_archive_dest_state_17archival destination #17 state text stringenable
962log_archive_dest_state_18archival destination #18 state text stringenable
963log_archive_dest_state_19archival destination #19 state text stringenable
964log_archive_dest_state_20archival destination #20 state text stringenable
965log_archive_dest_state_21archival destination #21 state text stringenable
966log_archive_dest_state_22archival destination #22 state text stringenable
967log_archive_dest_state_23archival destination #23 state text stringenable
968log_archive_dest_state_24archival destination #24 state text stringenable
969log_archive_dest_state_25archival destination #25 state text stringenable
970log_archive_dest_state_26archival destination #26 state text stringenable
971log_archive_dest_state_27archival destination #27 state text stringenable
972log_archive_dest_state_28archival destination #28 state text stringenable
973log_archive_dest_state_29archival destination #29 state text stringenable
974log_archive_dest_state_30archival destination #30 state text stringenable
975log_archive_dest_state_31archival destination #31 state text stringenable
976log_archive_startstart archival process on SGA initializationFALSE
977log_archive_destarchival destination text string
978log_archive_duplex_destduplex archival destination text string
979log_archive_min_succeed_destminimum number of archive destinations that must succeed1
980standby_archive_deststandby database archivelog destination text string?/dbs/arch
981_arch_sim_modeChange behavior of local archiving0
982_dg_corrupt_redo_logCorrupt redo log validation during archivals0
983_local_arc_assert_on_waitAssert whenever local ORL arch waits for spaceFALSE
984_defer_eor_orl_arch_for_sodefer EOR ORL archival for switchoverFALSE
985fal_clientFAL client
986fal_serverFAL server list
987_enable_ffwFAL FORWARDINGTRUE
988_force_rcv_info_pingForce recovery info ping to stdby0
989log_archive_traceEstablish archivelog operation tracing level0
990_log_archive_trace_pidslog archive trace pids parameter
991_flush_redo_to_standbyFlush redo to standby test event parameter0
992_redo_transport_sanity_checkredo transport sanity check bit mask0
993_dg_cf_check_timerData Guard controlfile check timer15
994_bypass_srl_for_so_eorbypass SRL for S/O EOR logsFALSE
995_rta_sync_wait_timeoutRTA sync wait timeout10
996_log_archive_prot_auto_demotelog archive protection auto demotionFALSE
997_serialize_lgwr_sync_ioSerialize LGWR SYNC local and remote ioFALSE
998_mgd_rcv_handle_orphan_datafilesManaged recovery handle orphan datafile situationFALSE
999_real_time_apply_simSimulation value with real time apply0
1000_defer_rcv_during_sw_to_sbyDefer recovery during switchover to standbyFALSE
1001_skip_trstamp_checkSkip terminal recovery stamp checkFALSE
1002_set_mgd_recovery_stateset mgd recovery state to new value0
1003_show_mgd_recovery_stateShow internal managed recovery stateFALSE
1004_log_archive_security_enabledlog archive security enabledTRUE
1005log_archive_configlog archive config parameter
1006_enable_sb_detectionSplit Brain DetectionTRUE
1007_log_archive_buffersNumber of buffers to allocate for archiving10
1008_redo_transport_compress_allIs ASYNC LNS compression allowed?TRUE
1009_log_archive_calloutarchival callout
1010log_archive_local_firstEstablish EXPEDITE attribute default valueTRUE
1011_rtc_infeasible_thresholdRedo Transport Compression infeasible threshold25
1012log_archive_formatarchival destination format%t%s%r.dbf
1013_disable_thread_snapshotThread snapshotTRUE
1014_log_archive_avoid_memcpylog archive avoid memcpyTRUE
1015_log_archive_strong_authlog archive security strong authTRUE
1016redo_transport_userData Guard transport user when using password file
1017_lgwr_ns_nl_minVariable to simulate network latency or buffer threshold500
1018_lgwr_ns_nl_maxVariable to simulate network latency or buffer threshold1000
1019_redo_transport_stall_timeI/O stall time before terminating redo transport process360
1020_redo_transport_stall_time_longlong I/O stall time before terminating redo transport process3600
1021log_archive_max_processesmaximum number of active ARCH processes4
1022_max_lns_shutdown_archival_timeMaximum time spent by LNS to archive last log during shutdown30
1023_ta_lns_wait_for_arch_logLNS Wait time for arhcived version of online log20
1024_lgwr_max_ns_wtMaximum wait time for lgwr to allow NetServer to progress1
1025_ns_max_flush_wtFlush wait time for NetServer to flush oustanding writes1
1026_ns_max_send_delayData Loss Time Bound for NetServer15
1027_lgwr_ta_sim_errVariable to simulate errors lgwr true async0
1028_lgwr_ns_sim_errVariable to simulate errors lgwrns0
1029_log_archive_network_redo_sizeLog archive network redo buffer size used by ARCH10
1030_switchover_to_standby_switch_logSwitchover to standby switches log for open redo threadsTRUE
1031_max_async_wait_for_catch_upSwitchover wait time for async LNS to catch up in seconds20
1032_lgwr_delay_writeLGWR write delay for debuggingFALSE
1033_enable_redo_global_postLGWR post globally on writeFALSE
1034log_bufferredo circular buffer size8478720
1035_log_io_sizeautomatically initiate log write if this many redo blocks in buffer0
1036_log_event_queuesnumber of the log writer event queues0
1037log_checkpoint_interval# redo blocks checkpoint threshold0
1038log_checkpoint_timeoutMaximum time interval between checkpoints in seconds1800
1039_log_switch_timeoutMaximum number of seconds redos in the current log could span0
1040archive_lag_targetMaximum number of seconds of redos the standby could lose0
1041_log_buffers_debugdebug redo buffers (slows things down)FALSE
1042_log_buffers_corruptcorrupt redo buffers before writeFALSE
1043_log_simultaneous_copiesnumber of simultaneous copies into redo buffer(# of copy latches)4
1044_log_parallelism_maxMaximum number of log buffer strands2
1045_log_parallelism_dynamicEnable dynamic strandsTRUE
1046_log_private_parallelism_mulActive sessions multiplier to deduce number of private strands10
1047_log_private_mulPrivate strand multiplier for log space preallocation5
1048_lightweight_hdrsLightweight headers for redoTRUE
1049_redo_read_from_memoryEnable reading redo from in-memory log bufferTRUE
1050_desired_readmem_rateThe desired percentage of redo reading from memory90
1051_log_read_buffer_sizebuffer size for reading log files8
1052_validate_readmem_redovalidate redo blocks read from in-memory log bufferOFF
1053_mirror_redo_buffersSave buffers for debugging redo corruptionsFALSE
1054_fg_log_checksumChecksum redo in foreground processTRUE
1055_verify_fg_log_checksumLGWR verifies redo checksums generated by foreground processesFALSE
1056_disable_loggingDisable loggingFALSE
1057_log_buffer_coalesceCoalescing log buffers for log writesFALSE
1058_fg_sync_sleep_usecsLog file sync via usleep0
1059_log_file_sync_timeoutLog file sync timeout (centiseconds)10
1060_use_adaptive_log_file_syncAdaptively switch between post/wait and pollingTRUE
1061_adaptive_log_file_sync_use_polling_thresholdRatio of redo synch time to expected poll time as a percentage200
1062_adaptive_log_file_sync_use_postwait_thresholdPercentage of foreground load from when post/wait was last used50
1063_adaptive_log_file_sync_sched_delay_windowWindow (in seconds) for measuring average scheduling delay60
1064_adaptive_log_file_sync_poll_aggressivenessPolling interval selection bias (conservative=0, aggressive=100)0
1065_adaptive_log_file_sync_high_switch_freq_thresholdThreshold for frequent log file sync mode switches (per minute)3
1066_max_pending_scn_bcastsmaximum number of pending SCN broadcasts8
1067_lgwr_posts_for_pending_bcastsLGWR posts commit waiters for pending broadcastsFALSE
1068_long_log_write_warning_thresholdthreshold for long log write warning messages in ms500
1069_long_bcast_ack_warning_thresholdthreshold for long bcast ack warning messages in ms500
1070_enable_flash_loggingEnable Exadata Smart Flash LoggingTRUE
1071db_filesmax allowable # db files200
1072db_file_multiblock_read_countdb block to be read each IO53
1073_db_file_exec_read_countmultiblock read count for regular clients53
1074_db_file_optimizer_read_countmultiblock read count for regular clients8
1075_db_file_noncontig_mblock_read_countnumber of noncontiguous db blocks to be prefetched11
1076read_only_open_delayedif TRUE delay opening of read only files until first accessFALSE
1077cluster_databaseif TRUE startup in cluster database modeFALSE
1078parallel_serverif TRUE startup in parallel server modeFALSE
1079parallel_server_instancesnumber of instances to use for sizing OPS SGA structures1
1080cluster_database_instancesnumber of instances to use for sizing cluster db SGA structures1
1081db_create_file_destdefault database location+DATA
1082db_create_online_log_dest_1online log/controlfile destination #1
1083db_create_online_log_dest_2online log/controlfile destination #2
1084db_create_online_log_dest_3online log/controlfile destination #3
1085db_create_online_log_dest_4online log/controlfile destination #4
1086db_create_online_log_dest_5online log/controlfile destination #5
1087db_recovery_file_destdefault database recovery file location+FRA
1088db_recovery_file_dest_sizedatabase recovery files size limit8589934592
1089_db_recovery_temporal_file_destdefault database recovery temporal file location
1090standby_file_managementif auto then files are created/dropped automatically on standbyMANUAL
1091_standby_switchover_timeoutNumber of secords for standby switchover enqueue timeout120
1092_hard_protectionif TRUE enable H.A.R.D specific format changesFALSE
1093_datafile_cowUse copy on write snapshot for the renamed fileFALSE
1094_max_filestat_triesmaximum number of file stat tries10
1095_allow_error_simulationAllow error simulation for testingFALSE
1096_db_file_format_io_buffersBlock formatting I/O buf count4
1097_disable_read_only_open_dict_checkDisable read-only open dictionary checkFALSE
1098_standby_flush_modestandby flush modeSLFLUSH
1099_causal_standby_wait_timeoutCausal standby wait timeout20
1100_gc_use_crif TRUE, allow CR pins on PI and WRITING buffersTRUE
1101_gc_undo_affinityif TRUE, enable dynamic undo affinityTRUE
1102_gc_disable_s_lock_brr_ping_checkif TRUE, disable S lock BRR ping check for lost write protectTRUE
1103_gc_policy_timehow often to make object policy decisions in minutes10
1104_gc_policy_minimumdynamic object policy minimum activity per minute1500
1105_gc_affinity_ratiodynamic object affinity ratio50
1106_gc_transfer_ratiodynamic object read-mostly transfer ratio2
1107_recovery_assertsif TRUE, enable expensive integrity checksFALSE
1108_gc_integrity_checksset the integrity check level1
1109_gc_vector_readif TRUE, vector read current buffersTRUE
1110_gc_element_percentglobal cache element percent110
1111_gc_latchesnumber of latches per LMS process8
1112_gc_statisticsif TRUE, kcl statistics are maintainedTRUE
1113_gc_keep_recovery_buffersif TRUE, make single instance crash recovery buffers currentTRUE
1114_recovery_read_limitnumber of recovery reads which can be outstanding1024
1115_gc_defer_timehow long to defer pings for hot buffers in milliseconds1
1116_gc_defer_ping_index_onlyif TRUE, restrict deferred ping to index blocks onlyTRUE
1117_kcl_debugif TRUE, record le historyTRUE
1118_kcl_index_splitif TRUE, reject pings on blocks in middle of a splitTRUE
1119_kcl_commitif TRUE, call kjbcommitTRUE
1120_fairness_thresholdnumber of times to CR serve before downgrading lock2
1121_interconnect_checksumif TRUE, checksum interconnect blocksTRUE
1122_cr_server_log_flushif TRUE, flush redo log before serving a CR bufferTRUE
1123_gc_log_flushif TRUE, flush redo log before a current block transferTRUE
1124_async_recovery_readsif TRUE, issue recovery reads asynchronouslyTRUE
1125_async_recovery_claimsif TRUE, issue recovery claims asynchronouslyTRUE
1126_avoid_prepareif TRUE, do not prepare a buffer when the master is localTRUE
1127_bwr_for_flushed_piif TRUE, generate a BWR for a flushed PITRUE
1128_send_requests_to_piif TRUE, try to send CR requests to PI buffersTRUE
1129_kcl_conservative_log_flushif TRUE, conservatively log flush before CR servingFALSE
1130_gc_check_bscnif TRUE, check for stale blocksTRUE
1131_gc_global_cpuglobal cpu checksTRUE
1132_gc_global_lruturn global lru off, make it automatic, or turn it onAUTO
1133_gc_global_lru_touch_countglobal lru touch count5
1134_gc_global_lru_touch_timeglobal lru touch time in seconds60
1135_gc_coalesce_recovery_readsif TRUE, coalesce recovery readsTRUE
1136_gc_maximum_bidsmaximum number of bids which can be prepared0
1137_gc_async_memcpyif TRUE, use async memcpyFALSE
1138_gc_global_checkpoint_scnif TRUE, enable global checkpoint scnTRUE
1139_gc_undo_block_disk_readsif TRUE, enable undo block disk readsTRUE
1140_gc_long_query_thresholdthreshold for long running query0
1141_gc_affinity_lockingif TRUE, enable object affinityTRUE
1142_gc_affinity_locksif TRUE, get affinity locksTRUE
1143_gc_read_mostly_lockingif TRUE, enable read-mostly lockingTRUE
1144_gc_persistent_read_mostlyif TRUE, enable persistent read-mostly lockingTRUE
1145_gc_bypass_readersif TRUE, modifications bypass readersTRUE
1146_gc_max_downcvtmaximum downconverts to process at one time256
1147_gc_tsn_undo_affinityif TRUE, use TSN undo affinityTRUE
1148_gc_fusion_compressioncompress fusion blocks if there is free space1024
1149_gc_down_convert_after_keepif TRUE, down-convert lock after recoveryTRUE
1150_gc_delta_push_objectsobjects which use delta push0
1151_gc_delta_push_max_levelmax delta level for delta push100
1152_gc_delta_push_compressionif delta >= K bytes, compress before push3072
1153_gc_flush_during_affinityif TRUE, flush during affinityTRUE
1154_gc_cr_server_read_waitif TRUE, cr server waits for a read to completeTRUE
1155_gc_read_mostly_flush_checkif TRUE, optimize flushes for read mostly objectsFALSE
1156_gc_override_force_crif TRUE, try to override force-cr requestsTRUE
1157_gc_escalate_bidif TRUE, escalates create a bidTRUE
1158_gc_cpu_timeif TRUE, record the gc cpu timeFALSE
1159_gc_fg_mergeif TRUE, merge pi buffers in the foregroundTRUE
1160_gc_no_fairness_for_clonesif TRUE, no fairness if we serve a cloneTRUE
1161_gc_serve_high_pi_as_currentif TRUE, use a higher clone scn when serving a piTRUE
1162_gc_sanity_check_cr_buffersif TRUE, sanity check CR buffersFALSE
1163_adaptive_direct_readAdaptive Direct ReadTRUE
1164_adaptive_direct_writeAdaptive Direct WriteTRUE
1165_db_block_align_direct_readAlign Direct ReadsTRUE
1166_db_noarch_disble_optimImage redo logging (NOARCHIVEMODE)FALSE
1167_db_disable_temp_encryptionDisable Temp Encryption for SpillsFALSE
1168db_unrecoverable_scn_trackingTrack nologging SCN in controlfileTRUE
1169_direct_io_slotsnumber of slots for direct path I/O0
1170_direct_io_skip_cur_slot_on_errorSkip current slot on errorTRUE
1171_direct_io_wslotsnumber of write slots for direct path I/O0
1172threadRedo thread to mount0
1173_disable_incremental_checkpointsDisable incremental checkpoints for thread recoveryFALSE
1174_disable_thread_internal_disableDisable thread internal disable featureFALSE
1175_disable_selftune_checkpointingDisable self-tune checkpointingFALSE
1176_selftune_checkpointing_lagSelf-tune checkpointing lag the tail of the redo log300
1177_target_rba_max_lag_percentagetarget rba max log lag percentage81
1178_no_recovery_through_resetlogsno recovery through this resetlogs operationFALSE
1179fast_start_io_targetUpper bound on recovery reads0
1180fast_start_mttr_targetMTTR target in seconds0
1181_log_blocks_during_backuplog block images when changed during backupTRUE
1182_allow_resetlogs_corruptionallow resetlogs even if it will cause corruptionFALSE
1183_allow_terminal_recovery_corruptionFinish terminal recovery even if it may cause corruptionFALSE
1184_allow_read_only_corruptionallow read-only open even if database is corruptFALSE
1185_recovery_skip_cfseq_checkallow media recovery even if controlfile seq check failsFALSE
1186log_checkpoints_to_alertlog checkpoint begin/end to alert fileFALSE
1187db_lost_write_protectenable lost write detectionNONE
1188_switchover_to_standby_optionoption for graceful switchover to standbyOPEN_ONE
1189recovery_parallelismnumber of server processes to use for parallel recovery0
1190_serial_recoveryforce serial recovery or parallel recoveryFALSE
1191_coord_message_bufferparallel recovery coordinator side extra message buffer size0
1192_multiple_instance_recoveryuse multiple instances for media recoveryFALSE
1193_backup_kgc_schemespecifies compression schemeZLIB
1194_backup_kgc_bufszspecifies buffer size to be used by BASIC compression0
1195_backup_kgc_typespecifies compression type used by kgc BASIC compression0
1196_backup_kgc_nitersspecifies number of iterations done by BASIC compression0
1197_backup_lzo_sizespecifies buffer size for LOW compression262144
1198_backup_kgc_perflevelspecifies compression (performance) level for MEDIUM compression1
1199_backup_kgc_windowbitsspecifies window size for MEDIUM compression15
1200_backup_kgc_memlevelspecifies memory level for MEDIUM compression8
1201_backup_kgc_blksizspecifies buffer size to be used by HIGH compression9
1202_backup_ksfq_bufcnt_maxmaximum number of buffers used for backup/restore64
1203_backup_ksfq_bufszsize of buffers used for backup/restore0
1204_backup_ksfq_bufcntnumber of buffers used for backup/restore0
1205_backup_disk_bufszsize of buffers used for DISK channels0
1206_backup_disk_bufcntnumber of buffers used for DISK channels0
1207_backup_seq_bufszsize of buffers used for non-DISK channels0
1208_backup_seq_bufcntnumber of buffers used for non-DISK channels0
1209_backup_file_bufszsize of buffers used for file access0
1210_backup_file_bufcntnumber of buffers used for file access0
1211_restore_maxopenfilesrestore assumption for maxopenfiles8
1212_backup_max_gap_sizelargest gap in an incremental/optimized backup buffer, in bytes4294967294
1213_unused_block_compressionenable unused block compressionTRUE
1214_restore_spfilerestore spfile to this location
1215_dummy_instancedummy instance started by RMANFALSE
1216_rman_io_prioritypriority at which rman backup i/o's are done3
1217_rman_restore_through_linkRMAN restore through linkFALSE
1218_backup_encrypt_opt_modespecifies encryption block optimization mode4294967294
1219_disable_initial_block_compressiondisable initial block compressionFALSE
1220_undo_block_compressionenable undo block compressionTRUE
1221_update_datafile_headers_with_space_informationuser requested update of datafile headers of locally managed datafiles with space informationFALSE
1222_disable_cell_optimized_backupsdisable cell optimized backupsFALSE
1223_backup_align_write_ioalign backup write I/OsTRUE
1224_backup_dynamic_buffersdynamically compute backup/restore buffer sizesTRUE
1225_backup_automatic_retryautomatic retry on backup write errors10
1226_controlfile_autobackup_delaytime delay (in seconds) for performing controlfile autobackups300
1227_deferred_log_dest_is_validconsider deferred log dest as valid for log deletion (TRUE/FALSE)TRUE
1228_log_deletion_policyarchivelog deletion policy for mandatory/all destinationmandatory
1229_auto_bmrenable/disable Auto BMRenabled
1230_auto_bmr_req_timeoutAuto BMR Requester Timeout60
1231_auto_bmr_sess_thresholdAuto BMR Request Session Threshold30
1232_auto_bmr_pub_timeoutAuto BMR Publish Timeout10
1233_auto_bmr_fc_timeAuto BMR Flood Control Time60
1234_auto_bmr_bg_timeAuto BMR Process Run Time3600
1235_auto_bmr_sys_thresholdAuto BMR Request System Threshold100
1236_bmr_prefered_standbystandby db_unique_name prefered for standby BMR
1237_tts_allow_charset_mismatchallow plugging in a tablespace with an incompatible character setFALSE
1238_xtts_allow_pre10allow cross platform for pre10 compatible tablespaceFALSE
1239_xtts_set_platform_infoset cross platform info during file header readFALSE
1240_bypass_xplatform_errorbypass datafile header cross-platform-compliance errorsFALSE
1241_query_on_physicalquery on physicalTRUE
1242_recoverable_recovery_batch_percentRecoverable recovery batch size (percentage of buffer cache)50
1243_disable_incremental_recovery_ckptDisable incremental recovery checkpoint mechanismFALSE
1244_incremental_recovery_ckpt_min_batchminimum number of writes for incremental recovery ckpt every second500
1245_multi_instance_pmrforce multi instance or single instance parallel recoveryTRUE
1246_disable_active_influx_movedisable active influx move during parallel media recoveryFALSE
1247_defer_log_boundary_ckptdefer media recovery checkpoint at log boundaryTRUE
1248_defer_log_countNumber of log boundaries media recovery checkpoint lags behind2
1249_transient_logical_clear_hold_mrp_bitclear KCCDI2HMRP flag during standby recoveryFALSE
1250_log_max_optimize_threadsmaximum number of threads to which log scan optimization is applied128
1251_reduce_sby_log_scanenable standby log scan optimizationTRUE
1252_sync_primary_wait_timewait time for alter session sync with primary5
1253_standby_implicit_rcv_timeoutminutes to wait for redo during standby implicit recovery1
1254_readable_standby_sync_timeoutreadable standby query scn sync timeout10
1255_read_only_violation_max_countread-only violation array max count500
1256_read_only_violation_max_count_per_moduleread-only violation array per module max count100
1257_read_only_violation_dump_to_traceread-only violation dump to trace filesFALSE
1258_media_recovery_read_batchmedia recovery block read batch32
1259_standby_causal_heartbeat_timeoutreadable standby causal heartbeat timeout2
1260_bct_public_dba_buffer_sizetotal size of all public change tracking dba buffers, in bytes0
1261_bct_initial_private_dba_buffer_sizeinitial number of entries in the private change tracking dba buffers0
1262_bct_bitmaps_per_filenumber of bitmaps to store for each datafile8
1263_bct_file_block_sizeblock size of change tracking file, in bytes0
1264_bct_file_extent_sizeextent size of change tracking file, in bytes0
1265_bct_chunk_sizechange tracking datafile chunk size, in bytes0
1266_bct_crash_reserve_sizechange tracking reserved crash recovery SGA space, in bytes262144
1267_bct_buffer_allocation_sizesize of one change tracking buffer allocation, in bytes2097152
1268_bct_buffer_allocation_maxmaximum size of all change tracking buffer allocations, in bytes104857600
1269_bct_buffer_allocation_min_extentsmininum number of extents to allocate per buffer allocation1
1270_bct_fixtab_filechange tracking file for fixed tables
1271_disable_primary_bitmap_switchdisable primary bitmap switchFALSE
1272_bct_health_check_intervalCTWR health check interval (seconds), zero to disable60
1273db_flashback_retention_targetMaximum Flashback Database log retention time in minutes.1440
1274_validate_flashback_databaseScan database to validate result of flashback databaseFALSE
1275_flashback_allow_noarchivelogAllow enabling flashback on noarchivelog databaseFALSE
1276_verify_flashback_redoVerify that the redo logs needed for flashback are availableTRUE
1277_flashback_verbose_infoPrint verbose information about flashback databaseFALSE
1278_flashback_dynamic_enable_failureSimulate failures during dynamic enable0
1279_flashback_dynamic_enableenable flashback enable code pathTRUE
1280_allow_drop_snapshot_standby_grspAllow dropping snapshot standby guaranteed restore pointFALSE
1281_flashback_marker_cache_sizeSize of flashback database marker cache328
1282_flashback_marker_cache_enabledEnable flashback database marker cacheTRUE
1283_flashback_database_test_onlyRun Flashback Database in test modeFALSE
1284_allow_drop_ts_with_grpAllow drop Tablespace with guaranteed restore pointsFALSE
1285_flashback_logfile_enqueue_timeoutflashback logfile enqueue timeout for opens600
1286_flashback_barrier_intervalFlashback barrier interval in seconds1800
1287_flashback_standby_barrier_intervalFlashback standby barrier interval in seconds1
1288_flashback_max_standby_sync_spanMaximum time span between standby recovery sync for flashback300
1289_flashback_fuzzy_barrierUse flashback fuzzy barrierTRUE
1290_disable_kcb_flashback_blocknew_optDisable KCB flashback block new optimizationFALSE
1291_disable_kcbl_flashback_blocknew_optDisable KCBL flashback block new optimizationFALSE
1292_disable_flashback_wait_callbackDisable flashback wait callbackFALSE
1293_check_block_new_invariant_for_flashbackcheck block new invariant for flashbackFALSE
1294_allow_compatibility_adv_w_grpallow advancing DB compatibility with guaranteed restore pointsFALSE
1295_minimum_db_flashback_retentionMinimum flashback retention60
1296_flashback_delete_chunk_MBAmount of flashback log (in MB) to delete in one attempt128
1297_flashback_11.1_block_new_optuse 11.1 flashback block new optimization schemeFALSE
1298_flashback_log_sizeFlashback log size1000
1299_flashback_log_min_sizeMinimum flashback log size100
1300_db_flashback_log_min_sizeMinimum flashback database log size in bytes16777216
1301_db_flashback_log_min_total_spaceMinimum flashback database log total space in bytes0
1302_flashback_copy_latchesNumber of flashback copy latches10
1303_flashback_n_log_per_threadDesired number of flashback logs per flashback thread128
1304_flashback_max_n_log_per_threadMaximum number of flashback logs per flashback thread2048
1305_flashback_generation_buffer_sizeflashback generation buffer size8388608
1306_flashback_max_log_sizeMaximum flashback log size in bytes (OS limit)0
1307_flashback_log_io_error_behaviorSpecify Flashback log I/O error behavior0
1308_flashback_prepare_logPrepare Flashback logs in the backgroundTRUE
1309_flashback_size_based_on_redoSize new flashback logs based on average redo log sizeTRUE
1310_flashback_validate_controlfilevalidate flashback pointers in controlfile for 11.2.0.2 databaseFALSE
1311_flashback_format_chunk_mbChunk mega-bytes for formatting flashback logs using sync write4
1312_flashback_format_chunk_mb_dwriteChunk mega-bytes for formatting flashback logs using delayed write16
1313_flashback_log_rac_balance_factorflashback log rac balance factor10
1314_flashback_write_max_loop_limitFlashback writer loop limit before it returns10
1315_flashback_hint_barrier_percentFlashback hint barrier percent20
1316_drop_flashback_logical_operations_enqDrop logical operations enqueue immediately during flashback marker generationFALSE
1317_percent_flashback_buf_partial_fullPercent of flashback buffer filled to be considered partial full50
1318_tdb_debug_modeset debug mode for testing transportable database16
1319_log_read_buffersNumber of log read buffers for media recovery8
1320_change_vector_buffersNumber of change vector buffers for media recovery1
1321_kcfis_trace_levelsets kcfis tracing level0
1322_kcfis_spawn_debuggerDecides whether to spawn the debugger at kcfis initializeFALSE
1323_kcfis_trace_bucket_sizeKCFIS tracing bucket size in bytes131072
1324_kcfis_fault_controlFault Injection Control0
1325_kcfis_caching_enabledenable kcfis intra-scan session cachingTRUE
1326_kcfis_large_payload_enabledenable large payload to be passed to cellsrvFALSE
1327_kcfis_cell_passthru_enabledDo not perform smart IO filtering on the cellFALSE
1328_kcfis_dump_corrupt_blockDump any corrupt blocks found during smart IOTRUE
1329_kcfis_kept_in_cellfc_enabledEnable usage of cellsrv flash cache for kept objectsTRUE
1330_kcfis_nonkept_in_cellfc_enabledEnable use of cellsrv flash cache for non-kept objectsFALSE
1331_kcfis_rdbms_blockio_enabledUse block IO instead of smart IO in the smart IO module on RDBMSFALSE
1332_kcfis_fast_response_enabledEnable smart scan optimization for fast response (first rows)TRUE
1333_kcfis_fast_response_thresholdFast response - the number of IOs after which smartIO is used1048576
1334_kcfis_fast_response_initiosizeFast response - The size of the first IO in logical blocks2
1335_kcfis_fast_response_iosizemultFast response - (next IO size = current IO size * this parameter)4
1336_kcfis_max_out_translationsSets the maximum number of outstanding translations in kcfis5000
1337_kcfis_max_cached_sessionsSets the maximum number of kcfis sessions cached10
1338_kcfis_storageidx_disabledDon't use storage index optimization on the storage cellFALSE
1339_kcfis_disable_platform_decryptionDon't use platform-specific decryption on the storage cellFALSE
1340_kcfis_storageidx_diag_modeDebug mode for storage index on the cell0
1341_kcfis_test_control1kcfis tst control10
1342_kcfis_stats_levelsets kcfis stats level0
1343_kcfis_io_prefetch_sizeSmart IO prefetch size for a cell8
1344_kcfis_block_dump_levelSmart IO block dump level0
1345_kcfis_ioreqs_throttle_enabledEnable Smart IO requests throttlingTRUE
1346_kcfis_work_set_appliancesWorking Set of appliances in a KCFIS session2
1347_kcfis_control1Kcfis control10
1348_kcfis_control2Kcfis control20
1349_kcfis_control3Kcfis control30
1350_kcfis_control4Kcfis control40
1351_kcfis_control5Kcfis control50
1352_kcfis_control6Kcfis control60
1353_kcfis_oss_io_sizeKCFIS OSS I/O size0
1354_kcfis_read_buffer_limitKCFIS Read Buffer (per session) memory limit in bytes0
1355_cell_file_format_chunk_sizeCell file format chunk size in MB0
1356_cell_offload_capabilities_enabledspecifies capability table to load1
1357_kcfis_cell_passthru_fromcpu_enabledEnable automatic passthru mode when cell CPU util is too highTRUE
1358_db_block_prefetch_skip_reading_enabledBatched IO enable skip reading buffersTRUE
1359_db_block_prefetch_fast_longjumps_enabledBatched IO enable fast longjumpsTRUE
1360_db_block_prefetch_private_cache_enabledBatched IO enable private cacheTRUE
1361_datafile_write_errors_crash_instancedatafile write errors crash instanceTRUE
1362_siop_perc_of_bc_x100percentange * 100 of cache to transfer to shared io pool2500
1363_db_flashback_iobuf_sizeFlashback IO Buffer Size1
1364_db_flashback_num_iobufFlashback Number of IO buffers32
1365_flashback_enable_raFlashback enable read aheadTRUE
1366dml_locksdml locks - one for each table modified in a transaction3396
1367_row_lockingrow-lockingalways
1368_serializableserializableFALSE
1369_scn_wait_interface_max_timeout_secsmax timeout for scn wait interface in kta2147483647
1370_scn_wait_interface_max_backoff_time_secsmax exponential backoff time for scn wait interface in kta600
1371replication_dependency_trackingtracking dependency for Replication parallel propagationTRUE
1372_ktb_debug_flagsktb-layer debug flags0
1373_log_committime_block_cleanoutLog commit-time block cleanoutFALSE
1374_ktc_latchesnumber of ktc latches0
1375_prescommpresume commit of IMU transactionsFALSE
1376_recursive_imu_transactionsrecursive transactions may be IMUFALSE
1377_ktc_debugfor ktc debug0
1378_enable_minscn_crenable/disable minscn optimization for CRTRUE
1379transactionsmax. number of concurrent active transactions849
1380transactions_per_rollback_segmentnumber of active transactions per rollback segment5
1381_ktu_latchesnumber of KTU latches0
1382rollback_segmentsundo segment list
1383_rollback_segment_initialstarting undo segment number1
1384_rollback_segment_countnumber of undo segments0
1385_offline_rollback_segmentsoffline undo segment list
1386_corrupted_rollback_segmentscorrupted undo segment list
1387_transaction_auditingtransaction auditing records generated in the redo logTRUE
1388_enable_block_level_transaction_recoveryenable block level recoveryTRUE
1389_cleanup_rollback_entriesno. of undo entries to apply per transaction cleanup100
1390undo_managementinstance runs in SMU mode if TRUE, else in RBU modeAUTO
1391undo_tablespaceuse/switch undo tablespaceUNDOTBS1
1392_smu_error_simulation_sitesite ID of error simulation in KTU code0
1393_smu_error_simulation_typeerror type for error simulation in KTU code0
1394_collect_undo_statsCollect Statistics v$undostatTRUE
1395_smu_timeoutscomma-separated AND double-quoted list of AUM timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl
1396_smu_debug_mode - set debug event for testing SMU operations0
1397_undo_debug_modedebug flag for undo related operations0
1398_verify_undo_quotaTRUE - verify consistency of undo quota statisticsFALSE
1399_tablespaces_per_transactionestimated number of tablespaces manipulated by each transaction10
1400_in_memory_tbs_searchFALSE - disable fast path for alter tablespace read onlyTRUE
1401_discrete_transactions_enabledenable OLTP modeFALSE
1402_in_memory_undoMake in memory undo for top level transactionsTRUE
1403_imu_poolsin memory undo pools3
1404_row_crenable row cr for all sqlTRUE
1405_undo_autotuneenable auto tuning of undo_retentionFALSE
1406_highthreshold_undoretentionhigh threshold undo_retention in seconds4294967294
1407_branch_taggingenable branch tagging for distributed transactionTRUE
1408undo_retentionundo retention in seconds60
1409_rollback_stopatstop at -position to step rollback0
1410_transaction_recovery_serversmax number of parallel recovery slaves that may be used0
1411fast_start_parallel_rollbackmax number of parallel recovery slaves that may be usedLOW
1412_parallel_recovery_stopatstop at -position- to step through SMON32767
1413resumable_timeoutset resumable_timeout0
1414_max_cr_rollbacksMaximum number of CR rollbacks per block (LMS)0
1415_cr_trc_buf_sizesize of cr trace buffer8192
1416_disable_txn_alertdisable txn layer alert0
1417_undo_debug_usageinvoke undo usage functions for testing0
1418_db_change_notification_enableenable db change notificationTRUE
1419_disable_flashback_archiverdisable flashback archiver0
1420_disable_fba_qrwdisable flashback archiver query rewrite0
1421_disable_fba_wprdisable flashback archiver wait for prepared transactions0
1422_flashback_archiver_partition_sizeflashback archiver table partition size0
1423_fbda_busy_percentageflashback archiver busy percentage0
1424_fbda_inline_percentageflashback archiver inline percentage0
1425_fbda_debug_modeflashback archiver debug event for testing0
1426_fbda_debug_assertflashback archiver debug assert for testing0
1427_fbda_global_bscn_lagflashback archiver global barrier scn lag0
1428_fbda_rac_inactive_limitflashback archiver rac inactive limit0
1429_partition_large_extentsEnables large extent allocation for partitioned tablesTRUE
1430_index_partition_large_extentsEnables large extent allocation for partitioned indicesFALSE
1431instance_numberinstance number0
1432_allocate_creation_ordershould files be examined in creation order during allocationFALSE
1433_log_space_errorsshould we report space errors to alert logTRUE
1434_assm_low_gsp_thresholdNumber of blocks rejected before collecting stats10000
1435_assm_high_gsp_thresholdNumber of blocks rejected before growing segment11024
1436_simulate_io_waitSimulate I/O wait to test segment advisor0
1437_bump_highwater_mark_counthow many blocks should we allocate per free list on advancing HWM0
1438_assm_defaultASSM defaultTRUE
1439_enable_hwm_syncenable HWM synchronizationTRUE
1440_hwm_sync_thresholdHWM synchronization threshold in percentage10
1441_enable_check_truncateenable checking of corruption caused by canceled truncateTRUE
1442_enable_tablespace_alertsenable tablespace alertsTRUE
1443_disable_temp_tablespace_alertsdisable tablespace alerts for TEMPORARY tablespacesFALSE
1444_disable_undo_tablespace_alertsdisable tablespace alerts for UNDO tablespacesFALSE
1445_last_allocation_periodperiod over which an instance can retain an active level1 bitmap5
1446_securefiles_forceflushsecurefiles force flush before allocationFALSE
1447_securefiles_concurrency_estimatesecurefiles concurrency estimate12
1448_securefiles_memory_percentofSGAsecurefiles memory as percent of SGA20
1449_inst_locking_periodperiod an instance can retain a newly acquired level1 bitmap5
1450_allocation_update_intervalinterval at which successful search in L1 should be updated3
1451_minimum_blocks_to_shrinkminimum number freeable blocks for shrink to be present0
1452_minimum_extents_to_shrinkminimum number freeable extents for shrink to be present1
1453_use_best_fituse best fit to allocate spaceFALSE
1454_step_down_limit_in_pctstep down limit in percentage1
1455_enable_space_preallocationenable space pre-allocation3
1456_ktspsrch_maxscmaximum segments supported by space search cache1024
1457_ktspsrch_maxskipspace search cache rejection skip upper limit5
1458_assm_force_fetchmetaenable metadata block fetching in ASSM segment scanFALSE
1459_max_fsu_segmentsMaximum segments to track for fast space usage4096
1460_max_fsu_stale_timeAllowed space usage staleness in seconds600
1461_max_shrink_obj_statsnumber of segments for which shrink stats will be maintained0
1462_check_ts_thresholdcheck tablespace thresholds0
1463_async_ts_thresholdcheck tablespace thresholds asynchronously1
1464_kttext_warningtablespace pre-extension warning threshold in percentage5
1465_smon_internal_errlimitlimit of SMON internal errors100
1466_smon_undo_seg_rescan_limitlimit of SMON continous undo segments re-scan10
1467_space_align_sizespace align size1048576
1468_enable_spacebgenable space management background taskTRUE
1469_max_spacebg_slavesmaximum space management background slaves10
1470_max_spacebg_tasksmaximum space management background tasks1000
1471_max_spacebg_msgs_percentagemaximum space management interrupt message throttling50
1472_ktslj_segext_warningsegment pre-extension warning threshold in percentage10
1473_ktslj_segext_warning_mbsegment pre-extension warning threshold in MB0
1474_ktslj_segext_max_mbsegment pre-extension max size in MB (0: unlimited)0
1475_ktslj_segext_retrysegment pre-extension retry5
1476_securefiles_fg_retrysegment retry before foreground waits100
1477_securefiles_bulkinsertsecurefiles segment insert only optizationFALSE
1478_db_row_overlap_checkingrow overlap checking override parameter for data/index blocksTRUE
1479_db_index_block_checkingindex block checking override parameterTRUE
1480_kdi_avoid_block_checkingavoid index block checking on sensitive opcodesFALSE
1481db_block_checkingheader checking and data and index block checkingTRUE
1482_disable_block_checkingdisable block checking at the session levelFALSE
1483_kd_symtab_chkenable or disable symbol table integrity block checkTRUE
1484recyclebinrecyclebin processingon
1485_compression_compatibilityCompression compatability11.2.0.3.0
1486_check_column_lengthcheck column lengthTRUE
1487_oltp_compressionoltp compression enabledTRUE
1488_inplace_update_retryinplace update retry for ora1551TRUE
1489_limit_itlslimit the number of ITLs in OLTP Compressed Tables20
1490_force_hsc_compresscompress all newly created tablesFALSE
1491_force_oltp_compressOLTP Compress all newly created compressed tablesFALSE
1492_force_oltp_update_optOLTP Compressed row optimization on updateTRUE
1493_force_arch_compressArchive Compress all newly created compressed tables0
1494_compression_advisorCompression advisor0
1495_compression_chainpercentage of chained rows allowed for Compression90
1496_compression_above_cachenumber of recompression above cache for sanity check0
1497_oltp_compression_gainoltp compression gain10
1498_arch_compressionarchive compression enabledTRUE
1499_arch_comp_dbg_scanarchive compression scan debug0
1500_arch_comp_dec_block_check_dumpdecompress archive compression blocks for checking and dumping1
1501_lmn_compressionsuppl logging for compression enabledTRUE
1502_alternate_iot_leaf_block_split_pointsenable alternate index-organized table leaf-block split-pointsTRUE
1503_kdu_array_deptharray update retry recursion depth limits16
1504_cell_offload_hybridcolumnarQuery offloading of hybrid columnar compressed tables to exadataTRUE
1505_disable_implicit_row_movementdisable implicit row movementFALSE
1506_release_insert_thresholdmaximum number of unusable blocks to unlink from freelist5
1507_walk_insert_thresholdmaximum number of unusable blocks to walk across freelist0
1508_enable_hash_overflowTRUE - enable hash cluster overflow based on SIZEFALSE
1509_kdtgsp_retriesmax number of retries in kdtgsp if space returns same block1024
1510_minfree_plusmax percentage of block space + minfree before we mark block full0
1511_use_seq_process_cachewhether to use process local seq cacheTRUE
1512_disable_index_block_prefetchingdisable index block prefetchingFALSE
1513_index_scan_check_skip_corruptcheck and skip corrupt blocks during index scansFALSE
1514_index_scan_check_stopkeycheck stopkey during index range scansFALSE
1515_reuse_index_loopnumber of blocks being examine for index block reuse5
1516_kdis_reject_limit#block rejections in space reclamation before segment extension5
1517_kdis_reject_levelb+tree level to enable rejection limit24
1518_kdis_reject_opsenable rejection heuristic for branch splitsFALSE
1519_kdbl_enable_post_allocationallocate dbas after populating data buffersFALSE
1520_ldr_io_sizesize of write IOs used during a load operation262144
1521_ldr_io_size2size of write IOs used during a load operation of EHCC with HWMB1048576
1522_ldr_pga_limpga limit, beyond which new partition loads are delayed0
1523_ignore_desc_in_indexignore DESC in indexes, sort those columns ascending anyhowFALSE
1524_kdic_segarr_szsize threshold for segmented arrays for seg_info_kdicctx0
1525_keep_remote_column_sizeremote column size does not get modifiedFALSE
1526_ignore_edition_enabled_for_EV_creationignore schema's edition-enabled status during EV creationFALSE
1527_kdli_traceinode trace level0
1528_kdli_sort_dbassort dbas during chunkificationFALSE
1529_kdli_safe_callbacksinvoke inode read/write callbacks safelyTRUE
1530_kdli_inode_preferenceinline inode evolution preference (data, headless, lhb)data
1531_kdli_reshapereshape an inode to inline or headless on length truncationFALSE
1532_kdli_cache_inodecache inode state across callsTRUE
1533_kdli_cache_verifyverify cached inode via deserializationFALSE
1534_kdli_cache_sizemaximum #entries in inode cache8
1535_kdli_memory_protecttrace accesses to inode memory outside kdli API functionsFALSE
1536_kdli_rci_lobmap_entries#entries in RCI lobmap before migration to lhb255
1537_kdli_readahead_strategyshared/cached IO readahead strategycontig
1538_kdli_readahead_limitshared/cached IO readahead limit0
1539_kdli_sio_onenable shared IO pool operationsTRUE
1540_kdli_sio_min_readshared IO pool read threshold0
1541_kdli_sio_min_writeshared IO pool write threshold0
1542_kdli_sio_asyncasynchronous shared IOTRUE
1543_kdli_sio_fgioreap asynchronous IO in the foregroundTRUE
1544_kdli_sio_nbufsmaximum #IO buffers to allocate per session8
1545_kdli_sio_niodsmaximum #IO descriptors to allocate per session8
1546_kdli_sio_strategyshared IO strategy: block vs. extentextent
1547_kdli_sio_fileopenshared IO fileopen mode: datasync vs nodatasync vs asyncnone
1548_kdli_sio_flushenable shared IO pool operationsFALSE
1549_kdli_sio_bpsmaximum blocks per IO slot0
1550_kdli_sio_pgause PGA allocations for direct IOFALSE
1551_kdli_sio_pga_topPGA allocations come from toplevel PGA heapFALSE
1552_kdli_sio_dopdegree-of-parallelism in the SIO keep pool2
1553_kdli_sio_freefree IO buffers when not in active useTRUE
1554_kdli_sio_backoffuse exponential backoff when attempting SIOP allocationsFALSE
1555_kdli_inline_xfmallow inline transformed lobsTRUE
1556_kdli_timer_trctrace inode timers to uts/tracefileFALSE
1557_kdli_timer_dmpdump inode timers on session terminationFALSE
1558_kdli_cacheable_lengthminimum lob length for inode cacheability0
1559_kdli_small_cache_limitsize limit of small inode cache32
1560_kdli_inject_assertinject asserts into the inode0
1561_kdli_inject_crashinject crashes into the inode0
1562_kdli_space_cache_limitmaximum size of the space cache in #blocks2048
1563_kdli_force_crforce CR when reading data blocks of direct-write lobsTRUE
1564_kdli_force_cr_metaforce CR when reading metadata blocks of direct-write lobsTRUE
1565_kdli_recent_scnuse recent (not dependent) scns for block format/allocationFALSE
1566_kdli_itree_entries#entries in lhb/itree blocks (for testing only)0
1567_kdli_cache_read_thresholdminimum lob size for cache->nocache read (0 disables heuristic)0
1568_kdli_cache_write_thresholdminimum lob size for cache->nocache write (0 disables heuristic)0
1569_kdli_full_readahead_thresholdmaximum lob size for full readahead0
1570_kdli_force_storageforce storage settings for all lobsnone
1571_kdli_allow_corruptallow corrupt filesystem_logging data blocks during read/writeTRUE
1572_kdli_squeezecompact lobmap extents with contiguous dbasTRUE
1573_kdli_buffer_injectuse buffer injection for CACHE [NO]LOGGING lobsTRUE
1574_kdli_inject_batchbuffer injection batch size [1, KCBNEWMAX]0
1575_kdli_flush_injectionsflush injected buffers of CACHE NOLOGGING lobs before commitTRUE
1576_kdli_flush_cache_readsflush cache-reads data blocks after loadFALSE
1577_kdli_checkpoint_flushdo not invalidate cache buffers after writeFALSE
1578_kdli_delay_flushesdelay flushing cache writes to direct-write lobsTRUE
1579_kdli_dbcoverride db_block_checking setting for securefilesnone
1580_kdli_preallocation_pctpercentage preallocation [0 .. inf) for lob growth0
1581_kdli_preallocation_modepreallocation mode for lob growthlength
1582_kdli_inplace_overwritemaximum inplace overwrite size (> chunksize)0
1583_kdli_sio_write_pctpercentage of buffer used for direct writes100
1584_kdli_sio_fbwrite_pctpercentage of buffer used for direct writes in flashback-db35
1585_kdli_vll_directuse skip-navigation and direct-positioning in vll-domainTRUE
1586_kdli_oneblkallocate chunks as single blocksFALSE
1587_kdli_STOP_tsnundocumented parameter for internal use only0
1588_kdli_STOP_dbaundocumented parameter for internal use only0
1589_kdli_STOP_fszundocumented parameter for internal use only0
1590_kdli_STOP_bszundocumented parameter for internal use only0
1591_kdli_STOP_nioundocumented parameter for internal use only0
1592_kdlw_enable_write_gatheringenable lob write gathering for sql txnsTRUE
1593_kdlw_enable_ksi_lockingenable ksi locking for lobsFALSE
1594_kdlwp_flush_thresholdWGC flush threshold in bytes4194304
1595_kdlxp_cmp_subunit_sizesize of compression sub-unit in bytes262144
1596_kdlxp_minxfm_sizeminimum transformation size in bytes32768
1597_kdlxp_lobcompressenable lob compression - only on SecureFilesFALSE
1598_kdlxp_lobcmplevelDefault securefile compression2
1599_kdlxp_lobcmprciverDefault securefile compression map version1
1600_kdlxp_lobencryptenable lob encryption - only on SecureFilesFALSE
1601_kdlxp_xfmcacheenable xfm cache - only on SecureFilesTRUE
1602_kdlxp_lobcmpadpenable adaptive compression - only on SecureFilesFALSE
1603_kdlxp_uncmplob data uncompressed - only on SecureFilesFALSE
1604_kdlxp_mincmplenminimum loblen to compress - only on SecureFiles200
1605_kdlxp_mincmpminimum comp ratio in pct - only on SecureFiles20
1606db_securefilepermit securefile storage during lob creationPERMITTED
1607_kdlxp_lobdeduplicateenable lob deduplication - only on SecureFilesFALSE
1608_kdlxp_lobdedupvalidateenable deduplicate validate - only on SecureFilesTRUE
1609_kdlxp_dedup_hash_algosecure hash algorithm for deduplication - only on SecureFilesSHA1
1610_kdlxp_dedup_flush_thresholddeduplication flush threshold in bytes8388608
1611_kdlxp_dedup_prefix_thresholddeduplication prefix hash threshold in bytes1048576
1612_kdlxp_dedup_inl_pctfreededuplication pct size increase by which inlining avoided5
1613_kdlxp_dedup_wapp_lendeduplication length to allow write-append0
1614_kdlxp_spare1deduplication spare 10
1615_securefile_timerscollect kdlu timers and accumulate per layersFALSE
1616_kdlu_trace_sessionUTS session dump0
1617_kdlu_trace_systemUTS system dump0
1618_kdlu_trace_layerUTS kdlu per-layer trace level0
1619_kdlu_max_bucket_sizeUTS kdlu bucket size4194304
1620_kdlu_max_bucket_size_mtsUTS kdlu bucket size for mts131072
1621_kdz_hcc_track_upd_ridsEnable rowid tracking during updatesTRUE
1622_kdz_hcc_flagsMiscellaneous HCC flags0
1623_row_cache_cursorsnumber of cached cursors for row cache management20
1624_kgl_cluster_lockLibrary cache support for cluster lockTRUE
1625_kgl_cluster_pinLibrary cache support for cluster pinsTRUE
1626_kgl_cluster_lock_read_mostlyLibrary cache support for cluster lock read mostly optimizationFALSE
1627_kgl_latch_countnumber of library cache latches0
1628_kgl_heap_sizeextent size for library cache heap 04096
1629_kgl_fixed_extentsfixed extent size for library cache memory allocationsTRUE
1630_kgl_bucket_countLibrary cache hash table bucket count (2^_kgl_bucket_count * 256)9
1631_library_cache_advicewhether KGL advice should be turned onTRUE
1632_kglsim_maxmem_percentmax percentage of shared pool size to be used for KGL advice5
1633_kgl_hash_collisionLibrary cache name hash collision possibleFALSE
1634_kgl_time_to_wait_for_lockstime to wait for locks and pins before timing out15
1635_kgl_large_heap_warning_thresholdmaximum heap size before KGL writes warnings to the alert log52428800
1636_synonym_repoint_tracingwhether to trace metadata comparisons for synonym repointingFALSE
1637_ignore_fg_depsignore fine-grain dependencies during invalidation
1638_trace_kqlidptrace kqlidp0 operationFALSE
1639_disable_fast_validatedisable PL/SQL fast validationFALSE
1640_kgl_message_locksRAC message lock count64
1641_kgl_debugLibrary cache debugging
1642_mutex_wait_timeMutex wait time1
1643_mutex_spin_countMutex spin count255
1644_mutex_wait_schemeMutex wait scheme2
1645_kgl_min_cached_so_countMinimum cached SO count. If > 1 can help find SO corruptions1
1646_kgl_hot_object_copiesNumber of copies for the hot object0
1647_kgl_kqr_cap_so_stackscapture stacks for library and row cache state objectsFALSE
1648_enable_kqf_purgeEnable KQF fixed runtime table purgeTRUE
1649create_stored_outlinescreate stored outlines for DML statements
1650_object_number_cache_sizeObject number cache size5
1651_enable_Front_End_View_Optimizationenable front end view optimization1
1652serial_reusereuse the frame segmentsdisable
1653_cursor_features_enabledShared cursor features enabled bits.2
1654_session_page_extentSession Page Extent Size2048
1655_cursor_runtimeheap_memlimitShared cursor runtime heap memory limit5242880
1656_kks_cached_parse_errorsKKS cached parse errors0
1657_kgx_latches# of mutex latches if CAS is not supported.1024
1658_cursor_stats_enabledEnable cursor statsTRUE
1659_enable_editions_for_usersenable editions for all usersFALSE
1660ldap_directory_accessRDBMS's LDAP access optionNONE
1661ldap_directory_sysauthOID usage parameterno
1662os_rolesretrieve roles from the operating systemFALSE
1663rdbms_server_dnRDBMS's Distinguished Name
1664max_enabled_rolesmax number of roles a user can have enabled150
1665remote_os_authentallow non-secure remote clients to use auto-logon accountsFALSE
1666remote_os_rolesallow non-secure remote clients to use os rolesFALSE
1667_case_sensitive_logoncase sensitive logon enabledTRUE
1668sec_case_sensitive_logoncase sensitive password enabled for logonTRUE
1669O7_DICTIONARY_ACCESSIBILITYVersion 7 Dictionary Accessibility SupportTRUE
1670_passwordfile_enqueue_timeoutpassword file enqueue timeout in seconds900
1671remote_login_passwordfilepassword file usage parameterEXCLUSIVE
1672license_max_usersmaximum number of named users that can be created in the database0
1673_dynamic_rls_policiesrls policies are dynamicTRUE
1674_app_ctx_versenable app ctx versioningFALSE
1675_session_context_sizesession app context size10000
1676audit_sys_operationsenable sys auditingFALSE
1677_default_encrypt_algdefault encryption algorithm0
1678_ols_cleanup_taskClean up unnecessary entries in OLS sessinfo tableTRUE
1679global_context_pool_sizeGlobal Application Context Pool Size in Bytes
1680_select_any_dictionary_security_enabledExclude user$ from SELECT ANY DICTIONARY system privilegeFALSE
1681_fusion_securityFusion SecurityFALSE
1682db_domaindirectory part of global database name stored with CREATE DATABASElhr.com
1683global_namesenforce that database links have same name as remote databaseFALSE
1684distributed_lock_timeoutnumber of seconds a distributed transaction waits for a lock60
1685_distributed_recovery_connection_hold_timenumber of seconds RECO holds outbound connections open200
1686commit_point_strengthBias this node has toward not preparing in a two-phase commit1
1687_k2q_latchesnumber of k2q latches0
1688_clusterwide_global_transactionsenable/disable clusterwide global transactionsTRUE
1689global_txn_processesnumber of background global transaction processes to start1
1690_autotune_gtx_thresholdauto-tune threshold for degree of global transaction concurrency60
1691_forwarded_2pc_thresholdauto-tune threshold for two-phase commit rate across RAC instances10
1692_disable_autotune_gtxdisable autotune global transaction background processesFALSE
1693_autotune_gtx_intervalinterval to autotune global transaction background processes5
1694_autotune_gtx_idle_timeidle time to trigger auto-shutdown a gtx background process600
1695_enable_separable_transactionsenable/disable separable transactionsFALSE
1696instance_nameinstance name supported by the instanceORCLASM
1697service_namesservice names supported by the instanceorclasm.lhr.com, orclasm
1698__dg_broker_service_namesservice names for broker use
1699dispatchersspecifications of dispatchers(PROTOCOL=TCP) (SERVICE=orclasmXDB)
1700shared_serversnumber of shared servers to start up1
1701max_shared_serversmax number of shared servers
1702max_dispatchersmax number of dispatchers
1703circuitsmax number of circuits
1704shared_server_sessionsmax number of shared server sessions
1705local_listenerlocal listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))))
1706remote_listenerremote listener
1707listener_networkslistener registration networks
1708_pmon_load_constantsserver load balancing constants (S,P,D,I,L,C,M)300,192,64,3,10,10,0,0
1709_dispatcher_rate_ttltime-to-live for rate statistic (100ths of a second)
1710_dispatcher_rate_scalescale to display rate statistic (100ths of a second)
1711_enable_shared_server_vector_ioEnable shared server vector I/OFALSE
1712_shared_server_load_balanceshared server load balance0
1713_shared_server_num_queuesnumber of shared server common queues2
1714_kernel_message_network_driverkernel message network driverFALSE
1715_dedicated_server_poll_countdedicated server poll count10
1716_dedicated_server_post_wait_calldedicated server post/wait callFALSE
1717_dedicated_server_post_waitdedicated server post/waitFALSE
1718_cp_num_hash_latchesconnection pool number of hash latches1
1719_connection_broker_hostconnection broker host for listen address
1720_fast_cursor_reexecuteuse more memory in order to get faster executionFALSE
1721cursor_space_for_timeuse more memory in order to get faster executionFALSE
1722session_cached_cursorsNumber of cursors to cache in a session.50
1723_cursor_obsolete_thresholdNumber of cursors per parent before obsoletion.100
1724_disable_cursor_sharingdisable cursor sharingFALSE
1725_dump_qbc_treedump top level query parse tree to trace0
1726remote_dependencies_moderemote-procedure-call dependencies mode parameterTIMESTAMP
1727utl_file_dirutl_file accessible directories list/home/oracle/
1728smtp_out_serverutl_smtp server and port configuration parameter
1729_plsql_dump_buffer_eventsconditions upon which the PL/SQL circular buffer is dumped
1730plsql_v2_compatibilityPL/SQL version 2.x compatibility flagFALSE
1731_ncomp_shared_objects_dirnative compilation shared objects dir
1732plsql_warningsPL/SQL compiler warnings settingsDISABLE:ALL
1733plsql_code_typePL/SQL code-typeINTERPRETED
1734_plsql_anon_block_code_typePL/SQL anonymous block code-typeINTERPRETED
1735plsql_debugPL/SQL debugFALSE
1736plsql_optimize_levelPL/SQL optimize level1
1737plsql_ccflagsPL/SQL ccflags
1738_inline_sql_in_plsqlinline SQL in PL/SQLFALSE
1739plscope_settingsplscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier dataidentifiers:none
1740_plsql_native_frame_thresholdAllocate PL/SQL native frames on the heap if size exceeds this value4294967294
1741_plsql_nvl_optimizePL/SQL NVL optimizeFALSE
1742_plsql_max_stack_sizePL/SQL maximum stack size0
1743permit_92_wrap_formatallow 9.2 or older wrap format in PL/SQLTRUE
1744java_jit_enabledJava VM JIT enabledTRUE
1745job_queue_processesmaximum number of job queue slave processes500
1746_job_queue_intervalWakeup interval in seconds for job queue co-ordinator5
1747_dbms_sql_security_levelSecurity level in DBMS_SQL1
1748parallel_min_percentminimum percent of threads required for parallel query0
1749_parallel_default_max_instancesdefault maximum number of instances for parallel query1
1750_system_trig_enabledare system triggers enabledTRUE
1751create_bitmap_area_sizesize of create bitmap buffer for bitmap index8388608
1752bitmap_merge_area_sizemaximum memory allow for BITMAP MERGE1048576
1753_kkfi_tracetrace expression substitutionFALSE
1754cursor_sharingcursor sharing modeEXACT
1755_adjust_literal_replacementIf TRUE, we will adjust the SQL/PLUS outputFALSE
1756_kolfuseslfallow kolf to use slffopenFALSE
1757result_cache_moderesult cache operator usage modeMANUAL
1758_result_cache_auto_size_thresholdresult cache auto max size allowed100
1759_result_cache_auto_time_thresholdresult cache auto time threshold1000
1760_result_cache_auto_execution_thresholdresult cache auto execution threshold1
1761_session_cached_instantiationsNumber of pl/sql instantiations to cache in a session.60
1762_protect_frame_heapsProtect cursor frame heapsFALSE
1763_frame_cache_timenumber of seconds a cached frame page stay in cache.0
1764_cursor_cache_timenumber of seconds a session cached cursor stay in cache.900
1765_aged_out_cursor_cache_timenumber of seconds an aged out session cached cursor stay in cache300
1766_px_tracepx trace parameternone
1767_xt_traceexternal tables trace parameternone
1768_xt_coverageexternal tables code coverage parameternone
1769_ku_tracedatapump trace parameternone
1770_optimizer_traceoptimizer trace parameternone
1771parallel_min_serversminimum parallel query servers per instance0
1772parallel_max_serversmaximum parallel query servers per instance80
1773_parallel_server_idle_timeidle time before parallel query server dies (in 1/100 sec)30000
1774_parallel_server_sleep_timesleep time between dequeue timeouts (in 1/100ths)10
1775_px_send_timeoutIPC message send timeout value in seconds300
1776_dynamic_stats_thresholddelay threshold (in seconds) between sending statistics messages30
1777parallel_instance_groupinstance group to use for all parallel operations
1778_px_execution_services_enabledenable service-based constraint of px slave allocationTRUE
1779_parallel_fake_class_pctfake db-scheduler percent used for testing0
1780_px_load_publish_intervalinterval at which LMON will check whether to publish PX load200
1781parallel_execution_message_sizemessage buffer size for parallel execution16384
1782_parallel_execution_message_alignAlignment of PX buffers to OS page boundaryFALSE
1783_PX_use_large_poolUse Large Pool as source of PX buffersFALSE
1784_parallel_min_message_poolminimum size of shared pool memory to reserve for pq servers491520
1785_px_buffer_ttlttl for px mesg buffers in seconds30
1786_tq_dump_periodtime period for duping of TQ statistics (s)0
1787_affinity_onenable/disable affinity at run timeTRUE
1788_enable_default_affinityenable default implementation of hard affinity osds0
1789_px_max_map_valMaximum value of rehash mapping for PX32
1790_dss_cache_flushenable full cache flush for parallel executionFALSE
1791_hash_join_enabledenable/disable hash joinTRUE
1792hash_area_sizesize of in-memory hash work area131072
1793_hash_multiblock_io_countnumber of blocks hash join will read/write at once0
1794_cursor_db_buffers_pinnedadditional number of buffers a cursor can pin at once80
1795_old_connect_by_enabledenable/disable old connect byFALSE
1796_table_lookup_prefetch_sizetable lookup prefetch vector size40
1797_multi_join_key_table_lookupTRUE iff multi-join-key table lookup prefetch is enabledTRUE
1798_table_lookup_prefetch_threshtable lookup prefetch threshold2
1799_adaptive_fetch_enabledenable/disable adaptive fetch in parallel group byTRUE
1800_query_execution_cache_max_sizemax size of query execution cache131072
1801_fast_dual_enabledenable/disable fast dualTRUE
1802_newsort_enabledcontrols whether new sorts can be used as system sortTRUE
1803_newsort_typespecifies options for the new sort algorithm0
1804_newsort_ordered_pctcontrols when new sort avoids sorting ordered input63
1805_recursive_with_max_recursion_levelcheck for maximum level of recursion instead of checking for cycles0
1806_sort_spill_thresholdforce sort to spill to disk each time this many rows are received0
1807_queue_buffer_max_dump_lenmax number of bytes to dump to trace file for queue buffer dump65536
1808_force_hash_join_spillforce hash join to spill to diskFALSE
1809_nlj_batching_ae_flagFAE flag type set after restoring to IO batching buffer2
1810_fix_controlbug fix control parameter
1811_sdiag_crashsql diag crashNONE
1812result_cache_max_sizemaximum amount of memory to be used by the cache2883584
1813result_cache_max_resultmaximum result size as percent of cache size5
1814result_cache_remote_expirationmaximum life time (min) for any result using a remote object0
1815_result_cache_block_sizeresult cache block size1024
1816_result_cache_copy_block_countblocks to copy instead of pinning the result1
1817_result_cache_globalAre results available globally across RAC?TRUE
1818_result_cache_timeoutmaximum time (sec) a session waits for a result10
1819_result_cache_auto_time_distanceresult cache auto time distance300
1820_result_cache_auto_dml_monitoring_slotsresult cache auto dml monitoring slot4
1821_result_cache_auto_dml_monitoring_durationresult cache auto dml monitoring duration15
1822_result_cache_auto_dml_thresholdresult cache auto dml threshold16
1823_result_cache_auto_dml_trend_thresholdresult cache auto dml trend threshold20
1824_parallel_queuing_max_waitingtimeparallel statement queuing: max waiting time in queue
1825_oss_skgxp_udp_dynamic_credit_mgmtOSSLIB enable[!0]/disable[0] dynamic credit mgmt for SKGXP-UDP1
1826shadow_core_dumpCore Size for Shadow ProcessesPARTIAL
1827background_core_dumpCore Size for Background Processespartial
1828background_dump_destDetached process dump directory/u01/app/oracle/diag/rdbms/orclasm/orclasm/trace
1829user_dump_destUser process dump directory/u01/app/oracle/diag/rdbms/orclasm/orclasm/trace
1830core_dump_destCore dump directory/u01/app/oracle/diag/rdbms/orclasm/orclasm/cdump
1831_oradbg_pathnamepath of oradbg script
1832_shmprotectallow mprotect use for shared memory0
1833_online_patch_disable_stack_checkdisable check for function on stack for online patchesFALSE
1834_vendor_lib_locVendor library search root directory
1835_disable_sun_rsmDisable IPC OSD support for Sun RSMAPITRUE
1836_ipc_test_failoverTest transparent cluster network failover0
1837_ipc_test_mult_netssimulate multiple cluster networks0
1838_ipc_fail_networkSimulate cluster network failer0
1839audit_file_destDirectory in which auditing files are to reside/u01/app/oracle/admin/orclasm/adump
1840audit_syslog_levelSyslog facility and level
1841_sem_per_semidthe exact number of semaphores per semaphore set to allocate
1842_ops_per_semopthe exact number of operations per semop system call
1843_linux_prepage_large_pagesprepage large pages during allocation on LinuxFALSE
1844_disable_streams_diagnosticsstreams diagnostics0
1845_max_aq_persistent_queue_memorymax aq persistent queue memory10
1846object_cache_optimal_sizeoptimal size of the user session's object cache in bytes102400
1847object_cache_max_size_percentpercentage of maximum size over optimal of the user session's object cache10
1848_no_objectsno object features are usedFALSE
1849_kokli_cache_sizeSize limit of ADT Table Lookup Cache128
1850_kokln_current_readMake all LOB reads for this session 'current' readsFALSE
1851session_max_open_filesmaximum number of open files allowed per session10
1852_domain_index_batch_sizemaximum number of rows from one call to domain index fetch routine2000
1853_domain_index_dml_batch_sizemaximum number of rows for one call to domain index dml routines200
1854_nchar_imp_convshould implicit conversion bewteen clob and nclob be allowedTRUE
1855_insert_enable_hwm_brokeredduring parallel inserts high water marks are brokeredTRUE
1856_pgactx_cap_stackscapture stacks for setting pgactxFALSE
1857open_linksmax # open links per session4
1858open_links_per_instancemax # open links per instance4
1859_all_shared_dblinkstreat all dblinks as shared
1860_close_cached_open_cursorsclose cursors cached by PL/SQL at each commitFALSE
1861_disable_savepoint_resetdisable the fix for bug 1402161FALSE
1862commit_writetransaction commit log write behaviour
1863commit_waittransaction commit log wait behaviour
1864commit_loggingtransaction commit log write behaviour
1865_init_sql_fileFile containing SQL statements to execute upon database creation?/rdbms/admin/sql.bsq
1866optimizer_features_enableoptimizer plan compatibility parameter11.2.0.3
1867fixed_datefixed SYSDATE value
1868audit_trailenable system auditingDB
1869sort_area_sizesize of in-memory sort work area65536
1870sort_area_retained_sizesize of in-memory sort work area retained between fetch calls0
1871_sort_multiblock_read_countmulti-block read count for sort2
1872_shrunk_aggs_enabledenable use of variable sized buffers for non-distinct aggregatesTRUE
1873_sql_ncg_modeOptimization mode for SQL NCGOFF
1874_cell_storidx_modeCell Storage Index modeEVA
1875_deferred_constant_folding_modeDeferred constant folding modeDEFAULT
1876_rdbms_internal_fplib_raise_errorsenable reraising of any exceptions in CELL FPLIBFALSE
1877_rdbms_internal_fplib_enabledenable CELL FPLIB filtering within rdbmsFALSE
1878_cell_index_scan_enabledenable CELL processing of index FFSTRUE
1879_cell_range_scan_enabledenable CELL processing of index range scansTRUE
1880_cell_offload_virtual_columnsenable offload of predicates on virtual columns to cellsTRUE
1881_cell_offload_predicate_reordering_enabledenable out-of-order SQL processing offload to cellsFALSE
1882_cell_offload_timezoneenable timezone related SQL processing offload to cellsTRUE
1883_direct_read_decision_statistics_drivenenable direct read decision based on optimizer statisticsTRUE
1884cell_offload_processingenable SQL processing offload to cellsTRUE
1885cell_offload_decryptionenable SQL processing offload of encrypted data to cellsTRUE
1886cell_offload_parametersAdditional cell offload parameters
1887cell_offload_compactionCell packet compaction strategyADAPTIVE
1888cell_offload_plan_displayCell offload explain plan displayAUTO
1889_shrunk_aggs_disable_thresholdpercentage of exceptions at which to switch to full length aggs60
1890_gby_onekey_enabledenable use of one comparison of all group by keysTRUE
1891db_namedatabase name specified in CREATE DATABASEorclasm
1892db_unique_nameDatabase Unique Nameorclasm
1893open_cursorsmax # cursors per session65535
1894ifileinclude file in init.ora
1895sql_traceenable SQL traceFALSE
1896os_authent_prefixprefix for auto-logon accountsops$
1897_sql_connect_capability_tableSQL Connect Capability Table (testing only)
1898optimizer_modeoptimizer modeALL_ROWS
1899_optimizer_mode_forceforce setting of optimizer mode for user recursive SQL alsoTRUE
1900_explain_rewrite_modeallow additional messages to be generated during explain rewriteFALSE
1901_query_rewrite_or_errorallow query rewrite, if referenced tables are not datalessFALSE
1902_sort_elimination_cost_ratiocost ratio for sort eimination under first_rows mode0
1903sql92_securityrequire select privilege for searched update/deleteFALSE
1904_sql_connect_capability_overrideSQL Connect Capability Table Override0
1905blank_trimmingblank trimming semantics parameterFALSE
1906_always_anti_joinalways use this method for anti-join when possibleCHOOSE
1907_optimizer_null_aware_antijoinnull-aware antijoin parameterTRUE
1908_partition_view_enabledenable/disable partitioned viewsTRUE
1909_always_star_transformationalways favor use of star transformationFALSE
1910_b_tree_bitmap_plansenable the use of bitmap plans for tables w. only B-tree indexesTRUE
1911star_transformation_enabledenable the use of star transformationFALSE
1912_column_elimination_offturn off predicate-only column eliminationFALSE
1913_cpu_to_iodivisor for converting CPU cost to I/O cost0
1914_optimizer_extended_cursor_sharingoptimizer extended cursor sharingUDO
1915_optimizer_extended_cursor_sharing_reloptimizer extended cursor sharing for relational operatorsSIMPLE
1916_optimizer_adaptive_cursor_sharingoptimizer adaptive cursor sharingTRUE
1917_optimizer_cost_modeloptimizer cost modelCHOOSE
1918_optimizer_undo_cost_changeoptimizer undo cost change11.2.0.3
1919_optimizer_system_stats_usagesystem statistics usageTRUE
1920_optimizer_cache_statscost with cache statisticsFALSE
1921_new_sort_cost_estimateenables the use of new cost estimate for sortTRUE
1922_complex_view_mergingenable complex view mergingTRUE
1923_simple_view_mergingcontrol simple view merging performed by the optimizerTRUE
1924_unnest_subqueryenables unnesting of complex subqueriesTRUE
1925_optimizer_unnest_all_subqueriesenables unnesting of every type of subqueryTRUE
1926_eliminate_common_subexprenables elimination of common sub-expressionsTRUE
1927_pred_move_aroundenables predicate move-aroundTRUE
1928_convert_set_to_joinenables conversion of set operator to joinFALSE
1929_px_bind_peek_sharingenables sharing of px cursors that were built using bind peekingTRUE
1930_px_ual_serial_inputenables new pq for UNION operatorsTRUE
1931_px_minus_intersectenables pq for minus/interect operatorsTRUE
1932_remove_aggr_subqueryenables removal of subsumed aggregated subqueryTRUE
1933_distinct_view_unnestingenables unnesting of in subquery into distinct viewFALSE
1934_optimizer_push_down_distinctpush down distinct from query block to table0
1935_optimizer_cost_based_transformationenables cost-based query transformationLINEAR
1936_optimizer_squ_bottomupenables unnesting of subquery in a bottom-up mannerTRUE
1937_optimizer_cbqt_factorcost factor for cost-based query transformation50
1938_push_join_predicateenable pushing join predicate inside a viewTRUE
1939_push_join_union_viewenable pushing join predicate inside a union all viewTRUE
1940_push_join_union_view2enable pushing join predicate inside a union viewTRUE
1941_fast_full_scan_enabledenable/disable index fast full scanTRUE
1942_optimizer_skip_scan_enabledenable/disable index skip scanTRUE
1943_optimizer_join_sel_sanity_checkenable/disable sanity check for multi-column join selectivityTRUE
1944_optim_enhance_nnull_detectionTRUE to enable index [fast] full scan more oftenTRUE
1945_idl_conventional_index_maintenanceenable conventional index maintenance for insert direct loadTRUE
1946_enable_cscn_cachingenable commit SCN caching for all transactionsFALSE
1947_parallel_broadcast_enabledenable broadcasting of small inputs to hash and sort merge joinsTRUE
1948_px_broadcast_fudge_factorset the tq broadcasting fudge factor percentage100
1949_px_kxib_tracingturn on kxib tracing0
1950_px_granule_sizedefault size of a rowid range granule (in KB)1000000
1951_px_xtgranule_sizedefault size of a external table granule (in KB)10000
1952_xtbuffer_sizebuffer size in KB needed for populate/query operation0
1953parallel_degree_policypolicy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)MANUAL
1954_px_async_getgranuleasynchronous get granule in the slaveFALSE
1955_px_min_granules_per_slaveminimum number of rowid range granules to generate per slave13
1956_px_max_granules_per_slavemaximum number of rowid range granules to generate per slave100
1957_px_no_stealingprevent parallel granule stealing in shared nothing environmentFALSE
1958_px_no_granule_sortprevent parallel partition granules to be sorted on sizeFALSE
1959_px_proc_constrainreduce parallel_max_servers if greater than (processes - fudge)TRUE
1960_px_freelist_latch_divisorDivide the computed number of freelists by this power of 22
1961parallel_adaptive_multi_userenable adaptive setting of degree for multiple user streamsTRUE
1962parallel_threads_per_cpunumber of parallel execution threads per CPU2
1963parallel_automatic_tuningenable intelligent defaults for parallel execution parametersFALSE
1964_parallel_adaptive_max_usersmaximum number of users running with default DOP4
1965_parallel_cluster_cache_policypolicy used for parallel execution on cluster(ADAPTIVE/CACHED)ADAPTIVE
1966_parallel_load_balancingparallel execution load balanced slave allocationTRUE
1967_parallel_load_bal_unitnumber of threads to allocate per instance0
1968_parallel_slave_acquisition_waittime(in seconds) to wait before retrying slave acquisition1
1969parallel_io_cap_enabledenable capping DOP by IO bandwidthFALSE
1970_px_io_system_bandwidthtotal IO system bandwidth in MB/sec for computing DOP0
1971_px_io_process_bandwidthIO process bandwidth in MB/sec for computing DOP200
1972_pdml_slaves_diff_partslaves start on different partition when doing index maintTRUE
1973_pdml_gim_samplingcontrol separation of global index maintenance for PDML5000
1974_pdml_gim_staggeredslaves start on different index when doing index maintFALSE
1975_px_dynamic_optturn off/on restartable qerpx dynamic optimizationTRUE
1976_px_dynamic_sample_sizenum of samples for restartable qerpx dynamic optimization50
1977_px_rownum_pdturn off/on parallel rownum pushdown optimizationTRUE
1978_predicate_elimination_enabledallow predicate elimination if set to TRUETRUE
1979_groupby_nopushdown_cut_ratiogroupby nopushdown cut ratio3
1980_groupby_orderby_combinegroupby/orderby don't combine threshold5000
1981_temp_tran_block_thresholdnumber of blocks for a dimension before we temp transform100
1982_temp_tran_cachedetermines if temp table is created with cache optionTRUE
1983_ordered_semijoinenable ordered semi-join subqueryTRUE
1984_always_semi_joinalways use this method for semi-join when possibleCHOOSE
1985_ordered_nested_loopenable ordered nested loop costingTRUE
1986_nested_loop_fudgenested loop fudge100
1987_project_view_columnsenable projecting out unreferenced columns of a viewTRUE
1988_no_or_expansionOR expansion during optimization disabledFALSE
1989_optimizer_max_permutationsoptimizer maximum join permutations per query block2000
1990optimizer_index_cost_adjoptimizer index cost adjustment100
1991optimizer_index_cachingoptimizer percent index caching0
1992_system_index_cachingoptimizer percent system index caching0
1993_serial_direct_readenable direct read in serialauto
1994_disable_datalayer_samplingdisable datalayer samplingFALSE
1995_disable_sample_io_optimdisable row sampling IO optimizationFALSE
1996_sample_rows_per_blocknumber of rows per block used for sampling IO optimization4
1997_ncmb_readahead_enabledenable multi-block readahead for an index scan0
1998_ncmb_readahead_tracingturn on multi-block readahead tracing0
1999_nlj_batching_enabledenable batching of the RHS IO in NLJ1
2000_nlj_batching_misses_enabledenable exceptions for buffer cache misses1
2001_ioq_fanin_multiplierIOQ miss count before a miss exception2
2002_index_prefetch_factorindex prefetching factor100
2003query_rewrite_enabledallow rewrite of queries using materialized views if enabledTRUE
2004query_rewrite_integrityperform rewrite using materialized views with desired integrityenforced
2005_query_cost_rewriteperform the cost based rewrite with materialized viewsTRUE
2006_query_rewrite_2perform query rewrite before&after or only after view mergingTRUE
2007_query_rewrite_1perform query rewrite before&after or only before view mergingTRUE
2008_query_rewrite_fudgecost based query rewrite with MVs fudge factor90
2009_query_rewrite_expressionrewrite with cannonical form for expressionsTRUE
2010_query_rewrite_jgmigratemv rewrite with jg migrationTRUE
2011_query_rewrite_fpcmv rewrite fresh partition containmentTRUE
2012_query_rewrite_drjmv rewrite and drop redundant joinsTRUE
2013_query_rewrite_maxdisjunctquery rewrite max disjuncts257
2014_query_rewrite_vop_cleanupprune frocol chain before rewrite after view-mergingTRUE
2015_mmv_query_rewrite_enabledallow rewrites with multiple MVs and/or base tablesTRUE
2016_bt_mmv_query_rewrite_enabledallow rewrites with multiple MVs and base tablesTRUE
2017_add_stale_mv_to_dependency_listadd stale mv to dependency listTRUE
2018_max_rwgs_groupingsmaximum no of groupings on materialized views8192
2019_full_pwise_join_enabledenable full partition-wise join when TRUETRUE
2020_partial_pwise_join_enabledenable partial partition-wise join when TRUETRUE
2021_slave_mapping_enabledenable slave mapping when TRUETRUE
2022_slave_mapping_group_sizeforce the number of slave group in a slave mapper0
2023_local_communication_costing_enabledenable local communication costing when TRUETRUE
2024_local_communication_ratioset the ratio between global and local communication (0..100)50
2025_parallelism_cost_fudge_factorset the parallelism cost fudge factor350
2026_left_nested_loops_randomenable random distribution method for left of nestedloopsTRUE
2027_improved_row_length_enabledenable the improvements for computing the average row lengthTRUE
2028_px_index_samplingparallel query sampling for index create (100000 = 100%)200
2029_index_join_enabledenable the use of index joinsTRUE
2030_use_nosegment_indexesuse nosegment indexes in explain planFALSE
2031_enable_type_dep_selectivityenable type dependent selectivity estimatesTRUE
2032_sqlexec_progression_costsql execution progression monitoring cost threshold1000
2033_improved_outerjoin_cardimproved outer-join cardinality calculationTRUE
2034_optimizer_adjust_for_nullsadjust selectivity for null valuesTRUE
2035_optimizer_degreeforce the optimizer to use the same degree of parallelism0
2036_use_column_stats_for_functionenable the use of column statistics for DDP functionsTRUE
2037_subquery_pruning_cost_factorsubquery pruning cost factor20
2038_subquery_pruning_reductionsubquery pruning reduction factor50
2039_subquery_pruning_enabledenable the use of subquery predicates to perform pruningTRUE
2040_subquery_pruning_mv_enabledenable the use of subquery predicates with MVs to perform pruningFALSE
2041_parallel_txn_globalenable parallel_txn hint with updates and deletesFALSE
2042_or_expand_nvl_predicateenable OR expanded plan for NVL/DECODE predicateTRUE
2043_like_with_bind_as_equalitytreat LIKE predicate with bind as an equality predicateFALSE
2044_table_scan_cost_plus_onebump estimated full table scan and index ffs cost by oneTRUE
2045_cost_equality_semi_joinenables costing of equality semi-joinTRUE
2046_default_non_equality_sel_checksanity check on default selectivity for like/range predicateTRUE
2047_new_initial_join_ordersenable initial join orders based on new ordering heuristicsTRUE
2048_oneside_colstat_for_equijoinssanity check on default selectivity for like/range predicateTRUE
2049_column_tracking_levelcolumn usage tracking1
2050_optim_peek_user_bindsenable peeking of user bindsTRUE
2051_mv_refresh_selectionscreate materialized views with selections and fast refreshTRUE
2052_cursor_plan_enabledenable collection and display of cursor plansTRUE
2053_minimal_stats_aggregationprohibit stats aggregation at compile/partition maintenance timeTRUE
2054_mv_refresh_eutrefresh materialized views using EUT(partition)-based algorithmTRUE
2055_mav_refresh_consistent_readrefresh materialized views using consistent read snapshotTRUE
2056_mav_refresh_optoptimizations during refresh of materialized views0
2057_mav_refresh_unionall_tables# tables for union all expansion during materialized view refresh3
2058_mv_refresh_delta_fractiondelta mv as fractional percentage of size of mv10
2059_force_temptables_for_gsetsexecutes concatenation of rollups using temp tablesFALSE
2060pga_aggregate_targetTarget size for the aggregate PGA memory consumed by the instance134217728
2061__pga_aggregate_targetCurrent target size for the aggregate PGA memory consumed134217728
2062_pga_max_sizeMaximum size of the PGA memory for one process209715200
2063workarea_size_policypolicy used to size SQL working areas (MANUAL/AUTO)AUTO
2064_smm_auto_min_io_sizeMinimum IO size (in KB) used by sort/hash-join in auto mode56
2065_smm_auto_max_io_sizeMaximum IO size (in KB) used by sort/hash-join in auto mode248
2066_smm_auto_cost_enabledif TRUE, use the AUTO size policy cost functionsTRUE
2067_smm_controlprovides controls on the memory manager0
2068_smm_traceTurn on/off tracing for SQL memory manager0
2069_smm_min_sizeminimum work area size in auto mode131
2070_smm_max_sizemaximum work area size in auto mode (serial)26214
2071_smm_px_max_sizemaximum work area size in auto mode (global)65536
2072_smm_retain_sizework area retain size in SGA for shared server sessions (0 for AUTO)0
2073_smm_boundoverwrites memory manager automatically computed bound0
2074_smm_advice_log_sizeoverwrites default size of the PGA advice workarea history log0
2075_smm_advice_enabledif TRUE, enable v$pga_adviceTRUE
2076_gs_anti_semi_join_allowedenable anti/semi join for the GS queryTRUE
2077_mv_refresh_use_statspass cardinality hints to refresh queriesFALSE
2078_mv_refresh_use_no_mergeuse no_merge hint in queriesTRUE
2079_mv_refresh_use_hash_sjuse hash_sj hint in queriesTRUE
2080_mv_refresh_no_idx_rebuildavoid index rebuild as part of the MV refreshFALSE
2081_optim_new_default_join_selimproves the way default equijoin selectivity are computedTRUE
2082_optimizer_dyn_smp_blksnumber of blocks for optimizer dynamic sampling32
2083optimizer_dynamic_samplingoptimizer dynamic sampling2
2084_pre_rewrite_push_predpush predicates into views before rewriteTRUE
2085_optimizer_new_join_card_computationcompute join cardinality using non-rounded input valuesTRUE
2086_mav_refresh_double_count_preventedmaterialized view MAV refreshes avoid double countingFALSE
2087_pct_refresh_double_count_preventedmaterialized view PCT refreshes avoid double countingTRUE
2088_mv_refresh_new_setup_disabledmaterialized view MV refresh new setup disablingFALSE
2089_load_without_compileLoad PL/SQL or Database objects without compilationNONE
2090_precompute_gid_valuesprecompute gid values and copy them before returning a rowTRUE
2091_union_rewrite_for_gsexpand queries with GSets into UNIONs for rewriteYES_GSET_MVS
2092_nested_mv_fast_oncommit_enablednested MV refresh fast on commit allowedTRUE
2093_generalized_pruning_enabledcontrols extensions to partition pruning for general predicatesTRUE
2094_rowsource_execution_statisticsif TRUE, Oracle will collect rowsource statisticsFALSE
2095_rowsource_profiling_statisticsif TRUE, Oracle will capture active row sources in v$active_session_historyTRUE
2096_rowsource_statistics_sampfreqfrequency of rowsource statistic sampling (must be a power of 2)128
2097_bitmap_or_improvement_enabledcontrols extensions to partition pruning for general predicatesTRUE
2098_intrapart_pdml_enabledEnable intra-partition updates/deletesTRUE
2099_force_tmp_segment_loadsForce tmp segment loadsFALSE
2100_force_slave_mapping_intra_part_loadsForce slave mapping for intra partition loadsFALSE
2101_intrapart_pdml_randomlocal_enabledEnable intra-partition updates/deletes with random local distTRUE
2102_optim_adjust_for_part_skewsadjust stats for skews across partitionsTRUE
2103_optimizer_compute_index_statsforce index stats collection on index creation/rebuildTRUE
2104_optimizer_autostats_jobenable/disable auto stats collection jobTRUE
2105_optimizer_push_pred_cost_baseduse cost-based query transformation for push pred optimizationTRUE
2106_optimizer_extend_jppd_view_typesjoin pred pushdown on group-by, distinct, semi-/anti-joined viewTRUE
2107_optimizer_filter_pred_pullupuse cost-based flter predicate pull up transformationTRUE
2108_optimizer_connect_by_cost_baseduse cost-based transformation for connect byTRUE
2109_optimizer_connect_by_combine_swcombine no filtering connect by and start withTRUE
2110_optimizer_connect_by_elim_dupsallow connect by to eliminate duplicates from inputTRUE
2111_connect_by_use_union_alluse union all for connect byTRUE
2112_force_datefold_truncforce use of trunc for datefolding rewriteFALSE
2113statistics_levelstatistics levelTYPICAL
2114_array_update_vector_read_enabledEnable array update vector readFALSE
2115_two_pass_reverse_polish_enableduses two-pass reverse polish alg. to generate canonical formsTRUE
2116_expand_aggregatesexpand aggregatesTRUE
2117_dump_common_subexpressionsdump common subexpressionsFALSE
2118_spr_use_hash_tableuse hash table for spreadsheetFALSE
2119_spr_use_AW_ASenable AW for hash table in spreadsheetTRUE
2120_dump_connect_by_loop_datadump connect by loop error message into trc fileFALSE
2121_column_compression_factorColumn compression ratio0
2122_dml_monitoring_enabledenable modification monitoringTRUE
2123_px_slaves_share_cursorsslaves share cursors with QC0
2124_fic_algorithm_setSet Frequent Itemset Counting Algorithmautomatic
2125_fic_area_sizesize of Frequent Itemset Counting work area131072
2126_fic_max_lengthFrequent Itemset Counting Maximum Itemset Length20
2127_fic_min_bmsizeFrequent Itemset Counting Minimum BITMAP Size1024
2128_dtree_area_sizesize of Decision Tree Classification work area131072
2129_dtree_pruning_enabledDecision Tree Pruning EnabledTRUE
2130_dtree_compressbmp_enabledDecision Tree Using Compressed Bitmaps EnabledTRUE
2131_dtree_binning_enabledDecision Tree Binning EnabledTRUE
2132_dtree_max_surrogatesmaximum number of surrogates1
2133_dtree_bintest_idDecision Tree Binning Test ID0
2134_right_outer_hash_enableRight Outer/Semi/Anti Hash EnabledTRUE
2135_optimizer_mjc_enabledenable merge join cartesianTRUE
2136_optimizer_sortmerge_join_enabledenable/disable sort-merge join methodTRUE
2137_cursor_bind_capture_area_sizemaximum size of the cursor bind capture area400
2138cursor_bind_capture_destinationAllowed destination for captured bind variablesmemory+disk
2139_flush_plan_in_awr_sqlPlan is being flushed from an AWR flush SQL0
2140_cursor_bind_capture_intervalinterval (in seconds) between two bind capture for a cursor900
2141_dump_cursor_heap_sizesdump comp/exec heap sizes to tryace fileFALSE
2142_projection_pushdownprojection pushdownTRUE
2143_projection_pushdown_debuglevel for projection pushdown debugging0
2144_px_compilation_debugdebug level for parallel compilation0
2145_px_compilation_tracetracing level for parallel compilation0
2146_trace_virtual_columnstrace virtual columns exprsFALSE
2147_replace_virtual_columnsreplace expressions with virtual columnsTRUE
2148_virtual_column_overload_allowedoverload virtual columns expressionTRUE
2149_kdt_bufferingcontrol kdt buffering for conventional insertsTRUE
2150_disable_parallel_conventional_loadDisable parallel conventional loadsFALSE
2151_ltc_tracetracing level for load table conventional0
2152_fic_outofmem_candidatesFrequent Itemset Counting Out Of Memory Candidates GenerationFALSE
2153_print_refresh_scheduleenable dbms_output of materialized view refresh schedulefalse
2154_optimizer_undo_changesundo changes to query optimizerFALSE
2155_optimizer_percent_paralleloptimizer percent parallel101
2156_optimizer_search_limitoptimizer search limit5
2157skip_unusable_indexesskip unusable indexes if set to TRUETRUE
2158_mv_refresh_costingrefresh decision based on cost or on rulesrule
2159_mv_refresh_anawhat percent to analyze after complete/PCT refresh0
2160_cache_stats_monitorif TRUE, enable cache stats monitoringFALSE
2161_sta_controlSQL Tuning Advisory control parameter0
2162_enable_automatic_sqltuneAutomatic SQL Tuning Advisory enabled parameterTRUE
2163_sql_analyze_enable_auto_txnSQL Analyze Autonomous Transaction control parameterFALSE
2164_ds_enable_auto_txnDynamic Sampling Service Autonomous Transaction control parameterFALSE
2165_sql_analyze_parse_modelSQL Analyze Parse Model control parameter2
2166_ds_parse_modelDynamic Sampling Service Parse Model control parameter2
2167_kes_parse_modelSQL Tune/SPA KES Layer Parse Model control parameter2
2168_ds_iocount_iosizeDynamic Sampling Service defaults: #IOs and IO Size6553664
2169_mv_refsched_timeincrproportionality constant for dop vs. time in MV refresh300000
2170_spr_push_pred_refsprpush predicates through reference spreadsheetTRUE
2171_optimizer_block_sizestandard block size used by optimizer8192
2172_spr_max_rulesmaximum number of rules in sql spreadsheet10000
2173_idxrb_rowincrproportionality constant for dop vs. rows in index rebuild100000000
2174_hj_bit_filter_thresholdhash-join bit filtering threshold (0 always enabled)50
2175_optimizer_save_statsenable/disable saving old versions of optimizer statsTRUE
2176_optimizer_cost_filter_predenables costing of filter predicates in IO cost modelFALSE
2177_optimizer_correct_sq_selectivityforce correct computation of subquery selectivityTRUE
2178_allow_commutativityallow for commutativity of +, * when comparing expressionsTRUE
2179_mv_refresh_rebuild_percentageminimum percentage change required in MV to force an indexrebuild10
2180_qa_controlOracle internal parameter to control QA0
2181_qa_lrg_typeOracle internal parameter to specify QA lrg type0
2182_mv_refresh_force_parallel_queryforce materialized view refreshes to use parallel query0
2183_enable_fast_ref_after_mv_tbsenable fast refresh after move tablespaceFALSE
2184_optim_dict_stats_at_db_cr_upgenable/disable dictionary stats gathering at db create/upgradeTRUE
2185_optimizer_dim_subq_join_seluse join selectivity in choosing star transformation dimensionsTRUE
2186_optimizer_disable_strans_sanity_checksdisable star transformation sanity checks0
2187_allow_level_without_connect_byallow level without connect byFALSE
2188_optimizer_ignore_hintsenables the embedded hints to be ignoredFALSE
2189_optimizer_random_planoptimizer seed value for random plans0
2190_optimizer_ceil_costCEIL cost in CBOTRUE
2191_delay_index_maintaindelays index maintenance until after MV is refreshedTRUE
2192_query_rewrite_setopgrw_enableperform general rewrite using set operator summariesTRUE
2193_cursor_plan_hash_versionversion of cursor plan hash value1
2194_disable_function_based_indexdisable function-based index matchingFALSE
2195_optimizer_invalidation_periodtime window for invalidation of cursors of analyzed objects18000
2196_px_net_msg_costCPU cost to send a PX message over the internconnect10000
2197_px_loc_msg_costCPU cost to send a PX message via shared memory1000
2198_smm_freeable_retainvalue in KB of the instance freeable PGA memory to retain5120
2199_cursor_plan_unparse_enabledenables/disables using unparse to build projection/predicatesTRUE
2200_kill_java_threads_on_eocKill Java threads and do sessionspace migration at end of callFALSE
2201_optimizer_join_order_controlcontrols the optimizer join order search algorithm3
2202_px_nss_planbenables or disables NSS Plan B reparse with outlineTRUE
2203_bloom_filter_enabledenables or disables bloom filterTRUE
2204_bloom_filter_debugdebug level for bloom filtering0
2205_bloom_vector_elementsnumber of elements in a bloom filter vector0
2206_bloom_predicate_enabledenables or disables bloom filter predicate pushdownTRUE
2207_bloom_predicate_pushdown_to_storageenables or disables bloom filter predicate pushdown to storageTRUE
2208_bloom_folding_enabledEnable folding of bloom filterTRUE
2209_bloom_folding_densitybloom filter folding density lower bound16
2210_bloom_folding_minbloom filter folding size lower bound131072
2211_bloom_pushing_maxbloom filter pushing size upper bound512
2212_bloom_max_sizebloom filter maximum size in bytes268435456
2213_enable_refresh_scheduleenable or disable MV refresh scheduling (revert to 9.2 behavior)TRUE
2214_optimizer_cartesian_enabledoptimizer cartesian join enabledTRUE
2215_optimizer_starplan_enabledoptimizer star plan enabledTRUE
2216_optimizer_join_elimination_enabledoptimizer join elimination enabledTRUE
2217_gby_hash_aggregation_enabledenable group-by and aggregation using hash schemeTRUE
2218_extended_pruning_enableddo runtime pruning in iterator if set to TRUETRUE
2219_globalindex_pnum_filter_enabledenables filter for global index with partition extended syntaxTRUE
2220_sql_model_unfold_forloopsspecifies compile-time unfolding of sql model forloopsRUN_TIME
2221_enable_dml_lock_escalationenable dml lock escalation against partitioned tables if TRUETRUE
2222_plsql_cache_enablePL/SQL Function Cache EnabledTRUE
2223_disable_fast_aggregationfast aggregationFALSE
2224_disable_adaptive_shrunk_aggregationadaptive shrunk aggregationFALSE
2225_plsql_minimum_cache_hit_percentplsql minimum cache hit percentage required to keep caching active20
2226_plan_outline_dataexplain plan outline data enabledTRUE
2227_outline_bitmap_treeBITMAP_TREE hint enabled in outlineTRUE
2228_drop_table_optimization_enabledreduce SGA memory use during drop of a partitioned tableTRUE
2229_very_large_partitioned_tablevery_large_partitioned_table1024
2230_drop_table_granuledrop_table_granule256
2231_xpl_traceExplain Plan tracing parameter0
2232_dm_max_shared_pool_pctmax percentage of the shared pool to use for a mining model1
2233_optimizer_multiple_cenvgenerate and run plans using several compilation environments
2234_kql_subheap_tracetracing level for library cache subheap level pins0
2235_optimizer_cost_hjsmj_multimatchadd cost of generating result set when #rows per key > 1TRUE
2236_optimizer_transitivity_retainretain equi-join pred upon transitive equality pred generationTRUE
2237optimizer_secure_view_mergingoptimizer secure view merging and predicate pushdown/movearoundTRUE
2238_px_pwg_enabledparallel partition wise group by enabledTRUE
2239_sql_hash_debugHash value of the SQL statement to debug0
2240_mv_rolling_invcreate/alter mv uses rolling cursor invalidation instead of immediateFALSE
2241_smm_isort_capmaximum work area for insertion sort(v1)102400
2242_optimizer_cbqt_no_size_restrictiondisable cost based transformation query size restrictionTRUE
2243_windowfunc_optimization_settingssettings for window function optimizations0
2244_truncate_optimization_enableddo truncate optimization if set to TRUETRUE
2245_optimizer_enhanced_filter_pushpush filters before trying cost-based query transformationTRUE
2246_compilation_call_heap_extent_sizeSize of the compilation call heaps extents16384
2247_xpl_peeked_binds_log_sizemaximum bytes for logging peeked bind values for V$SQL_PLAN (0 = OFF)8192
2248_rowsrc_trace_levelRow source tree tracing level0
2249_optimizer_rownum_pred_based_fkrenable the use of first K rows due to rownum predicateTRUE
2250_optimizer_better_inlist_costingenable improved costing of index access using in-list(s)ALL
2251_optimizer_self_induced_cache_costaccount for self-induced cachingFALSE
2252_optimizer_min_cache_blocksset minimum cached blocks10
2253_enable_exchange_validation_using_checkuse check constraints on the table for validationTRUE
2254_optimizer_or_expansioncontrol or expansion approach usedDEPTH
2255_optimizer_outer_to_anti_enabledEnable transformation of outer-join to anti-join if possibleTRUE
2256_optimizer_order_by_elimination_enabledEliminates order bys from views before query transformationTRUE
2257_optimizer_star_tran_in_with_clauseenable/disable star transformation in with clause queriesTRUE
2258_optimizer_sortmerge_join_inequalityenable/disable sort-merge join using inequality predicatesTRUE
2259_selfjoin_mv_duplicatescontrol rewrite self-join algorithmTRUE
2260_dimension_skip_nullcontrol dimension skip when null featureTRUE
2261_force_rewrite_enablecontrol new query rewrite featuresFALSE
2262_optimizer_complex_pred_selectivityenable selectivity estimation for builtin functionsTRUE
2263_build_deferred_mv_skipping_mvlog_updateDEFERRED MV creation skipping MV log setup updateTRUE
2264_bloom_pruning_enabledEnable partition pruning using bloom filteringTRUE
2265_query_mmvrewrite_maxpredsquery mmv rewrite maximum number of predicates per disjunct10
2266_query_mmvrewrite_maxintervalsquery mmv rewrite maximum number of intervals per disjunct5
2267_query_mmvrewrite_maxinlistsquery mmv rewrite maximum number of in-lists per disjunct5
2268_query_mmvrewrite_maxdmapsquery mmv rewrite maximum number of dmaps per query disjunct10
2269_query_mmvrewrite_maxcmapsquery mmv rewrite maximum number of cmaps per dmap in query disjunct20
2270_query_mmvrewrite_maxregpermquery mmv rewrite maximum number of region permutations512
2271_row_shipping_thresholdrow shipping column selection threshold80
2272_row_shipping_explainenable row shipping explain plan supportFALSE
2273_query_mmvrewrite_maxqryinlistvalsquery mmv rewrite maximum number of query in-list values500
2274_first_k_rows_dynamic_prorationenable the use of dynamic proration of join cardinalitiesTRUE
2275_optimizer_aw_stats_enabledEnables statistcs on AW olap_table table functionTRUE
2276_enable_row_shippinguse the row shipping optimization for wide table selectsTRUE
2277_optimizer_skip_scan_guessconsider index skip scan for predicates with guessed selectivityFALSE
2278_optimizer_distinct_eliminationEliminates redundant SELECT DISTNCT'sTRUE
2279_add_col_optim_enabledAllows new add column optimizationTRUE
2280_optimizer_multi_level_push_predconsider join-predicate pushdown that requires multi-level pushdown to base tableTRUE
2281ddl_lock_timeouttimeout to restrict the time that ddls wait for dml lock0
2282_enable_ddl_wait_lockuse this to turn off ddls with wait semanticsTRUE
2283deferred_segment_creationdefer segment creation to first insertTRUE
2284_optimizer_group_by_placementconsider group-by placement optimizationTRUE
2285_optimizer_distinct_placementconsider distinct placement optimizationTRUE
2286_optimizer_coalesce_subqueriesconsider coalescing of subqueries optimizationTRUE
2287_optimizer_enable_density_improvementsuse improved density computation for selectivity estimationTRUE
2288_optimizer_rownum_bind_defaultDefault value to use for rownum bind10
2289_enable_query_rewrite_on_remote_objsmv rewrite on remote table/viewTRUE
2290_enable_scn_wait_interfaceuse this to turn off scn wait interface in ktaTRUE
2291optimizer_use_pending_statisticsControl whether to use optimizer pending statisticsFALSE
2292_optimizer_improve_selectivityimprove table and partial overlap join selectivity computationTRUE
2293_optimizer_aw_join_push_enabledEnables AW Join Push optimizationTRUE
2294_kks_free_cursor_stat_pctpercentage of cursor stats buckets to scan on each load, in 1/10th of a percent10
2295_cvw_enable_weak_checkingenable weak view checkingTRUE
2296optimizer_capture_sql_plan_baselinesautomatic capture of SQL plan baselines for repeatable statementsFALSE
2297optimizer_use_sql_plan_baselinesuse of SQL plan baselines for captured sql statementsFALSE
2298_enable_online_index_without_s_lockingAllow online index creation algorithm without S DML lockTRUE
2299_sqlmon_thresholdCPU/IO time threshold before a statement is monitored. 0 is disabled5
2300_sqlmon_max_planMaximum number of plans entry that can be monitored. Defaults to 20 per CPU40
2301_sqlmon_max_planlinesNumber of plan lines beyond which a plan cannot be monitored300
2302_sqlmon_recycle_timeMinimum time (in s) to wait before a plan entry can be recycled60
2303_sqlmon_binds_xml_formatformat of column binds_xml in [G]V$SQL_MONITORdefault
2304_optimizer_native_full_outer_joinexecute full outer join using native implementaionFORCE
2305_optimizer_enable_extended_statsuse extended statistics for selectivity estimationTRUE
2306_direct_path_insert_featuresdisable direct path insert features0
2307_optimizer_free_transformation_heapfree transformation subheap after each transformationTRUE
2308_pivot_implementation_methodpivot implementation methodCHOOSE
2309_optimizer_use_subheapEnables physical optimizer subheapTRUE
2310_optimizer_or_expansion_subheapUse subheap for optimizer or-expansionTRUE
2311_optimizer_star_trans_min_costoptimizer star transformation minimum cost0
2312_optimizer_star_trans_min_ratiooptimizer star transformation minimum ratio0
2313_with_subqueryWITH subquery transformationOPTIMIZER
2314_optimizer_reuse_cost_annotationsreuse cost annotations during cost-based query transformationTRUE
2315_optimizer_interleave_jppdinterleave join predicate pushdown during CBQTTRUE
2316_optimizer_fkr_index_cost_biasOptimizer index bias over FTS/IFFS under first K rows mode10
2317_px_dump_12805_sourceenables or disables tracing of 12805 signal sourceTRUE
2318parallel_min_time_thresholdthreshold above which a plan is a candidate for parallelization (in seconds)AUTO
2319_parallel_time_unitunit of work used to derive the degree of parallelism (in seconds)10
2320parallel_degree_limitlimit placed on degree of parallelismCPU
2321parallel_force_localforce single instance executionFALSE
2322_parallel_scalabilityParallel scalability criterion for parallel execution50
2323_parallel_syspls_obey_forceTRUE to obey force parallel query/dml/ddl under System PL/SQLTRUE
2324_optimizer_nested_rollup_for_gsetnumber of groups above which we use nested rollup exec for gset100
2325_plan_verify_local_time_limitLocal time limit to use for an individual plan verification0
2326_plan_verify_improvement_marginPerformance improvement criterion for evolving plan baselines150
2327_evolve_plan_baseline_report_levelLevel of detail to show in plan verification/evolution reporttypical
2328_statistics_based_srf_enabledenable/disable the use of statistics for storage reduction factorTRUE
2329_selectivity_for_srf_enabledenable/disable selectivity for storage reduction factorFALSE
2330optimizer_use_invisible_indexesUsage of invisible indexes (TRUE/FALSE)FALSE
2331_optimizer_extended_stats_usage_controlcontrols the optimizer usage of extended stats192
2332_sql_plan_management_controlcontrols various internal SQL Plan Management algorithms0
2333_optimizer_fast_pred_transitivityuse fast algorithm to generate transitive predicatesTRUE
2334_optimizer_fast_access_pred_analysisuse fast algorithm to traverse predicates for physical optimizerTRUE
2335_optimizer_multiple_cenv_reportcontrol what to report in trace file when run in multi-plan moderesult
2336_optimizer_multiple_cenv_stmtcontrol the types of statements that are run in multi-plan modequery
2337_parallel_cluster_cache_pctmax percentage of the global buffer cache to use for affinity80
2338_px_granule_batch_sizedefault size of a batch of granules10
2339_optimizer_instance_countforce the optimizer to use the specified number of instances0
2340_block_sample_readahead_prob_thresholdcontrols readahead value during block sampling10
2341_mv_generalized_oj_refresh_optenable/disable new algorithm for MJV with generalized outer joinsTRUE
2342_parallel_optimization_phase_for_localparallel optimization phase when all slaves are localFALSE
2343_enable_schema_synonymsenable DDL operations (e.g. creation) involving schema synonymsFALSE
2344_enable_rename_userenable RENAME-clause using ALTER USER statementFALSE
2345_mv_refresh_enhanced_dml_detectionenable enhanced detection of DML types from MV logON_RC
2346_mv_refresh_pkfk_relationship_optcontrol MV refresh based on the use of PK-FK relationshipsTRUE
2347_mv_refresh_pkfk_data_units_optcontrol MV refresh based on the assumption of PK-FK data unitsauto
2348_optimizer_unnest_disjunctive_subqUnnesting of disjunctive subqueries (TRUE/FALSE)TRUE
2349_optimizer_unnest_corr_set_subqUnnesting of correlated set subqueries (TRUE/FALSE)TRUE
2350_optimizer_distinct_agg_transformTransforms Distinct Aggregates to non-distinct aggregatesTRUE
2351_aggregation_optimization_settingssettings for aggregation optimizations0
2352_arch_compress_checksumsenable/disable row checksums for archive compressed blocksFALSE
2353_optimizer_eliminate_filtering_joinoptimizer filtering join elimination enabledTRUE
2354dst_upgrade_insert_convEnables/Disables internal conversions during DST upgradeTRUE
2355_create_table_in_any_clusterallow creation of table in a cluster not owned by the userFALSE
2356_dsc_feature_levelcontrols the feature level for deferred segment creation0
2357_parallel_statement_queuingparallel statement queuing enabledFALSE
2358_parallel_conservative_queuingconservative parallel statement queuingFALSE
2359parallel_servers_targetinstance target in terms of number of parallel servers32
2360_px_load_factorweighted autodop load factor300
2361_dml_frequency_trackingControl DML frequency trackingFALSE
2362_dml_frequency_tracking_advanceControl automatic advance and broadcast of DML frequenciesTRUE
2363_dml_frequency_tracking_slotsNumber of slots to use for DML frequency tracking4
2364_dml_frequency_tracking_slot_timeTime length of each slot for DML frequency tracking15
2365_px_gim_factorweighted autodop global index maintenance factor100
2366_add_trim_for_nlssortadd trimming for fixed char semanticsTRUE
2367_optimizer_connect_by_cb_whr_onlyuse cost-based transformation for whr clause in connect byFALSE
2368_optimizer_join_factorizationuse join factorization transformationTRUE
2369_optimizer_force_CBQTforce CBQT transformation regardless of cost
2370_optimizer_use_cbqt_star_transformationuse rewritten star transformation using cbqt frameworkTRUE
2371_rep_base_pathbase path for EM reports in database
2372_optimizer_table_expansionconsider table expansion transformationTRUE
2373_and_pruning_enabledallow partition pruning based on multiple mechanismsTRUE
2374_dml_batch_error_limitnumber or error handles allocated for DML in batch mode0
2375_noseg_for_unusable_index_enabledno segments for unusable indexes if set to TRUETRUE
2376_slave_mapping_skew_ratiomaximum skew before slave mapping is disabled2
2377_px_index_sampling_objsizeparallel query sampling for index create based on object sizeTRUE
2378_sql_compatibilitysql compatability bit vector0
2379_optimizer_use_feedbackoptimizer use feedbackTRUE
2380_optimizer_feedback_controlcontrols the optimizer feedback framework
2381_optimizer_try_st_before_jppdtry Star Transformation before Join Predicate Push DownTRUE
2382_parallel_blackbox_sizeparallel execution blackbox bucket size16384
2383_parallel_blackbox_enabledparallel execution blackbox enabledTRUE
2384_parallel_load_publish_thresholddiffrence in percentage controlling px load propagation10
2385_px_partition_scan_enabledenables or disables parallel partition-based scanTRUE
2386_px_partition_scan_thresholdleast number of partitions per slave to start partition-based scan64
2387_parallel_heartbeat_snapshot_intervalinterval of snapshot to track px msging between instances2
2388_parallel_heartbeat_snapshot_maxmaximum number of historical snapshots archived128
2389_bloom_pushing_total_maxbloom filter combined pushing size (DOP x filter size) upper bound262144
2390_optimizer_false_filter_pred_pullupoptimizer false predicate pull up transformationTRUE
2391_px_granule_randomizeenables or disables randomization of parallel scans rowid granulesTRUE
2392_optimizer_purge_stats_iteration_row_countnumber of rows to be deleted at each iteration of the stats purging process10000
2393_mv_refresh_update_analysismaterialized view refresh using update analysisTRUE
2394_ptn_cache_thresholdflags and threshold to control partition metadata caching0
2395_bloom_minmax_enabledenable or disable bloom min max filteringTRUE
2396_optimizer_enable_table_lookup_by_nlconsider table lookup by nl transformationTRUE
2397_px_max_message_pool_pctpercentage of shared pool for px msg buffers range [5,60]40
2398_px_chunklist_count_ratioratio of the number of chunk lists to the default DOP per instance8
2399_px_hold_timehold px at execution time (unit: second)0
2400_cdc_subscription_ownerChange Data Capture subscription_owner
2401_optimizer_filter_pushdownenable/disable filter predicate pushdownTRUE
2402_px_round_robin_rowcntround robin row count to enq to next slave1000
2403_optimizer_outer_join_to_innerenable/disable outer to inner join conversionTRUE
2404_optimizer_full_outer_join_to_outerenable/disable full outer to left outer join conversionTRUE
2405_px_numa_support_enabledenable/disable PQ NUMA supportTRUE
2406_px_numa_stealing_enabledenable/disable PQ granule stealing across NUMA nodesTRUE
2407_px_adaptive_offload_thresholdthreshold (GB/s) for PQ adaptive offloading of granules10
2408_px_adaptive_offload_pecentagepercentage for PQ adaptive offloading of granules0
2409sec_protocol_error_trace_actionTTC protocol error actionTRACE
2410sec_protocol_error_further_actionTTC protocol error continue actionCONTINUE
2411sec_max_failed_login_attemptsmaximum number of failed login attempts on a connection10
2412sec_return_server_release_bannerwhether the server retruns the complete version informationFALSE
2413_sec_enable_test_rpcsWhether to enable the test RPCsFALSE
2414_use_zero_copy_ioShould network vector IO interface be used for data transferTRUE
2415enable_ddl_loggingenable ddl loggingFALSE
2416_tstz_localtime_bypassShould TTC not convert to LocalTime to preserve Timestamp with Timezone valuesFALSE
2417_client_tstz_error_checkShould Client give error for suspect Timestamp with Timezone operationsTRUE
2418client_result_cache_sizeclient result cache max size in bytes0
2419client_result_cache_lagclient result cache maximum lag in milliseconds3000
2420_client_result_cache_bypassbypass the client result cacheFALSE
2421_emon_regular_ntfn_slavesnumber of EMON slaves doing regular database notifications4
2422_emon_outbound_connect_timeouttimeout for completing connection set up to clients30000
2423_emon_max_active_connectionsmaximum open connections to clients per emon256
2424_client_ntfn_pingtimeouttimeout to connect to unreachable notification clients30000
2425_client_ntfn_pingintervaltime between pings to unreachable notification clients75
2426_client_ntfn_pingretriesnumber of times to ping unreachable notification clients6
2427_client_ntfn_cleanup_intervalinterval after which dead client registration cleanup task repeats2400
2428_srvntfn_q_msgcountsrvntfn q msg count for job exit50
2429_srvntfn_q_msgcount_incsrvntfn q msg count increase for job submit100
2430_srvntfn_jobsubmit_intervalsrvntfn job submit interval3
2431_srvntfn_max_concurrent_jobssrvntfn max concurrent jobs20
2432_srvntfn_job_deq_timeoutsrvntfn job deq timeout60
2433_tsm_connect_stringTSM test connect string
2434_sscr_dirSession State Capture and Restore DIRectory object
2435_sscr_osdirSession State Capture and Restore OS DIRectory
2436_tsm_disable_auto_cleanupDisable TSM auto cleanup actions1
2437_enable_nativenet_tcpipEnable skgxp driver usage for native netFALSE
2438_close_deq_by_cond_cursClose Dequeue By Condition CursorsFALSE
2439_deq_maxwait_timeChange wait times between dequeue calls0
2440_deq_max_fetch_countdeq max fetch count10
2441_deq_execute_reset_timedeq execute reset time30
2442aq_tm_processesnumber of AQ Time Managers to start1
2443_aq_tm_statistics_durationstatistics collection window duration0
2444_orph_cln_intervalqmon periodic interval for removed subscriber messages cleanup1200
2445_aq_max_scan_delayMaximum allowable scan delay for AQ indexes and IOTs1500
2446_aq_tm_scanlimitscan limit for Time Managers to clean up IOT0
2447_aq_tm_deqcountintervaldequeue count interval for Time Managers to cleanup DEQ IOT BLOCKS0
2448_disable_gvaq_cacheDisable cacheFALSE
2449_prop_old_enabledShift to pre 11g propagation behaviourFALSE
2450_bufq_stop_flow_controlStop enforcing flow control for buffered queuesFALSE
2451_capture_publisher_flow_control_thresholdFlow control threshold for capture publishers0
2452_buffered_publisher_flow_control_thresholdFlow control threshold for buffered publishers except capture0
2453_buffered_message_spill_ageBuffered message spill age300
2454_deq_log_array_sizedeq log array size10000
2455_deq_ht_max_elementsdeq ht max elements100000
2456_deq_ht_child_latchesdeq ht child latches8
2457_deq_large_txn_sizedeq large txn size25000
2458hs_autoregisterenable automatic server DD updates in HS agent self-registrationTRUE
2459xml_db_eventsare XML DB events enabledenable
2460dg_broker_startstart Data Guard broker (DMON process)FALSE
2461dg_broker_config_file1data guard broker configuration file #1/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1orclasm.dat
2462dg_broker_config_file2data guard broker configuration file #2/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2orclasm.dat
2463_dg_broker_trace_leveldata guard broker trace level
2464_olapi_history_retentionenable olapi history retentionFALSE
2465_olapi_session_historyenable olapi session history collection300
2466_olapi_session_history_retentionenable olapi session history retentionFALSE
2467_olapi_iface_object_historyenable olapi interface object history collection1000
2468_olapi_iface_object_history_retentionenable olapi interface object history retentionFALSE
2469_olapi_interface_operation_historyenable olapi interface operation history collection1000
2470_olapi_iface_operation_history_retentionenable olapi interface operation history retentionFALSE
2471_olapi_memory_operation_historyenable olapi memory alloc/free history collection1000
2472_olapi_memory_operation_history_retentionenable olapi memory operation history retentionFALSE
2473_olapi_memory_operation_history_pause_at_seqnoenable olapi memory alloc/free history collection pausing0
2474olap_page_pool_sizesize of the olap page pool in bytes0
2475_olap_continuous_trace_fileOLAP logging definitionfalse
2476_olap_table_function_statisticsSpecify TRUE to output OLAP table function timed statistics traceFALSE
2477_olap_parallel_update_thresholdOLAP parallel update threshold in pages1000
2478_olap_parallel_update_small_thresholdOLAP parallel update threshold for number of small pagespaces1000
2479_olap_parallel_update_server_numOLAP parallel update server count0
2480_olap_aggregate_buffer_sizeOLAP Aggregate max buffer size1048576
2481_olap_aggregate_min_buffer_sizeOLAP Aggregate min buffer size1024
2482_olap_aggregate_work_per_threadOLAP Aggregate max work parents1024
2483_olap_aggregate_min_thread_statusOLAP Aggregate minimum cardinality of dimensions for thread64
2484_olap_aggregate_statlen_threshOLAP Aggregate status array usage threshold1024
2485_olap_aggregate_worklist_maxOLAP Aggregate max worklists generated at once5000
2486_olap_aggregate_max_thread_tuplesOLAP Aggregate max thread tuples creation5000
2487_olap_aggregate_function_cache_enabledOLAP Aggregate function cache enablerTRUE
2488_olap_aggregate_multipath_hierOLAP Aggregate Multi-path Hierarhies enabledFALSE
2489_olap_aggregate_flagsOLAP Aggregate debug flags0
2490_olap_allocate_errorlog_headerOLAP Allocate Errorlog Header formatDim Source Basis %-8d %-8s %-8b Description -------- -------- -------- -----------
2491_olap_allocate_errorlog_formatOLAP Allocate Errorlog Format%8p %8y %8z %e (%n)
2492_olap_dbgoutfile_echo_to_eventlogOLAP DbgOutfile copy output to event log (tracefile)FALSE
2493_olap_eif_export_lob_sizeOLAP EIF Export BLOB size2147483647
2494_olap_sort_buffer_sizeOLAP Sort Buffer Size262144
2495_olap_sort_buffer_pctOLAP Sort Buffer Size Percentage10
2496_olap_sesscache_enabledOLAP Session Cache knobTRUE
2497_olap_object_hash_classOLAP Object Hash Table Class3
2498_olap_dimension_corehash_sizeOLAP Dimension In-Core Hash Table Maximum Memory Use30
2499_olap_dimension_corehash_pressureOLAP Dimension In-Core Hash Table Pressure Threshold90
2500_olap_dimension_corehash_largeOLAP Dimension In-Core Hash Table Large Threshold50000
2501_olap_dimension_corehash_forceOLAP Dimension In-Core Hash Table ForceFALSE
2502_olap_page_pool_lowOLAP Page Pool Low Watermark262144
2503_olap_page_pool_hiOLAP Page Pool High Watermark50
2504_olap_page_pool_expand_rateOLAP Page Pool Expand Rate20
2505_olap_page_pool_shrink_rateOLAP Page Pool Shrink Rate50
2506_olap_page_pool_hit_targetOLAP Page Pool Hit Target100
2507_olap_page_pool_pressureOLAP Page Pool Pressure Threshold90
2508_olap_statbool_thresholdOLAP Status Boolean CBM threshold8100
2509_olap_statbool_corebitsOLAP Status Boolean max incore bits20000000
2510_olap_lmgen_dim_sizeLimitmap generator dimension column size100
2511_olap_lmgen_meas_sizeLimitmap generator measure column size1000
2512_olap_wrap_errorsWrap error messages to OLAP outfileFALSE
2513_olap_analyze_maxOLAP DML ANALYZE command max cells to analyze10000
2514_olap_adv_comp_stats_max_rowsdo additional predicate stats analysis for AW rowsource100000
2515_olap_adv_comp_stats_cc_precompdo additional predicate stats analysis for AW rowsource20
2516_xsolapi_fetch_typeOLAP API fetch typePARTIAL
2517_xsolapi_dimension_group_creationOLAP API symmetric overfetchOVERFETCH
2518_xsolapi_sql_auto_measure_hintsOLAP API enable automatic measure hintsTRUE
2519_xsolapi_sql_auto_dimension_hintsOLAP API enable automatic dimension hintsFALSE
2520_xsolapi_sql_hintsOLAP API generic hints
2521_xsolapi_sql_measure_hintsOLAP API measure hints
2522_xsolapi_sql_dimension_hintsOLAP API dimension hints
2523_xsolapi_sql_top_measure_hintsOLAP API top measure hints
2524_xsolapi_sql_top_dimension_hintsOLAP API top dimension hints
2525_xsolapi_sql_all_non_base_hintsOLAP API non-base hints
2526_xsolapi_sql_all_multi_join_non_base_hintsOLAP API multi-join non-base hints
2527_xsolapi_densify_cubesOLAP API cube densificationTABULAR
2528_xsolapi_sql_optimizeOLAP API enable optimizationTRUE
2529_xsolapi_sql_remove_columnsOLAP API enable remove unused columns optimizationsTRUE
2530_xsolapi_sql_symmetric_predicateOLAP API enable symmetric predicate for dimension groupsTRUE
2531_xsolapi_sql_use_bind_variablesOLAP API enable bind variables optimizationTRUE
2532_xsolapi_sql_prepare_stmt_cache_sizeOLAP API prepare statement cache size16
2533_xsolapi_sql_result_set_cache_sizeOLAP API result set cache size32
2534_xsolapi_sql_minus_thresholdOLAP API SQL MINUS threshold1000
2535_xsolapi_debug_outputOLAP API debug output dispositionSUPPRESS
2536_xsolapi_materialize_sourcesOLAP API Enable source materializationTRUE
2537_xsolapi_load_at_process_startWhen to load OLAP API library at server process startNEVER
2538_xsolapi_fix_vptrsOLAP API Enable vptr fixing logic in shared server modeTRUE
2539_xsolapi_auto_materialization_typeOLAP API behavior for auto materializationPRED_AND_RC
2540_xsolapi_auto_materialization_boundOLAP API lower bound for auto materialization.20
2541_xsolapi_materialization_rowcache_min_rows_for_useOLAP API min number of rows required to use rowcache in query materialization1
2542_xsolapi_source_traceOLAP API output Source definitions to trace fileFALSE
2543_xsolapi_dml_traceOLAP API output dml commands and expressions to trace file
2544_xsolapi_build_traceOLAP API output build info to trace fileFALSE
2545_xsolapi_metadata_reader_modeOLAP API metadata reader modeDEFAULT
2546_xsolapi_odbo_modeOLAP API uses ODBO mode?FALSE
2547_xsolapi_set_nlsOLAP API sets NLS?TRUE
2548_xsolapi_stringify_order_levelsOLAP API stringifies order levels?FALSE
2549_xsolapi_suppression_chunk_sizeOLAP API suppression chunk size4000
2550_xsolapi_suppression_aw_mask_thresholdOLAP API suppression AW mask threshold1000
2551_xsolapi_share_executorsOLAP API share executors?TRUE
2552_xsolapi_hierarchy_value_typeOLAP API hierarchy value typeunique
2553_xsolapi_use_modelsOLAP API uses models?TRUE
2554_xsolapi_use_olap_dmlOLAP API uses OLAP DML?TRUE
2555_xsolapi_use_olap_dml_for_rankOLAP API uses OLAP DML for rank?TRUE
2556_xsolapi_remove_columns_for_materializationOLAP API removes columns for materialization?TRUE
2557_xsolapi_precompute_subqueryOLAP API precomputes subqueries?TRUE
2558_xsolapi_optimize_suppressionOLAP API optimizes suppressions?TRUE
2559_xsolapi_generate_with_clauseOLAP API generates WITH clause?FALSE
2560_xsolapi_sql_enable_aw_joinOLAP API enables AW join?TRUE
2561_xsolapi_sql_enable_aw_qdr_mergeOLAP API enables AW QDR merge?TRUE
2562_xsolapi_opt_aw_positionOLAP API enables AW position and count optimization?TRUE
2563_xsolapi_support_mtmOLAP API MTM mapping classes supported?FALSE
2564_asm_runtime_capability_volume_supportruntime capability for volume support returns supportedFALSE
2565_asm_disable_multiple_instance_checkDisable checking for multiple ASM instances on a given nodeFALSE
2566_asm_disable_amdu_dumpDisable AMDU dumpFALSE
2567_asmsidASM instance idasm
2568_asm_allow_system_alias_renameif system alias renaming is allowedFALSE
2569_asm_instlock_quotaASM Instance Lock Quota0
2570asm_diskstringdisk set locations for discovery
2571_asm_disk_repair_timeseconds to wait before dropping a failing disk14400
2572asm_preferred_read_failure_groupspreferred read failure groups
2573_asm_disable_profilediscoverydisable profile query for discoveryFALSE
2574_asm_imbalance_tolerancehundredths of a percentage of inter-disk imbalance to tolerate3
2575_asm_shadow_cycleInverse shadow cycle requirement3
2576_asm_primary_load_cyclesTrue if primary load is in cycles, false if extent countsTRUE
2577_asm_primary_loadNumber of cycles/extents to load for non-mirrored files1
2578_asm_secondary_load_cyclesTrue if secondary load is in cycles, false if extent countsFALSE
2579_asm_secondary_loadNumber of cycles/extents to load for mirrored files10000
2580_kffmap_hash_sizesize of kffmap_hash table1024
2581_kffmop_hash_sizesize of kffmop_hash table2048
2582asm_diskgroupsdisk groups to mount automatically
2583asm_power_limitnumber of parallel relocations for disk rebalancing1
2584_disable_rebalance_space_checkdisable space usage checks for storage reconfigurationFALSE
2585_disable_rebalance_compactdisable space usage checks for storage reconfigurationFALSE
2586_asm_log_scale_rebalanceRebalance power uses logarithmic scaleFALSE
2587_asm_sync_rebalanceRebalance uses sync I/OFALSE
2588_diag_arb_before_killdump diagnostics before killing unresponsive ARBsFALSE
2589_asm_ausizeallocation unit size1048576
2590_asm_blksizemetadata block size4096
2591_asm_acd_chunksinitial ACD chunks created1
2592_asm_partner_target_disk_parttarget maximum number of disk partners for repartnering8
2593_asm_partner_target_fg_reltarget maximum number of failure group relationships for repartnering4
2594_asm_automatic_rezoneautomatically rebalance free space across zonesTRUE
2595_asm_rebalance_plan_sizemaximum rebalance work unit120
2596_asm_rebalance_space_errorsnumber of out of space errors allowed before aborting rebalance4
2597_asm_librarieslibrary search order for discoveryufs
2598_asm_maxioMaximum size of individual I/O request1048576
2599_asm_allow_only_raw_disksDiscovery only raw devicesTRUE
2600_asm_fob_tac_frequencyTimeout frequency for FOB cleanup9
2601_asm_emulate_nfs_diskEmulate NFS disk test eventFALSE
2602_asmlib_testOsmlib test event0
2603_asm_allow_lvm_resilveringEnable disk resilvering for external redundancyTRUE
2604_asm_lsod_bucket_sizeASM lsod bucket size13
2605_asm_iostat_latch_countASM I/O statistics latch count31
2606_kfm_disable_set_fencedisable set fence calls and revert to default (process fence)FALSE
2607_asm_disable_smr_creationDo Not create smrFALSE
2608_asm_wait_timeMax/imum time to wait before asmb exits18
2609_asm_skip_resize_checkskip the checking of the clients for s/w compatibility for resizeFALSE
2610_asm_skip_rename_checkskip the checking of the clients for s/w compatibility for renameFALSE
2611_asm_direct_con_expire_timeExpire time for idle direct connection to ASM instance120
2612_asm_check_for_misbehaving_cf_clientscheck for misbehaving CF-holding clientsFALSE
2613_asm_diag_dead_clientsdiagnostics for dead clientsFALSE
2614_asm_reserve_slavesreserve ASM slaves for CF txnsTRUE
2615_asm_kill_unresponsive_clientskill unresponsive ASM clientsTRUE
2616_asm_disable_async_msgsdisable async intra-instance messagingFALSE
2617_asm_stripewidthASM file stripe width8
2618_asm_stripesizeASM file stripe size131072
2619_disable_fastopenDo Not Use FastopenFALSE
2620_asm_random_zoneRandom zones for new filesFALSE
2621_asm_serialize_volume_rebalanceSerialize volume rebalanceFALSE
2622_asm_force_quiesceForce diskgroup quiescingFALSE
2623_asm_dba_thresholdASM Disk Based Allocation Threshold0
2624_asm_dba_batchASM Disk Based Allocation Max Batch Size500000
2625_asm_usd_batchASM USD Update Max Batch Size64
2626_asm_fail_random_rxRandomly fail some RX enqueue getsFALSE
2627_relocation_commit_batch_sizeASM relocation commit batch size8
2628_asm_max_redo_buffer_sizeasm maximum redo buffer size2097152
2629_asm_max_cod_stridesmaximum number of COD strides5
2630_asm_kfioeventKFIO event0
2631_asm_evenreadASM Even Read level0
2632_asm_evenread_alphaASM Even Read Alpha0
2633_asm_evenread_alpha2ASM Even Read Second Alpha0
2634_asm_evenread_faststartASM Even Read Fast Start Threshold0
2635_asm_dbmsdg_nohdrchkdbms_diskgroup.checkfile does not check block headersFALSE
2636_asm_root_directoryASM default root directoryASM
2637_asm_hbeatiowaitnumber of secs to wait for PST Async Hbeat IO return15
2638_asm_hbeatwaitquantumquantum used to compute time-to-wait for a PST Hbeat check2
2639_asm_repairquantumquantum (in 3s) used to compute elapsed time for disk drop60
2640_asm_emulmaxmax number of concurrent disks to emulate I/O errors10000
2641_asm_emultimeouttimeout before emulation begins (in 3s ticks)0
2642_asm_kfdpeventKFDP event0
2643_asm_storagemaysplitPST Split PossibleFALSE
2644_asm_avoid_pst_scansAvoid PST ScansTRUE
2645_disable_storage_typeDisable storage type checksTRUE
2646_asm_compatibilitydefault ASM compatibility level10.1
2647_rdbms_compatibilitydefault RDBMS compatibility level10.1
2648_allow_cell_smart_scan_attrAllow checking smart_scan_capable AttrTRUE
2649_asm_admin_with_sysdbaDoes the sysdba role have administrative privileges on ASM?FALSE
2650_asm_allow_appliance_dropdisk_noforceAllow DROP DISK/FAILUREGROUP NOFORCE on ASM AppliancesFALSE
2651_disable_appliance_checkDisable checking for appliance bread crumbsFALSE
2652_asm_appliance_config_fileAppliance configuration file name
2653_disable_appliance_partneringDisable partnering mode for applianceFALSE
2654control_management_pack_accessdeclares which manageability packs are enabledDIAGNOSTIC+TUNING
2655_alert_expirationseconds before an alert message is moved to exception queue604800
2656_alert_message_cleanupEnable Alert Message Cleanup1
2657_alert_message_purgeEnable Alert Message Purge1
2658_alert_post_backgroundEnable Background Alert Posting1
2659_swrf_test_actiontest action parameter for SWRF0
2660_sysaux_test_paramtest parameter for SYSAUX1
2661_swrf_mmon_flushEnable/disable SWRF MMON FLushingTRUE
2662_awr_corrupt_modeAWR Corrupt ModeFALSE
2663_awr_restrict_modeAWR Restrict ModeFALSE
2664_swrf_mmon_metricsEnable/disable SWRF MMON Metrics CollectionTRUE
2665_swrf_metric_frequent_modeEnable/disable SWRF Metric Frequent Mode CollectionFALSE
2666_awr_flush_threshold_metricsEnable/Disable Flushing AWR Threshold MetricsTRUE
2667_awr_flush_workload_metricsEnable/Disable Flushing AWR Workload MetricsFALSE
2668_awr_disabled_flush_tablesDisable flushing of specified AWR tables
2669_swrf_on_disk_enabledParameter to enable/disable SWRFTRUE
2670_swrf_mmon_dbfusEnable/disable SWRF MMON DB Feature UsageTRUE
2671_awr_mmon_cpuusageEnable/disable AWR MMON CPU Usage TrackingTRUE
2672_swrf_test_dbfusEnable/disable DB Feature Usage TestingFALSE
2673_adr_migrate_runonceEnable/disable ADR Migrate Runonce actionTRUE
2674_mwin_scheduleEnable/disable Maintenance Window SchedulesTRUE
2675_awr_sql_child_limitSetting for AWR SQL Child Limit200
2676awr_snapshot_time_offsetSetting for AWR Snapshot Time Offset0
2677_awr_mmon_deep_purge_intervalSet interval for deep purge of AWR contents7
2678_awr_mmon_deep_purge_extentSet extent of rows to check each deep purge run7
2679_awr_mmon_deep_purge_numrowsSet max number of rows per table to delete each deep purge run5000
2680sqltune_categoryCategory qualifier for applying hintsetsDEFAULT
2681_sqltune_category_parsedParsed category qualifier for applying hintsetsDEFAULT
2682_ash_sampling_intervalTime interval between two successive Active Session samples in millisecs1000
2683_ash_sizeTo set the size of the in-memory Active Session History buffers1048618
2684_ash_enableTo enable or disable Active Session sampling and flushingTRUE
2685_ash_disk_write_enableTo enable or disable Active Session History flushingTRUE
2686_ash_disk_filter_ratioRatio of the number of in-memory samples to the number of samples actually written to disk10
2687_ash_eflush_triggerThe percentage above which if the in-memory ASH is full the emergency flusher will be triggered66
2688_ash_sample_allTo enable or disable sampling every connected session including ones waiting for idle waitsFALSE
2689_ash_dummy_test_paramOracle internal dummy ASH parameter used ONLY for testing!0
2690_ash_min_mmnl_dumpMinimum Time interval passed to consider MMNL Dump90
2691_ash_compression_enableTo enable or disable string compression in ASHTRUE
2692_kebm_nstrikeskebm # strikes to auto suspend an action3
2693_kebm_suspension_timekebm auto suspension time in seconds82800
2694_timemodel_collectionenable timemodel collectionTRUE
2695_disable_metrics_groupDisable Metrics Group (or all Metrics Groups)0
2696_threshold_alerts_enableif 1, issue threshold-based alerts1
2697_enable_default_undo_thresholdEnable Default Tablespace Utilization Threshold for TEMPORARY TablespacesTRUE
2698_enable_default_temp_thresholdEnable Default Tablespace Utilization Threshold for UNDO TablespacesTRUE
2699_addm_auto_enablegoverns whether ADDM gets run automatically after every AWR snapshotTRUE
2700_addm_version_checkgoverns whether ADDM checks the input AWR snapshot versionTRUE
2701_addm_skiprulescomma-separated list of ADDM nodes to skip
2702_automatic_maintenance_testEnable AUTOTASK Test Mode0
2703_autotask_min_windowMinimum Maintenance Window Length in minutes15
2704_autotask_max_windowMaximum Logical Maintenance Window Length in minutes480
2705_enable_automatic_maintenanceif 1, Automated Maintenance Is Enabled1
2706_bsln_adaptive_thresholds_enabledAdaptive Thresholds EnabledTRUE
2707_wcr_controlOracle internal test WCR parameter used ONLY for testing!0
2708_capture_buffer_sizeTo set the size of the PGA I/O recording buffers65536
2709_diag_verbose_error_on_initAllow verbose error tracing on diag init0
2710_diag_hm_rc_enabledParameter to enable/disable Diag HM Reactive ChecksTRUE
2711_diag_hm_tc_enabledParameter to enable/disable Diag HM Test(dummy) ChecksFALSE
2712diagnostic_destdiagnostic base directory/u01/app/oracle
2713_diag_adr_enabledParameter to enable/disable Diag ADRTRUE
2714_diag_adr_auto_purgeEnable/disable ADR MMON Auto PurgingTRUE
2715_diag_backward_compatBackward Compatibility for DiagnosabilityTRUE
2716_diag_adr_test_paramTest parameter for Diagnosability0
2717_dra_enable_offline_dictionaryEnable the periodic creation of the offline dictionary for DRAFALSE
2718_dra_bmr_number_thresholdMaximum number of BMRs that can be done to a file1000
2719_dra_bmr_percent_thresholdMaximum percentage of blocks in a file that can be BMR-ed10
2720_diag_conf_cap_enabledParameter to enable/disable Diag Configuration CaptureTRUE
2721_dde_flood_control_initInitialize Flood Control at database openTRUE
2722_diag_dde_fc_enabledParameter to enable/disable Diag Flood ControlTRUE
2723_diag_dde_fc_implicit_timeOverride Implicit Error Flood Control time parameter0
2724_diag_dde_fc_macro_timeOverride Macro Error Flood Control time parameter0
2725_diag_cc_enabledParameter to enable/disable Diag Call ContextTRUE
2726_diag_dde_inc_proc_delayThe minimum delay between two MMON incident sweeps (minutes)1
2727_diag_dde_async_msgsdiag dde async actions: number of preallocated message buffers50
2728_diag_dde_async_msg_capacitydiag dde async actions: message buffer capacity1024
2729_diag_dde_async_slavesdiag dde async actions: max number of concurrent slave processes5
2730_diag_dde_async_modediag dde async actions: dispatch mode1
2731_diag_dde_async_age_limitdiag dde async actions: message age limit (in seconds)300
2732_diag_dde_async_process_ratediag dde async actions: message processing rate - per loop5
2733_diag_dde_async_runtime_limitdiag dde async actions: action runtime limit (in seconds)900
2734_diag_dde_async_cputime_limitdiag dde async actions: action cputime limit (in seconds)300
2735_diag_dde_enabledenable DDE handling of critical errorsTRUE
2736tracefile_identifiertrace file custom identifier
2737_trace_files_publicCreate publicly accessible trace filesFALSE
2738max_dump_file_sizeMaximum size (in bytes) of dump fileunlimited
2739_diag_uts_controlUTS control parameter0
2740_trace_pool_sizetrace pool size in bytes
2741trace_enabledenable in memory tracingTRUE
2742_evt_system_event_propagationdisable system event propagationTRUE
2743_diag_enable_startup_eventsenable events in instance startup notifiersFALSE
2744_auto_manage_exadata_disksAutomate Exadata disk managementTRUE
2745_auto_manage_ioctl_bufszoss_ioctl buffer size, to read and respond to cell notifications8192
2746_auto_manage_num_triesNum. tries before giving up on a automation operation2
2747_auto_manage_enable_offline_checkperodically check for OFFLINE disks and attempt to ONLINETRUE
2748_auto_manage_max_online_triesMax. attempts to auto ONLINE an ASM disk3
2749_auto_manage_online_tries_expire_timeAllow Max. attempts to auto ONLINE an ASM disk after lapsing this time (unit in seconds)86400
2750_auto_manage_num_pipe_msgsMax. number of out-standing msgs in the KXDAM pipe1000
2751_auto_manage_infreq_toutTEST: Set infrequent timeout action to run at this interval, unit is seconds0

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

7 + 5 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部