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