PlsqlMaxRequestsPerSession
Specifies the maximum number of requests a pooled database connection should service before closing it down and reopening it- Syntax:
- PlsqlMaxRequestsPerSession [number]
- Default:
- 1000
- Example:
- PlsqlMaxRequestsPerSession 1000
Tips for PlsqlMaxRequestsPerSession
This parameter helps mitigate memory and resource problems that may occur due to prolonged session reuse by a PL/SQL application
This parameter should normally not be tweaked
Setting this to a low number will result in performance issues. If you have an infrequently used DAD and performance is not a concern, you can choose to set this to a low number
If you set this really low (e.g. 1) and the DAD is accessed frequently, you might start hitting bug#1575624
In older versions, the parallel to this parameter is "reuse". Instead of taking a value of "Yes/No", the new parameter allows for more fine-grained control for the connection pool reuse in mod_plsql