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

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