| オプション名 / 管理ポータル名 (該当する場合) |
CPF 名 |
API |
SET OPTION 名 |
| AdaptiveMode / [アダプティブモードをオフにして実行時プラン選択と自動チューニングを無効にする] |
AdaptiveMode |
SetOption()Opens in a new tab |
N/A |
| AllowExtrinsicFunction |
ExtrinsicFunctions |
SetOption()Opens in a new tab |
N/A |
| AllowRowIDUpdate |
AllowRowIDUpdate |
N/A |
N/A |
| ANSIPrecedence |
ANSIPrecedence |
SetOption()Opens in a new tab |
N/A |
| AutoCommit |
N/A |
SetOption()Opens in a new tab |
N/A |
| AutoParallel / [単一プロセス内でクエリを実行] |
AutoParallel |
SetOption()Opens in a new tab |
N/A |
| AutoParallelThreshold |
AutoParallelThreshold |
SetOption()Opens in a new tab |
AUTO_PARALLEL_ THRESHOLD |
| BiasQueriesAsOutlier |
BiasQueriesAsOutlier |
N/A |
N/A |
| BitmapFriendlyCheck |
N/A |
SetOption()Opens in a new tab |
N/A |
| CachedQueryLockTimeout |
N/A |
SetOption()Opens in a new tab |
N/A |
| CachedQuerySaveSource / [クエリキャッシュのソースを保持] |
SaveMAC |
SetOption()Opens in a new tab |
N/A |
| ClientMaxIdleTime / [Client maximum idle time (seconds)] |
ClientMaxIdleTime |
SetOption()Opens in a new tab |
N/A |
| CollectionProjection |
N/A |
SetOption()Opens in a new tab |
N/A |
| CompileModeDeferred |
N/A |
SetOption()Opens in a new tab |
COMPILEMODE |
| CompileModeImmediate |
N/A |
SetOption()Opens in a new tab |
COMPILEMODE |
| CompileModeInstall |
N/A |
SetOption()Opens in a new tab |
COMPILEMODE |
| CompileModeNocheck |
N/A |
SetOption()Opens in a new tab |
COMPILEMODE |
| DDLDefineBitmapExtent |
DDLDefineBitmapExtent |
SetOption()Opens in a new tab |
N/A |
| DDLDropTabDelData |
DropDelete |
SetOption()Opens in a new tab |
N/A |
| DDLFinal |
DDLFinal |
SetOption()Opens in a new tab |
N/A |
| DDLNo201 / [冗長な DDL ステートメントを無視] |
DDLNo201 |
N/A |
N/A |
| DDLNo30 / [冗長な DDL ステートメントを無視] |
DDLNo30 |
N/A |
N/A |
| DDLNo307 / [冗長な DDL ステートメントを無視] |
DDLNo307 |
N/A |
N/A |
| DDLNo311 / [冗長な DDL ステートメントを無視] |
DDLNo311 |
N/A |
N/A |
| DDLNo315 / [冗長な DDL ステートメントを無視] |
DDLNo315 |
N/A |
N/A |
| DDLNo324 / [冗長な DDL ステートメントを無視] |
DDLNo324 |
N/A |
N/A |
| DDLNo333 / [冗長な DDL ステートメントを無視] |
DDLNo333 |
N/A |
N/A |
| DDLPKeyNotIDKey / [DDL を使用して作成されたテーブルのプライマリーキーをIDキーとして定義する] |
IDKey |
SetOption()Opens in a new tab |
PKEY_IS_IDKEY |
| DDLSQLOnlyCompile |
DDLSQLOnlyCompile |
N/A |
N/A |
| DDLUseExtentSet |
DDLUseExtentSet |
SetOption()Opens in a new tab |
N/A |
| DDLUseSequence |
DDLUseSequence |
SetOption()Opens in a new tab |
N/A |
| DefaultSchema / [デフォルトスキーマ] |
DefaultSchema |
N/A |
DEFAULT_SCHEMA |
| DefaultTimePrecision |
TimePrecision |
SetOption()Opens in a new tab |
N/A |
| DelimitedIdentifiers |
DelimitedIds |
SetOption()Opens in a new tab |
SUPPORT_DELIMITED_ IDENTIFIERS |
| ECPSync |
ECPSync |
SetOption()Opens in a new tab |
N/A |
| FastDistinct / [GROUP BY と DISTINCT クエリでオリジナルの値を結果に返す] |
FastDistinct |
SetOption()Opens in a new tab |
EXACT_DISTINCT |
| FilterRefIntegrity |
ReferentialChecks |
SetOption()Opens in a new tab |
N/A |
| IdentityInsert |
N/A |
SetOption()Opens in a new tab |
N/A |
| IdTrxFrom |
IdTrxFrom |
SetDDLIdentifier Translations()Opens in a new tab |
N/A |
| IdTrxTo |
IdTrxTo |
SetDDLIdentifier Translations()Opens in a new tab |
N/A |
| IsolationMode |
N/A |
SetOption()Opens in a new tab |
N/A |
| LockThreshold / [ロックエスカレーション閾値] |
LockThreshold |
SetOption()Opens in a new tab |
LOCK_ESCALATION_ THRESHOLD |
| LockTimeout / [ロックタイムアウト(秒)] |
LockTimeout |
SetOption()Opens in a new tab |
LOCK_TIMEOUT |
| ODBCVarcharMaxlen / [VARCHAR のデフォルト長] |
ODBCVarcharMaxlen |
N/A |
N/A |
| ProcessLockTimeout |
N/A |
SetOption()Opens in a new tab |
N/A |
| ParameterSampling / [クエリ実行のパラメータを収集するパラメータ収集を有効にする] |
ParameterSampling |
SetOption()Opens in a new tab |
N/A |
| QueryProcedures |
QueryProcedures |
SetOption()Opens in a new tab |
N/A |
| RetainSQL |
Comment |
SetOption()Opens in a new tab |
N/A |
| RTPC |
RTPC |
SetOption()Opens in a new tab |
N/A |
| SQLFunctionArgConversion |
N/A |
SetOption()Opens in a new tab |
N/A |
| SQLSecurity |
DBMSSecurity |
SetOption()Opens in a new tab |
N/A |
| SelectMode |
N/A |
SetOption()Opens in a new tab |
N/A |
| ServerDisconnectCode |
N/A |
SetOption()Opens in a new tab |
N/A |
| ServerInitCode |
N/A |
SetOption()Opens in a new tab |
N/A |
| TCPKeepAlive / [クライアント接続の TCP キープアライブ(秒)] |
TCPKeepAlive |
SetOption()Opens in a new tab |
N/A |
| ToDateDefaultFormat / [TO_DATE デフォルトフォーマット] |
TODATEDefaultFormat |
SetOption()Opens in a new tab |
N/A |