Query to Get Process Limit in Oracle 11g

limitsoracle

I'm getting the error:

Maximum Number Of Process Exceeded

I want to see (using a query) what the setting is in my database for the process limit.

My question is: What is the query to get the process limit on Oracle 11g?

Best Answer

This should give you a more nuanced view of the limits and usage

select 
  resource_name, 
  current_utilization, 
  max_utilization, 
  limit_value 
from v$resource_limit 
where resource_name in ('sessions', 'processes');

From here

Related Question