Initialization Parameters

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.
ACT AQ_ ARC AUD BAC BIT BLA BUF CIR CLU COM CON COR CPU CRE
CUR DBL DBW DB_ DG_ DIS DML DRS ENQ EVE FAL FAS FIL FIX GC_
GLO HAS HI_ HS_ IFI INS JAV JOB LAR LIC LOC LOG MAX NLS O7_
OBJ OLA OPE OPT ORA OS_ PAR PGA PLS PRE PRO QUE RDB REA REC
REM REP RES ROL ROW SER SES SGA SHA SOR SPF SQL STA TAP THR
TIM TRA UND USE UTL WOR

ACTIVE_INSTANCE_COUNT: Definition

AQ_TM_PROCESSES: Definition

ARCHIVE_LAG_TARGET: Definition

AUDIT_FILE_DEST: Definition

AUDIT_SYS_OPERATIONS: Definition

AUDIT_TRAIL: Definition

BACKGROUND_CORE_DUMP: Definition

BACKGROUND_DUMP_DEST: Definition

BACKUP_TAPE_IO_SLAVES: Definition

BITMAP_MERGE_AREA_SIZE: Definition

BLANK_TRIMMING: Definition

BUFFER_POOL_KEEP: Definition

BUFFER_POOL_RECYCLE: Definition

CIRCUITS: Definition

CLUSTER_DATABASE: Definition

CLUSTER_DATABASE_INSTANCES: Definition

CLUSTER_INTERCONNECTS: Definition

COMMIT_POINT_STRENGTH: Definition

COMPATIBLE: Definition

CONTROL_FILES: Definition

CONTROL_FILE_RECORD_KEEP_TIME: Definition

CORE_DUMP_DEST: Definition

CPU_COUNT: Definition

CREATE_BITMAP_AREA_SIZE: Definition

CURSOR_SHARING: Definition

CURSOR_SPACE_FOR_TIME: Definition

DBLINK_ENCRYPT_LOGIN: Definition

DBWR_IO_SLAVES: Definition

DB_BLOCK_BUFFERS: Definition

DB_BLOCK_CHECKING: Definition

DB_BLOCK_CHECKSUM: Definition

DB_BLOCK_SIZE: Definition

DB_CACHE_ADVICE: Definition

DB_CACHE_SIZE: Definition

DB_CREATE_FILE_DEST: Definition

DB_DOMAIN: Definition

DB_FILES: Definition

DB_FILE_MULTIBLOCK_READ_COUNT: Definition

DB_FILE_NAME_CONVERT: Definition

DB_KEEP_CACHE_SIZE: Definition

DB_NAME: Definition

DB_RECYCLE_CACHE_SIZE: Definition

DB_WRITER_PROCESSES: Definition

DG_BROKER_START: Definition

DISK_ASYNCH_IO: Definition

DISPATCHERS: Definition

DISTRIBUTED_LOCK_TIMEOUT: Definition

DML_LOCKS: Definition

DRS_START: Definition

ENQUEUE_RESOURCES: Definition

EVENT: Definition

FAL_CLIENT: Definition

FAL_SERVER: Definition

FAST_START_IO_TARGET: Definition

FAST_START_MTTR_TARGET: Definition

FAST_START_PARALLEL_ROLLBACK: Definition

FILESYSTEMIO_OPTIONS: Definition

FILE_MAPPING: Definition

FIXED_DATE: Definition

GC_FILES_TO_LOCKS: Definition

GLOBAL_CONTEXT_POOL_SIZE: Definition

GLOBAL_NAMES: Definition

HASH_AREA_SIZE: Definition

HASH_JOIN_ENABLED: Definition

HI_SHARED_MEMORY_ADDRESS: Definition

HS_AUTOREGISTER: Definition

IFILE: Definition

INSTANCE_GROUPS: Definition

INSTANCE_NAME: Definition

INSTANCE_NUMBER: Definition

JAVA_MAX_SESSIONSPACE_SIZE: Definition

JAVA_POOL_SIZE: Definition

JAVA_SOFT_SESSIONSPACE_LIMIT: Definition

JOB_QUEUE_PROCESSES: Definition

LARGE_POOL_SIZE: Definition

LICENSE_MAX_SESSIONS: Definition

LICENSE_MAX_USERS: Definition

LICENSE_SESSIONS_WARNING: Definition

LOCAL_LISTENER: Definition

LOCK_NAME_SPACE: Definition

LOCK_SGA: Definition

LOGMNR_MAX_PERSISTENT_SESSIONS: Definition

LOG_ARCHIVE_DEST: Definition

LOG_ARCHIVE_DUPLEX_DEST: Definition

LOG_ARCHIVE_FORMAT: Definition

LOG_ARCHIVE_MAX_PROCESSES: Definition

LOG_ARCHIVE_MIN_SUCCEED_DEST: Definition

LOG_ARCHIVE_START: Definition

LOG_ARCHIVE_TRACE: Definition

LOG_BUFFER: Definition

LOG_CHECKPOINTS_TO_ALERT: Definition

LOG_CHECKPOINT_INTERVAL: Definition

LOG_CHECKPOINT_TIMEOUT: Definition

LOG_FILE_NAME_CONVERT: Definition

LOG_PARALLELISM: Definition

MAX_COMMIT_PROPAGATION_DELAY: Definition

MAX_DISPATCHERS: Definition

MAX_DUMP_FILE_SIZE: Definition

MAX_ENABLED_ROLES: Definition

MAX_ROLLBACK_SEGMENTS: Definition

MAX_SHARED_SERVERS: Definition

NLS_CALENDAR: Definition

NLS_COMP: Definition

NLS_CURRENCY: Definition

NLS_DATE_FORMAT: Definition

NLS_DATE_LANGUAGE: Definition

NLS_DUAL_CURRENCY: Definition

NLS_ISO_CURRENCY: Definition

NLS_LANGUAGE: Definition

NLS_LENGTH_SEMANTICS: Definition

NLS_NCHAR_CONV_EXCP: Definition

NLS_NUMERIC_CHARACTERS: Definition

NLS_SORT: Definition

NLS_TERRITORY: Definition

NLS_TIMESTAMP_FORMAT: Definition

NLS_TIMESTAMP_TZ_FORMAT: Definition

O7_DICTIONARY_ACCESSIBILITY: Definition

OBJECT_CACHE_MAX_SIZE_PERCENT: Definition

OBJECT_CACHE_OPTIMAL_SIZE: Definition

OLAP_PAGE_POOL_SIZE: Definition

OPEN_CURSORS: Definition

OPEN_LINKS: Definition

OPEN_LINKS_PER_INSTANCE: Definition

OPTIMIZER_DYNAMIC_SAMPLING: Definition

OPTIMIZER_FEATURES_ENABLE: Definition

OPTIMIZER_INDEX_CACHING: Definition

OPTIMIZER_INDEX_COST_ADJ: Definition

OPTIMIZER_MAX_PERMUTATIONS: Definition

OPTIMIZER_MODE: Definition

ORACLE_TRACE_COLLECTION_NAME: Definition

ORACLE_TRACE_COLLECTION_PATH: Definition

ORACLE_TRACE_COLLECTION_SIZE: Definition

ORACLE_TRACE_ENABLE: Definition

ORACLE_TRACE_FACILITY_NAME: Definition

ORACLE_TRACE_FACILITY_PATH: Definition

OS_AUTHENT_PREFIX: Definition

OS_ROLES: Definition

PARALLEL_ADAPTIVE_MULTI_USER: Definition

PARALLEL_AUTOMATIC_TUNING: Definition

PARALLEL_EXECUTION_MESSAGE_SIZE: Definition

PARALLEL_INSTANCE_GROUP: Definition

PARALLEL_MAX_SERVERS: Definition

PARALLEL_MIN_PERCENT: Definition

PARALLEL_MIN_SERVERS: Definition

PARALLEL_THREADS_PER_CPU: Definition

PARTITION_VIEW_ENABLED: Definition

PGA_AGGREGATE_TARGET: Definition

PLSQL_COMPILER_FLAGS: Definition

PLSQL_NATIVE_C_COMPILER: Definition

PLSQL_NATIVE_LIBRARY_DIR: Definition

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT: Definition

PLSQL_NATIVE_LINKER: Definition

PLSQL_NATIVE_MAKE_FILE_NAME: Definition

PLSQL_NATIVE_MAKE_UTILITY: Definition

PLSQL_V2_COMPATIBILITY: Definition

PRE_PAGE_SGA: Definition

PROCESSES: Definition

QUERY_REWRITE_ENABLED: Definition

QUERY_REWRITE_INTEGRITY: Definition

RDBMS_SERVER_DN: Definition

READ_ONLY_OPEN_DELAYED: Definition

RECOVERY_PARALLELISM: Definition

REMOTE_ARCHIVE_ENABLE: Definition

REMOTE_DEPENDENCIES_MODE: Definition

REMOTE_LISTENER: Definition

REMOTE_LOGIN_PASSWORDFILE: Definition

REMOTE_OS_AUTHENT: Definition

REMOTE_OS_ROLES: Definition

REPLICATION_DEPENDENCY_TRACKING: Definition

RESOURCE_LIMIT: Definition

RESOURCE_MANAGER_PLAN: Definition

ROLLBACK_SEGMENTS: Definition

ROW_LOCKING: Definition

SERIAL _REUSE: Definition

SERVICE_NAMES: Definition

SESSIONS: Definition

SESSION_CACHED_CURSORS: Definition

SESSION_MAX_OPEN_FILES: Definition

SGA_MAX_SIZE: Definition

SHADOW_CORE_DUMP: Definition

SHARED_MEMORY_ADDRESS: Definition

SHARED_POOL_RESERVED_SIZE: Definition

SHARED_POOL_SIZE: Definition

SHARED_SERVERS: Definition

SHARED_SERVER_SESSIONS: Definition

SORT_AREA_RETAINED_SIZE: Definition

SORT_AREA_SIZE: Definition

SPFILE: Definition

SQL92_SECURITY: Definition

SQL_TRACE: Definition

STANDBY_ARCHIVE_DEST: Definition

STANDBY_FILE_MANAGEMENT: Definition

STAR_TRANSFORMATION_ENABLED: Definition

STATISTICS_LEVEL: Definition

TAPE_ASYNCH_IO: Definition

THREAD: Definition

TIMED_OS_STATISTICS: Definition

TIMED_STATISTICS: Definition

TRACEFILE_IDENTIFIER: Definition

TRACE_ENABLED: Definition

TRANSACTIONS: Definition

TRANSACTIONS_PER_ROLLBACK_SEGMENT: Definition

TRANSACTION_AUDITING: Definition

UNDO_MANAGEMENT: Definition

UNDO_RETENTION: Definition

UNDO_SUPPRESS_ERRORS: Definition

UNDO_TABLESPACE: Definition

USER_DUMP_DEST: Definition

USE_INDIRECT_DATA_BUFFERS: Definition

UTL_FILE_DIR: Definition

WORKAREA_SIZE_POLICY: Definition