归档日志统计

查看oracle 10g每天产生的归档日志

SELECT
        trunc(completion_time) as "Date" ,
        count(*) as "Count" ,
        ((sum(blocks * block_size)) /1024 /1024) as "MB"
FROM
        v$archived_log
GROUP BY
        trunc(completion_time)
ORDER BY
        "Date";