|  Home |  Help |  Contact Us | 
Initialization parameters perform the following functions:
If you know the name of the parameter you want, select its abbreviation. Otherwise, scroll down to see the entire list.
| ACT | AQ_ | ARC | ASM | AUD | AWR | BAC | BIT | BLA | CIR | CLI | CLO | CLU | COM | CON | COR | CPU | CRE | CUR | DBW | 
| DB_ | DDL | DEF | DG_ | DIA | DIS | DML | DST | ENA | EVE | FAL | FAS | FIL | FIX | GCS | GLO | HAS | HI_ | HS_ | IFI | 
| INS | JAV | JOB | LAR | LDA | LIC | LIS | LOC | LOG | MAX | MEM | NLS | O7_ | OBJ | OLA | OPE | OPT | OS_ | PAR | PER | 
| PGA | PLS | PRE | PRO | QUE | RDB | REA | REC | RED | REM | REP | RES | ROL | SEC | SER | SES | SGA | SHA | SKI | SMT | 
| SOR | SPF | SQL | STA | STR | TAP | THR | TIM | TRA | UND | USE | UTL | WOR | XML | 
| 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 | 
| AWR_SNAPSHOT_TIME_OFFSET: 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 | 
| CLONEDB: 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_BIND_CAPTURE_DESTINATION: 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_UNRECOVERABLE_SCN_TRACKING: 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 | 
| PERMIT_92_WRAP_FORMAT: 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 |