A script-enabled browser is required for this page to function properly.

Record Group Fetch Size Property

Description

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,

  1. The value is not defaulted to 20;
  2. Forms calculates the optimised FETCH SIZE depending upon the size and type of the column(s) under consideration.

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.