oracle 序列 增长量,查看ORACLE Archive log增长量

select

trunc(completion_time) as "Date"

,count(*) as "Count"

,trunc((sum(blocks * block_size)) /1024 /1024) as "MB"

from v$archived_log

group by trunc(completion_time)

order by "Date"

;

SQL> select   2  trunc(completion_time) as "Date"   3  ,count(*) as "Count"   4  ,trunc((sum(blocks * block_size)) /1024 /1024) as "MB"   5  from v$archived_log   6  group by trunc(completion_time)   7  order by "Date"   8  ; Date                 Count         MB --------------- ---------- ---------- 02-JUN-10               87       3727 17-JUN-10              266      11344 18-JUN-10              655      29995 19-JUN-10                2         86 20-JUN-10                1         43 21-JUN-10               27       1140 22-JUN-10               18        777 23-JUN-10                6        247 24-JUN-10                4        172 25-JUN-10                6        259 26-JUN-10                4        172 Date                 Count         MB --------------- ---------- ---------- 27-JUN-10                3        129 28-JUN-10                4        172 29-JUN-10                4        172 30-JUN-10                7        294 01-JUL-10                3        129 02-JUL-10                4        172 03-JUL-10                7        302 04-JUL-10                3        129 05-JUL-10                2         86 20 rows selected.