HS_RPC_FETCH_SIZE
HS_RPC_FETCH_SIZE initialization parameter for Oracle Database Gateway for DRDA.
| Property | Description |
|---|---|
|
Default value |
|
|
Range of values |
1 to 10000000 |
Tunes internal data buffering to optimize the data transfer rate between the server and the agent process.
Increasing the value can reduce the number of network round-trips needed to transfer a given amount of data, but also tends to increase data bandwidth and to reduce latency as measured between issuing a query and completion of all fetches for the query. Nevertheless, increasing the fetch size can increase latency for the initial fetch results of a query, because the first fetch results are not transmitted until additional data is available.