Archive generation query

select db.name ,

db.log_mode , trunc(FIRST_TIME)

, count(1), to_char(sum(blocks*block_size)/1024/1024,'999,999.99') "Size_in_MB" from v$archived_log al,v$database db

where COMPLETION_time>=sysdate-7 and (al.name like '%/%' or al.name like '%\%') group by db.log_mode,db.name,trunc(FIRST_TIME) order by 1;