--查看每天产生的归档日志大小:
select aa.ArchiveDate,aa.ArchiveSize from (
select trunc(first_time) as ArchiveDate,
sum(block_size * blocks) / 1024 / 1024 / 1024 as ArchiveSize
from v$archived_log
group by trunc(first_time)
) aa order by aa.ArchiveDate desc
锲而不舍,水滴石穿