select
round(sample_time,'MI'),
count(*) as active_sessions
from
dba_hist_active_sess_history
where
sample_time > sysdate - 7
group by
round(sample_time, 'MI')
You can then graph the values as in this example:

0 Comments