oracle参数列表

2022-02-27 04:46:37

NUM NAME TYPE VALUE ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISMODIFIED ISADJUSTED DESCRIPTION UPDATE_COMMENT
2 tracefile_identifier 2 NULL TRUE TRUE FALSE FALSE FALSE trace file custom identifier NULL
9 processes 3 150 FALSE FALSE FALSE FALSE FALSE user processes NULL
10 sessions 3 170 TRUE FALSE FALSE FALSE FALSE user and system sessions NULL
11 timed_statistics 1 TRUE FALSE TRUE IMMEDIATE FALSE FALSE maintain internal timing statistics NULL
12 timed_os_statistics 3 0 TRUE TRUE IMMEDIATE FALSE FALSE internal os statistic gathering interval in seconds NULL
13 resource_limit 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE master switch for resource limit NULL
14 license_max_sessions 3 0 TRUE FALSE IMMEDIATE FALSE FALSE maximum number of non-system user sessions allowed NULL
15 license_sessions_warning 3 0 TRUE FALSE IMMEDIATE FALSE FALSE warning level for number of non-system user sessions NULL
19 cpu_count 3 1 TRUE FALSE FALSE FALSE FALSE initial number of cpu's for this instance NULL
22 instance_groups 2 NULL TRUE FALSE FALSE FALSE FALSE list of instance group names NULL
23 event 2 NULL TRUE FALSE FALSE FALSE FALSE debug event control - default null string NULL
24 shared_pool_size 6 46137344 FALSE FALSE IMMEDIATE FALSE FALSE size in bytes of shared pool internally adjusted
25 sga_max_size 6 118255568 TRUE FALSE FALSE FALSE FALSE max total SGA size internally adjusted
29 shared_pool_reserved_size 6 1677721 TRUE FALSE FALSE FALSE FALSE size in bytes of reserved area of shared pool NULL
32 large_pool_size 2 1048576 FALSE FALSE FALSE FALSE FALSE size in bytes of the large allocation pool NULL
34 java_pool_size 2 33554432 FALSE FALSE FALSE FALSE FALSE size in bytes of the Java pool NULL
35 java_soft_sessionspace_limit 3 0 TRUE FALSE FALSE FALSE FALSE warning limit on size in bytes of a Java sessionspace NULL
36 java_max_sessionspace_size 3 0 TRUE FALSE FALSE FALSE FALSE max allowed size in bytes of a Java sessionspace NULL
37 pre_page_sga 1 FALSE TRUE FALSE FALSE FALSE FALSE pre-page sga for process NULL
38 shared_memory_address 3 0 TRUE FALSE FALSE FALSE FALSE SGA starting address (low order 32-bits on 64-bit platforms) NULL
39 hi_shared_memory_address 3 0 TRUE FALSE FALSE FALSE FALSE SGA starting address (high order 32-bits on 64-bit platforms) NULL
40 use_indirect_data_buffers 1 FALSE TRUE FALSE FALSE FALSE FALSE Enable indirect data buffers (very large SGA on 32-bit platforms NULL
42 lock_sga 1 FALSE TRUE FALSE FALSE FALSE FALSE Lock entire SGA in physical memory NULL
55 spfile 2 NULL TRUE FALSE FALSE FALSE FALSE server parameter file NULL
57 lock_name_space 2 NULL TRUE FALSE FALSE FALSE FALSE lock name space used for generating lock names for standby/clone NULL
59 enqueue_resources 3 968 TRUE FALSE FALSE FALSE FALSE resources for enqueues NULL
64 trace_enabled 1 TRUE TRUE FALSE IMMEDIATE FALSE FALSE enable KST tracing NULL
72 nls_language 2 AMERICAN TRUE TRUE FALSE FALSE FALSE NLS language name NULL
73 nls_territory 2 AMERICA TRUE TRUE FALSE FALSE FALSE NLS territory name NULL
74 nls_sort 2 NULL TRUE TRUE FALSE FALSE FALSE NLS linguistic definition name NULL
75 nls_date_language 2 NULL TRUE TRUE FALSE FALSE FALSE NLS date language name NULL
76 nls_date_format 2 NULL TRUE TRUE FALSE FALSE FALSE NLS Oracle date format NULL
77 nls_currency 2 NULL TRUE TRUE FALSE FALSE FALSE NLS local currency symbol NULL
78 nls_numeric_characters 2 NULL TRUE TRUE FALSE FALSE FALSE NLS numeric characters NULL
79 nls_iso_currency 2 NULL TRUE TRUE FALSE FALSE FALSE NLS ISO currency territory name NULL
80 nls_calendar 2 NULL TRUE TRUE FALSE FALSE FALSE NLS calendar system name NULL
81 nls_time_format 2 NULL TRUE TRUE FALSE FALSE FALSE time format NULL
82 nls_timestamp_format 2 NULL TRUE TRUE FALSE FALSE FALSE time stamp format NULL
83 nls_time_tz_format 2 NULL TRUE TRUE FALSE FALSE FALSE time with timezone format NULL
84 nls_timestamp_tz_format 2 NULL TRUE TRUE FALSE FALSE FALSE timestampe with timezone format NULL
85 nls_dual_currency 2 NULL TRUE TRUE FALSE FALSE FALSE Dual currency symbol NULL
86 nls_comp 2 NULL TRUE TRUE FALSE FALSE FALSE NLS comparison NULL
87 nls_length_semantics 2 BYTE TRUE FALSE IMMEDIATE FALSE FALSE create columns using byte or char semantics by default NULL
88 nls_nchar_conv_excp 2 FALSE TRUE FALSE IMMEDIATE FALSE FALSE NLS raise an exception instead of allowing implicit conversion NULL
91 disk_asynch_io 1 TRUE TRUE FALSE FALSE FALSE FALSE Use asynch I/O for random access devices NULL
92 tape_asynch_io 1 TRUE TRUE FALSE FALSE FALSE FALSE Use asynch I/O requests for tape devices NULL
94 dbwr_io_slaves 3 0 TRUE FALSE FALSE FALSE FALSE DBWR I/O slaves NULL
98 backup_tape_io_slaves 1 FALSE TRUE FALSE DEFERRED FALSE FALSE BACKUP Tape I/O slaves NULL
108 resource_manager_plan 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE resource mgr top plan NULL
117 cluster_interconnects 2 NULL TRUE FALSE FALSE FALSE FALSE interconnects for RAC use NULL
131 active_instance_count 3 NULL TRUE FALSE FALSE FALSE FALSE number of active instances in the cluster database NULL
173 control_files 2 D:\oracle\oradata\Tianyi\CONTROL01.CTL, D:\oracle\oradata\Tianyi\CONTROL02.CTL, D:\oracle\oradata\Tianyi\CONTROL03.CTL FALSE FALSE FALSE FALSE FALSE control file names list NULL
175 db_file_name_convert 2 NULL TRUE FALSE FALSE FALSE FALSE datafile name convert patterns and strings for standby/clone db NULL
176 log_file_name_convert 2 NULL TRUE FALSE FALSE FALSE FALSE logfile name convert patterns and strings for standby/clone db NULL
177 db_block_buffers 3 0 TRUE FALSE FALSE FALSE FALSE Number of database blocks cached in memory NULL
180 db_block_checksum 1 TRUE TRUE FALSE IMMEDIATE FALSE FALSE store checksum in db blocks and check during reads NULL
181 db_block_size 3 4096 FALSE FALSE FALSE FALSE FALSE Size of database block in bytes NULL
187 db_writer_processes 3 1 TRUE FALSE FALSE FALSE FALSE number of background database writer processes to start NULL
200 db_keep_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of KEEP buffer pool for standard block size buffers NULL
201 db_recycle_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of RECYCLE buffer pool for standard block size buffers NULL
202 db_2k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 2K buffers NULL
203 db_4k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 4K buffers NULL
204 db_8k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 8K buffers NULL
205 db_16k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 16K buffers NULL
206 db_32k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 32K buffers NULL
207 db_cache_size 6 33554432 FALSE FALSE IMMEDIATE FALSE FALSE Size of DEFAULT buffer pool for standard block size buffers NULL
209 buffer_pool_keep 2 NULL TRUE FALSE FALSE FALSE FALSE Number of database blocks/latches in keep buffer pool NULL
210 buffer_pool_recycle 2 NULL TRUE FALSE FALSE FALSE FALSE Number of database blocks/latches in recycle buffer pool NULL
235 db_cache_advice 2 OFF TRUE FALSE IMMEDIATE FALSE FALSE Buffer cache sizing advisory NULL
236 max_commit_propagation_delay 3 700 TRUE FALSE FALSE FALSE FALSE Max age of new snapshot in .01 seconds NULL
238 compatible 2 9.0.0 FALSE FALSE FALSE FALSE FALSE Database will be completely compatible with this software versio NULL
244 remote_archive_enable 1 TRUE TRUE FALSE FALSE FALSE FALSE remote archivelog destinations enabled NULL
245 log_archive_start 1 FALSE TRUE FALSE FALSE FALSE FALSE start archival process on SGA initialization NULL
248 log_archive_dest 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE archival destination text string NULL
249 log_archive_duplex_dest 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE duplex archival destination text string NULL
250 log_archive_dest_1 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #1 text string NULL
251 log_archive_dest_2 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #2 text string NULL
252 log_archive_dest_3 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #3 text string NULL
253 log_archive_dest_4 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #4 text string NULL
254 log_archive_dest_5 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #5 text string NULL
255 log_archive_dest_6 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #6 text string NULL
256 log_archive_dest_7 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #7 text string NULL
257 log_archive_dest_8 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #8 text string NULL
258 log_archive_dest_9 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #9 text string NULL
259 log_archive_dest_10 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE archival destination #10 text string NULL
260 log_archive_dest_state_1 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #1 state text string NULL
261 log_archive_dest_state_2 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #2 state text string NULL
262 log_archive_dest_state_3 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #3 state text string NULL
263 log_archive_dest_state_4 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #4 state text string NULL
264 log_archive_dest_state_5 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #5 state text string NULL
265 log_archive_dest_state_6 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #6 state text string NULL
266 log_archive_dest_state_7 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #7 state text string NULL
267 log_archive_dest_state_8 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #8 state text string NULL
268 log_archive_dest_state_9 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #9 state text string NULL
269 log_archive_dest_state_10 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination #10 state text string NULL
270 log_archive_max_processes 3 1 TRUE FALSE IMMEDIATE FALSE FALSE maximum number of active ARCH processes NULL
271 log_archive_min_succeed_dest 3 1 TRUE TRUE IMMEDIATE FALSE FALSE minimum number of archive destinations that must succeed NULL
272 standby_archive_dest 2 %ORACLE_HOME%\RDBMS TRUE FALSE IMMEDIATE FALSE FALSE standby database archivelog destination text string NULL
273 log_archive_trace 3 0 TRUE FALSE IMMEDIATE FALSE FALSE Establish archivelog operation tracing level NULL
274 fal_server 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE FAL server list NULL
275 fal_client 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE FAL client NULL
276 log_archive_format 2 ARC%S.%T TRUE FALSE FALSE FALSE FALSE archival destination format NULL
283 log_buffer 3 524288 TRUE FALSE FALSE FALSE FALSE redo circular buffer size NULL
285 log_checkpoint_interval 3 0 TRUE FALSE IMMEDIATE FALSE FALSE # redo blocks checkpoint threshold NULL
286 log_checkpoint_timeout 3 1800 TRUE FALSE IMMEDIATE FALSE FALSE Maximum time interval between checkpoints in seconds NULL
288 archive_lag_target 3 0 TRUE FALSE IMMEDIATE FALSE FALSE Maximum number of seconds of redos the standby could lose NULL
294 db_files 3 200 TRUE FALSE FALSE FALSE FALSE max allowable # db files NULL
295 db_file_multiblock_read_count 3 8 TRUE TRUE IMMEDIATE FALSE FALSE db block to be read each IO NULL
298 read_only_open_delayed 1 FALSE TRUE FALSE FALSE FALSE FALSE if TRUE delay opening of read only files until first access NULL
299 cluster_database 1 FALSE TRUE FALSE FALSE FALSE FALSE if TRUE startup in cluster database mode NULL
300 parallel_server 1 FALSE TRUE FALSE FALSE FALSE FALSE if TRUE startup in parallel server mode NULL
301 parallel_server_instances 3 1 TRUE FALSE FALSE FALSE FALSE number of instances to use for sizing OPS SGA structures NULL
302 cluster_database_instances 3 1 TRUE FALSE FALSE FALSE FALSE number of instances to use for sizing cluster db SGA structures NULL
303 db_create_file_dest 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE default database location NULL
304 db_create_online_log_dest_1 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfile destination #1 NULL
305 db_create_online_log_dest_2 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfile destination #2 NULL
306 db_create_online_log_dest_3 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfile destination #3 NULL
307 db_create_online_log_dest_4 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfile destination #4 NULL
308 db_create_online_log_dest_5 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfile destination #5 NULL
309 standby_file_management 2 MANUAL TRUE FALSE IMMEDIATE FALSE FALSE if auto then files are created/dropped automatically on standby NULL
310 standby_preserves_names 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE File names on standby are the same as on the primary. NULL
315 gc_files_to_locks 2 NULL TRUE FALSE FALSE FALSE FALSE mapping between file numbers and global cache locks (DFS) NULL
335 thread 3 0 TRUE FALSE FALSE FALSE FALSE Redo thread to mount NULL
338 fast_start_io_target 3 0 TRUE FALSE IMMEDIATE FALSE FALSE Upper bound on recovery reads NULL
339 fast_start_mttr_target 3 300 FALSE FALSE IMMEDIATE FALSE FALSE MTTR target of forward crash recovery in seconds NULL
343 log_checkpoints_to_alert 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE log checkpoint begin/end to alert file NULL
344 recovery_parallelism 3 0 TRUE FALSE FALSE FALSE FALSE number of server processes to use for parallel recovery NULL
345 control_file_record_keep_time 3 7 TRUE FALSE IMMEDIATE FALSE FALSE control file record keep time in days NULL
346 logmnr_max_persistent_sessions 3 1 TRUE FALSE FALSE FALSE FALSE maximum number of threads to mine NULL
348 dml_locks 3 748 TRUE FALSE FALSE FALSE FALSE dml locks - one for each table modified in a transaction NULL
349 row_locking 2 always TRUE FALSE FALSE FALSE FALSE row-locking NULL
350 serializable 1 FALSE TRUE FALSE FALSE FALSE FALSE serializable NULL
351 replication_dependency_tracking 1 TRUE TRUE FALSE FALSE FALSE FALSE tracking dependency for Replication parallel propagation NULL
352 instance_number 3 0 TRUE FALSE FALSE FALSE FALSE instance number NULL
359 transactions 3 187 TRUE FALSE FALSE FALSE FALSE max. number of concurrent active transactions NULL
360 transactions_per_rollback_segment 3 5 TRUE FALSE FALSE FALSE FALSE number of active transactions per rollback segment NULL
361 max_rollback_segments 3 37 TRUE FALSE FALSE FALSE FALSE max. number of rollback segments in SGA cache NULL
362 rollback_segments 2 NULL TRUE FALSE FALSE FALSE FALSE undo segment list NULL
367 transaction_auditing 1 TRUE TRUE FALSE DEFERRED FALSE FALSE transaction auditing records generated in the redo log NULL
370 undo_management 2 AUTO FALSE FALSE FALSE FALSE FALSE instance runs in SMU mode if TRUE, else in RBU mode NULL
371 undo_tablespace 2 UNDOTBS FALSE FALSE IMMEDIATE FALSE FALSE use/switch undo tablespace NULL
375 undo_suppress_errors 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE Suppress RBU errors in SMU mode NULL
379 undo_retention 3 900 TRUE FALSE IMMEDIATE FALSE FALSE undo retention in seconds NULL
382 fast_start_parallel_rollback 2 LOW TRUE FALSE IMMEDIATE FALSE FALSE max number of parallel recovery slaves that may be used NULL
384 db_block_checking 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE data and index block checking NULL
399 os_roles 1 FALSE TRUE FALSE FALSE FALSE FALSE retrieve roles from the operating system NULL
400 rdbms_server_dn 2 NULL TRUE FALSE FALSE FALSE FALSE RDBMS's Distinguished Name NULL
401 max_enabled_roles 3 30 TRUE FALSE FALSE FALSE FALSE max number of roles a user can have enabled NULL
402 remote_os_authent 1 FALSE TRUE FALSE FALSE FALSE FALSE allow non-secure remote clients to use auto-logon accounts NULL
403 remote_os_roles 1 FALSE TRUE FALSE FALSE FALSE FALSE allow non-secure remote clients to use os roles NULL
404 O7_DICTIONARY_ACCESSIBILITY 1 FALSE TRUE FALSE FALSE FALSE FALSE Version 7 Dictionary Accessibility Support NULL
406 remote_login_passwordfile 2 EXCLUSIVE FALSE FALSE FALSE FALSE FALSE password file usage parameter NULL
407 dblink_encrypt_login 1 FALSE TRUE FALSE FALSE FALSE FALSE enforce password for distributed login always be encrypted NULL
408 license_max_users 3 0 TRUE FALSE IMMEDIATE FALSE FALSE maximum number of named users that can be created in the databas NULL
409 global_context_pool_size 2 NULL TRUE FALSE FALSE FALSE FALSE Global Application Context Pool Size in Bytes NULL
410 db_domain 2 Oracle FALSE FALSE FALSE FALSE FALSE directory part of global database name stored with CREATE DATABA NULL
411 global_names 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE enforce that database links have same name as remote database NULL
413 distributed_transactions 3 46 TRUE FALSE FALSE FALSE FALSE max. number of concurrent distributed transactions NULL
414 max_transaction_branches 3 8 TRUE FALSE FALSE FALSE FALSE max. number of branches per distributed transaction NULL
416 commit_point_strength 3 1 TRUE FALSE FALSE FALSE FALSE Bias this node has toward not preparing in a two-phase commit NULL
417 instance_name 2 Tianyi FALSE FALSE FALSE FALSE FALSE instance name supported by the instance NULL
418 service_names 2 Tianyi.Oracle TRUE FALSE IMMEDIATE FALSE FALSE service names supported by the instance NULL
419 dispatchers 2 (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) FALSE FALSE IMMEDIATE FALSE FALSE specifications of dispatchers NULL
420 mts_dispatchers 2 (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) TRUE FALSE IMMEDIATE FALSE FALSE specifications of dispatchers NULL
421 shared_servers 3 1 TRUE FALSE IMMEDIATE FALSE FALSE number of shared servers to start up NULL
422 mts_servers 3 1 TRUE FALSE IMMEDIATE FALSE FALSE number of shared servers to start up NULL
423 max_shared_servers 3 20 TRUE FALSE FALSE FALSE FALSE max number of shared servers NULL
424 mts_max_servers 3 20 TRUE FALSE FALSE FALSE FALSE max number of shared servers NULL
425 max_dispatchers 3 5 TRUE FALSE FALSE FALSE FALSE max number of dispatchers NULL
426 mts_max_dispatchers 3 5 TRUE FALSE FALSE FALSE FALSE max number of dispatchers NULL
427 circuits 3 170 TRUE FALSE FALSE FALSE FALSE max number of circuits NULL
428 mts_circuits 3 170 TRUE FALSE FALSE FALSE FALSE max number of circuits NULL
429 shared_server_sessions 3 165 TRUE FALSE FALSE FALSE FALSE max number of shared server sessions NULL
430 mts_sessions 3 165 TRUE FALSE FALSE FALSE FALSE max number of shared server sessions NULL
431 local_listener 2 NULL TRUE FALSE FALSE FALSE FALSE local listener NULL
432 remote_listener 2 NULL TRUE FALSE FALSE FALSE FALSE remote listener NULL
436 mts_service 2 Tianyi TRUE FALSE FALSE FALSE FALSE service supported by dispatchers NULL
437 mts_listener_address 2 NULL TRUE FALSE FALSE FALSE FALSE address(es) of network listener NULL
438 mts_multiple_listeners 1 FALSE TRUE FALSE FALSE FALSE FALSE Are multiple listeners enabled? NULL
439 serial_reuse 2 DISABLE TRUE FALSE FALSE FALSE FALSE reuse the frame segments NULL
440 cursor_space_for_time 1 FALSE TRUE FALSE FALSE FALSE FALSE use more memory in order to get faster execution NULL
441 session_cached_cursors 3 0 TRUE TRUE FALSE FALSE FALSE number of cursors to save in the session cursor cache NULL
442 remote_dependencies_mode 2 TIMESTAMP TRUE TRUE IMMEDIATE FALSE FALSE remote-procedure-call dependencies mode parameter NULL
443 utl_file_dir 2 NULL TRUE FALSE FALSE FALSE FALSE utl_file accessible directories list NULL
446 plsql_v2_compatibility 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL version 2.x compatibility flag NULL
447 plsql_compiler_flags 2 INTERPRETED TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL compiler flags NULL
448 plsql_native_c_compiler 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE plsql native C compiler NULL
449 plsql_native_linker 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE plsql native linker NULL
450 plsql_native_library_dir 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE plsql native library dir NULL
451 plsql_native_make_utility 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE plsql native compilation make utility NULL
452 plsql_native_make_file_name 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE plsql native compilation make file NULL
453 plsql_native_library_subdir_count 3 0 TRUE FALSE IMMEDIATE FALSE FALSE plsql native library number of subdirectories NULL
454 job_queue_processes 3 0 TRUE FALSE IMMEDIATE FALSE FALSE number of job queue slave processes NULL
458 parallel_min_percent 3 0 TRUE TRUE FALSE FALSE FALSE minimum percent of threads required for parallel query NULL
461 create_bitmap_area_size 3 8388608 TRUE FALSE FALSE FALSE FALSE size of create bitmap buffer for bitmap index NULL
462 bitmap_merge_area_size 3 1048576 TRUE FALSE FALSE FALSE FALSE maximum memory allow for BITMAP MERGE NULL
464 cursor_sharing 2 EXACT TRUE TRUE IMMEDIATE FALSE FALSE cursor sharing mode NULL
466 parallel_min_servers 3 0 TRUE FALSE FALSE FALSE FALSE minimum parallel query servers per instance NULL
467 parallel_max_servers 3 5 TRUE FALSE FALSE FALSE FALSE maximum parallel query servers per instance NULL
471 parallel_instance_group 2 NULL TRUE TRUE IMMEDIATE FALSE FALSE instance group to use for all parallel operations NULL
474 parallel_execution_message_size 3 2148 TRUE FALSE FALSE FALSE FALSE message buffer size for parallel execution NULL
482 hash_join_enabled 1 TRUE TRUE TRUE FALSE FALSE FALSE enable/disable hash join NULL
483 hash_area_size 3 1048576 TRUE TRUE FALSE FALSE FALSE size of in-memory hash work area NULL
490 shadow_core_dump 2 partial TRUE FALSE FALSE FALSE FALSE Core Size for Shadow Processes NULL
491 background_core_dump 2 partial TRUE FALSE FALSE FALSE FALSE Core Size for Background Processes NULL
492 background_dump_dest 2 D:\oracle\admin\Tianyi\bdump FALSE FALSE IMMEDIATE FALSE FALSE Detached process dump directory NULL
493 user_dump_dest 2 D:\oracle\admin\Tianyi\udump FALSE FALSE IMMEDIATE FALSE FALSE User process dump directory NULL
494 max_dump_file_size 2 UNLIMITED TRUE TRUE IMMEDIATE FALSE FALSE Maximum size (blocks) of dump file NULL
495 core_dump_dest 2 D:\oracle\admin\Tianyi\cdump FALSE FALSE IMMEDIATE FALSE FALSE Core dump directory NULL
497 oracle_trace_enable 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE Oracle Trace enabled/disabled NULL
498 oracle_trace_facility_path 2 %ORACLE_HOME%\OTRACE\ADMIN\FDF\ TRUE FALSE FALSE FALSE FALSE Oracle TRACE facility path NULL
499 oracle_trace_collection_path 2 %ORACLE_HOME%\OTRACE\ADMIN\CDF\ TRUE FALSE FALSE FALSE FALSE Oracle TRACE collection path NULL
500 oracle_trace_facility_name 2 oracled TRUE FALSE FALSE FALSE FALSE Oracle TRACE default facility name NULL
501 oracle_trace_collection_name 2 NULL TRUE FALSE FALSE FALSE FALSE Oracle TRACE default collection name NULL
502 oracle_trace_collection_size 3 5242880 TRUE FALSE FALSE FALSE FALSE Oracle TRACE collection file max. size NULL
505 object_cache_optimal_size 3 102400 TRUE TRUE DEFERRED FALSE FALSE optimal size of the user session's object cache in bytes NULL
506 object_cache_max_size_percent 3 10 TRUE TRUE DEFERRED FALSE FALSE percentage of maximum size over optimal of the user session's ob NULL
508 session_max_open_files 3 10 TRUE FALSE FALSE FALSE FALSE maximum number of open files allowed per session NULL
512 open_links 3 4 TRUE FALSE FALSE FALSE FALSE max # open links per session NULL
513 open_links_per_instance 3 4 TRUE FALSE FALSE FALSE FALSE max # open links per instance NULL
517 optimizer_features_enable 2 9.0.1 TRUE FALSE FALSE FALSE FALSE optimizer plan compatibility parameter NULL
518 fixed_date 2 NULL TRUE FALSE IMMEDIATE FALSE FALSE fixed SYSDATE value NULL
519 audit_trail 2 NONE TRUE FALSE FALSE FALSE FALSE enable system auditing NULL
520 sort_area_size 3 524288 FALSE TRUE DEFERRED FALSE FALSE size of in-memory sort work area NULL
521 sort_area_retained_size 3 0 TRUE TRUE DEFERRED FALSE FALSE size of in-memory sort work area retained between fetch calls NULL
526 db_name 2 Tianyi FALSE FALSE FALSE FALSE FALSE database name specified in CREATE DATABASE NULL
527 open_cursors 3 300 FALSE FALSE IMMEDIATE FALSE FALSE max # cursors per session NULL
528 ifile 4 D:\oracle\admin\Tianyi\pfile\init.ora FALSE FALSE FALSE FALSE FALSE include file in init.ora NULL
529 sql_trace 1 FALSE TRUE FALSE FALSE FALSE FALSE enable SQL trace NULL
531 os_authent_prefix 2 OPS$ TRUE FALSE FALSE FALSE FALSE prefix for auto-logon accounts NULL
533 optimizer_mode 2 CHOOSE TRUE TRUE FALSE FALSE FALSE optimizer mode NULL
538 sql92_security 1 FALSE TRUE FALSE FALSE FALSE FALSE require select privilege for searched update/delete NULL
540 blank_trimming 1 FALSE TRUE FALSE FALSE FALSE FALSE blank trimming semantics parameter NULL
542 partition_view_enabled 1 FALSE TRUE TRUE FALSE FALSE FALSE enable/disable partitioned views NULL
545 star_transformation_enabled 2 FALSE TRUE TRUE FALSE FALSE FALSE enable the use of star transformation NULL
561 parallel_broadcast_enabled 1 FALSE TRUE TRUE FALSE FALSE FALSE enable broadcasting of small inputs to hash and sort merge joins NULL
569 parallel_adaptive_multi_user 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE enable adaptive setting of degree for multiple user streams NULL
570 parallel_threads_per_cpu 3 2 TRUE FALSE IMMEDIATE FALSE FALSE number of parallel execution threads per CPU NULL
571 parallel_automatic_tuning 1 FALSE TRUE FALSE FALSE FALSE FALSE enable intelligent defaults for parallel execution parameters NULL
590 optimizer_max_permutations 3 2000 TRUE TRUE FALSE FALSE FALSE optimizer maximum join permutations per query block NULL
591 optimizer_index_cost_adj 3 100 TRUE TRUE FALSE FALSE FALSE optimizer index cost adjustment NULL
592 optimizer_index_caching 3 0 TRUE TRUE FALSE FALSE FALSE optimizer percent index caching NULL
599 query_rewrite_enabled 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE allow rewrite of queries using materialized views if enabled NULL
600 query_rewrite_integrity 2 enforced TRUE TRUE IMMEDIATE FALSE FALSE perform rewrite using materialized views with desired integrity NULL
627 sql_version 2 NATIVE TRUE TRUE FALSE FALSE FALSE sql language version parameter for compatibility issues NULL
654 pga_aggregate_target 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Target size for the aggregate PGA memory consumed by the instanc NULL
656 workarea_size_policy 2 MANUAL TRUE TRUE IMMEDIATE FALSE FALSE policy used to size SQL working areas (MANUAL/AUTO) NULL
679 aq_tm_processes 3 0 TRUE FALSE IMMEDIATE FALSE FALSE number of AQ Time Managers to start NULL
681 hs_autoregister 1 TRUE TRUE FALSE IMMEDIATE FALSE FALSE enable automatic server DD updates in HS agent self-registration NULL
682 drs_start 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE start DR Server framework (DMON process) NULL
版权说明

  如果标题未标有<转载、转>等字则属于作者原创，欢迎转载，其版权归作者和博客园共有。
  作      者：温景良
  文章出处：http://wenjl520.cnblogs.com/  或  http://www.cnblogs.com/

posted @ 2009-04-28 23:51 温景良(Jason) Views(435) Comments(0) Edit 收藏
 
oracle参数列表
oracle参数列表

公告

oracle参数列表
本文转自我的程序人生博客园博客，原文链接：http://www.cnblogs.com/wenjl520/archive/2009/04/28/1445781.html/，如需转载请自行联系原作者
 
上一篇：MaxCompute与DataWorks权限介绍和示例


下一篇：Kafka数据如何同步至MaxCompute之实践讲解