Hi
We recently had an issue with our environment that jobs were staying in a READY state after we combined 2 environments. We doubled the workload in the environment but we have plenty of capacity. We event sent over to Broadcom our numbers for both environments, server specs, etc and got sign off.
Now every since we had the issue with jobs getting stuck in READY we had to recycle the database (Oracle) and the application.
Now today when we ran a query the should us we had over 450+ INACTIVE jdbc connections. Has anyone had a similar issue? Is there a setting within the db.properties we should be setting? Currently we have the following 2 setting in our db.properties file
database.maxconnections.in.pool=1000
database.connection.idle.flush.threshold=600
Any help would be greatly appreciated