CommitBufferSizeMax

CommitBufferSizeMax indicates the total amount of memory in MB allocated to the transaction commit buffer.

Set this attribute to handle the size of reclaim records.

You can use the ALTER SESSION SQL statement, described in Oracle TimesTen In-Memory Database SQL Reference, to assign or change the maximum size of the commit buffer within a session. The new value takes effect when a new transaction starts.

ALTER SESSION SET COMMIT_BUFFER_SIZE_MAX = n;

You can see the configured maximum for the commit buffer by calling the ttConfiguration built-in procedure.

For more information on reclaim operations, including details about setting the commit buffer size, see Transaction Reclaim Operations in the Oracle TimesTen In-Memory Database Operations Guide. Also see information about the ttCommitBufferStats and the ttCommitBufferStatsReset built-in procedures.

Required Privilege

No privilege is required to change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set CommitBufferSizeMax as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic or in the database definition (.dbdef) file in TimesTen Scaleout	CommitBufferSizeMax	0 - Commit buffer is configured to the default size. (10MB). n - Integer value. Minimum user configured size is 1 (MB), Configure this value to a value much smaller than TempSize.
Windows ODBC Data Source Administrator	Not applicable

Note:

When you call the built-in procedure ttCommitBufferStats, the commit buffer statistics are expressed in bytes. However, the ttConfiguration built-in procedure output and the value set by the connection attribute CommitBufferSizeMax are expressed in MB.