Measure Number of Active Sessions

--  measure number of Active Sessions

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');