Set Fetch Size Parameters
Use this activity to set the fetch size parameters for the grouped push process. Adjust these parameters on the
Application Parameters page:
- FETCH_SIZE_DATA: Specifies the number of entity data rows without LOB columns fetched from
the database to PL/SQL memory in a single SQL call. The default value is 2000.
- FETCH_SIZE_LOB_DATA: Specifies the number of entity data rows containing LOB columns fetched
from the database to PL/SQL memory in a single SQL call. The default value is 500.
- FETCH_SIZE_LOG: Specifies the number of transaction log rows fetched from the database to
PL/SQL memory in a single SQL call. The default value is 5000.
- FETCH_SIZE_OBJKEY: Specifies the number of OBJKEYs fetched from the database to PL/SQL
memory in a single SQL call. The default value is 10,000.
Refer to the Application Parameters section in technical documentation for further details.
Prerequisites
- Grouped Push must be enabled.
System Effects
As a result of this activity, the fetch size parameters for grouped push will be updated.