オプション名 / 管理ポータル名 (該当する場合) |
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 |