Limit Oracle DB connections in WCC

Document ID : KB000012209
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Is there a mechanism to limit the number of database connections that WCC creates?  Currently it appears that it opens 40 database connections even when idle.

Environment:
CA Workload Control Center 11.3.6, 11.4
Answer:

On Unix, in $CA_WCC_INSTALL_LOCATION/data/config/application/config/resource/connection.properties, find the following parameters and make appropriate adjustment: 

wcc.database.initialSize=10 

wcc.database.maxActive=50 

reporting.database.initialSize=10 

reporting.database.maxActive=50 

Save the change and restart WCC services.

On Windows, the connection.properties file can be located under %CA_WCC_INSTALL_LOCATION%\data\config\application\config\resource.

 

 

Additional Information:

The *.database.initialSize parameters set the number of database connections that WCC can create when starting up.  The *.database.maxActive parameters set the maximum number of database connections that the WCC server can establish at any time.