We are using Version-11.2.0.4 of oracle. And front end is Java. Our application team is saying as we have ~25 threads active at sometime but the connection pool only allocate 10 connection at anytime, so they say they are really waiting for access to connections during run time. So are asking to increase the current connection to twice the number of threads i.e 50.
I want to understand from experts, how should we evaluate the scenario, and what all precaution need to be taken to ensure its not badly affecting database/application performance and if any DB parameters needs to be validated/changed for this? also if there is any symptom which would really suggests that we are falling short of connections and those needs to be increased to handle the load? Appreciate your response.