select t.SQL_ID, t.EVENT,count(*)
from v$active_session_history t
where t.SAMPLE_TIME > to_timestamp('20180416090000', 'YYYYMMDDhh24miss')
and t.SAMPLE_TIME < to_timestamp('20180416091600', 'YYYYMMDDhh24miss')
group by t.SQL_ID,t.EVENT order by count(*) desc
from v$active_session_history t
where t.SAMPLE_TIME > to_timestamp('20180416090000', 'YYYYMMDDhh24miss')
and t.SAMPLE_TIME < to_timestamp('20180416091600', 'YYYYMMDDhh24miss')
group by t.SQL_ID,t.EVENT order by count(*) desc