次に、初期化パラメータを機能カテゴリ別に示します。
ANSI準拠
BLANK_TRIMMING
バックアップおよびリストア
BACKUP_TAPE_IO_SLAVES
CLONEDB
RECYCLEBIN
TAPE_ASYNCH_IO
BFILE
SESSION_MAX_OPEN_FILES
バッファ・キャッシュ、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
USER_INDIRECT_DATA_BUFFERS
カーソル、ライブラリ・キャッシュ
CURSOR_BIND_CAPTURE_DESTINATION
CURSOR_SHARING
CURSOR_SPACE_FOR_TIME
OPEN_CURSORS
SESSION_CACHED_CURSORS
データベース/インスタンスの識別
DB_DOMAIN
DB_NAME
INSTANCE_NAME
診断、統計
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
分散、レプリケーション
COMMIT_POINT_STRENGTH
DISTRIBUTED_LOCK_TIMEOUT
ENABLE_GOLDENGATE_REPLICATIONS
GLOBAL_NAMES
HS_AUTOREGISTER
OPEN_LINKS
OPEN_LINKS_PER_INSTANCE
REPLICATION_DEPENDENCY_TRACKING
ファイルの位置、名前、サイズ
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
グローバリゼーション
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_MAX_SESSIONSPACE_SIZE
ジョブ・キュー
JOB_QUEUE_PROCESSES
ライセンスの制限
LICENSE_MAX_SESSIONS
LICENSE_MAX_USERS
LICENSE_SESSIONS_WARNING
メモリー
INMEMORY_CLAUSE_DEFAULT
INMEMORY_FORCE
INMEMORY_MAX_POPULATE_SERVERS
INMEMORY_QUERY
INMEMORY_SIZE
INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT
MEMORY_MAX_TARGET
MEMORY_TARGET
その他
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
マルチテナント・アーキテクチャ
COMMON_USER_PREFIX
NONCDB_COMPATIBLE
PDB_FILE_NAME_CONVERT
ネットワーキング
CONNECTION_BROKERS
LOCAL_LISTENER
REMOTE_LISTENER
SERVICE_NAMES
オブジェクト、LOB
OBJECT_CACHE_MAX_SIZE_PERCENT
OBJECT_CACHE_OPTIMAL_SIZE
OLAP
OLAP_PAGE_POOL_SIZE
オプティマイザ
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_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コンパイラ
PERMIT_92_WRAP_FORMAT
PLSCOPE_SETTINGS
PLSQL_CCFLAGS
PLSQL_CODE_TYPE
PLSQL_DEBUG
PLSQL_OPTIMIZE_LEVEL
PLSQL_WARNINGS
NLS_LENGTH_SEMANTICS
SGAメモリー
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ログ、アーカイブ、リカバリ
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
リソース・マネージャ
PROCESSOR_GROUP_NAME
RESOURCE_LIMIT
RESOURCE_MANAGER_CPU_ALLOCATION
RESOURCE_MANAGER_PLAN
セキュリティ、監査
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
セッション、プロセス
CPU_COUNT
PROCESSES
SESSIONS
THREADED_EXECUTION
USE_DEDICATED_BROKER
共有サーバー・アーキテクチャ
CIRCUITS
DISPATCHERS
MAX_DISPATCHERS
MAX_SHARED_SERVERS
SHARED_SERVER_SESSIONS
SHARED_SERVERS
スタンバイ・データベース
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
一時ソート領域
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
トランザクション
COMMIT_LOGGING
COMMIT_WAIT
DB_LOST_WRITE_PROTECT
DDL_LOCK_TIMEOUT
DML_LOCKS
FAST_START_PARALLEL_ROLLBACK
GLOBAL_TXN_PROCESSES
TRANSACTIONS
UNDO管理
RESUMABLE_TIMEOUT
ROLLBACK_SEGMENTS
TEMP_UNDO_ENABLED
TRANSACTIONS_PER_ROLLBACK_SEGMENT
UNDO_MANAGEMENT
UNDO_RETENTION
UNDO_TABLESPACE