SELECT TRUNC(A.first_time), COUNT(1), round(sum(blocks*block_size) / (1024*1024)) "MB"
FROM V$ARCHIVED_LOG A
WHERE A.dest_id = 1
AND   A.first_time > '01-AGO-08'
GROUP BY ROLLUP(TRUNC(A.first_time))
ORDER BY 1 DESC;