Oracle B12255-01 - Manual (Page 96)

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