Specifies the number of records in the record group to be fetched for each fetch operation. A larger fetch size reduces the number of fetches required to obtain the record group. For example, a record group of 5000 records will require 500 trips to be fetched if Record Group Fetch Size is set to 10, but only 5 trips if Record Group Fetch Size is set to 1000.
When the RECORD GROUP FETCH SIZE is set to 0, then,
With Oracle Forms, the Record Group Fetch Size Property now defaults to 0 instead of 20. Oracle Forms calculates the optimized FETCH SIZE depending on the size and type of column(s) under consideration.
Also, the way in which the actual value is computed when a value of 0 is specified has changed. The actual value in this case is now 0.5 M / total_record_size (i.e. sum_of_column_sizes, not max_column_size), but no more than 100 and no less than 20. The coefficients (0.5 M, 100, and 20) can be changed by setting these environment variables: FORMS_COMPUTED_RGFS_DIVIDEND, FORMS_MAX_COMPUTED_RGFS, and FORMS_MIN_COMPUTED_RGFS.
In previous releases, the actual value in this case was roughly 64K / max_column_size (i.e. the size of the largest CHAR column).
Applies to record group functional
Set Oracle Forms
Default
0
Required/Optional required
Usage Notes
Only available when Record Group Type is set to Query.