So you need a little data about how much archivelog your DB is producing?

Here is a query that will give you the last 24 hour summary.

select to_char(first_time,’dd-mon-yy’) In_Day,
round(sum(blocks*block_size)/1024/1024/1024,2) Total_GB_Archived,
count(*) Num_of_Archs,
round(sum(blocks*block_size)/1024/1024/count(*),2) Avg_MB_Per_Arch
from v$archived_log
where first_time>sysdate-1
group by to_char(first_time,’dd-mon-yy’)
order by to_char(first_time,’dd-mon-yy’);

Need to see the hourly archivelog data?

— want to see archivelog data by the hour
select to_char(first_time,’dd-mon-yy hh24′) InHour,
round(sum(blocks*block_size)/1024/1024/1024,1) Total_GB_Archived,
count(*) Num_of_Archs,
round(sum(blocks*block_size)/1024/1024/count(*),0) Avg_MB_Per_Arch
from v$archived_log
where first_time>sysdate-1
group by to_char(first_time,’dd-mon-yy hh24′)
order by to_char(first_time,’dd-mon-yy hh24′);