Query to check current utilization of processes/sessions and max utilization in Oracle Database



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

RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION
------------------------------ ------------------- ---------------
processes                                      208             400
sessions                                       216             420




If you like please follow and comment