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 | BAC | BIT | BLA | CIR | CLU | COM | CON | COR | CPU | CRE | CUR | DBW | DB_ | DG_ | DIS |
DML | EVE | FAL | FAS | FIL | FIX | GCS | GC_ | GLO | HAS | HI_ | HS_ | IFI | INS | JAV | JOB | LAR | LDA | LIC | LOC |
LOG | MAX | NLS | O7_ | OBJ | OLA | OPE | OPT | OS_ | PAR | PGA | PLS | PRE | PRO | QUE | RDB | REA | REC | REM | REP |
RES | ROL | SER | SES | SGA | SHA | SKI | SMT | SOR | SPF | SQL | STA | STR | TAP | THR | TIM | TRA | UND | USE | UTL |
WOR |
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 |
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 |
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 |
CLUSTER_DATABASE: Syntax, Search for it |
CLUSTER_DATABASE_INSTANCES: Syntax, Search for it |
CLUSTER_INTERCONNECTS: Syntax, Search for it |
COMMIT_POINT_STRENGTH: 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 |
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_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_FLASHBACK_RETENTION_TARGET: Syntax, Search for it |
DB_KEEP_CACHE_SIZE: 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_UNIQUE_NAME: Syntax, Search for it |
DB_WRITER_PROCESSES: Syntax, Search for it |
DBWR_IO_SLAVES: Syntax, Search for it |
DG_BROKER_START: 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 |
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 |
GC_FILES_TO_LOCKS: 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 |
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_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 |
LICENSE_MAX_SESSIONS: Syntax, Search for it |
LICENSE_MAX_USERS: Syntax, Search for it |
LICENSE_SESSIONS_WARNING: 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 |
LOGMNR_MAX_PERSISTENT_SESSIONS: Syntax, Search for it |
MAX_COMMIT_PROPAGATION_DELAY: 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 |
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_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 |
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_EXECUTION_MESSAGE_SIZE: Syntax, Search for it |
PARALLEL_INSTANCE_GROUP: 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_THREADS_PER_CPU: Syntax, Search for it |
PGA_AGGREGATE_TARGET: Syntax, Search for it |
PLSQL_CCFLAGS: Syntax, Search for it |
PLSQL_CODE_TYPE: Syntax, Search for it |
PLSQL_COMPILER_FLAGS: Syntax, Search for it |
PLSQL_DEBUG: Syntax, Search for it |
PLSQL_NATIVE_LIBRARY_DIR: Syntax, Search for it |
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT: 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_11G_ENABLE_CAPTURE: 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 |
REMOTE_ARCHIVE_ENABLE: 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_PLAN: Syntax, Search for it |
RESUMABLE_TIMEOUT: Syntax, Search for it |
ROLLBACK_SEGMENTS: 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 |
UTL_FILE_DIR: Syntax, Search for it |
WORKAREA_SIZE_POLICY: Syntax, Search for it |