Параметры инициализации – это конфигурационные параметры, которые затрагивают основные операции экземпляра базы данных. Экземпляр читает эти параметры из файла конфигурации при запуске.
Функциональные группы параметров инициализации
Большинство параметров инициализации принадлежит одной из следующих функциональных групп:
- Параметры, задающие имена объектов (например, такие как файлы и директории).
- Параметры, которые устанавливают лимиты для процессов, ресурсов или непосредственно для самой базы данных.
- Параметры, которые затрагивают объём, например размер SGA (такие параметры ещё называют «переменными параметрами»).
Последние параметры наиболее интересны для администраторов базы данных, так как они могут использовать их для того, чтобы улучшить работу базы данных.
Параметры инициализации в алфавитном порядке
- ACTIVE_INSTANCE_COUNT
- AQ_TM_PROCESSES
- ARCHIVE_LAG_TARGET
- ASM_DISKGROUPS
- ASM_DISKSTRING
- ASM_POWER_LIMIT
- ASM_PREFERRED_READ_FAILURE_GROUPS
- AUDIT_FILE_DEST
- AUDIT_SYS_OPERATIONS
- AUDIT_SYSLOG_LEVEL
- AUDIT_TRAIL
- BACKGROUND_CORE_DUMP
- BACKGROUND_DUMP_DEST
- BACKUP_TAPE_IO_SLAVES
- BITMAP_MERGE_AREA_SIZE
- BLANK_TRIMMING
- CIRCUITS
- CLIENT_RESULT_CACHE_LAG
- CLIENT_RESULT_CACHE_SIZE
- CLUSTER_DATABASE
- CLUSTER_DATABASE_INSTANCES
- CLUSTER_INTERCONNECTS
- COMMIT_LOGGING
- COMMIT_POINT_STRENGTH
- COMMIT_WAIT
- COMMIT_WRITE
- COMPATIBLE
- CONTROL_FILE_RECORD_KEEP_TIME
- CONTROL_FILES
- CONTROL_MANAGEMENT_PACK_ACCESS
- CORE_DUMP_DEST
- CPU_COUNT
- CREATE_BITMAP_AREA_SIZE
- CREATE_STORED_OUTLINES
- CURSOR_BIND_CAPTURE_DESTINATION
- CURSOR_SHARING
- CURSOR_SPACE_FOR_TIME
- DB_nK_CACHE_SIZE
- DB_BLOCK_BUFFERS
- DB_BLOCK_CHECKING
- DB_BLOCK_CHECKSUM
- DB_BLOCK_SIZE
- DB_CACHE_ADVICE
- DB_CACHE_SIZE
- DB_CREATE_FILE_DEST
- DB_CREATE_ONLINE_LOG_DEST_n
- DB_DOMAIN
- DB_FILE_MULTIBLOCK_READ_COUNT
- DB_FILE_NAME_CONVERT
- DB_FILES
- DB_FLASH_CACHE_FILE
- DB_FLASH_CACHE_SIZE
- DB_FLASHBACK_RETENTION_TARGET
- DB_KEEP_CACHE_SIZE
- DB_LOST_WRITE_PROTECT
- DB_NAME
- DB_RECOVERY_FILE_DEST
- DB_RECOVERY_FILE_DEST_SIZE
- DB_RECYCLE_CACHE_SIZE
- DB_SECUREFILE
- DB_ULTRA_SAFE
- DB_UNIQUE_NAME
- DB_UNRECOVERABLE_SCN_TRACKING
- DB_WRITER_PROCESSES
- DBWR_IO_SLAVES
- DDL_LOCK_TIMEOUT
- DEFERRED_SEGMENT_CREATION
- DG_BROKER_CONFIG_FILEn
- DG_BROKER_START
- DIAGNOSTIC_DEST
- DISK_ASYNCH_IO
- DISPATCHERS
- DISTRIBUTED_LOCK_TIMEOUT
- DML_LOCKS
- DST_UPGRADE_INSERT_CONV
- ENABLE_DDL_LOGGING
- EVENT
- FAL_CLIENT
- FAL_SERVER
- FAST_START_MTTR_TARGET
- FAST_START_PARALLEL_ROLLBACK
- FILE_MAPPING
- FILEIO_NETWORK_ADAPTERS
- FILESYSTEMIO_OPTIONS
- FIXED_DATE
- GCS_SERVER_PROCESSES
- GLOBAL_CONTEXT_POOL_SIZE
- GLOBAL_NAMES
- GLOBAL_TXN_PROCESSES
- HASH_AREA_SIZE
- HI_SHARED_MEMORY_ADDRESS
- HS_AUTOREGISTER
- IFILE
- INSTANCE_GROUPS
- INSTANCE_NAME
- INSTANCE_NUMBER
- INSTANCE_TYPE
- JAVA_JIT_ENABLED
- JAVA_MAX_SESSIONSPACE_SIZE
- JAVA_POOL_SIZE
- JAVA_SOFT_SESSIONSPACE_LIMIT
- JOB_QUEUE_PROCESSES
- LARGE_POOL_SIZE
- LDAP_DIRECTORY_ACCESS
- LDAP_DIRECTORY_SYSAUTH
- LICENSE_MAX_SESSIONS
- LICENSE_MAX_USERS
- LICENSE_SESSIONS_WARNING
- LISTENER_NETWORKS
- LOCAL_LISTENER
- LOCK_NAME_SPACE
- LOCK_SGA
- LOG_ARCHIVE_CONFIG
- LOG_ARCHIVE_DEST
- LOG_ARCHIVE_DEST_n
- LOG_ARCHIVE_DEST_STATE_n
- LOG_ARCHIVE_DUPLEX_DEST
- LOG_ARCHIVE_FORMAT
- LOG_ARCHIVE_LOCAL_FIRST
- LOG_ARCHIVE_MAX_PROCESSES
- LOG_ARCHIVE_MIN_SUCCEED_DEST
- LOG_ARCHIVE_TRACE
- LOG_BUFFER
- LOG_CHECKPOINT_INTERVAL
- LOG_CHECKPOINT_TIMEOUT
- LOG_CHECKPOINTS_TO_ALERT
- LOG_FILE_NAME_CONVERT
- MAX_DISPATCHERS
- MAX_DUMP_FILE_SIZE
- MAX_ENABLED_ROLES
- MAX_SHARED_SERVERS
- MEMORY_MAX_TARGET
- MEMORY_TARGET
- NLS_CALENDAR
- NLS_COMP
- NLS_CURRENCY
- NLS_DATE_FORMAT
- NLS_DATE_LANGUAGE
- NLS_DUAL_CURRENCY
- NLS_ISO_CURRENCY
- NLS_LANGUAGE
- NLS_LENGTH_SEMANTICS
- NLS_NCHAR_CONV_EXCP
- NLS_NUMERIC_CHARACTERS
- NLS_SORT
- NLS_TERRITORY
- NLS_TIMESTAMP_FORMAT
- NLS_TIMESTAMP_TZ_FORMAT
- O7_DICTIONARY_ACCESSIBILITY
- OBJECT_CACHE_MAX_SIZE_PERCENT
- OBJECT_CACHE_OPTIMAL_SIZE
- OLAP_PAGE_POOL_SIZE
- OPEN_CURSORS
- OPEN_LINKS
- OPEN_LINKS_PER_INSTANCE
- OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES
- OPTIMIZER_DYNAMIC_SAMPLING
- OPTIMIZER_FEATURES_ENABLE
- OPTIMIZER_INDEX_CACHING
- OPTIMIZER_INDEX_COST_ADJ
- OPTIMIZER_MODE
- OPTIMIZER_SECURE_VIEW_MERGING
- OPTIMIZER_USE_INVISIBLE_INDEXES
- OPTIMIZER_USE_PENDING_STATISTICS
- OPTIMIZER_USE_SQL_PLAN_BASELINES
- OS_AUTHENT_PREFIX
- OS_ROLES
- PARALLEL_ADAPTIVE_MULTI_USER
- PARALLEL_AUTOMATIC_TUNING
- PARALLEL_DEGREE_LIMIT
- PARALLEL_DEGREE_POLICY
- PARALLEL_EXECUTION_MESSAGE_SIZE
- PARALLEL_FORCE_LOCAL
- PARALLEL_INSTANCE_GROUP
- PARALLEL_IO_CAP_ENABLED
- PARALLEL_MAX_SERVERS
- PARALLEL_MIN_PERCENT
- PARALLEL_MIN_SERVERS
- PARALLEL_MIN_TIME_THRESHOLD
- PARALLEL_SERVERS_TARGET
- PARALLEL_THREADS_PER_CPU
- PGA_AGGREGATE_TARGET
- PLSCOPE_SETTINGS
- PLSQL_CCFLAGS
- PLSQL_CODE_TYPE
- PLSQL_DEBUG
- PLSQL_OPTIMIZE_LEVEL
- PLSQL_V2_COMPATIBILITY
- PLSQL_WARNINGS
- PRE_PAGE_SGA
- PROCESSES
- QUERY_REWRITE_ENABLED
- QUERY_REWRITE_INTEGRITY
- RDBMS_SERVER_DN
- READ_ONLY_OPEN_DELAYED
- RECOVERY_PARALLELISM
- RECYCLEBIN
- REDO_TRANSPORT_USER
- REMOTE_DEPENDENCIES_MODE
- REMOTE_LISTENER
- REMOTE_LOGIN_PASSWORDFILE
- REMOTE_OS_AUTHENT
- REMOTE_OS_ROLES
- REPLICATION_DEPENDENCY_TRACKING
- RESOURCE_LIMIT
- RESOURCE_MANAGER_CPU_ALLOCATION
- RESOURCE_MANAGER_PLAN
- RESULT_CACHE_MAX_RESULT
- RESULT_CACHE_MAX_SIZE
- RESULT_CACHE_MODE
- RESULT_CACHE_REMOTE_EXPIRATION
- RESUMABLE_TIMEOUT
- ROLLBACK_SEGMENTS
- SEC_CASE_SENSITIVE_LOGON
- SEC_MAX_FAILED_LOGIN_ATTEMPTS
- SEC_PROTOCOL_ERROR_FURTHER_ACTION
- SEC_PROTOCOL_ERROR_TRACE_ACTION
- SEC_RETURN_SERVER_RELEASE_BANNER
- SERIAL_REUSE
- SERVICE_NAMES
- SESSION_CACHED_CURSORS
- SESSION_MAX_OPEN_FILES
- SESSIONS
- SGA_MAX_SIZE
- SGA_TARGET
- SHADOW_CORE_DUMP
- SHARED_MEMORY_ADDRESS
- SHARED_POOL_RESERVED_SIZE
- SHARED_POOL_SIZE
- SHARED_SERVER_SESSIONS
- SHARED_SERVERS
- SKIP_UNUSABLE_INDEXES
- SMTP_OUT_SERVER
- SORT_AREA_RETAINED_SIZE
- SORT_AREA_SIZE
- SPFILE
- SQL_TRACE
- SQL92_SECURITY
- SQLTUNE_CATEGORY
- STANDBY_ARCHIVE_DEST
- STANDBY_FILE_MANAGEMENT
- STAR_TRANSFORMATION_ENABLED
- STATISTICS_LEVEL
- STREAMS_POOL_SIZE
- TAPE_ASYNCH_IO
- THREAD
- TIMED_OS_STATISTICS
- TIMED_STATISTICS
- TRACE_ENABLED
- TRACEFILE_IDENTIFIER
- TRANSACTIONS
- TRANSACTIONS_PER_ROLLBACK_SEGMENT
- UNDO_MANAGEMENT
- UNDO_RETENTION
- UNDO_TABLESPACE
- USE_INDIRECT_DATA_BUFFERS
- USER_DUMP_DEST
- UTL_FILE_DIR
- WORKAREA_SIZE_POLICY
- XML_DB_EVENTS