D.35 HS_RPC_FETCH_REBLOCKING

HS_RPC_FETCH_REBLOCKING initialization parameter for Oracle Database Gateway for SQL Server.

Property	Description
Default value	ON
Range of values	OFF or ON

Controls whether Heterogeneous Services attempts to optimize performance of data transfer between the Oracle database and the Heterogeneous Services agent connected to the non-Oracle data store.

The following values are possible:

• OFF disables reblocking of fetched data so that data is immediately sent from agent to server.
• ON enables reblocking, which means that data fetched from the non-Oracle system is buffered in the agent and is not sent to the Oracle database until the amount of fetched data is equal to or higher than the value of HS_RPC_FETCH_SIZE initialization parameter. However, any buffered data is returned immediately when a fetch indicates that no more data exists or when the non-Oracle system reports an error.