D.35 HS_RPC_FETCH_REBLOCKING
HS_RPC_FETCH_REBLOCKING
initialization parameter for Oracle Database Gateway for SQL Server.
Property | Description |
---|---|
Default value |
|
Range of values |
|
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 ofHS_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.
Parent topic: Initialization Parameters