11.2.0.4 version Growing process number to 1000 problem

Hello,

A short time ago, I saw notifications in the alert.log file that there were session errors in some applications due to the lack of processes in the database, and I was getting the "maximum process exceeded" error. Our value was 750. Although I increased the number to 1000, the problems still continue due to the problems in some applications. We don't get as many errors as before, but it still seems to be an ongoing situation.

What I want to learn is to analyze the application and sql statements that are the source of these problems exactly.

There are some parameters that I look at myself, but they do not satisfy me very much. More specifically, I would appreciate it if you could guide me to direct the software developers.