Oracle B12255-01 - Manual (Page 114)

mod_plsql
7-44 Oracle HTTP Server Administrator’s Guide
PlsqlMaxRequestsPerSession Specifies the maximum number of requests a
pooled database connection should service before it is closed and re-opened.
Notes:
■
This parameter helps relieve memory and resource problems that may occur
due to prolonged session reuse by a PL/SQL application.
■
This parameter should not need to be changed; the default is sufficient in most
cases.
■
Setting this parameter to a low number can degrade performance. A case for a
lower value might be an infrequently used DAD whose performance is not a
concern, and for which limiting the number of requests provides some benefit.
■
In older versions of the product, the equivalent to this parameter is reuse.
Instead of taking a value of “Yes” or “No”, the new parameter enables you to
have finer control over the connection pool reuse in mod_plsql.
PlsqlNLSLanguage Specifies the NLS_LANG variable for this DAD. This parameter
overrides the NLS_LANG environment variable. When this parameter is set, the
PL/SQL Gateway uses the specified NLS_LANG to connect to the database. Once
connected, an alter session command is issued to switch to the specified language
and territory. If the middle tier character set matches that of the database, then no
alter session call is issued by mod_plsql.
Category Value
Syntax PlsqlMaxRequestsPerSession number
Default 1000
Example PlsqlMaxRequestsPerSession 1000
Category Value
Syntax PlsqlNLSLanguage string
Default None
Example PlsqlNLSLanguage America_America.UTF8