select INST_ID,resource_name, current_utilization,initial_allocation, max_utilization, limit_value
from gv$resource_limit where resource_name in ( 'sessions', 'processes');
select * from DBA_HIST_RESOURCE_LIMIT where resource_name in ('sessions','processes') where INSTANCE_NUMBER=1;
select
s.instance_number,
s.end_interval_time,
rn.current_utilization
from
dba_hist_snapshot s
join dba_hist_resource_limit rn on (s.snap_id = rn.snap_id and s.instance_number = rn.instance_number)
where
rn.resource_name = 'processes'
and s.end_interval_time > sysdate - 300 and s.INSTANCE_NUMBER=1
order by
s.end_interval_time;
https://docs.oracle.com/cd/E57185_01/HFMAG/apbs09s05.html
