DATABASE:AWSDLGNVAL0075.jnj.com        : STATUS: P50:P50 has reached 87.3% of the process limit.
process limit is set to 1000 
 
SQL> SELECT resource_name, current_utilization, max_utilization, limit_value  
  2  FROM v$resource_limit  
  3  WHERE resource_name IN ('processes', 'sessions'); 
 
RESOURCE_NAME 
-------------------------------------------------------------------------------- 
CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE 
------------------- --------------- ------------------------------ 
processes 
                736             940       1000 
 
sessions 
                825            1114       2016 
