Query to find number of archive logs getting generated every day

SELECT A.*,
Round(A.Count#*B.AVG#/1024/1024) Daily_Avg_Mb
FROM
(
SELECT
To_Char(First_Time,'YYYY-MM-DD') DAY,
Count(1) Count#,
Min(RECID) Min#,
Max(RECID) Max#
FROM
v$log_history
GROUP
BY To_Char(First_Time,'YYYY-MM-DD')
ORDER
BY 1 DESC
) A,
(
SELECT
Avg(BYTES) AVG#,
Count(1) Count#,
Max(BYTES) Max_Bytes,
Min(BYTES) Min_Bytes
FROM
v$log
) B;


============

SQL> SELECT A.*,
2 Round(A.Count#*B.AVG#/1024/1024) Daily_Avg_Mb
3 FROM
4 (
5 SELECT
6 To_Char(First_Time,'YYYY-MM-DD') DAY,
7 Count(1) Count#,
8 Min(RECID) Min#,
9 Max(RECID) Max#
10 FROM
v$log_history
11 12 GROUP
13 BY To_Char(First_Time,'YYYY-MM-DD')
14 ORDER
15 BY 1 DESC
16 ) A,
17 (
18 SELECT
19 Avg(BYTES) AVG#,
20 Count(1) Count#,
21 Max(BYTES) Max_Bytes,
22 Min(BYTES) Min_Bytes
23 FROM
24 v$log
25 ) B;

DAY COUNT# MIN# MAX# DAILY_AVG_MB
---------- ---------- ---------- ---------- ------------
2013-06-06 47 928 974 47000
2013-06-05 64 864 927 64000
2013-06-04 51 812 863 51000
2013-06-03 48 765 814 48000
2013-06-02 48 717 764 48000
2013-06-01 48 669 716 48000
2013-05-31 52 617 668 52000
2013-05-30 63 554 616 63000
2013-05-29 67 487 553 67000
2013-05-28 50 437 486 50000
2013-05-27 48 389 436 48000

DAY COUNT# MIN# MAX# DAILY_AVG_MB
---------- ---------- ---------- ---------- ------------
2013-05-26 48 341 388 48000
2013-05-25 48 293 340 48000
2013-05-24 60 233 292 60000
2013-05-23 56 177 232 56000
2013-05-22 48 129 176 48000
2013-05-21 82 47 128 82000
2013-05-20 17 29 46 17000
2013-05-19 1 30 30 1000
2013-05-17 1 28 28 1000
2013-05-13 1 26 26 1000
2013-05-10 3 23 27 3000

DAY COUNT# MIN# MAX# DAILY_AVG_MB
---------- ---------- ---------- ---------- ------------
2013-05-08 3 21 24 3000
2013-05-07 1 20 20 1000
2013-05-04 2 17 19 2000
2013-05-02 1 18 18 1000
2013-04-28 6 10 16 6000
2013-04-26 10 1 11 10000

28 rows selected.

SQL>