Google+ Followers

Pages

Thursday, March 2, 2017

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

No comments:

Post a Comment