TTC_NetMsgMaxRows
The TTC_NetMsgMaxRows attribute specifies the maximum number of rows stored in the client result set buffer.
Notes
The server stores a maximum number of rows in the result set buffer size returned from a SELECT statement. To improve the application’s performance, you can increase or decrease the maximum number of rows of a client result set buffer with the TTC_NetMsgMaxRows connection attribute.
- The
SELECTstatement will always return a complete result set even if filling the buffer takes multiple iterations. TheSELECTresult is not limited by theTTC_NetMsgMaxRowsattribute.
- The buffer size can be set in terms of rows or bytes. 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.
You can set the TTC_NetMsgMaxRows attribute in a connection string
or DSN to serve as the value for any
SELECT statement on the
connection.
See Sizing the Client Result Set Buffer in 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_NetMsgMaxRows as follows:
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems |
|
A positive integer value. The minimum is 1 row. Default is 8192 rows. |
|
Windows ODBC Data Source Administrator |
Net Msg Max Rows field on the Oracle TimesTen Client DSN Setup dialog. |
A positive integer value. The minimum is 1 row. Default is 8192 rows. |