Home
Home
Help
Help
Contact us
Contact Us

Initialization Parameters

Initialization parameters perform the following functions:

Shortcuts to Parameter Names

If you know the name of the parameter you want, select its abbreviation. Otherwise, scroll down to see the entire list.

List of Initialization Parameters (A-Z)

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_ACTIONS: 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
AUDIT_UNIFIED_CONTEXTS: Syntax, Search for it
AUDIT_UNIFIED_ENABLED_POLICIES: Syntax, Search for it
AUDIT_UNIFIED_POLICIES: Syntax, Search for it
AUDIT_UNIFIED_POLICY_COMMENTS: Syntax, Search for it
AUDITABLE_SYSTEM_ACTIONS: 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
CAT: Syntax, Search for it
CATALOG: Syntax, Search for it
CHAINED_ROWS: 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
CLIENT_RESULT_CACHE_STATS$: Syntax, Search for it
CLONEDB: Syntax, Search for it
CLU: Syntax, Search for it
CLUSTER_DATABASE: Syntax, Search for it
CLUSTER_DATABASE_INSTANCES: Syntax, Search for it
CLUSTER_INTERCONNECTS: Syntax, Search for it
COL: Syntax, Search for it
COLS: 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
CONNECTION_BROKERS: 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
DATABASE_EXPORT_OBJECTS: Syntax, Search for it
DATABASE_PROPERTIES: 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
DBFS_CONTENT: Syntax, Search for it
DBFS_CONTENT_PROPERTIES: Syntax, Search for it
DBMS_ALERT_INFO: Syntax, Search for it
DBMS_LOCK_ALLOCATED: 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
DEPTREE: Syntax, Search for it
DG_BROKER_START: Syntax, Search for it
DIAGNOSTIC_DEST: Syntax, Search for it
DICT: Syntax, Search for it
DICT_COLUMNS: Syntax, Search for it
DICTIONARY: Syntax, Search for it
DISK_ASYNCH_IO: Syntax, Search for it
DISPATCHERS: Syntax, Search for it
DISTRIBUTED_LOCK_TIMEOUT: Syntax, Search for it
DM_USER_MODELS: Syntax, Search for it
DML_LOCKS: Syntax, Search for it
DNFS_BATCH_SIZE: Syntax, Search for it
DOCUMENT_LINKS: Syntax, Search for it
DST_UPGRADE_INSERT_CONV: Syntax, Search for it
ENABLE_DDL_LOGGING: Syntax, Search for it
ENABLE_PLUGGABLE_DATABASE: Syntax, Search for it
ERROR_SIZE: Syntax, Search for it
EVENT: Syntax, Search for it
EXCEPTIONS: 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
FLASHBACK_TRANSACTION_QUERY: Syntax, Search for it
GCS_SERVER_PROCESSES: Syntax, Search for it
GLOBAL_CONTEXT: Syntax, Search for it
GLOBAL_CONTEXT_POOL_SIZE: Syntax, Search for it
GLOBAL_NAME: Syntax, Search for it
GLOBAL_NAMES: Syntax, Search for it
GLOBAL_TXN_PROCESSES: Syntax, Search for it
HASH_AREA_SIZE: Syntax, Search for it
HEAT_MAP: Syntax, Search for it
HI_SHARED_MEMORY_ADDRESS: Syntax, Search for it
HS_ALL_CAPS: Syntax, Search for it
HS_ALL_DD: Syntax, Search for it
HS_ALL_INITS: Syntax, Search for it
HS_AUTOREGISTER: Syntax, Search for it
HS_BASE_CAPS: Syntax, Search for it
HS_BASE_DD: Syntax, Search for it
HS_CLASS_CAPS: Syntax, Search for it
HS_CLASS_DD: Syntax, Search for it
HS_CLASS_INIT: Syntax, Search for it
HS_FDS_CLASS: Syntax, Search for it
HS_FDS_INST: Syntax, Search for it
HS_INST_CAPS: Syntax, Search for it
HS_INST_DD: Syntax, Search for it
HS_INST_INIT: Syntax, Search for it
IDEPTREE: Syntax, Search for it
IFILE: Syntax, Search for it
IND: Syntax, Search for it
INDEX_HISTOGRAM: Syntax, Search for it
INDEX_STATS: 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
LOGSTDBY_UNSUPPORTED_TABLES: Syntax, Search for it
MAP_OBJECT: 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
MAX_STRING_SIZE: 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_DATABASE_PARAMETERS: 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_INSTANCE_PARAMETERS: 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_SESSION_PARAMETERS: 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
NONCDB_COMPATIBLE: Syntax, Search for it
O7_DICTIONARY_ACCESSIBILITY: Syntax, Search for it
OBJ: 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_ADAPTIVE_FEATURES: Syntax, Search for it
OPTIMIZER_ADAPTIVE_REPORTING_ONLY: 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
PATH_VIEW: Syntax, Search for it
PDB_ALERTS: Syntax, Search for it
PDB_FILE_NAME_CONVERT: Syntax, Search for it
PDB_PLUG_IN_VIOLATIONS: Syntax, Search for it
PERMIT_92_WRAP_FORMAT: Syntax, Search for it
PGA_AGGREGATE_LIMIT: Syntax, Search for it
PGA_AGGREGATE_TARGET: Syntax, Search for it
PLAN_TABLE: 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
PLUGGABLE_SET_CHECK: Syntax, Search for it
PRE_PAGE_SGA: Syntax, Search for it
PROCESSES: Syntax, Search for it
PROCESSOR_GROUP_NAME: Syntax, Search for it
PRODUCT_COMPONENT_VERSION: Syntax, Search for it
PROXY_USERS: Syntax, Search for it
PSTUBTBL: Syntax, Search for it
PUBLIC_DEPENDENCY: Syntax, Search for it
PUBLICSYN: Syntax, Search for it
QUERY_REWRITE_ENABLED: Syntax, Search for it
QUERY_REWRITE_INTEGRITY: Syntax, Search for it
QUEUE_PRIVILEGES: 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
RECYCLEBIN: Syntax, Search for it
REDACTION_COLUMNS: Syntax, Search for it
REDACTION_POLICIES: Syntax, Search for it
REDACTION_VALUES_FOR_TYPE_FULL: 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
REPORT_COMPONENTS: Syntax, Search for it
REPORT_FILES: Syntax, Search for it
REPORT_FORMATS: Syntax, Search for it
RESOURCE_COST: 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
RESOURCE_MAP: Syntax, Search for it
RESOURCE_VIEW: 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
ROLE_ROLE_PRIVS: Syntax, Search for it
ROLE_SYS_PRIVS: Syntax, Search for it
ROLE_TAB_PRIVS: Syntax, Search for it
ROLLBACK_SEGMENTS: Syntax, Search for it
SCHEDULER_BATCH_ERRORS: Syntax, Search for it
SCHEMA_EXPORT_OBJECTS: 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
SEQ: Syntax, Search for it
SERIAL_REUSE: Syntax, Search for it
SERVICE_NAMES: Syntax, Search for it
SESSION_CACHED_CURSORS: Syntax, Search for it
SESSION_CONTEXT: Syntax, Search for it
SESSION_MAX_OPEN_FILES: Syntax, Search for it
SESSION_PRIVS: Syntax, Search for it
SESSION_ROLES: 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
SOURCE_SIZE: Syntax, Search for it
SPATIAL_VECTOR_ACCELERATION: 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
STMT_AUDIT_OPTION_MAP: Syntax, Search for it
STREAMS_POOL_SIZE: Syntax, Search for it
SYN: Syntax, Search for it
SYNONYMS: Syntax, Search for it
SYS_OBJECTS: Syntax, Search for it
SYSCATALOG: Syntax, Search for it
SYSFILES: Syntax, Search for it
SYSSEGOBJ: Syntax, Search for it
SYSTEM_PRIVILEGE_MAP: Syntax, Search for it
TAB: Syntax, Search for it
TABLE_EXPORT_OBJECTS: Syntax, Search for it
TABLE_PRIVILEGE_MAP: Syntax, Search for it
TABQUOTAS: Syntax, Search for it
TABS: Syntax, Search for it
TAPE_ASYNCH_IO: Syntax, Search for it
TEMP_UNDO_ENABLED: Syntax, Search for it
THREAD: Syntax, Search for it
THREADED_EXECUTION: 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
TRUSTED_SERVERS: Syntax, Search for it
TS_PITR_CHECK: Syntax, Search for it
TS_PITR_OBJECTS_TO_BE_DROPPED: Syntax, Search for it
UNDO_MANAGEMENT: Syntax, Search for it
UNDO_RETENTION: Syntax, Search for it
UNDO_TABLESPACE: Syntax, Search for it
UNI_PLUGGABLE_SET_CHECK: Syntax, Search for it
UNIFIED_AUDIT_SGA_QUEUE_SIZE: Syntax, Search for it
UNIFIED_AUDIT_TRAIL: Syntax, Search for it
USE_DEDICATED_BROKER: 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