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
SELECT
statement will always return a complete result set even if filling the buffer takes multiple iterations. TheSELECT
result is not limited by theTTC_NetMsgMaxRows
attribute.
- 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. |