Parameters by Functional Category

The following list shows the initialization parameters by their functional category:

• ANSI Compliance

  • BLANK_TRIMMING

• Backup and Restore

  • BACKUP_TAPE_IO_SLAVES
  • CLONEDB
  • RECYCLEBIN
  • TAPE_ASYNCH_IO

• BFILEs

  • SESSION_MAX_OPEN_FILES

• Buffer Cache and I/O

  • CLIENT_RESULT_CACHE_LAG
  • CLIENT_RESULT_CACHE_SIZE
  • DB_nK_CACHE_SIZE
  • DB_BIG_TABLE_CACHE_PERCENT_TARGET
  • DB_BLOCK_BUFFERS
  • DB_BLOCK_SIZE
  • DB_CACHE_ADVICE
  • DB_CACHE_SIZE
  • DB_FILE_MULTIBLOCK_READ_COUNT
  • DB_KEEP_CACHE_SIZE
  • DB_RECYCLE_CACHE_SIZE
  • DB_WRITER_PROCESSES
  • DBWR_IO_SLAVES
  • DISK_ASYNCH_IO
  • DNFS_BATCH_SIZE
  • FILESYSTEMIO_OPTIONS
  • READ_ONLY_OPEN_DELAYED
  • RESULT_CACHE_MAX_RESULT
  • RESULT_CACHE_MAX_SIZE
  • RESULT_CACHE_MODE
  • USE_INDIRECT_DATA_BUFFERS

• Cursors and Library Cache

  • CURSOR_BIND_CAPTURE_DESTINATION
  • CURSOR_SHARING
  • CURSOR_SPACE_FOR_TIME
  • OPEN_CURSORS
  • SESSION_CACHED_CURSORS

• Database/Instance Identification

  • DB_DOMAIN
  • DB_NAME
  • INSTANCE_NAME

• Diagnostics and Statistics

  • BACKGROUND_CORE_DUMP
  • BACKGROUND_DUMP_DEST
  • CORE_DUMP_DEST
  • DB_BLOCK_CHECKING
  • DB_BLOCK_CHECKSUM
  • DIAGNOSTIC_DEST
  • EVENT
  • HEAT_MAP
  • MAX_DUMP_FILE_SIZE
  • SHADOW_CORE_DUMP
  • STATISTICS_LEVEL
  • TIMED_OS_STATISTICS
  • TIMED_STATISTICS
  • TRACE_ENABLED
  • TRACEFILE_IDENTIFIER
  • USER_DUMP_DEST

• Distributed, Replication

  • COMMIT_POINT_STRENGTH
  • DISTRIBUTED_LOCK_TIMEOUT
  • ENABLE_GOLDENGATE_REPLICATION
  • GLOBAL_NAMES
  • HS_AUTOREGISTER
  • OPEN_LINKS
  • OPEN_LINKS_PER_INSTANCE
  • REPLICATION_DEPENDENCY_TRACKING

• File Locations, Names, and Sizes

  • AUDIT_FILE_DEST
  • BACKGROUND_CORE_DUMP
  • BACKGROUND_DUMP_DEST
  • CONTROL_FILES
  • CORE_DUMP_DEST
  • DB_CREATE_FILE_DEST
  • DB_CREATE_ONLINE_LOG_DEST_n
  • DB_FILES
  • DB_RECOVERY_FILE_DEST
  • DB_RECOVERY_FILE_DEST_SIZE
  • FILE_MAPPING
  • IFILE
  • LOG_ARCHIVE_DEST_n
  • SPFILE

• Globalization

  • NLS_CALENDAR
  • NLS_COMP
  • NLS_CURRENCY
  • NLS_DATE_FORMAT
  • NLS_DATE_LANGUAGE
  • NLS_DUAL_CURRENCY
  • NLS_ISO_CURRENCY
  • NLS_LANGUAGE
  • NLS_LENGTH_SEMANTICS
  • NLS_NCHAR_CONV_EXCP
  • NLS_NUMERIC_CHARACTERS
  • NLS_SORT
  • NLS_TERRITORY
  • NLS_TIMESTAMP_FORMAT
  • NLS_TIMESTAMP_TZ_FORMAT

• Java

  • JAVA_JIT_ENABLED
  • JAVA_MAX_SESSIONSPACE_SIZE
  • JAVA_POOL_SIZE
  • JAVA_SOFT_SESSIONSPACE_LIMIT

• Job Queues

  • JOB_QUEUE_PROCESSES

• License Limits

  • LICENSE_MAX_SESSIONS
  • LICENSE_MAX_USERS
  • LICENSE_SESSIONS_WARNING

• Memory

  • INMEMORY_CLAUSE_DEFAULT
  • INMEMORY_FORCE
  • INMEMORY_MAX_POPULATE_SERVERS
  • INMEMORY_QUERY
  • INMEMORY_SIZE
  • INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT
  • MEMORY_MAX_TARGET
  • MEMORY_TARGET

• Miscellaneous

  • AQ_TM_PROCESSES
  • AWR_SNAPSHOT_TIME_OFFSET
  • ASM_PREFERRED_READ_FAILURE_GROUPS
  • COMPATIBLE
  • DB_INDEX_COMPRESSION_INHERITANCE
  • FIXED_DATE
  • LDAP_DIRECTORY_SYSAUTH
  • MAX_STRING_SIZE
  • SPATIAL_VECTOR_ACCELERATION
  • XML_DB_EVENTS

• Multitenant Architecture

  • COMMON_USER_PREFIX
  • NONCDB_COMPATIBLE
  • PDB_FILE_NAME_CONVERT

• Networking

  • CONNECTION_BROKERS
  • LOCAL_LISTENER
  • REMOTE_LISTENER
  • SERVICE_NAMES

• Objects and LOBs

  • OBJECT_CACHE_MAX_SIZE_PERCENT
  • OBJECT_CACHE_OPTIMAL_SIZE

• OLAP

  • OLAP_PAGE_POOL_SIZE

• Optimizer

  • OPTIMIZER_ADAPTIVE_FEATURES
  • OPTIMIZER_ADAPTIVE_REPORTING_ONLY
  • OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES
  • OPTIMIZER_DYNAMIC_SAMPLING
  • OPTIMIZER_FEATURES_ENABLE
  • OPTIMIZER_INDEX_CACHING
  • OPTIMIZER_INDEX_COST_ADJ
  • OPTIMIZER_INMEMORY_AWARE
  • OPTIMIZER_MODE
  • OPTIMIZER_SECURE_VIEW_MERGING
  • OPTIMIZER_USE_PENDING_STATISTICS
  • OPTIMIZER_USE_SQL_PLAN_BASELINES
  • QUERY_REWRITE_ENABLED
  • QUERY_REWRITE_INTEGRITY
  • STAR_TRANSFORMATION_ENABLED

• Parallel Execution

  • PARALLEL_ADAPTIVE_MULTI_USER
  • PARALLEL_EXECUTION_MESSAGE_SIZE
  • PARALLEL_MAX_SERVERS
  • PARALLEL_MIN_PERCENT
  • PARALLEL_MIN_SERVERS
  • PARALLEL_THREADS_PER_CPU

• PL/SQL

  • PLSQL_V2_COMPATIBILITY
  • REMOTE_DEPENDENCIES_MODE
  • UTL_FILE_DIR

• PL/SQL Compiler

  • PERMIT_92_WRAP_FORMAT
  • PLSCOPE_SETTINGS
  • PLSQL_CCFLAGS
  • PLSQL_CODE_TYPE
  • PLSQL_DEBUG
  • PLSQL_OPTIMIZE_LEVEL
  • PLSQL_WARNINGS
  • NLS_LENGTH_SEMANTICS

• SGA Memory

  • DB_nK_CACHE_SIZE
  • DB_CACHE_SIZE
  • HI_SHARED_MEMORY_ADDRESS
  • JAVA_POOL_SIZE
  • LARGE_POOL_SIZE
  • LOCK_SGA
  • OLAP_PAGE_POOL_SIZE
  • PRE_PAGE_SGA
  • SGA_MAX_SIZE
  • SGA_TARGET
  • SHARED_MEMORY_ADDRESS
  • SHARED_POOL_RESERVED_SIZE
  • SHARED_POOL_SIZE
  • STREAMS_POOL_SIZE
  • USE_LARGE_PAGES

• Oracle RAC

  • ACTIVE_INSTANCE_COUNT
  • CLUSTER_DATABASE
  • CLUSTER_DATABASE_INSTANCES
  • CLUSTER_INTERCONNECTS
  • INSTANCE_NUMBER
  • PARALLEL_INSTANCE_GROUP
  • THREAD

• Redo Logs, Archiving, and Recovery

  • CONTROL_FILE_RECORD_KEEP_TIME
  • DB_CREATE_ONLINE_LOG_DEST_n
  • DB_RECOVERY_FILE_DEST
  • DB_RECOVERY_FILE_DEST_SIZE
  • DB_UNRECOVERABLE_SCN_TRACKING
  • FAST_START_MTTR_TARGET
  • LOG_BUFFER
  • LOG_CHECKPOINT_INTERVAL
  • LOG_CHECKPOINT_TIMEOUT
  • LOG_CHECKPOINTS_TO_ALERT
  • LOG_ARCHIVE_CONFIG
  • LOG_ARCHIVE_DEST_n
  • LOG_ARCHIVE_DEST_STATE_n
  • LOG_ARCHIVE_DUPLEX_DEST
  • LOG_ARCHIVE_FORMAT
  • LOG_ARCHIVE_MAX_PROCESSES
  • LOG_ARCHIVE_MIN_SUCCEED_DEST
  • LOG_ARCHIVE_TRACE
  • REDO_TRANSPORT_USER
  • RECOVERY_PARALLELISM

• Resource Manager

  • PROCESSOR_GROUP_NAME
  • RESOURCE_LIMIT
  • RESOURCE_MANAGER_CPU_ALLOCATION
  • RESOURCE_MANAGER_PLAN

• Security and Auditing

  • AUDIT_FILE_DEST
  • AUDIT_SYS_OPERATIONS
  • AUDIT_SYSLOG_LEVEL
  • AUDIT_TRAIL
  • COMMIT_LOGGING
  • COMMIT_WAIT
  • DBFIPS_140
  • O7_DICTIONARY_ACCESSIBILITY
  • OS_AUTHENT_PREFIX
  • OS_ROLES
  • RDBMS_SERVER_DN
  • REMOTE_LOGIN_PASSWORDFILE
  • REMOTE_OS_AUTHENT
  • REMOTE_OS_ROLES
  • SEC_CASE_SENSITIVE_LOGON
  • SEC_MAX_FAILED_LOGIN_ATTEMPTS
  • SEC_PROTOCOL_ERROR_FURTHER_ACTION
  • SEC_PROTOCOL_ERROR_TRACE_ACTION
  • SEC_RETURN_SERVER_RELEASE_BANNER
  • SQL92_SECURITY
  • UNIFIED_AUDIT_SGA_QUEUE_SIZE

• Sessions and Processes

  • CPU_COUNT
  • PROCESSES
  • SESSIONS
  • THREADED_EXECUTION
  • USE_DEDICATED_BROKER

• Shared Server Architecture

  • CIRCUITS
  • DISPATCHERS
  • MAX_DISPATCHERS
  • MAX_SHARED_SERVERS
  • SHARED_SERVER_SESSIONS
  • SHARED_SERVERS

• Standby Database

  • ARCHIVE_LAG_TARGET
  • DB_FILE_NAME_CONVERT
  • DB_UNIQUE_NAME
  • DG_BROKER_CONFIG_FILEn
  • DG_BROKER_START
  • FAL_CLIENT
  • FAL_SERVER
  • LOG_FILE_NAME_CONVERT
  • STANDBY_FILE_MANAGEMENT

• Temporary Sort Space

  • BITMAP_MERGE_AREA_SIZE
  • CREATE_BITMAP_AREA_SIZE
  • HASH_AREA_SIZE
  • PGA_AGGREGATE_LIMIT
  • PGA_AGGREGATE_TARGET
  • SORT_AREA_RETAINED_SIZE
  • SORT_AREA_SIZE
  • WORKAREA_SIZE_POLICY

• Transactions

  • COMMIT_LOGGING
  • COMMIT_WAIT
  • DB_LOST_WRITE_PROTECT
  • DDL_LOCK_TIMEOUT
  • DML_LOCKS
  • FAST_START_PARALLEL_ROLLBACK
  • GLOBAL_TXN_PROCESSES
  • TRANSACTIONS

• Undo Management

  • RESUMABLE_TIMEOUT
  • ROLLBACK_SEGMENTS
  • TEMP_UNDO_ENABLED
  • TRANSACTIONS_PER_ROLLBACK_SEGMENT
  • UNDO_MANAGEMENT
  • UNDO_RETENTION
  • UNDO_TABLESPACE