Database size seven days ago
select a.data_size + b.temp_size + c.redo_size + d.cont_size "total_size"
from (select sum(bytes) data_size from dba_data_files ) a,
(select nvl(sum(bytes),0) temp_size from dba_temp_files ) b,
(select sum(bytes) redo_size from sys.v_$logfile lf, sys.v_$log l where lf.group# = l.group#) c,
(select sum(block_size*file_size_blks) cont_size from v$controlfile ) d;
How can I use the awr history tables to find out the database total size seven days ago? I can find particular tablespace growth for seven days, but what about controlfiles and temp files all that? Thanks.