摘要： select trunc(completion_time) as "Date",count(*) as "Count",trunc((sum(blocks * block_size)) /1024 /1024) as "MB"from v$archived_loggroup by trunc(completion_time)order by "Date";SQL> select 2 trunc(completion_time) as "Date" 3 ,count(*) as " 阅读全文