PlsqlFetchBufferSize

Specifies the number of rows of content to fetch from the database for each trip (using either owa_util.get_page or owa_util.get_page_raw).

By default, mod_plsql will attempt fetching 200 response lines of output where each line is of 255 bytes. In situations where the response bytes are single-byte, the response buffer is populated to the maximum and can pack 255*200=51000 bytes per round trip. But, for responses containing multi-byte data, the byte packing of each row could be less than ideal resulting in lesser bytes getting transferred per round trip. If your application generates large pages frequently and the response does not fit in one round-trip, consider setting this parameter higher. However, the memory usage for mod_plsql will increase.

Syntax:
PlsqlFetchBufferSize [number]
Default:
200
Example:
PlsqlFetchBufferSize 256

Tips for PlsqlFetchBufferSize

This parameter is tweaked only if your application generates large pages frequently

The minimum value for this parameter is 28, but this parameter is hardly ever tweaked down

This parameter needs to be tweaked only in the following circumstances

  • The average response page is big and you wish to reduce the number of round-trips made by mod_plsql to the database to fetch the response
  • The character set in use is multi-byte, and you want to compensate for the problem of get_page or get_page_raw fetching lesser number of bytes-per-row (calculations in the PL/SQL Web ToolKit are character-based and in case of multi-byte characters, OWA packages assume a worst-case character byte size and do not attempt to pack each row to its maximum)

In older versions, this parameter was called response_array_size

In Oracle iAS Version 9.0.2.0 and below, the default for this parameter was 128