| Oracle® Databaseリファレンス 12c リリース1 (12.1) B71292-14 |
|
 前 |
 次 |
次に、初期化パラメータを機能カテゴリ別に示します。
ANSI準拠
BLANK_TRIMMINGバックアップおよびリストア
BACKUP_TAPE_IO_SLAVESCLONEDBRECYCLEBINTAPE_ASYNCH_IOBFILE
SESSION_MAX_OPEN_FILESバッファ・キャッシュ、I/O
CLIENT_RESULT_CACHE_LAGCLIENT_RESULT_CACHE_SIZEDB_nK_CACHE_SIZEDB_BIG_TABLE_CACHE_PERCENT_TARGETDB_BLOCK_BUFFERSDB_BLOCK_SIZEDB_CACHE_ADVICEDB_CACHE_SIZEDB_FILE_MULTIBLOCK_READ_COUNTDB_KEEP_CACHE_SIZEDB_RECYCLE_CACHE_SIZEDB_WRITER_PROCESSESDBWR_IO_SLAVESDISK_ASYNCH_IODNFS_BATCH_SIZEFILESYSTEMIO_OPTIONSREAD_ONLY_OPEN_DELAYEDRESULT_CACHE_MAX_RESULTRESULT_CACHE_MAX_SIZERESULT_CACHE_MODEUSER_INDIRECT_DATA_BUFFERSカーソル、ライブラリ・キャッシュ
CURSOR_BIND_CAPTURE_DESTINATIONCURSOR_SHARINGCURSOR_SPACE_FOR_TIMEOPEN_CURSORSSESSION_CACHED_CURSORSデータベース/インスタンスの識別
DB_DOMAINDB_NAMEINSTANCE_NAME診断、統計
BACKGROUND_CORE_DUMPBACKGROUND_DUMP_DESTCORE_DUMP_DESTDB_BLOCK_CHECKINGDB_BLOCK_CHECKSUMDIAGNOSTIC_DESTEVENTHEAT_MAPMAX_DUMP_FILE_SIZESHADOW_CORE_DUMPSTATISTICS_LEVELTIMED_OS_STATISTICSTIMED_STATISTICSTRACE_ENABLEDTRACEFILE_IDENTIFIERUSER_DUMP_DEST分散、レプリケーション
COMMIT_POINT_STRENGTHDISTRIBUTED_LOCK_TIMEOUTENABLE_GOLDENGATE_REPLICATIONSGLOBAL_NAMESHS_AUTOREGISTEROPEN_LINKSOPEN_LINKS_PER_INSTANCEREPLICATION_DEPENDENCY_TRACKINGファイルの位置、名前、サイズ
AUDIT_FILE_DESTBACKGROUND_CORE_DUMPBACKGROUND_DUMP_DESTCONTROL_FILESCORE_DUMP_DESTDB_CREATE_FILE_DESTDB_CREATE_ONLINE_LOG_DEST_nDB_FILESDB_RECOVERY_FILE_DESTDB_RECOVERY_FILE_DEST_SIZEFILE_MAPPINGIFILELOG_ARCHIVE_DEST_nSPFILEグローバリゼーション
NLS_CALENDARNLS_COMPNLS_CURRENCYNLS_DATE_FORMATNLS_DATE_LANGUAGENLS_DUAL_CURRENCYNLS_ISO_CURRENCYNLS_LANGUAGENLS_LENGTH_SEMANTICSNLS_NCHAR_CONV_EXCPNLS_NUMERIC_CHARACTERSNLS_SORTNLS_TERRITORYNLS_TIMESTAMP_FORMATNLS_TIMESTAMP_TZ_FORMATJava
JAVA_JIT_ENABLEDJAVA_MAX_SESSIONSPACE_SIZEJAVA_POOL_SIZEJAVA_MAX_SESSIONSPACE_SIZEジョブ・キュー
JOB_QUEUE_PROCESSESライセンスの制限
LICENSE_MAX_SESSIONSLICENSE_MAX_USERSLICENSE_SESSIONS_WARNINGメモリー
INMEMORY_CLAUSE_DEFAULTINMEMORY_FORCEINMEMORY_MAX_POPULATE_SERVERSINMEMORY_QUERYINMEMORY_SIZEINMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENTMEMORY_MAX_TARGETMEMORY_TARGETその他
AQ_TM_PROCESSESAWR_SNAPSHOT_TIME_OFFSETASM_PREFERRED_READ_FAILURE_GROUPSCOMPATIBLEDB_INDEX_COMPRESSION_INHERITANCEFIXED_DATELDAP_DIRECTORY_SYSAUTHMAX_STRING_SIZESPATIAL_VECTOR_ACCELERATIONXML_DB_EVENTSマルチテナント・アーキテクチャ
COMMON_USER_PREFIXNONCDB_COMPATIBLEPDB_FILE_NAME_CONVERTネットワーキング
CONNECTION_BROKERSLOCAL_LISTENERREMOTE_LISTENERSERVICE_NAMESオブジェクト、LOB
OBJECT_CACHE_MAX_SIZE_PERCENTOBJECT_CACHE_OPTIMAL_SIZEOLAP
OLAP_PAGE_POOL_SIZEオプティマイザ
OPTIMIZER_ADAPTIVE_FEATURESOPTIMIZER_ADAPTIVE_REPORTING_ONLYOPTIMIZER_CAPTURE_SQL_PLAN_BASELINESOPTIMIZER_DYNAMIC_SAMPLINGOPTIMIZER_FEATURES_ENABLEOPTIMIZER_INDEX_CACHINGOPTIMIZER_INDEX_COST_ADJOPTIMIZER_INMEMORY_AWAREOPTIMIZER_MODEOPTIMIZER_SECURE_VIEW_MERGINGOPTIMIZER_USE_PENDING_STATISTICSOPTIMIZER_USE_SQL_PLAN_BASELINESQUERY_REWRITE_ENABLEDQUERY_REWRITE_INTEGRITYSTAR_TRANSFORMATION_ENABLEDパラレル実行
PARALLEL_ADAPTIVE_MULTI_USERPARALLEL_EXECUTION_MESSAGE_SIZEPARALLEL_MAX_SERVERSPARALLEL_MIN_PERCENTPARALLEL_MIN_SERVERSPARALLEL_THREADS_PER_CPUPL/SQL
PLSQL_V2_COMPATIBILITYREMOTE_DEPENDENCIES_MODEUTL_FILE_DIRPL/SQLコンパイラ
PERMIT_92_WRAP_FORMATPLSCOPE_SETTINGSPLSQL_CCFLAGSPLSQL_CODE_TYPEPLSQL_DEBUGPLSQL_OPTIMIZE_LEVELPLSQL_WARNINGSNLS_LENGTH_SEMANTICSSGAメモリー
DB_nK_CACHE_SIZEDB_CACHE_SIZEHI_SHARED_MEMORY_ADDRESSJAVA_POOL_SIZELARGE_POOL_SIZELOCK_SGAOLAP_PAGE_POOL_SIZEPRE_PAGE_SGASGA_MAX_SIZESGA_TARGETSHARED_MEMORY_ADDRESSSHARED_POOL_RESERVED_SIZESHARED_POOL_SIZESTREAMS_POOL_SIZEUSE_LARGE_PAGESOracle RAC
ACTIVE_INSTANCE_COUNTCLUSTER_DATABASECLUSTER_DATABASE_INSTANCESCLUSTER_INTERCONNECTSINSTANCE_NUMBERPARALLEL_INSTANCE_GROUPTHREADREDOログ、アーカイブ、リカバリ
CONTROL_FILE_RECORD_KEEP_TIMEDB_CREATE_ONLINE_LOG_DEST_nDB_RECOVERY_FILE_DESTDB_RECOVERY_FILE_DEST_SIZEDB_UNRECOVERABLE_SCN_TRACKINGFAST_START_MTTR_TARGETLOG_BUFFERLOG_CHECKPOINT_INTERVALLOG_CHECKPOINT_TIMEOUTLOG_CHECKPOINTS_TO_ALERTLOG_ARCHIVE_CONFIGLOG_ARCHIVE_DEST_nLOG_ARCHIVE_DEST_STATE_nLOG_ARCHIVE_DUPLEX_DESTLOG_ARCHIVE_FORMATLOG_ARCHIVE_MAX_PROCESSESLOG_ARCHIVE_MIN_SUCCEED_DESTLOG_ARCHIVE_TRACEREDO_TRANSPORT_USERRECOVERY_PARALLELISMリソース・マネージャ
PROCESSOR_GROUP_NAMERESOURCE_LIMITRESOURCE_MANAGER_CPU_ALLOCATIONRESOURCE_MANAGER_PLANセキュリティ、監査
AUDIT_FILE_DESTAUDIT_SYS_OPERATIONSAUDIT_SYSLOG_LEVELAUDIT_TRAILCOMMIT_LOGGINGCOMMIT_WAITDBFIPS_140O7_DICTIONARY_ACCESSIBILITYOS_AUTHENT_PREFIXOS_ROLESRDBMS_SERVER_DNREMOTE_LOGIN_PASSWORDFILEREMOTE_OS_AUTHENTREMOTE_OS_ROLESSEC_CASE_SENSITIVE_LOGONSEC_MAX_FAILED_LOGIN_ATTEMPTSSEC_PROTOCOL_ERROR_FURTHER_ACTIONSEC_PROTOCOL_ERROR_TRACE_ACTIONSEC_RETURN_SERVER_RELEASE_BANNERSQL92_SECURITYUNIFIED_AUDIT_SGA_QUEUE_SIZEセッション、プロセス
CPU_COUNTPROCESSESSESSIONSTHREADED_EXECUTIONUSE_DEDICATED_BROKER共有サーバー・アーキテクチャ
CIRCUITSDISPATCHERSMAX_DISPATCHERSMAX_SHARED_SERVERSSHARED_SERVER_SESSIONSSHARED_SERVERSスタンバイ・データベース
ARCHIVE_LAG_TARGETDB_FILE_NAME_CONVERTDB_UNIQUE_NAMEDG_BROKER_CONFIG_FILEnDG_BROKER_STARTFAL_CLIENTFAL_SERVERLOG_FILE_NAME_CONVERTSTANDBY_FILE_MANAGEMENT一時ソート領域
BITMAP_MERGE_AREA_SIZECREATE_BITMAP_AREA_SIZEHASH_AREA_SIZEPGA_AGGREGATE_LIMITPGA_AGGREGATE_TARGETSORT_AREA_RETAINED_SIZESORT_AREA_SIZEWORKAREA_SIZE_POLICYトランザクション
COMMIT_LOGGINGCOMMIT_WAITDB_LOST_WRITE_PROTECTDDL_LOCK_TIMEOUTDML_LOCKSFAST_START_PARALLEL_ROLLBACKGLOBAL_TXN_PROCESSESTRANSACTIONSUNDO管理
RESUMABLE_TIMEOUTROLLBACK_SEGMENTSTEMP_UNDO_ENABLEDTRANSACTIONS_PER_ROLLBACK_SEGMENTUNDO_MANAGEMENTUNDO_RETENTIONUNDO_TABLESPACE