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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s