Unanswered: maximum number of processes - is there a high water mark history for this info
I get "ORA-00020: maximum number of processes (150) exceeded" in my application log.
I know I should enlarge the processes initiation parameter.
I would like to know if there is a place (i.e. v$ table) I can look in and find what was the maximum connection number in the last "x" days/hours etc'
I am not sure if there a way to track that information.
You might wanna consider creating a trigger in this case, which would log that event (<150 processes). I am not sure how to do that, but just a suggestion.
Thanx and Regards