oracle参数说明（陆续添加）

l NAMEDESCRIPTIONactive_instance_count

number of active instances in the cluster database

aq_tm_processesnumber of AQ Time Managers to startarchive_lag_targetMaximum number of seconds of redos the standby could loseasm_diskgroupsdisk groups to mount automaticallyasm_diskstringdisk set locations for discoveryasm_power_limitnumber of processes for disk rebalancingaudit_file_destDirectory in which auditing files are to resideaudit_syslog_levelSyslog facility and levelaudit_sys_operationsenable sys auditingaudit_trailenable system auditingbackground_core_dumpCore Size for Background Processesbackground_dump_destDetached process dump directorybackup_tape_io_slavesBACKUP Tape I/O slavesbitmap_merge_area_sizemaximum memory allow for BITMAP MERGEblank_trimmingblank trimming semantics parameterbuffer_pool_keepNumber of database blocks/latches in keep buffer poolbuffer_pool_recycleNumber of database blocks/latches in recycle buffer poolcircuitsmax number of circuitscluster_databaseif TRUE startup in cluster database modecluster_database_instancesnumber of instances to use for sizing cluster db SGA structurescluster_interconnectsinterconnects for RAC usecommit_point_strengthBias this node has toward not preparing in a two-phase commitcommit_writetransaction commit log write behaviourcompatibleDatabase will be completely compatible with this software versioncontrol_filescontrol file names listcontrol_file_record_keep_timecontrol file record keep time in dayscore_dump_destCore dump directorycpu_countnumber of CPUs for this instancecreate_bitmap_area_sizesize of create bitmap buffer for bitmap indexcreate_stored_outlinescreate stored outlines for DML statementscursor_sharingcursor sharing modecursor_space_for_timeuse more memory in order to get faster executiondbwr_io_slavesDBWR I/O slavesdb_16k_cache_sizeSize of cache for 16K buffersdb_2k_cache_sizeSize of cache for 2K buffersdb_32k_cache_sizeSize of cache for 32K buffersdb_4k_cache_sizeSize of cache for 4K buffersdb_8k_cache_sizeSize of cache for 8K buffersdb_block_buffersNumber of database blocks cached in memorydb_block_checkingheader checking and data and index block checkingdb_block_checksumstore checksum in db blocks and check during readsdb_block_sizeSize of database block in bytesdb_cache_adviceBuffer cache sizing advisorydb_cache_sizeSize of DEFAULT buffer pool for standard block size buffersdb_create_file_destdefault database locationdb_create_online_log_dest_1online log/controlfile destination #1db_create_online_log_dest_2online log/controlfile destination #2db_create_online_log_dest_3online log/controlfile destination #3db_create_online_log_dest_4online log/controlfile destination #4db_create_online_log_dest_5online log/controlfile  destination #5db_domaindirectory part of global database name stored with CREATE DATABASEdb_filesmax allowable # db filesdb_file_multiblock_read_countdb block to be read each IOdb_file_name_convertdatafile name convert patterns and strings for standby/clone dbdb_flashback_retention_targetMaximum Flashback Database log retention time in minutes.db_keep_cache_sizeSize of KEEP buffer pool for standard block size buffersdb_namedatabase name specified in CREATE DATABASEdb_recovery_file_destdefault database recovery file locationdb_recovery_file_dest_sizedatabase recovery files size limitdb_recycle_cache_sizeSize of RECYCLE buffer pool for standard block size buffersdb_unique_nameDatabase Unique Namedb_writer_processesnumber of background database writer  processes to startddl_wait_for_locksDisable NOWAIT DML lock acquisitionsdg_broker_config_file1data guard broker configuration file #1dg_broker_config_file2data guard broker configuration file #2dg_broker_startstart Data Guard broker framework (DMON process)disk_asynch_ioUse asynch I/O for random access devicesdispatchersspecifications of dispatchersdistributed_lock_timeoutnumber of seconds a distributed transaction waits for a lockdml_locksdml locks - one for each table modified in a transactiondrs_startstart DG Broker monitor (DMON process)eventdebug event control - default null stringfal_clientFAL clientfal_serverFAL server listfast_start_io_targetUpper bound on recovery readsfast_start_mttr_targetMTTR target in secondsfast_start_parallel_rollbackmax number of parallel recovery slaves that may be usedfileio_network_adaptersNetwork Adapters for File I/Ofilesystemio_optionsIO operations on filesystem filesfile_mappingenable file mappingfixed_datefixed SYSDATE valuegcs_server_processesnumber of background gcs server processes to startgc_files_to_locksmapping between file numbers and global cache locksglobal_context_pool_sizeGlobal Application Context Pool Size in Bytesglobal_namesenforce that database links have same name as remote databasehash_area_sizesize of in-memory hash work areahi_shared_memory_addressSGA starting address (high order 32-bits on 64-bit platforms)hs_autoregisterenable automatic server DD updates in HS agent self-registrationifileinclude file in init.orainstance_groupslist of instance group namesinstance_nameinstance name supported by the instanceinstance_numberinstance numberinstance_typetype of instance to be executedjava_max_sessionspace_sizemax allowed size in bytes of a Java sessionspacejava_pool_sizesize in bytes of java pooljava_soft_sessionspace_limitwarning limit on size in bytes of a Java sessionspacejob_queue_processesnumber of job queue slave processeslarge_pool_sizesize in bytes of large poolldap_directory_accessRDBMS's LDAP access optionlicense_max_sessionsmaximum number of non-system user sessions allowedlicense_max_usersmaximum number of named users that can be created in the databaselicense_sessions_warningwarning level for number of non-system user sessionslocal_listenerlocal listenerlock_name_spacelock name space used for generating lock names for standby/clone databaselock_sgaLock entire SGA in physical memorylogmnr_max_persistent_sessionsmaximum number of threads to minelog_archive_configlog archive config parameterlog_archive_destarchival destination text stringlog_archive_dest_1archival destination #1 text stringlog_archive_dest_10archival destination #10 text stringlog_archive_dest_2archival destination #2 text stringlog_archive_dest_3archival destination #3 text stringlog_archive_dest_4archival destination #4 text stringlog_archive_dest_5archival destination #5 text stringlog_archive_dest_6archival destination #6 text stringlog_archive_dest_7archival destination #7 text stringlog_archive_dest_8archival destination #8 text stringlog_archive_dest_9archival destination #9 text stringlog_archive_dest_state_1archival destination #1 state text stringlog_archive_dest_state_10archival destination #10 state text stringlog_archive_dest_state_2archival destination #2 state text stringlog_archive_dest_state_3archival destination #3 state text stringlog_archive_dest_state_4archival destination #4 state text stringlog_archive_dest_state_5archival destination #5 state text stringlog_archive_dest_state_6archival destination #6 state text stringlog_archive_dest_state_7archival destination #7 state text stringlog_archive_dest_state_8archival destination #8 state text stringlog_archive_dest_state_9archival destination #9 state text stringlog_archive_duplex_destduplex archival destination text stringlog_archive_formatarchival destination formatlog_archive_local_first

Establish EXPEDITE attribute default value

如果在用STANDBY的情况下，保证归档到本地成功，在远程

log_archive_max_processesmaximum number of active ARCH processeslog_archive_min_succeed_destminimum number of archive destinations that must succeedlog_archive_startstart archival process on SGA initializationlog_archive_traceEstablish archivelog operation tracing levellog_bufferredo circular buffer sizelog_checkpoints_to_alertlog checkpoint begin/end to alert filelog_checkpoint_interval# redo blocks checkpoint thresholdlog_checkpoint_timeoutMaximum time interval between checkpoints in secondslog_file_name_convertlogfile name convert patterns and strings for standby/clone dbmax_commit_propagation_delayMax age of new snapshot in .01 secondsmax_dispatchersmax number of dispatchersmax_dump_file_sizeMaximum size (blocks) of dump filemax_enabled_rolesmax number of roles a user can have enabledmax_shared_serversmax number of shared serversnls_calendarNLS calendar system namenls_compNLS comparisonnls_currencyNLS local currency symbolnls_date_formatNLS Oracle date formatnls_date_languageNLS date language namenls_dual_currencyDual currency symbolnls_iso_currencyNLS ISO currency territory namenls_languageNLS language namenls_length_semanticscreate columns using byte or char semantics by defaultnls_nchar_conv_excpNLS raise an exception instead of allowing implicit conversionnls_numeric_charactersNLS numeric charactersnls_sortNLS linguistic definition namenls_territoryNLS territory namenls_timestamp_formattime stamp formatnls_timestamp_tz_formattimestampe with timezone formatnls_time_formattime formatnls_time_tz_formattime with timezone formatO7_DICTIONARY_ACCESSIBILITYVersion 7 Dictionary Accessibility Supportobject_cache_max_size_percentpercentage of maximum size over optimal of the user session's object cacheobject_cache_optimal_sizeoptimal size of the user session's object cache in bytesolap_page_pool_sizesize of the olap page pool in bytesopen_cursorsmax # cursors per sessionopen_linksmax # open links per sessionopen_links_per_instancemax # open links per instanceoptimizer_dynamic_samplingoptimizer dynamic samplingoptimizer_features_enableoptimizer plan compatibility parameteroptimizer_index_cachingoptimizer percent index cachingoptimizer_index_cost_adjoptimizer index cost adjustmentoptimizer_modeoptimizer modeoptimizer_secure_view_mergingoptimizer secure view merging and predicate pushdown/movearoundos_authent_prefixprefix for auto-logon accountsos_rolesretrieve roles from the operating systemparallel_adaptive_multi_userenable adaptive setting of degree for multiple user streamsparallel_automatic_tuningenable intelligent defaults for parallel execution parametersparallel_execution_message_sizemessage buffer size for parallel executionparallel_instance_groupinstance group to use for all parallel operationsparallel_max_serversmaximum parallel query servers per instanceparallel_min_percentminimum percent of threads required for parallel queryparallel_min_serversminimum parallel query servers per instanceparallel_serverif TRUE startup in parallel server modeparallel_server_instancesnumber of instances to use for sizing OPS SGA structuresparallel_threads_per_cpunumber of parallel execution threads per CPUpga_aggregate_targetTarget size for the aggregate PGA memory consumed by the instanceplsql_ccflagsPL/SQL ccflagsplsql_code_typePL/SQL code-typeplsql_compiler_flagsPL/SQL compiler flagsplsql_debugPL/SQL debugplsql_native_library_dirplsql native library dirplsql_native_library_subdir_countplsql native library number of subdirectoriesplsql_optimize_levelPL/SQL optimize levelplsql_v2_compatibilityPL/SQL version 2.x compatibility flagplsql_warningsPL/SQL compiler warnings settingspre_11g_enable_captureTo enable capture of DB Replaypre_page_sgapre-page sga for processprocessesuser processesquery_rewrite_enabledallow rewrite of queries using materialized views if enabledquery_rewrite_integrityperform rewrite using materialized views with desired integrityrdbms_server_dnRDBMS's Distinguished Nameread_only_open_delayedif TRUE delay opening of read only files until first accessrecovery_parallelismnumber of server processes to use for parallel recoveryrecyclebinrecyclebin processingremote_archive_enableremote archival enable settingremote_dependencies_moderemote-procedure-call dependencies mode parameterremote_listenerremote listenerremote_login_passwordfilepassword file usage parameterremote_os_authentallow non-secure remote clients to use auto-logon accountsremote_os_rolesallow non-secure remote clients to use os rolesreplication_dependency_trackingtracking dependency for Replication parallel propagationresource_limitmaster switch for resource limitresource_manager_planresource mgr top planresumable_timeoutset resumable_timeoutrollback_segmentsundo segment listserial_reusereuse the frame segmentsservice_namesservice names supported by the instancesessionsuser and system sessionssession_cached_cursorsNumber of cursors to cache in a session.session_max_open_filesmaximum number of open files allowed per sessionsga_max_sizemax total SGA sizesga_targetTarget size of SGAshadow_core_dumpCore Size for Shadow Processesshared_memory_addressSGA starting address (low order 32-bits on 64-bit platforms)shared_pool_reserved_sizesize in bytes of reserved area of shared poolshared_pool_sizesize in bytes of shared poolshared_serversnumber of shared servers to start upshared_server_sessionsmax number of shared server sessionsskip_unusable_indexesskip unusable indexes if set to TRUEsmtp_out_serverutl_smtp server and port configuration parametersort_area_retained_sizesize of in-memory sort work area retained between fetch callssort_area_sizesize of in-memory sort work areaspfileserver parameter filesql92_securityrequire select privilege for searched update/deletesqltune_categoryCategory qualifier for applying hintsetssql_traceenable SQL tracesql_versionsql language version parameter for compatibility issuesstandby_archive_deststandby database archivelog destination text stringstandby_file_managementif auto then files are created/dropped automatically on standbystar_transformation_enabledenable the use of star transformationstatistics_levelstatistics levelstreams_pool_sizesize in bytes of the streams pooltape_asynch_ioUse asynch I/O requests for tape devicesthreadRedo thread to mounttimed_os_statisticsinternal os statistic gathering interval in secondstimed_statisticsmaintain internal timing statisticstracefile_identifiertrace file custom identifiertrace_enabledenable KST tracingtransactionsmax. number of concurrent active transactionstransactions_per_rollback_segmentnumber of active transactions per rollback segmentundo_managementinstance runs in SMU mode if TRUE, else in RBU modeundo_retentionundo retention in secondsundo_tablespaceuse/switch undo tablespaceuser_dump_destUser process dump directoryuse_indirect_data_buffersEnable indirect data buffers (very large SGA on 32-bit platforms)utl_file_dirutl_file accessible directories listworkarea_size_policypolicy used to size SQL working areas (MANUAL/AUTO)

 

sec_case_sensitive_logon 11g中控制登录密码大小写是否敏感的