I see that many users are trying to find the current
utilization and max utilization of processes, sessions, enqueue_locks,
resources…etic.
You will get the resource
limit details from v$resoruce_limit
SQL>
select resource_name, current_utilization, max_utilization from
v$resource_limit;
RESOURCE_NAME CURRENT_UTILIZATION
MAX_UTILIZATION
------------------------------
------------------- ---------------
processes 223 235
sessions 232 250
enqueue_locks 231 264
enqueue_resources 34 72
ges_procs 0 0
ges_ress 0 0
ges_locks 0 0
ges_cache_ress 0 0
ges_reg_msgs 0 0
ges_big_msgs 0 0
ges_rsv_msgs 0 0
RESOURCE_NAME CURRENT_UTILIZATION
MAX_UTILIZATION
------------------------------
------------------- ---------------
gcs_resources 0 0
gcs_shadows 0 0
smartio_overhead_memory 0 71704
smartio_buffer_memory 0 0
smartio_metadata_memory 0 0
smartio_sessions 0 1
dml_locks 0 27
temporary_table_locks 0 3
transactions 0 8
branches 0 0
cmtcallbk 0 5
RESOURCE_NAME CURRENT_UTILIZATION
MAX_UTILIZATION
------------------------------
------------------- ---------------
max_rollback_segments 11 11
sort_segment_locks 5 18
k2q_locks 0 0
max_shared_servers 0 0
parallel_max_servers 0 5
