Archive log generated per day

select trunc(completion_time), sum(blocks*block_size)/1048576 mb
from gv$archived_log
group by trunc(completion_time)

Advertisements