Home
Home
Help
Help
Contact us
Contact Us

Initialization Parameters

Initialization parameters perform the following functions:

Shortcuts to Parameter Names

If you know the name of the parameter you want, select its abbreviation. Otherwise, scroll down to see the entire list.

List of Initialization Parameters (A-Z)

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

As an Amazon Associate I earn from qualifying purchases.