My database keeps running up against the maximum processes parameter. Currently PROCESSES=1000 in the parameter file. This does not seem reasonable to me, especially since my other database installations with the same database schema are running on maximum processes of 150.
I see lots of discussions on this issue but they all require procedures in a SqlPlus session -- but I can't use a sql session because there are too many processes. Is there a log file I can look at somewhere to maybe get some idea of what is happening?