select count(*) from gv$archived_log
where dest_id=1
and applied='NO'
and completion_time between to_date('20/06/2016 09:00:00', 'dd/mm/yyyy hh21:mi:ss') and to_date('20/06/2016 18:00:00', 'dd/mm/yyyy hh21:mi:ss')
order by next_time desc;