Archivelog generation on a daily basis：setpages 1000selecttrunc(COMPLETION_TIME,'DD')Day, thread#, round(sum(BLOCKS*BLOCK_SIZE)/1048576) MB,count(*) Archives_Generatedfromv$archived_loggroupbytrunc(COMPLETION_TIME,'DD'),thread#orderby1;
Archive log generation on an hourly basis:setpages 1000selecttrunc(COMPLETION_TIME,'HH')Hour,thread# , round(sum(BLOCKS*BLOCK_SIZE)/1048576) MB,count(*) Archivesfromv$archived_loggroupbytrunc(COMPLETION_TIME,'HH'),thread# orderby1 ;