Performance issues with large number of active projects on Oracle

The ALM environment may experience slow performance for a period of time, and new database connections may be refused.

This problem may affect large ALM environments (over 500 active projects) configured to work on an Oracle database. Both ALM-PC and pure ALM environments may be affected.
PC’s PAL orphan maintenance task connects to the schema of each active project every predefined interval (default value is 1440 minutes).
This can result in a large number of open database connections which can cause slow performance until the database connections are closed.

To fix this issue

Disable the PAL maintenance tasks.
To disable the tasks, execute the following SQL query directly on the LAB project schema:

update LAB_MAINTENANCE_TASKS set LTASK_STATUS=’N’ where LTASK_NAME like ‘%PAL%’

Advertisements