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 |