Oracle B12255-01 Manual Do Utilizador

mod_plsql

Oracle HTTP Server Administrator’s Guide

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

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.

This file contains the configuration parameters for the PL/SQL Database Access
Descriptor (DAD).

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

Syntax

PlsqlIdleSessionCleanupInterval number

Default

15 (minutes)

Example

PlsqlIdleSessionCleanupInterval 15