It verifies the amount of REdo-log used during one
hour in the period of 60 days each redo tends 20Mb,
if in 1 hour we have the value 4 q we can say in this period
80 Mb mesta was moved hour. * *

set feedback off echo off trims on
set pagesize 50000
set line 200
set veri off
set termout off

def time="time" -- Oracle7

col time new_value time
col mes format a3

spool d:\somtingdir\temp\redolog.txt

select 'to_char(first_time,''MM/DD/YY HH24:MI:SS'')' time
from dual
where &&_O_RELEASE like '8%' -- Oracle8
/

set termout on

break on mes skip 1 on report

ttitle center 'Relatorio de quantidade e tamanho de transações por
periodo de até 60 dias' center

compute sum of Total_Diario on mes
compute sum of Volume_Mb on mes
compute avg of total_diario on report
-- compute sum of total_diario on report
compute avg of volume_Mb on report
col total_diario format 999,999.99
col volume_mb format 999,999.99

select substr(&&time,1,2) mes,
substr(&&time,4,5) dia,
to_char(sum(decode(substr(&&time,10,2),'00',1,0)),'999') "00",
to_char(sum(decode(substr(&&time,10,2),'01',1,0)),'999') "01",
to_char(sum(decode(substr(&&time,10,2),'02',1,0)),'999') "02",
to_char(sum(decode(substr(&&time,10,2),'03',1,0)),'999') "03",
to_char(sum(decode(substr(&&time,10,2),'04',1,0)),'999') "04",
to_char(sum(decode(substr(&&time,10,2),'05',1,0)),'999') "05",
to_char(sum(decode(substr(&&time,10,2),'06',1,0)),'999') "06",
to_char(sum(decode(substr(&&time,10,2),'07',1,0)),'999') "07",
to_char(sum(decode(substr(&&time,10,2),'08',1,0)),'999') "08",
to_char(sum(decode(substr(&&time,10,2),'09',1,0)),'999') "09",
to_char(sum(decode(substr(&&time,10,2),'10',1,0)),'999') "10",
to_char(sum(decode(substr(&&time,10,2),'11',1,0)),'999') "11",
to_char(sum(decode(substr(&&time,10,2),'12',1,0)),'999') "12",
to_char(sum(decode(substr(&&time,10,2),'13',1,0)),'999') "13",
to_char(sum(decode(substr(&&time,10,2),'14',1,0)),'999') "14",
to_char(sum(decode(substr(&&time,10,2),'15',1,0)),'999') "15",
to_char(sum(decode(substr(&&time,10,2),'16',1,0)),'999') "16",
to_char(sum(decode(substr(&&time,10,2),'17',1,0)),'999') "17",
to_char(sum(decode(substr(&&time,10,2),'18',1,0)),'999') "18",
to_char(sum(decode(substr(&&time,10,2),'19',1,0)),'999') "19",
to_char(sum(decode(substr(&&time,10,2),'20',1,0)),'999') "20",
to_char(sum(decode(substr(&&time,10,2),'21',1,0)),'999') "21",
to_char(sum(decode(substr(&&time,10,2),'22',1,0)),'999') "22",
to_char(sum(decode(substr(&&time,10,2),'23',1,0)),'999') "23",
sum ((decode(substr(&&time,10,2),'00',1,0))+
(decode(substr(&&time,10,2),'00',1,0))+
(decode(substr(&&time,10,2),'01',1,0))+
(decode(substr(&&time,10,2),'02',1,0))+
(decode(substr(&&time,10,2),'03',1,0))+
(decode(substr(&&time,10,2),'04',1,0))+
(decode(substr(&&time,10,2),'05',1,0))+
(decode(substr(&&time,10,2),'06',1,0))+
(decode(substr(&&time,10,2),'07',1,0))+
(decode(substr(&&time,10,2),'08',1,0))+
(decode(substr(&&time,10,2),'09',1,0))+
(decode(substr(&&time,10,2),'10',1,0))+
(decode(substr(&&time,10,2),'11',1,0))+
(decode(substr(&&time,10,2),'12',1,0))+
(decode(substr(&&time,10,2),'13',1,0))+
(decode(substr(&&time,10,2),'14',1,0))+
(decode(substr(&&time,10,2),'15',1,0))+
(decode(substr(&&time,10,2),'16',1,0))+
(decode(substr(&&time,10,2),'17',1,0))+
(decode(substr(&&time,10,2),'18',1,0))+
(decode(substr(&&time,10,2),'19',1,0))+
(decode(substr(&&time,10,2),'20',1,0))+
(decode(substr(&&time,10,2),'21',1,0))+
(decode(substr(&&time,10,2),'22',1,0))+
(decode(substr(&&time,10,2),'23',1,0))) Total_Diario,
sum ((decode(substr(&&time,10,2),'00',1,0))+
(decode(substr(&&time,10,2),'00',1,0))+
(decode(substr(&&time,10,2),'01',1,0))+
(decode(substr(&&time,10,2),'02',1,0))+
(decode(substr(&&time,10,2),'03',1,0))+
(decode(substr(&&time,10,2),'04',1,0))+
(decode(substr(&&time,10,2),'05',1,0))+
(decode(substr(&&time,10,2),'06',1,0))+
(decode(substr(&&time,10,2),'07',1,0))+
(decode(substr(&&time,10,2),'08',1,0))+
(decode(substr(&&time,10,2),'09',1,0))+
(decode(substr(&&time,10,2),'10',1,0))+
(decode(substr(&&time,10,2),'11',1,0))+
(decode(substr(&&time,10,2),'12',1,0))+
(decode(substr(&&time,10,2),'13',1,0))+
(decode(substr(&&time,10,2),'14',1,0))+
(decode(substr(&&time,10,2),'15',1,0))+
(decode(substr(&&time,10,2),'16',1,0))+
(decode(substr(&&time,10,2),'17',1,0))+
(decode(substr(&&time,10,2),'18',1,0))+
(decode(substr(&&time,10,2),'19',1,0))+
(decode(substr(&&time,10,2),'20',1,0))+
(decode(substr(&&time,10,2),'21',1,0))+
(decode(substr(&&time,10,2),'22',1,0))+
(decode(substr(&&time,10,2),'23',1,0)))* 20
Volume_Mb
-- 20 is the size in Mb of your redolog file
from sys.v_$log_history
where substr(&&time, 1, 5) != '10/12'
AND substr(&&time, 1, 5) != '10/13'
group by substr(&&time, 1, 2), substr(&&time, 4, 5)
/
spool off


Change the value of !='xx/xx' above for a valid date your.

this script is write in Portugues if you prefer I changed for Ingles.

See firts if this resolve your question.