Oracle B12255-01 - Manual (Page 113)

mod_plsql
Oracle HTTP Server Modules 7-43
Notes:
■
This parameter is changed only for performance reasons. The minimum value
for this parameter is 28, but it is seldom reduced.
■
Change this parameter only under the following circumstances:
■
The average response page is large and you want to reduce the number of
round-trips mod_plsql makes 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 fewer bytes for each row
(calculations in the OWA Web ToolKit are character-based and in the 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 of the product, this parameter was called response_array_
size
.
■
In older versions of the product, the default for this parameter was 128.
PlsqlInfoLogging Specifies what mode mod_plsql should use to do extra
performance logging.
The mode is:
InfoDebug : This logs more information to the Apache’s error_log. This is used
in conjunction with Apache’s “info” logging level. If the Apache’s logging level is
not at least set to this high, this setting will be ignored.
This logging setting is useful for debugging problems in your PL/SQL application.
Category Value
Syntax PlsqlFetchBufferSize number
Default 200
Example PlsqlFetchBufferSize 256
Category Value
Syntax PlsqlInfoLogging InfoDebug
Default Empty
Example PlsqlInfoLogging InfoDebug