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 |
|
|
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 attributeCommitBufferSizeMax
are expressed in
MB.