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.