How to calculate daily redo log files volume?

How to calculate daily redo log files volume?

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
order by 1;



Leave a comment