|
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 | 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 |
| 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 |