Tuesday, July 29, 2014

Query to find number of archives generated each day

select to_char(completion_time,'dd-mon-yyyy'),count(*) from v$archived_log group by to_char(completion_time,'dd-mon-yyyy') order by to_char(completion_time,'dd-mon-yyyy')
/

No comments:

Post a Comment