alex77ander
MIS
I am trying to find a way to report the number of archive logs produced by the hour by day.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
select to_char(completion_time,'yyyy/mm/dd hh24'), count(*) from v$archived_log
where completion_time between trunc(sysdate-1) and trunc(sysdate)
group by to_char(completion_time,'yyyy/mm/dd hh24')
order by 1