l
NAME | DESCRIPTION |
active_instance_count | number of active instances in the cluster database |
aq_tm_processes | number of AQ Time Managers to start |
archive_lag_target | Maximum number of seconds of redos the standby could lose |
asm_diskgroups | disk groups to mount automatically |
asm_diskstring | disk set locations for discovery |
asm_power_limit | number of processes for disk rebalancing |
audit_file_dest | Directory in which auditing files are to reside |
audit_syslog_level | Syslog facility and level |
audit_sys_operations | enable sys auditing |
audit_trail | enable system auditing |
background_core_dump | Core Size for Background Processes |
background_dump_dest | Detached process dump directory |
backup_tape_io_slaves | BACKUP Tape I/O slaves |
bitmap_merge_area_size | maximum memory allow for BITMAP MERGE |
blank_trimming | blank trimming semantics parameter |
buffer_pool_keep | Number of database blocks/latches in keep buffer pool |
buffer_pool_recycle | Number of database blocks/latches in recycle buffer pool |
circuits | max number of circuits |
cluster_database | if TRUE startup in cluster database mode |
cluster_database_instances | number of instances to use for sizing cluster db SGA structures |
cluster_interconnects | interconnects for RAC use |
commit_point_strength | Bias this node has toward not preparing in a two-phase commit |
commit_write | transaction commit log write behaviour |
compatible | Database will be completely compatible with this software version |
control_files | control file names list |
control_file_record_keep_time | control file record keep time in days |
core_dump_dest | Core dump directory |
cpu_count | number of CPUs for this instance |
create_bitmap_area_size | size of create bitmap buffer for bitmap index |
create_stored_outlines | create stored outlines for DML statements |
cursor_sharing | cursor sharing mode |
cursor_space_for_time | use more memory in order to get faster execution |
dbwr_io_slaves | DBWR I/O slaves |
db_16k_cache_size | Size of cache for 16K buffers |
db_2k_cache_size | Size of cache for 2K buffers |
db_32k_cache_size | Size of cache for 32K buffers |
db_4k_cache_size | Size of cache for 4K buffers |
db_8k_cache_size | Size of cache for 8K buffers |
db_block_buffers | Number of database blocks cached in memory |
db_block_checking | header checking and data and index block checking |
db_block_checksum | store checksum in db blocks and check during reads |
db_block_size | Size of database block in bytes |
db_cache_advice | Buffer cache sizing advisory |
db_cache_size | Size of DEFAULT buffer pool for standard block size buffers |
db_create_file_dest | default database location |
db_create_online_log_dest_1 | online log/controlfile destination #1 |
db_create_online_log_dest_2 | online log/controlfile destination #2 |
db_create_online_log_dest_3 | online log/controlfile destination #3 |
db_create_online_log_dest_4 | online log/controlfile destination #4 |
db_create_online_log_dest_5 | online log/controlfile destination #5 |
db_domain | directory part of global database name stored with CREATE DATABASE |
db_files | max allowable # db files |
db_file_multiblock_read_count | db block to be read each IO |
db_file_name_convert | datafile name convert patterns and strings for standby/clone db |
db_flashback_retention_target | Maximum Flashback Database log retention time in minutes. |
db_keep_cache_size | Size of KEEP buffer pool for standard block size buffers |
db_name | database name specified in CREATE DATABASE |
db_recovery_file_dest | default database recovery file location |
db_recovery_file_dest_size | database recovery files size limit |
db_recycle_cache_size | Size of RECYCLE buffer pool for standard block size buffers |
db_unique_name | Database Unique Name |
db_writer_processes | number of background database writer processes to start |
ddl_wait_for_locks | Disable NOWAIT DML lock acquisitions |
dg_broker_config_file1 | data guard broker configuration file #1 |
dg_broker_config_file2 | data guard broker configuration file #2 |
dg_broker_start | start Data Guard broker framework (DMON process) |
disk_asynch_io | Use asynch I/O for random access devices |
dispatchers | specifications of dispatchers |
distributed_lock_timeout | number of seconds a distributed transaction waits for a lock |
dml_locks | dml locks - one for each table modified in a transaction |
drs_start | start DG Broker monitor (DMON process) |
event | debug event control - default null string |
fal_client | FAL client |
fal_server | FAL server list |
fast_start_io_target | Upper bound on recovery reads |
fast_start_mttr_target | MTTR target in seconds |
fast_start_parallel_rollback | max number of parallel recovery slaves that may be used |
fileio_network_adapters | Network Adapters for File I/O |
filesystemio_options | IO operations on filesystem files |
file_mapping | enable file mapping |
fixed_date | fixed SYSDATE value |
gcs_server_processes | number of background gcs server processes to start |
gc_files_to_locks | mapping between file numbers and global cache locks |
global_context_pool_size | Global Application Context Pool Size in Bytes |
global_names | enforce that database links have same name as remote database |
hash_area_size | size of in-memory hash work area |
hi_shared_memory_address | SGA starting address (high order 32-bits on 64-bit platforms) |
hs_autoregister | enable automatic server DD updates in HS agent self-registration |
ifile | include file in init.ora |
instance_groups | list of instance group names |
instance_name | instance name supported by the instance |
instance_number | instance number |
instance_type | type of instance to be executed |
java_max_sessionspace_size | max allowed size in bytes of a Java sessionspace |
java_pool_size | size in bytes of java pool |
java_soft_sessionspace_limit | warning limit on size in bytes of a Java sessionspace |
job_queue_processes | number of job queue slave processes |
large_pool_size | size in bytes of large pool |
ldap_directory_access | RDBMS's LDAP access option |
license_max_sessions | maximum number of non-system user sessions allowed |
license_max_users | maximum number of named users that can be created in the database |
license_sessions_warning | warning level for number of non-system user sessions |
local_listener | local listener |
lock_name_space | lock name space used for generating lock names for standby/clone database |
lock_sga | Lock entire SGA in physical memory |
logmnr_max_persistent_sessions | maximum number of threads to mine |
log_archive_config | log archive config parameter |
log_archive_dest | archival destination text string |
log_archive_dest_1 | archival destination #1 text string |
log_archive_dest_10 | archival destination #10 text string |
log_archive_dest_2 | archival destination #2 text string |
log_archive_dest_3 | archival destination #3 text string |
log_archive_dest_4 | archival destination #4 text string |
log_archive_dest_5 | archival destination #5 text string |
log_archive_dest_6 | archival destination #6 text string |
log_archive_dest_7 | archival destination #7 text string |
log_archive_dest_8 | archival destination #8 text string |
log_archive_dest_9 | archival destination #9 text string |
log_archive_dest_state_1 | archival destination #1 state text string |
log_archive_dest_state_10 | archival destination #10 state text string |
log_archive_dest_state_2 | archival destination #2 state text string |
log_archive_dest_state_3 | archival destination #3 state text string |
log_archive_dest_state_4 | archival destination #4 state text string |
log_archive_dest_state_5 | archival destination #5 state text string |
log_archive_dest_state_6 | archival destination #6 state text string |
log_archive_dest_state_7 | archival destination #7 state text string |
log_archive_dest_state_8 | archival destination #8 state text string |
log_archive_dest_state_9 | archival destination #9 state text string |
log_archive_duplex_dest | duplex archival destination text string |
log_archive_format | archival destination format |
log_archive_local_first | Establish EXPEDITE attribute default value 如果在用STANDBY的情况下,保证归档到本地成功,在远程 |
log_archive_max_processes | maximum number of active ARCH processes |
log_archive_min_succeed_dest | minimum number of archive destinations that must succeed |
log_archive_start | start archival process on SGA initialization |
log_archive_trace | Establish archivelog operation tracing level |
log_buffer | redo circular buffer size |
log_checkpoints_to_alert | log checkpoint begin/end to alert file |
log_checkpoint_interval | # redo blocks checkpoint threshold |
log_checkpoint_timeout | Maximum time interval between checkpoints in seconds |
log_file_name_convert | logfile name convert patterns and strings for standby/clone db |
max_commit_propagation_delay | Max age of new snapshot in .01 seconds |
max_dispatchers | max number of dispatchers |
max_dump_file_size | Maximum size (blocks) of dump file |
max_enabled_roles | max number of roles a user can have enabled |
max_shared_servers | max number of shared servers |
nls_calendar | NLS calendar system name |
nls_comp | NLS comparison |
nls_currency | NLS local currency symbol |
nls_date_format | NLS Oracle date format |
nls_date_language | NLS date language name |
nls_dual_currency | Dual currency symbol |
nls_iso_currency | NLS ISO currency territory name |
nls_language | NLS language name |
nls_length_semantics | create columns using byte or char semantics by default |
nls_nchar_conv_excp | NLS raise an exception instead of allowing implicit conversion |
nls_numeric_characters | NLS numeric characters |
nls_sort | NLS linguistic definition name |
nls_territory | NLS territory name |
nls_timestamp_format | time stamp format |
nls_timestamp_tz_format | timestampe with timezone format |
nls_time_format | time format |
nls_time_tz_format | time with timezone format |
O7_DICTIONARY_ACCESSIBILITY | Version 7 Dictionary Accessibility Support |
object_cache_max_size_percent | percentage of maximum size over optimal of the user session's object cache |
object_cache_optimal_size | optimal size of the user session's object cache in bytes |
olap_page_pool_size | size of the olap page pool in bytes |
open_cursors | max # cursors per session |
open_links | max # open links per session |
open_links_per_instance | max # open links per instance |
optimizer_dynamic_sampling | optimizer dynamic sampling |
optimizer_features_enable | optimizer plan compatibility parameter |
optimizer_index_caching | optimizer percent index caching |
optimizer_index_cost_adj | optimizer index cost adjustment |
optimizer_mode | optimizer mode |
optimizer_secure_view_merging | optimizer secure view merging and predicate pushdown/movearound |
os_authent_prefix | prefix for auto-logon accounts |
os_roles | retrieve roles from the operating system |
parallel_adaptive_multi_user | enable adaptive setting of degree for multiple user streams |
parallel_automatic_tuning | enable intelligent defaults for parallel execution parameters |
parallel_execution_message_size | message buffer size for parallel execution |
parallel_instance_group | instance group to use for all parallel operations |
parallel_max_servers | maximum parallel query servers per instance |
parallel_min_percent | minimum percent of threads required for parallel query |
parallel_min_servers | minimum parallel query servers per instance |
parallel_server | if TRUE startup in parallel server mode |
parallel_server_instances | number of instances to use for sizing OPS SGA structures |
parallel_threads_per_cpu | number of parallel execution threads per CPU |
pga_aggregate_target | Target size for the aggregate PGA memory consumed by the instance |
plsql_ccflags | PL/SQL ccflags |
plsql_code_type | PL/SQL code-type |
plsql_compiler_flags | PL/SQL compiler flags |
plsql_debug | PL/SQL debug |
plsql_native_library_dir | plsql native library dir |
plsql_native_library_subdir_count | plsql native library number of subdirectories |
plsql_optimize_level | PL/SQL optimize level |
plsql_v2_compatibility | PL/SQL version 2.x compatibility flag |
plsql_warnings | PL/SQL compiler warnings settings |
pre_11g_enable_capture | To enable capture of DB Replay |
pre_page_sga | pre-page sga for process |
processes | user processes |
query_rewrite_enabled | allow rewrite of queries using materialized views if enabled |
query_rewrite_integrity | perform rewrite using materialized views with desired integrity |
rdbms_server_dn | RDBMS's Distinguished Name |
read_only_open_delayed | if TRUE delay opening of read only files until first access |
recovery_parallelism | number of server processes to use for parallel recovery |
recyclebin | recyclebin processing |
remote_archive_enable | remote archival enable setting |
remote_dependencies_mode | remote-procedure-call dependencies mode parameter |
remote_listener | remote listener |
remote_login_passwordfile | password file usage parameter |
remote_os_authent | allow non-secure remote clients to use auto-logon accounts |
remote_os_roles | allow non-secure remote clients to use os roles |
replication_dependency_tracking | tracking dependency for Replication parallel propagation |
resource_limit | master switch for resource limit |
resource_manager_plan | resource mgr top plan |
resumable_timeout | set resumable_timeout |
rollback_segments | undo segment list |
serial_reuse | reuse the frame segments |
service_names | service names supported by the instance |
sessions | user and system sessions |
session_cached_cursors | Number of cursors to cache in a session. |
session_max_open_files | maximum number of open files allowed per session |
sga_max_size | max total SGA size |
sga_target | Target size of SGA |
shadow_core_dump | Core Size for Shadow Processes |
shared_memory_address | SGA starting address (low order 32-bits on 64-bit platforms) |
shared_pool_reserved_size | size in bytes of reserved area of shared pool |
shared_pool_size | size in bytes of shared pool |
shared_servers | number of shared servers to start up |
shared_server_sessions | max number of shared server sessions |
skip_unusable_indexes | skip unusable indexes if set to TRUE |
smtp_out_server | utl_smtp server and port configuration parameter |
sort_area_retained_size | size of in-memory sort work area retained between fetch calls |
sort_area_size | size of in-memory sort work area |
spfile | server parameter file |
sql92_security | require select privilege for searched update/delete |
sqltune_category | Category qualifier for applying hintsets |
sql_trace | enable SQL trace |
sql_version | sql language version parameter for compatibility issues |
standby_archive_dest | standby database archivelog destination text string |
standby_file_management | if auto then files are created/dropped automatically on standby |
star_transformation_enabled | enable the use of star transformation |
statistics_level | statistics level |
streams_pool_size | size in bytes of the streams pool |
tape_asynch_io | Use asynch I/O requests for tape devices |
thread | Redo thread to mount |
timed_os_statistics | internal os statistic gathering interval in seconds |
timed_statistics | maintain internal timing statistics |
tracefile_identifier | trace file custom identifier |
trace_enabled | enable KST tracing |
transactions | max. number of concurrent active transactions |
transactions_per_rollback_segment | number of active transactions per rollback segment |
undo_management | instance runs in SMU mode if TRUE, else in RBU mode |
undo_retention | undo retention in seconds |
undo_tablespace | use/switch undo tablespace |
user_dump_dest | User process dump directory |
use_indirect_data_buffers | Enable indirect data buffers (very large SGA on 32-bit platforms) |
utl_file_dir | utl_file accessible directories list |
workarea_size_policy | policy used to size SQL working areas (MANUAL/AUTO) |
sec_case_sensitive_logon 11g中控制登录密码大小写是否敏感的