TTC_NetMsgMaxBytes

The TTC_NetMsgMaxBytes attribute specifies the maximum size in bytes of a client result set buffer.

The server stores a maximum number of bytes in the result set buffer size returned from a SELECT statement. To improve the application’s performance, you can increase or decrease the maximum size in bytes of a client result set buffer with the TTC_NetMsgMaxBytes connection attribute.

The buffer size can be set in terms of bytes or rows. The lower limit takes precedence. If you set one of them, it is recommended that you set the other also. It is suggested to decide first which maximum attribute you want to use and set it; then, set the other attribute to a value high enough to ensure that this value is not reached first.

The SELECT statement will always return a complete result set even if filling the buffer takes multiple iterations. The SELECT result is not limited by the TTC_NetMsgMaxBytes attribute.

You can set the TTC_NetMsgMaxBytes attribute in a connection string or DSN to serve as the value for any SELECT statement on the connection.

Note:

Although the minimum possible setting value for the TTC_NetMsgMaxBytes attribute is one byte, using this value would result in a buffer that is too small to contain the smallest row. For this reason, regardless of the value specified, the buffer is always sized to be large enough to contain at least one row.

See Sizing the Client Result Set Buffer in the Oracle TimesTen In-Memory Database Operations Guide for more information.

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 TTC_NetMsgMaxBytes 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	TTC_NetMsgMaxBytes	A positive integer value. The minimum size is 1. Default is 2097152 bytes (2MB).
Windows ODBC Data Source Administrator	Net Msg Max Bytes field on the Oracle TimesTen Client DSN Setup dialog.	A positive integer value. The minimum size is 1. Default is 2097152 bytes (2MB).