This weekend we received an alert from the oracle database informing us that there was too much connection to the NIMPROD database. There's a limit of 300 connections. The DBA told us that they grow the limit to a higher number if needed.
There was near 300 connections and most of the connection were old and inactive. The connections were coming from the discovery server, the primary hub and both UMP servers. We restarted the robot of all these servers and the connection number went down.
We would like to know why there was so much inactive connection and why they were not kill automatically. When a connection is not use anymore, does the application kill the connection? There was connection as old as august.
Should we configure oracle to raise the limit of the connection? If yes, what should be the number?
Release : Any UIM
Component : UNIFIED INFRASTRUCTURE MGMT