How to calculate daily redo log files volume?
Posted: June 11, 2014 Filed under: General | Tags: calculate, daily, logfile, redo, volume Leave a commentHow 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;