点击(此处)折叠或打开
INDX | NAME | KSPPDESC | KSPPSTVL |
0 | _appqos_qt | System Queue time retrieval interval | 10 |
1 | _ior_serialize_fault | inject fault in the ior serialize code | 0 |
2 | _shutdown_completion_timeout_mins | minutes for shutdown operation to wait for sessions to complete | 60 |
3 | _inject_startup_fault | inject fault in the startup code | 0 |
4 | _latch_recovery_alignment | align latch recovery structures | 65534 |
5 | _spin_count | Amount to spin waiting for a latch | 2000 |
6 | _latch_miss_stat_sid | Sid of process for which to collect latch stats | 0 |
7 | _max_sleep_holding_latch | max time to sleep while holding a latch | 4 |
8 | _max_exponential_sleep | max sleep during exponential backoff | 0 |
9 | _other_wait_threshold | threshold wait percentage for event wait class Other | 0 |
10 | _other_wait_event_exclusion | exclude event names from _other_wait_threshold calculations | |
11 | _use_vector_post | use vector post | TRUE |
12 | _latch_class_0 | latch class 0 | |
13 | _latch_class_1 | latch class 1 | |
14 | _latch_class_2 | latch class 2 | |
15 | _latch_class_3 | latch class 3 | |
16 | _latch_class_4 | latch class 4 | |
17 | _latch_class_5 | latch class 5 | |
18 | _latch_class_6 | latch class 6 | |
19 | _latch_class_7 | latch class 7 | |
20 | _latch_classes | latch classes override | |
21 | _ultrafast_latch_statistics | maintain fast-path statistics for ultrafast latches | TRUE |
22 | _enable_reliable_latch_waits | Enable reliable latch waits | TRUE |
23 | _wait_breakup_time_csecs | Wait breakup time (in centiseconds) | 300 |
24 | _wait_breakup_threshold_csecs | Wait breakup threshold (in centiseconds) | 600 |
25 | _disable_wait_state | Disable wait state | |
26 | _wait_tracker_num_intervals | Wait Tracker number of intervals | 0 |
27 | _wait_tracker_interval_secs | Wait Tracker number of seconds per interval | 10 |
28 | _wait_samples_max_time_secs | Wait Samples maximum time in seconds | 120 |
29 | _wait_samples_max_sections | Wait Samples maximum sections | 40 |
30 | _wait_yield_mode | Wait Yield - Mode | yield |
31 | _wait_yield_hp_mode | Wait Yield - High Priority Mode | yield |
32 | _wait_yield_sleep_time_msecs | Wait Yield - Sleep Time (in milliseconds) | 1 |
33 | _wait_yield_sleep_freq | Wait Yield - Sleep Frequency | 100 |
34 | _wait_yield_yield_freq | Wait Yield - Yield Frequency | 20 |
35 | _post_wait_queues_num_per_class | Post Wait Queues - Num Per Class | |
36 | _post_wait_queues_dynamic_queues | Post Wait Queues - Num Dynamic Queues | 40 |
37 | lock_name_space | lock name space used for generating lock names for standby/clone database | |
38 | processes | user processes | 500 |
39 | sessions | user and system sessions | 772 |
40 | timed_statistics | maintain internal timing statistics | TRUE |
41 | timed_os_statistics | internal os statistic gathering interval in seconds | 0 |
42 | resource_limit | master switch for resource limit | FALSE |
43 | license_max_sessions | maximum number of non-system user sessions allowed | 0 |
44 | license_sessions_warning | warning level for number of non-system user sessions | 0 |
45 | _session_idle_bit_latches | one latch per session or a latch per group of sessions | 0 |
46 | _ksu_diag_kill_time | number of seconds ksuitm waits before killing diag | 5 |
47 | _ksuitm_dont_kill_dumper | delay inst. termination to allow processes to dump | FALSE |
48 | _cleanup_timeout | timeout value for PMON cleanup | 150 |
49 | _cleanup_timeout_flags | flags for PMON cleanup timeout | 2 |
50 | _disable_image_check | Disable Oracle executable image checking | FALSE |
51 | _num_longop_child_latches | number of child latches for long op array | 2 |
52 | _longops_enabled | longops stats enabled | TRUE |
53 | _test_ksusigskip | test the function ksusigskip | 5 |
54 | _module_action_old_length | Use module and action old length parameter | TRUE |
55 | _disable_kcbhxor_osd | disable kcbh(c)xor OSD functionality | FALSE |
56 | _disable_kgghshcrc32_osd | disable kgghshcrc32chk OSD functionality | FALSE |
57 | _disable_system_state | disable system state dump | 4294967294 |
58 | _disable_system_state_wait_samples | Disable system state dump - wait samples | FALSE |
59 | _session_wait_history | enable session wait history collection | 10 |
60 | _pkt_enable | enable progressive kill test | FALSE |
61 | _pkt_start | start progressive kill test instrumention | FALSE |
62 | _pkt_pmon_interval | PMON process clean-up interval (cs) | 50 |
63 | _collapse_wait_history | collapse wait history | FALSE |
64 | _short_stack_timeout_ms | short stack timeout in ms | 30000 |
65 | _sga_early_trace | sga early trace event | 0 |
66 | _kill_session_dump | Process dump on kill session immediate | TRUE |
67 | _logout_storm_rate | number of processes that can logout in a second | 0 |
68 | _logout_storm_timeout | timeout in centi-seconds for time to wait between retries | 5 |
69 | _logout_storm_retrycnt | maximum retry count for logouts | 600 |
70 | _ksuitm_addon_trccmd | command to execute when dead processes don't go away | |
71 | _timeout_actions_enabled | enables or disables KSU timeout actions | TRUE |
72 | _idle_session_kill_enabled | enables or disables resource manager session idle limit checks | TRUE |
73 | _session_allocation_latches | one latch per group of sessions | 2 |
74 | _disable_highres_ticks | disable high-res tick counter | FALSE |
75 | _timer_precision | VKTM timer precision in milli-sec | 10 |
76 | _dbrm_quantum | DBRM quantum | |
77 | _highres_drift_allowed_sec | allowed highres timer drift for VKTM | 1 |
78 | _lowres_drift_allowed_sec | allowed lowres timer drift for VKTM | 5 |
79 | _vktm_assert_thresh | soft assert threshold VKTM timer drift | 30 |
80 | _iorm_tout | IORM scheduler timeout value in msec | 1000 |
81 | __oracle_base | ORACLE_BASE | /u01/app/oracle |
82 | _single_process | run without detached processes | FALSE |
83 | _disable_cpu_check | disable cpu_count check | FALSE |
84 | _available_core_count | number of cores for this instance | 0 |
85 | cpu_count | number of CPUs for this instance | 2 |
86 | _dbg_proc_startup | debug process startup | FALSE |
87 | _static_backgrounds | static backgrounds | |
88 | _enqueue_deadlock_time_sec | requests with timeout <= this will not have deadlock detection | 5 |
89 | _number_cached_attributes | maximum number of cached attributes per instance | 10 |
90 | instance_groups | list of instance group names | |
91 | _number_cached_group_memberships | maximum number of cached group memberships | 32 |
92 | _kss_quiet | if TRUE access violations during kss dumps are not recorded | FALSE |
93 | _kss_callstack_type | state object callstack trace type | |
94 | event | debug event control - default null string | |
95 | _oradebug_force | force target processes to execute oradebug commands? | FALSE |
96 | _ksdxdocmd_default_timeout_ms | default timeout for internal oradebug commands | 30000 |
97 | _ksdxdocmd_enabled | if TRUE ksdxdocmd* invocations are enabled | TRUE |
98 | _ksdx_charset_ratio | ratio between the system and oradebug character set | 0 |
99 | _oradebug_cmds_at_startup | oradebug commands to execute at instance startup | |
100 | _watchpoint_on | is the watchpointing feature turned on? | FALSE |
101 | _ksdxw_num_sgw | number of watchpoints to be shared by all processes | 10 |
102 | _ksdxw_num_pgw | number of watchpoints on a per-process basis | 10 |
103 | _ksdxw_stack_depth | number of PCs to collect in the stack when watchpoint is hit | 4 |
104 | _ksdxw_cini_flg | ksdxw context initialization flag | 0 |
105 | _ksdxw_nbufs | ksdxw number of buffers in buffered mode | 1000 |
106 | sga_max_size | max total SGA size | 1275068416 |
107 | _enable_shared_pool_durations | temporary to disable/enable kgh policy | TRUE |
108 | _NUMA_pool_size | aggregate size in bytes of NUMA pool | Not specified |
109 | _enable_NUMA_optimization | Enable NUMA specific optimizations | FALSE |
110 | _enable_NUMA_support | Enable NUMA support and optimizations | FALSE |
111 | _enable_NUMA_interleave | Enable NUMA interleave mode | TRUE |
112 | _enable_LGPG_debug | Enable LGPG debug mode | FALSE |
113 | use_large_pages | Use large pages if available (TRUE/FALSE/ONLY) | TRUE |
114 | _max_largepage_alloc_time_secs | Maximum number of seconds to spend on largepage allocation | 10 |
115 | pre_page_sga | pre-page sga for process | FALSE |
116 | shared_memory_address | SGA starting address (low order 32-bits on 64-bit platforms) | 0 |
117 | hi_shared_memory_address | SGA starting address (high order 32-bits on 64-bit platforms) | 0 |
118 | use_indirect_data_buffers | Enable indirect data buffers (very large SGA on 32-bit platforms) | FALSE |
119 | _use_ism | Enable Shared Page Tables - ISM | TRUE |
120 | lock_sga | Lock entire SGA in physical memory | FALSE |
121 | _lock_sga_areas | Lock specified areas of the SGA in physical memory | 0 |
122 | _NUMA_instance_mapping | Set of nodes that this instance should run on | Not specified |
123 | _simulator_upper_bound_multiple | upper bound multiple of pool size | 2 |
124 | _simulator_pin_inval_maxcnt | maximum count of invalid chunks on pin list | 16 |
125 | _simulator_lru_rebalance_thresh | LRU list rebalance threshold (count) | 10240 |
126 | _simulator_lru_rebalance_sizthr | LRU list rebalance threshold (size) | 5 |
127 | _simulator_bucket_mindelta | LRU bucket minimum delta | 8192 |
128 | _simulator_lru_scan_count | LRU scan count | 8 |
129 | _simulator_internal_bound | simulator internal bound percent | 10 |
130 | _simulator_reserved_obj_count | simulator reserved object count | 1024 |
131 | _simulator_reserved_heap_count | simulator reserved heap count | 4096 |
132 | _simulator_sampling_factor | sampling factor for the simulator | 2 |
133 | _realfree_heap_max_size | minimum max total heap size, in Kbytes | 32768 |
134 | _realfree_heap_pagesize_hint | hint for real-free page size in bytes | 65536 |
135 | _realfree_heap_mode | mode flags for real-free heap | 0 |
136 | _use_realfree_heap | use real-free based allocator for PGA memory | TRUE |
137 | _pga_large_extent_size | PGA large extent size | 1048576 |
138 | _uga_cga_large_extent_size | UGA/CGA large extent size | 262144 |
139 | _total_large_extent_memory | Total memory for allocating large extents | 0 |
140 | _use_ism_for_pga | Use ISM for allocating large extents | TRUE |
141 | _private_memory_address | Start address of large extent memory segment | |
142 | _mem_annotation_sh_lev | shared memory annotation collection level | 0 |
143 | _mem_annotation_pr_lev | private memory annotation collection level | 0 |
144 | _mem_annotation_scale | memory annotation pre-allocation scaling | 1 |
145 | _mem_annotation_store | memory annotation in-memory store | FALSE |
146 | _4031_dump_bitvec | bitvec to specify dumps prior to 4031 error | 67194879 |
147 | _4031_max_dumps | Maximum number of 4031 dumps for this process | 100 |
148 | _4031_dump_interval | Dump 4031 error once for each n-second interval | 300 |
149 | _4031_sga_dump_interval | Dump 4031 SGA heapdump error once for each n-second interval | 3600 |
150 | _4031_sga_max_dumps | Maximum number of SGA heapdumps | 10 |
151 | _4030_dump_bitvec | bitvec to specify dumps prior to 4030 error | 4095 |
152 | _numa_trace_level | numa trace event | 0 |
153 | _mem_std_extent_size | standard extent size for fixed-size-extent heaps | 4096 |
154 | _kgsb_threshold_size | threshold size for base allocator | 16777216 |
155 | _endprot_chunk_comment | chunk comment for selective overrun protection | chk 10235 dflt |
156 | _endprot_heap_comment | heap comment for selective overrun protection | hp 10235 dflt |
157 | _endprot_subheaps | selective overrun protection for subeheaps | TRUE |
158 | _sga_locking | sga granule locking state | none |
159 | _ksm_pre_sga_init_notif_delay_secs | seconds to delay instance startup at sga initialization (pre) | 0 |
160 | _ksm_post_sga_init_notif_delay_secs | seconds to delay instance startup at sga initialization (post) | 0 |
161 | processor_group_name | Name of the processor group that this instance should run in. | |
162 | __shared_pool_size | Actual size in bytes of shared pool | 503316480 |
163 | shared_pool_size | size in bytes of shared pool | 285212672 |
164 | __large_pool_size | Actual size in bytes of large pool | 67108864 |
165 | large_pool_size | size in bytes of large pool | 67108864 |
166 | __java_pool_size | Actual size in bytes of java pool | 67108864 |
167 | java_pool_size | size in bytes of java pool | 67108864 |
168 | __streams_pool_size | Actual size in bytes of streams pool | 67108864 |
169 | streams_pool_size | size in bytes of the streams pool | 67108864 |
170 | _large_pool_min_alloc | minimum allocation size in bytes for the large allocation pool | 65536 |
171 | shared_pool_reserved_size | size in bytes of reserved area of shared pool | 25165824 |
172 | _shared_pool_reserved_pct | percentage memory of the shared pool allocated for the reserved area | 5 |
173 | _shared_pool_reserved_min_alloc | minimum allocation size in bytes for reserved area of shared pool | 4400 |
174 | java_soft_sessionspace_limit | warning limit on size in bytes of a Java sessionspace | 0 |
175 | java_max_sessionspace_size | max allowed size in bytes of a Java sessionspace | 0 |
176 | _kghdsidx_count | max kghdsidx count | 2 |
177 | _test_param_1 | test parmeter 1 - integer | 25 |
178 | _test_param_2 | test parameter 2 - string | |
179 | _test_param_3 | test parameter 3 - string | |
180 | _test_param_4 | test parameter 4 - string list | |
181 | _test_param_5 | test parmeter 5 - deprecated integer | 25 |
182 | _test_param_6 | test parmeter 6 - size (ub8) | 0 |
183 | spfile | server parameter file | /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorclasm.ora |
184 | instance_type | type of instance to be executed | RDBMS |
185 | _disable_instance_params_check | disable instance type check for ksp | FALSE |
186 | _parameter_table_block_size | parameter table block size | 2048 |
187 | _high_priority_processes | High Priority Process Name Mask | LMS*|VKTM |
188 | _os_sched_high_priority | OS high priority level | 1 |
189 | _ksb_restart_clean_time | process uptime for restarts | 30000 |
190 | _ksb_restart_policy_times | process restart policy times in seconds | 0, 60, 120, 240 |
191 | _ksd_test_param | KSD test parmeter | 999 |
192 | _kse_die_timeout | amount of time a dying process is spared by PMON (in centi-secs) | 60000 |
193 | _stack_guard_level | stack guard level | 0 |
194 | _kse_pc_table_size | kse pc table cache size | 256 |
195 | _kse_signature_entries | number of entries in the kse stack signature cache | 0 |
196 | _kse_signature_limit | number of stack frames to cache per kse signature | 7 |
197 | _kse_snap_ring_size | ring buffer to debug internal error 17090 | 0 |
198 | _kse_snap_ring_record_stack | should error snap ring entries show a short stack trace | FALSE |
199 | _kse_trace_int_msg_clear | enables soft assert of KGECLEAERERROR is cleares an interrupt message | FALSE |
200 | _system_api_interception_debug | enable debug tracing for system api interception | FALSE |
201 | _messages | message queue resources - dependent on # processes & # buffers | 1000 |
202 | _enqueue_locks | locks for managed enqueues | 9100 |
203 | _enqueue_resources | resources for enqueues | 3616 |
204 | _enqueue_hash | enqueue hash table length | 1579 |
205 | _enqueue_debug_multi_instance | debug enqueue multi instance | FALSE |
206 | _enqueue_hash_chain_latches | enqueue hash chain latches | 2 |
207 | _enqueue_deadlock_scan_secs | deadlock scan interval | 0 |
208 | _enqueue_paranoia_mode_enabled | enable enqueue layer advanced debugging checks | FALSE |
209 | _ksi_trace | KSI trace string of lock type(s) | |
210 | _ksi_trace_bucket | memory tracing: use ksi-private or rdbms-shared bucket | PRIVATE |
211 | _ksi_trace_bucket_size | size of the KSI trace bucket | 8192 |
212 | _ksi_clientlocks_enabled | if TRUE, DLM-clients can provide the lock memory | TRUE |
213 | _trace_processes | enable KST tracing in process | ALL |
214 | _trace_events | trace events enabled at startup | |
215 | _trace_buffers | trace buffer sizes per process | ALL:256 |
216 | _trace_dump_static_only | if TRUE filter trace dumps to always loaded dlls | FALSE |
217 | _trace_dump_all_procs | if TRUE on error buckets of all processes will be dumped to the current trace file | FALSE |
218 | _trace_dump_cur_proc_only | if TRUE on error just dump our process bucket | FALSE |
219 | _trace_dump_client_buckets | if TRUE dump client (ie. non-kst) buckets | TRUE |
220 | _cdmp_diagnostic_level | cdmp directory diagnostic level | 2 |
221 | nls_language | NLS language name | AMERICAN |
222 | nls_territory | NLS territory name | AMERICA |
223 | nls_sort | NLS linguistic definition name | BINARY |
224 | nls_date_language | NLS date language name | AMERICAN |
225 | nls_date_format | NLS Oracle date format | YYYY-MM-DD HH24:MI:SS |
226 | nls_currency | NLS local currency symbol | $ |
227 | nls_numeric_characters | NLS numeric characters | ., |
228 | nls_iso_currency | NLS ISO currency territory name | AMERICA |
229 | nls_calendar | NLS calendar system name | GREGORIAN |
230 | nls_time_format | time format | HH.MI.SSXFF AM |
231 | nls_timestamp_format | time stamp format | DD-MON-RR HH.MI.SSXFF AM |
232 | nls_time_tz_format | time with timezone format | HH.MI.SSXFF AM TZR |
233 | nls_timestamp_tz_format | timestamp with timezone format | DD-MON-RR HH.MI.SSXFF AM TZR |
234 | nls_dual_currency | Dual currency symbol | $ |
235 | nls_comp | NLS comparison | BINARY |
236 | nls_length_semantics | create columns using byte or char semantics by default | BYTE |
237 | nls_nchar_conv_excp | NLS raise an exception instead of allowing implicit conversion | FALSE |
238 | _nchar_imp_cnv | NLS allow Implicit Conversion between CHAR and NCHAR | TRUE |
239 | _nls_parameter_sync_enabled | enables or disables updates to v$parameter whenever an alter session statement modifies various nls parameters | TRUE |
240 | _disable_file_locks | disable file locks for control, data, redo log files | FALSE |
241 | _ksfd_verify_write | verify asynchronous writes issued through ksfd | FALSE |
242 | _disable_odm | disable odm feature | FALSE |
243 | fileio_network_adapters | Network Adapters for File I/O | |
244 | _enable_list_io | Enable List I/O | FALSE |
245 | filesystemio_options | IO operations on filesystem files | none |
246 | _omf | enable/disable OMF | enabled |
247 | _aiowait_timeouts | Number of aiowait timeouts before error is reported | 100 |
248 | _io_shared_pool_size | Size of I/O buffer pool from SGA | 4194304 |
249 | _max_io_size | Maximum I/O size in bytes for sequential file accesses | 1048576 |
250 | _io_statistics | if TRUE, ksfd I/O statistics are collected | TRUE |
251 | _disk_sector_size_override | if TRUE, OSD sector size could be overridden | FALSE |
252 | _simulate_disk_sectorsize | Enables skgfr to report simulated disk sector size | 0 |
253 | _enable_asyncvio | enable asynch vectored I/O | FALSE |
254 | _iocalibrate_max_ios | iocalibrate max I/Os per process | 0 |
255 | _iocalibrate_init_ios | iocalibrate init I/Os per process | 2 |
256 | clonedb | clone database | FALSE |
257 | _db_file_direct_io_count | Sequential I/O buf size | 1048576 |
258 | _cell_fast_file_create | Allow optimized file creation path for Cells | TRUE |
259 | _cell_fast_file_restore | Allow optimized rman restore for Cells | TRUE |
260 | _file_size_increase_increment | Amount of file size increase increment, in bytes | 67108864 |
261 | _ioslave_issue_count | IOs issued before completion check | 500 |
262 | _ioslave_batch_count | Per attempt IOs picked | 1 |
263 | disk_asynch_io | Use asynch I/O for random access devices | TRUE |
264 | tape_asynch_io | Use asynch I/O requests for tape devices | TRUE |
265 | _io_slaves_disabled | Do not use I/O slaves | FALSE |
266 | dbwr_io_slaves | DBWR I/O slaves | 0 |
267 | _lgwr_io_slaves | LGWR I/O slaves | 0 |
268 | _arch_io_slaves | ARCH I/O slaves | 0 |
269 | _backup_disk_io_slaves | BACKUP Disk I/O slaves | 0 |
270 | backup_tape_io_slaves | BACKUP Tape I/O slaves | FALSE |
271 | _fg_iorm_slaves | ForeGround I/O slaves for IORM | 1 |
272 | _backup_io_pool_size | memory to reserve from the large pool | 1048576 |
273 | _reset_maxcap_history | reset maxcap history time | 10 |
274 | _high_server_threshold | high server thresholds | 0 |
275 | _low_server_threshold | low server thresholds | 0 |
276 | _active_session_idle_limit | active session idle limit | 5 |
277 | _active_session_legacy_behavior | active session legacy behavior | FALSE |
278 | resource_manager_cpu_allocation | Resource Manager CPU allocation | 2 |
279 | _resource_manager_plan | resource mgr top plan for internal use | |
280 | resource_manager_plan | resource mgr top plan | |
281 | _vkrm_schedule_interval | VKRM scheduling interval | 10 |
282 | _dbrm_dynamic_threshold | DBRM dynamic threshold setting | 16843752 |
283 | _resource_manager_always_off | disable the resource manager always | FALSE |
284 | _resource_manager_always_on | enable the resource manager always | TRUE |
285 | _io_resource_manager_always_on | io resource manager always on | FALSE |
286 | _max_small_io | IORM:max number of small I/O's to issue | 0 |
287 | _max_large_io | IORM:max number of large I/O's to issue | 0 |
288 | _auto_assign_cg_for_sessions | auto assign CGs for sessions | FALSE |
289 | _rm_numa_simulation_pgs | number of PGs for numa simulation in resource manager | 0 |
290 | _rm_numa_simulation_cpus | number of cpus for each pg for numa simulation in resource manager | 0 |
291 | _rm_numa_sched_enable | Is Resource Manager (RM) related NUMA scheduled policy enabled | FALSE |
292 | _dbrm_runchk | Resource Manager Diagnostic Running Thread Check | 0 |
293 | _dbrm_short_wait_us | Resource Manager short wait length | 300 |
294 | _dbrm_num_runnable_list | Resource Manager number of runnable list per NUMA node | 0 |
295 | _db_check_cell_hints | FALSE | |
296 | _pqq_enabled | Enable Resource Manager based Parallel Statement Queuing | TRUE |
297 | _pqq_debug_txn_act | pq queuing transaction active | FALSE |
298 | _ksr_unit_test_processes | number of ksr unit test processes | 0 |
299 | _ksv_spawn_control_all | control all spawning of background slaves | FALSE |
300 | _ksv_max_spawn_fail_limit | bg slave spawn failure limit | 5 |
301 | _ksv_pool_wait_timeout | bg slave pool wait limit | 600 |
302 | _ksv_pool_hang_kill_to | bg slave pool terminate timeout | 0 |
303 | _ksvppktmode | ksv internal pkt test | 0 |
304 | _ksv_static_flags1 | ksv static flags 1 - override default behavior | 0 |
305 | _ksv_dynamic_flags1 | ksv dynamic flags 1 - override default behavior | 0 |
306 | _first_spare_parameter | first spare parameter - integer | |
307 | _second_spare_parameter | second spare parameter - integer | |
308 | _third_spare_parameter | third spare parameter - integer | |
309 | _fourth_spare_parameter | fourth spare parameter - integer | |
310 | _fifth_spare_parameter | fifth spare parameter - integer | |
311 | _sixth_spare_parameter | sixth spare parameter - integer | |
312 | _seventh_spare_parameter | seventh spare parameter - integer | |
313 | _eighth_spare_parameter | eighth spare parameter - integer | |
314 | _ninth_spare_parameter | ninth spare parameter - integer | |
315 | _tenth_spare_parameter | tenth spare parameter - integer | |
316 | _eleventh_spare_parameter | eleventh spare parameter - string | |
317 | _twelfth_spare_parameter | twelfth spare parameter - string | |
318 | _thirteenth_spare_parameter | thirteenth spare parameter - string | |
319 | _fourteenth_spare_parameter | fourteenth spare parameter - string | |
320 | _fifteenth_spare_parameter | fifteenth spare parameter - string | |
321 | _sixteenth_spare_parameter | sixteenth spare parameter - string list | |
322 | _seventeenth_spare_parameter | seventeenth spare parameter - string list | |
323 | _eighteenth_spare_parameter | eighteenth spare parameter - string list | |
324 | _nineteenth_spare_parameter | nineteenth spare parameter - string list | |
325 | _twentieth_spare_parameter | twentieth spare parameter - string list | |
326 | _ksxp_ping_enable | disable dynamic loadin of lib skgxp | TRUE |
327 | _ksxp_ping_polling_time | max. arrays for ipc statistics | 0 |
328 | _ksxp_disable_dynamic_loading | disable dynamic loadin of lib skgxp | FALSE |
329 | _ksxp_disable_rolling_migration | disable possibility of starting rolling migration | FALSE |
330 | _skgxp_udp_use_tcb | disable use of high speek timer | TRUE |
331 | _ksxp_skgxp_library_path | over-ride default location of lib skgxp | |
332 | _ksxp_skgxp_compat_library_path | over-ride default location of lib skgxp compat | |
333 | _ksxp_disable_ipc_stats | disable ipc statistics | FALSE |
334 | _ksxp_max_stats_bkts | max. arrays for ipc statistics | 0 |
335 | _ksxp_init_stats_bkts | initial number arrays for ipc statistics | 0 |
336 | _ksxp_stats_mem_lmt | limit ipc statistics memory. this parameter is a percentage value | 0 |
337 | cluster_interconnects | interconnects for RAC use | |
338 | _rm_cluster_interconnects | interconnects for RAC use (RM) | |
339 | _ksxp_disable_clss | disable CLSS interconnects | 0 |
340 | _ksxp_send_timeout | set timeout for sends queued with the inter-instance IPC | 300 |
341 | _ksxp_dump_timeout | set timeout for kjzddmp request | 20 |
342 | _ksxp_diagmode | set to OFF to disable automatic slowsend diagnostics | OFF |
343 | _skgxp_reaping | tune skgxp OSD reaping limit | 1000 |
344 | _ksxp_reaping | tune ksxp layer reaping limit | 20 |
345 | _ksxp_wait_flags | tune ksxpwait | 0 |
346 | _ksxp_control_flags | modify ksxp behavior | 0 |
347 | _skgxp_udp_hiwat_warn | ach hiwat mark warning interval | 1000 |
348 | _skgxp_udp_ach_reaping_time | time in minutes before idle ach's are reaped | 120 |
349 | _skgxp_udp_timed_wait_seconds | time in seconds before timed wait is invoked | 5 |
350 | _skgxp_udp_timed_wait_buffering | diagnostic log buffering space (in bytes) for timed wait (0 means unbufferd | 1024 |
351 | _skgxp_udp_keep_alive_ping_timer_secs | connection idle time in seconds before keep alive is initiated. min: 30 sec max: 1800 sec default: 300 sec | 300 |
352 | _disable_duplex_link | Turn off connection duplexing | TRUE |
353 | _diag_diagnostics | Turn off diag diagnostics | TRUE |
354 | _disable_interface_checking | disable interface checking at startup | FALSE |
355 | _skgxp_udp_interface_detection_time_secs | time in seconds between interface detection checks | 60 |
356 | _skgxp_udp_lmp_on | enable UDP long message protection | FALSE |
357 | _skgxp_udp_lmp_mtusize | MTU size for UDP LMP testing | 0 |
358 | _skgxp_udp_enable_dynamic_credit_mgmt | Enables dynamic credit management | 0 |
359 | _skgxp_udp_ack_delay | Enables delayed acks | 0 |
360 | _skgxp_gen_ant_ping_misscount | ANT protocol ping miss count | 3 |
361 | _skgxp_gen_rpc_no_path_check_in_sec | ANT ping protocol miss count | 5 |
362 | _skgxp_gen_rpc_timeout_in_sec | VRPC request timeout when ANT enabled | 300 |
363 | _skgxp_gen_ant_off_rpc_timeout_in_sec | VRPC request timeout when ANT disabled | 30 |
364 | _skgxp_min_zcpy_len | IPC threshold for zcpy operation (default = 0 - disabled) | 0 |
365 | _skgxp_min_rpc_rcv_zcpy_len | IPC threshold for rpc rcv zcpy operation (default = 0 - disabled) | 0 |
366 | _skgxp_zcpy_flags | IPC zcpy options flags | 0 |
367 | _skgxp_ctx_flags1 | IPC debug options flags (oss) | 0 |
368 | _skgxp_ctx_flags1mask | IPC debug options flags mask (oss) | 0 |
369 | _skgxp_dynamic_protocol | IPC protocol override (!0/-1=*,2=UDP,3=RDS,0x1000=ipc_X) | 0 |
370 | _skgxp_inets | limit SKGXP networks | |
371 | _skgxp_rgn_ports | region socket limits (0xFFFFNNXX): F=flags, N=min, X=max | 0 |
372 | _ksxp_skgxp_ctx_flags1 | IPC debug options flags (RAC) | 0 |
373 | _ksxp_skgxp_ctx_flags1mask | IPC debug options flags mask (RAC) | 0 |
374 | _ksxp_skgxp_dynamic_protocol | IPC protocol override (RAC) (0/-1=*,2=UDP,3=RDS,!0x1000=ipc_X) | 4096 |
375 | _ksxp_skgxp_rgn_ports | region socket limits (0xFFFFNNXX): F=flags, N=min, X=max | 0 |
376 | _ksxp_dynamic_skgxp_param | dynamic skgxp parameters | |
377 | _ksxp_if_config | ksxp if config flags | 0 |
378 | _ksxp_compat_flags | ksxp compat flags | 0 |
379 | _skgxp_spare_param1 | ipc oss spare parameter 1 | |
380 | _ksxp_skgxp_spare_param1 | ipc ksxp spare parameter 1 | |
381 | _skgxp_spare_param2 | ipc oss spare parameter 2 | |
382 | _ksxp_skgxp_spare_param2 | ipc ksxp spare parameter 2 | |
383 | _skgxp_spare_param3 | ipc oss spare parameter 3 | |
384 | _ksxp_skgxp_spare_param3 | ipc ksxp spare parameter 3 | |
385 | _skgxp_spare_param4 | ipc oss spare parameter 4 | |
386 | _ksxp_skgxp_spare_param4 | ipc ksxp spare parameter 4 | |
387 | _skgxp_spare_param5 | ipc oss spare parameter 5 | |
388 | _ksxp_skgxp_spare_param5 | ipc ksxp spare parameter 5 | |
389 | _skgxpg_last_parameter | last defined skgxpg parameter - oss | 26 |
390 | _ksxp_skgxpg_last_parameter | last defined skgxpg parameter - ksxp | 26 |
391 | _ksxp_testing | KSXP test parameter | 0 |
392 | _ksxp_reporting_process | reporting process for KSXP | LMD0 |
393 | _ksxp_unit_test_byte_transformation | enable byte transformation unit test | FALSE |
394 | _ksxp_lwipc_enabled | enable lwipc for KSXP | FALSE |
395 | _ksmd_protect_mode | KSMD protect mode for catching stale access | off |
396 | _ksmg_granule_size | granule size in bytes | 16777216 |
397 | _ksmg_granule_locking_status | granule locking status | 1 |
398 | _ksmg_lock_check_interval | timeout action interval in minutes | |
399 | _ksmg_lock_reacquire_count | repeat count for acquisition of locks | 5 |
400 | file_mapping | enable file mapping | FALSE |
401 | _filemap_dir | FILEMAP directory | |
402 | _object_statistics | enable the object level statistics collection | TRUE |
403 | _object_stats_max_entries | Maximum number of entries to be tracked per stat | 3072 |
404 | _enable_rlb | enable RLB metrics processing | TRUE |
405 | _enable_midtier_affinity | enable midtier affinity metrics processing | TRUE |
406 | _midtier_affinity_clusterwait_threshold | cluster wait threshold to enter affinity | 100 |
407 | _midtier_affinity_goodness_threshold | goodness gradient threshold to dissolve affinity | 2000 |
408 | _service_cleanup_timeout | timeout to peform service cleanup | 30 |
409 | _max_services | maximum number of database services | 150 |
410 | _disable_health_check | Disable Health Check | FALSE |
411 | _mpmt_enabled | MPMT mode enabled | FALSE |
412 | _spawn_diag_thresh_secs | thread spawn diagnostic minimal threshold in seconds | 30 |
413 | _spawn_diag_opts | thread spawn diagnostic options | 0 |
414 | _sched_delay_sample_interval_ms | scheduling delay sampling interval in ms | 1000 |
415 | _sched_delay_max_samples | scheduling delay maximum number of samples | 4 |
416 | _sched_delay_sample_collection_thresh_ms | scheduling delay sample collection duration threshold ms | 200 |
417 | _sched_delay_measurement_sleep_us | scheduling delay mesurement sleep us | 1000 |
418 | _sched_delay_os_tick_granularity_us | os tick granularity used by scheduling delay calculations | 16000 |
419 | _accept_versions | List of parameters for rolling operation | |
420 | _hang_analysis_num_call_stacks | hang analysis num call stacks | 3 |
421 | _local_hang_analysis_interval_secs | the interval at which local hang analysis is run | 3 |
422 | _deadlock_resolution_level | automatic deadlock resolution level | 1 |
423 | _deadlock_resolution_incidents_enabled | create incidents during deadlock resolution | TRUE |
424 | _deadlock_resolution_incidents_always | create incidents when resolving any deadlock? | FALSE |
425 | _deadlock_resolution_min_wait_timeout_secs | the minimum wait timeout required for deadlock resolution | 60 |
426 | _deadlock_resolution_signal_process_thresh_secs | the amount of time given to process a deadlock resolution signal | 60 |
427 | _heur_deadlock_resolution_secs | the heuristic wait time per node for deadlock resolution | 0 |
428 | _deadlock_diagnostic_level | automatic deadlock resolution diagnostics level | 2 |
429 | _blocking_sess_graph_cache_size | blocking session graph cache size in bytes | |
430 | _diag_proc_enabled | enable hung process diagnostic API | TRUE |
431 | _diag_proc_stack_capture_type | hung process diagnostic API stack capture type | 1 |
432 | _diag_proc_max_time_ms | hung process diagnostic API max wait time in milliseconds | 30000 |
433 | _hang_msg_checksum_enabled | enable hang graph message checksum | TRUE |
434 | _kspol_tac_timeout | timeouts for TAC registerd by kspol | 5 |
435 | _disable_12751 | disable policy timeout error (ORA-12751) | FALSE |
436 | _diskmon_pipe_name | DiSKMon skgznp pipe name | |
437 | _dskm_health_check_cnt | DiSKMon health check counter | 20 |
438 | _ksmb_debug | ksmb debug flags | 0 |
439 | _pmon_enable_dead_blkrs | look for dead blockers during PMON cleanup | TRUE |
440 | _pmon_dead_blkrs_scan_rate_secs | rate to scan for dead blockers during cleanup (in seconds) | 3 |
441 | _pmon_dead_blkrs_alive_chk_rate_secs | rate to check blockers are alive during cleanup (in seconds) | 3 |
442 | _pmon_dead_blkrs_max_cleanup_attempts | max attempts per blocker while checking dead blockers | 5 |
443 | _pmon_dead_blkrs_max_blkrs | max blockers to check during cleanup | 200 |
444 | _pmon_max_consec_posts | PMON max consecutive posts in main loop | 5 |
445 | _dead_process_scan_interval | PMON dead process scan interval (in seconds) | 60 |
446 | _main_dead_process_scan_interval | PMON main dead process scan interval (in seconds) | 0 |
447 | _use_platform_compression_lib | Enable platform optimized compression implementation | FALSE |
448 | _use_platform_encryption_lib | Enable platform optimized encryption implementation | TRUE |
449 | _use_hybrid_encryption_mode | Enable platform optimized encryption in hybrid mode | FALSE |
450 | _xengem_diagmode | set to OFF to disable VM GEM support and functionalities | OFF |
451 | _xengem_devname | override default VM GEM device name used by skgvm | DEFAULT |
452 | _xengem_enabled | Enable OVM GEM support | TRUE |
453 | _diag_daemon | start DIAG daemon | TRUE |
454 | _dump_system_state_scope | scope of sysstate dump during instance termination | local |
455 | _dump_trace_scope | scope of trace dump during a process crash | global |
456 | _dump_interval_limit | trace dump time interval limit (in seconds) | 120 |
457 | _dump_max_limit | max number of dump within dump interval | 5 |
458 | _diag_dump_timeout | timeout parameter for SYNC dump | 30 |
459 | _diag_dump_request_debug_level | DIAG dump request debug level (0-2) | 1 |
460 | _diag_crashdump_level | parameter for systemstate dump level, used by DIAG during crash | 10 |
461 | _hang_detection_enabled | Hang Management detection | TRUE |
462 | _hang_detection_interval | Hang Management detection interval in seconds | 32 |
463 | _hang_resolution_scope | Hang Management hang resolution scope | PROCESS |
464 | _hang_resolution_policy | Hang Management hang resolution policy | HIGH |
465 | _hang_resolution_confidence_promotion | Hang Management hang resolution confidence promotion | FALSE |
466 | _hang_resolution_global_hang_confidence_promotion | Hang Management hang resolution global hang confidence promotion | FALSE |
467 | _hang_resolution_promote_process_termination | Hang Management hang resolution promote process termination | FALSE |
468 | _hang_output_suspected_hangs | Hang Management enabled output of suspected hangs | FALSE |
469 | _hang_signature_list_match_output_frequency | Hang Signature List matched output frequency | 10 |
470 | _hm_analysis_output_disk | if TRUE the hang manager outputs hang analysis results to disk | FALSE |
471 | _hm_analysis_oradebug_node_dump_level | the oradebug node dump level for hang manager hang analysis | 0 |
472 | _hm_analysis_oradebug_sys_dump_level | the oradebug system state level for hang manager hang analysis | 0 |
473 | _global_hang_analysis_interval_secs | the interval at which global hang analysis is run | 10 |
474 | _hang_verification_interval | Hang Management verification interval in seconds | 46 |
475 | _hang_ignored_hangs_interval | Time in seconds ignored hangs must persist after verification | 300 |
476 | _hang_ignored_hang_count | Hang Management ignored hang count | 1 |
477 | _hang_hiload_promoted_ignored_hang_count | Hang Management high load or promoted ignored hang count | 2 |
478 | _hang_log_incidents | Hang Manager incident logging | FALSE |
479 | _hang_long_wait_time_threshold | Long session wait time threshold in seconds | 0 |
480 | _hang_lws_file_count | Number of trace files for long waiting sessions | 5 |
481 | _hang_lws_file_time_limit | Timespan in seconds for current long waiting session trace file | 3600 |
482 | _hang_hiprior_session_attribute_list | Hang Management high priority session attribute list | |
483 | _ipddb_enable | Enable IPD/DB data collection | FALSE |
484 | _trace_navigation_scope | enabling trace navigation linking | global |
485 | _max_protocol_support | Max occurrence protocols supported in a process | 10000 |
486 | _lm_lms | number of background gcs server processes to start | 0 |
487 | gcs_server_processes | number of background gcs server processes to start | 0 |
488 | _lm_dynamic_lms | dynamic lms invocation | FALSE |
489 | _lm_max_lms | max. number of background global cache server processes | 0 |
490 | _lm_activate_lms_threshold | threshold value to activate an additional lms | 100 |
491 | _lm_lmd_waittime | default wait time for lmd in centiseconds | 8 |
492 | _lm_lms_waittime | default wait time for lms in centiseconds | 3 |
493 | _lm_procs | number of client processes configured for cluster database | 320 |
494 | _lm_lms_priority_dynamic | enable lms priority modification | TRUE |
495 | _lm_lms_rt_threshold | maximum number of real time lms processes on machine | |
496 | _lm_ress | number of resources configured for cluster database | 6000 |
497 | _lm_locks | number of enqueues configured for cluster database | 12000 |
498 | _lm_master_weight | master resource weight for this instance | 1 |
499 | active_instance_count | number of active instances in the cluster database | |
500 | _active_instance_count | number of active instances in the cluster database |
About Me
...............................................................................................................................
● 本文作者:小麦苗,只专注于数据库的技术,更注重技术的运用
● 本文在itpub(http://blog.itpub.net/26736162)、博客园(http://www.cnblogs.com/lhrbest)和个人微信公众号(xiaomaimiaolhr)上有同步更新
● 本文itpub地址:http://blog.itpub.net/26736162/abstract/1/
● 本文博客园地址:http://www.cnblogs.com/lhrbest
● 本文pdf版及小麦苗云盘地址:http://blog.itpub.net/26736162/viewspace-1624453/
● 数据库笔试面试题库及解答:http://blog.itpub.net/26736162/viewspace-2134706/
● QQ群:230161599 微信群:私聊
● 联系我请加QQ好友(646634621),注明添加缘由
● 于 2017-06-02 09:00 ~ 2017-06-30 22:00 在魔都完成
● 文章内容来源于小麦苗的学习笔记,部分整理自网络,若有侵权或不当之处还请谅解
● 版权所有,欢迎分享本文,转载请保留出处
...............................................................................................................................
拿起手机使用微信客户端扫描下边的左边图片来关注小麦苗的微信公众号:xiaomaimiaolhr,扫描右边的二维码加入小麦苗的QQ群,学习最实用的数据库技术。