Oracle HTTP Server, Administrator'S Manual

Page: 113 / 224

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