1. Scaleout User's Guide
  2. Using SQL in TimesTen Scaleout
  3. Using the TT_CommitDMLOnSuccess Hint

Using the TT_CommitDMLOnSuccess Hint

The TT_CommitDMLOnSuccess hint is used to enable or disable a commit operation as part of DML execution. You can specify the hint at the connection level or at the statement level.

While using this hint (TT_CommitDMLOnSuccess set to 1):

  • At statement level, if a statement encounters an error while executing, the transaction remains active and the database consistent.

  • For transactions that impact a single replica set, the commit operation uses a one-phase commit instead of a two-phase commit protocol.

There is no difference in performance if you set autocommit to 1 or if you set the TT_CommitDMLOnSuccess hint to 1.

See TT_CommitDMLOnSuccess Optimizer Hint in Oracle TimesTen In-Memory Database SQL Reference.