Database: Oracle 12.1.0.2
We want to know why number of process has increase and determine if we need to increase process limit. Currently, our limit value for process is 400 and session is 640. However, max_utilization for process is 390
select max_utilization from v$resource_limit where resource_name ='processes'
-- 390
Based on dba_hist_resource_limit I know it happen 7 days ago.
Is there any views / logs I can check to know what lead to increase in number of processes?
I checked awr report but did not find anything.
To avoid , ORA-00020 (maximum number of processes exceeded) , Is it ok to increase number of process to 500 without increasing the session?
Appreciate your time.