Home Help Feedback

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
Search requires an Internet connection to Oracle.com and free registration on the Oracle Technology Network. If you do not have Internet access, use the Master Index or List of Books instead.

ACTIVE_INSTANCE_COUNT: Definition , Search for it

AQ_TM_PROCESSES: Definition , Search for it

ARCHIVE_LAG_TARGET: Definition , Search for it

AUDIT_FILE_DEST: Definition , Search for it

AUDIT_SYS_OPERATIONS: Definition , Search for it

AUDIT_TRAIL: Definition , Search for it

BACKGROUND_CORE_DUMP: Definition , Search for it

BACKGROUND_DUMP_DEST: Definition , Search for it

BACKUP_TAPE_IO_SLAVES: Definition , Search for it

BITMAP_MERGE_AREA_SIZE: Definition , Search for it

BLANK_TRIMMING: Definition , Search for it

BUFFER_POOL_KEEP: Definition , Search for it

BUFFER_POOL_RECYCLE: Definition , Search for it

CIRCUITS: Definition , Search for it

CLUSTER_DATABASE: Definition , Search for it

CLUSTER_DATABASE_INSTANCES: Definition , Search for it

CLUSTER_INTERCONNECTS: Definition , Search for it

COMMIT_POINT_STRENGTH: Definition , Search for it

COMPATIBLE: Definition , Search for it

CONTROL_FILES: Definition , Search for it

CONTROL_FILE_RECORD_KEEP_TIME: Definition , Search for it

CORE_DUMP_DEST: Definition , Search for it

CPU_COUNT: Definition , Search for it

CREATE_BITMAP_AREA_SIZE: Definition , Search for it

CURSOR_SHARING: Definition , Search for it

CURSOR_SPACE_FOR_TIME: Definition , Search for it

DBLINK_ENCRYPT_LOGIN: Definition , Search for it

DBWR_IO_SLAVES: Definition , Search for it

DB_BLOCK_BUFFERS: Definition , Search for it

DB_BLOCK_CHECKING: Definition , Search for it

DB_BLOCK_CHECKSUM: Definition , Search for it

DB_BLOCK_SIZE: Definition , Search for it

DB_CACHE_ADVICE: Definition , Search for it

DB_CACHE_SIZE: Definition , Search for it

DB_CREATE_FILE_DEST: Definition , Search for it

DB_DOMAIN: Definition , Search for it

DB_FILES: Definition , Search for it

DB_FILE_MULTIBLOCK_READ_COUNT: Definition , Search for it

DB_FILE_NAME_CONVERT: Definition , Search for it

DB_KEEP_CACHE_SIZE: Definition , Search for it

DB_NAME: Definition , Search for it

DB_RECYCLE_CACHE_SIZE: Definition , Search for it

DB_WRITER_PROCESSES: Definition , Search for it

DG_BROKER_START: Definition , Search for it

DISK_ASYNCH_IO: Definition , Search for it

DISPATCHERS: Definition , Search for it

DISTRIBUTED_LOCK_TIMEOUT: Definition , Search for it

DML_LOCKS: Definition , Search for it

DRS_START: Definition , Search for it

ENQUEUE_RESOURCES: Definition , Search for it

EVENT: Definition , Search for it

FAL_CLIENT: Definition , Search for it

FAL_SERVER: Definition , Search for it

FAST_START_IO_TARGET: Definition , Search for it

FAST_START_MTTR_TARGET: Definition , Search for it

FAST_START_PARALLEL_ROLLBACK: Definition , Search for it

FILESYSTEMIO_OPTIONS: Definition , Search for it

FILE_MAPPING: Definition , Search for it

FIXED_DATE: Definition , Search for it

GC_FILES_TO_LOCKS: Definition , Search for it

GLOBAL_CONTEXT_POOL_SIZE: Definition , Search for it

GLOBAL_NAMES: Definition , Search for it

HASH_AREA_SIZE: Definition , Search for it

HASH_JOIN_ENABLED: Definition , Search for it

HI_SHARED_MEMORY_ADDRESS: Definition , Search for it

HS_AUTOREGISTER: Definition , Search for it

IFILE: Definition , Search for it

INSTANCE_GROUPS: Definition , Search for it

INSTANCE_NAME: Definition , Search for it

INSTANCE_NUMBER: Definition , Search for it

JAVA_MAX_SESSIONSPACE_SIZE: Definition , Search for it

JAVA_POOL_SIZE: Definition , Search for it

JAVA_SOFT_SESSIONSPACE_LIMIT: Definition , Search for it

JOB_QUEUE_PROCESSES: Definition , Search for it

LARGE_POOL_SIZE: Definition , Search for it

LICENSE_MAX_SESSIONS: Definition , Search for it

LICENSE_MAX_USERS: Definition , Search for it

LICENSE_SESSIONS_WARNING: Definition , Search for it

LOCAL_LISTENER: Definition , Search for it

LOCK_NAME_SPACE: Definition , Search for it

LOCK_SGA: Definition , Search for it

LOGMNR_MAX_PERSISTENT_SESSIONS: Definition , Search for it

LOG_ARCHIVE_DEST: Definition , Search for it

LOG_ARCHIVE_DUPLEX_DEST: Definition , Search for it

LOG_ARCHIVE_FORMAT: Definition , Search for it

LOG_ARCHIVE_MAX_PROCESSES: Definition , Search for it

LOG_ARCHIVE_MIN_SUCCEED_DEST: Definition , Search for it

LOG_ARCHIVE_START: Definition , Search for it

LOG_ARCHIVE_TRACE: Definition , Search for it

LOG_BUFFER: Definition , Search for it

LOG_CHECKPOINTS_TO_ALERT: Definition , Search for it

LOG_CHECKPOINT_INTERVAL: Definition , Search for it

LOG_CHECKPOINT_TIMEOUT: Definition , Search for it

LOG_FILE_NAME_CONVERT: Definition , Search for it

LOG_PARALLELISM: Definition , Search for it

MAX_COMMIT_PROPAGATION_DELAY: Definition , Search for it

MAX_DISPATCHERS: Definition , Search for it

MAX_DUMP_FILE_SIZE: Definition , Search for it

MAX_ENABLED_ROLES: Definition , Search for it

MAX_ROLLBACK_SEGMENTS: Definition , Search for it

MAX_SHARED_SERVERS: Definition , Search for it

NLS_CALENDAR: Definition , Search for it

NLS_COMP: Definition , Search for it

NLS_CURRENCY: Definition , Search for it

NLS_DATE_FORMAT: Definition , Search for it

NLS_DATE_LANGUAGE: Definition , Search for it

NLS_DUAL_CURRENCY: Definition , Search for it

NLS_ISO_CURRENCY: Definition , Search for it

NLS_LANGUAGE: Definition , Search for it

NLS_LENGTH_SEMANTICS: Definition , Search for it

NLS_NCHAR_CONV_EXCP: Definition , Search for it

NLS_NUMERIC_CHARACTERS: Definition , Search for it

NLS_SORT: Definition , Search for it

NLS_TERRITORY: Definition , Search for it

NLS_TIMESTAMP_FORMAT: Definition , Search for it

NLS_TIMESTAMP_TZ_FORMAT: Definition , Search for it

O7_DICTIONARY_ACCESSIBILITY: Definition , Search for it

OBJECT_CACHE_MAX_SIZE_PERCENT: Definition , Search for it

OBJECT_CACHE_OPTIMAL_SIZE: Definition , Search for it

OLAP_PAGE_POOL_SIZE: Definition , Search for it

OPEN_CURSORS: Definition , Search for it

OPEN_LINKS: Definition , Search for it

OPEN_LINKS_PER_INSTANCE: Definition , Search for it

OPTIMIZER_DYNAMIC_SAMPLING: Definition , Search for it

OPTIMIZER_FEATURES_ENABLE: Definition , Search for it

OPTIMIZER_INDEX_CACHING: Definition , Search for it

OPTIMIZER_INDEX_COST_ADJ: Definition , Search for it

OPTIMIZER_MAX_PERMUTATIONS: Definition , Search for it

OPTIMIZER_MODE: Definition , Search for it

ORACLE_TRACE_COLLECTION_NAME: Definition , Search for it

ORACLE_TRACE_COLLECTION_PATH: Definition , Search for it

ORACLE_TRACE_COLLECTION_SIZE: Definition , Search for it

ORACLE_TRACE_ENABLE: Definition , Search for it

ORACLE_TRACE_FACILITY_NAME: Definition , Search for it

ORACLE_TRACE_FACILITY_PATH: Definition , Search for it

OS_AUTHENT_PREFIX: Definition , Search for it

OS_ROLES: Definition , Search for it

PARALLEL_ADAPTIVE_MULTI_USER: Definition , Search for it

PARALLEL_AUTOMATIC_TUNING: Definition , Search for it

PARALLEL_EXECUTION_MESSAGE_SIZE: Definition , Search for it

PARALLEL_INSTANCE_GROUP: Definition , Search for it

PARALLEL_MAX_SERVERS: Definition , Search for it

PARALLEL_MIN_PERCENT: Definition , Search for it

PARALLEL_MIN_SERVERS: Definition , Search for it

PARALLEL_THREADS_PER_CPU: Definition , Search for it

PARTITION_VIEW_ENABLED: Definition , Search for it

PGA_AGGREGATE_TARGET: Definition , Search for it

PLSQL_COMPILER_FLAGS: Definition , Search for it

PLSQL_NATIVE_C_COMPILER: Definition , Search for it

PLSQL_NATIVE_LIBRARY_DIR: Definition , Search for it

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT: Definition , Search for it

PLSQL_NATIVE_LINKER: Definition , Search for it

PLSQL_NATIVE_MAKE_FILE_NAME: Definition , Search for it

PLSQL_NATIVE_MAKE_UTILITY: Definition , Search for it

PLSQL_V2_COMPATIBILITY: Definition , Search for it

PRE_PAGE_SGA: Definition , Search for it

PROCESSES: Definition , Search for it

QUERY_REWRITE_ENABLED: Definition , Search for it

QUERY_REWRITE_INTEGRITY: Definition , Search for it

RDBMS_SERVER_DN: Definition , Search for it

READ_ONLY_OPEN_DELAYED: Definition , Search for it

RECOVERY_PARALLELISM: Definition , Search for it

REMOTE_ARCHIVE_ENABLE: Definition , Search for it

REMOTE_DEPENDENCIES_MODE: Definition , Search for it

REMOTE_LISTENER: Definition , Search for it

REMOTE_LOGIN_PASSWORDFILE: Definition , Search for it

REMOTE_OS_AUTHENT: Definition , Search for it

REMOTE_OS_ROLES: Definition , Search for it

REPLICATION_DEPENDENCY_TRACKING: Definition , Search for it

RESOURCE_LIMIT: Definition , Search for it

RESOURCE_MANAGER_PLAN: Definition , Search for it

ROLLBACK_SEGMENTS: Definition , Search for it

ROW_LOCKING: Definition , Search for it

SERIAL _REUSE: Definition , Search for it

SERVICE_NAMES: Definition , Search for it

SESSIONS: Definition , Search for it

SESSION_CACHED_CURSORS: Definition , Search for it

SESSION_MAX_OPEN_FILES: Definition , Search for it

SGA_MAX_SIZE: Definition , Search for it

SHADOW_CORE_DUMP: Definition , Search for it

SHARED_MEMORY_ADDRESS: Definition , Search for it

SHARED_POOL_RESERVED_SIZE: Definition , Search for it

SHARED_POOL_SIZE: Definition , Search for it

SHARED_SERVERS: Definition , Search for it

SHARED_SERVER_SESSIONS: Definition , Search for it

SORT_AREA_RETAINED_SIZE: Definition , Search for it

SORT_AREA_SIZE: Definition , Search for it

SPFILE: Definition , Search for it

SQL92_SECURITY: Definition , Search for it

SQL_TRACE: Definition , Search for it

STANDBY_ARCHIVE_DEST: Definition , Search for it

STANDBY_FILE_MANAGEMENT: Definition , Search for it

STAR_TRANSFORMATION_ENABLED: Definition , Search for it

STATISTICS_LEVEL: Definition , Search for it

TAPE_ASYNCH_IO: Definition , Search for it

THREAD: Definition , Search for it

TIMED_OS_STATISTICS: Definition , Search for it

TIMED_STATISTICS: Definition , Search for it

TRACEFILE_IDENTIFIER: Definition , Search for it

TRACE_ENABLED: Definition , Search for it

TRANSACTIONS: Definition , Search for it

TRANSACTIONS_PER_ROLLBACK_SEGMENT: Definition , Search for it

TRANSACTION_AUDITING: Definition , Search for it

UNDO_MANAGEMENT: Definition , Search for it

UNDO_RETENTION: Definition , Search for it

UNDO_SUPPRESS_ERRORS: Definition , Search for it

UNDO_TABLESPACE: Definition , Search for it

USER_DUMP_DEST: Definition , Search for it

USE_INDIRECT_DATA_BUFFERS: Definition , Search for it

UTL_FILE_DIR: Definition , Search for it

WORKAREA_SIZE_POLICY: Definition , Search for it