查看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.