Oracle HTTP Server, Руководство администратора

Страница: 96 / 224

mod_plsql
7-26 Oracle HTTP Server Administrator’s Guide
PlsqlIdleSessionCleanupInterval
Specifies the time (in minutes) in which the idle
database sessions should be closed and cleaned by
mod_plsql
.
This directive is used in conjunction with connection pooling of database
connections and sessions in
mod_plsql
. When a session is not used for the
specified amount of time, it is closed, and freed. This is done so that unused
sessions can be cleaned, and the memory is freed on the database side.
Setting this time to a low number helps in faster cleanup of unused database
sessions. Be aware that if this number is too low, then this may adversely affect the
performance benefits of connection pooling in
mod_plsql
.
If the number of open database sessions is not a concern, you can increase the value
of this parameter for best performance. In such a case, if the site is accessed
frequently enough that the idle session cleanup interval is never reached for a
session, then the DAD configuration parameter
PlsqlMaxRequestsPerSession
can be modified so that it is guaranteed that a pooled database session gets recycled
on a regular basis.
For most installations, the default parameter value should suffice.
dads.conf
This file contains the configuration parameters for the PL/SQL Database Access
Descriptor (DAD).
DAD Parameters This section describes all the DAD level parameters that can be
specified in the
dads.conf
file. Besides these directives, you can also specify
additional Oracle HTTP Server directives that can be specified in the context of a
<
Location
> directive, such as:
Order deny,allow
AllowOverride None
Category Value
Syntax
PlsqlIdleSessionCleanupInterval number
Default 15 (minutes)
Example
PlsqlIdleSessionCleanupInterval 15